<div>
you can create view on the main table to achieve the same
</div>


you can create view on the main table to achieve the same

<div>
That's a nice idea, however I need to be able to update the column based on possible user input<br />
<br />
insert into names (name,shortname) values ('Robert Louis Stevenson','Bob')<br />
resolves &quot;Robert Louis Stevenson&quot; - &quot;Bob&quot;<br />
<br />
insert into names (name) values ('Robert Louis Stevenson')<br />
resolves &quot;Robert Louis Stevenson&quot; - &quot;Robert &quot;<br />
<br />
Any other ideas?<br />
<br />
Thanks<br />
<br />
Mike
</div>


That's a nice idea, however I need to be able to update the column based on possible user input

insert into names (name,shortname) values ('Robert Louis Stevenson','Bob')
resolves "Robert Louis Stevenson" - "Bob"

insert into names (name) values ('Robert Louis Stevenson')
resolves "Robert Louis Stevenson" - "Robert "

Any other ideas?

Thanks

Mike

<div>
Solution did not fully solve the problem but no other solutions were given.
</div>


Solution did not fully solve the problem but no other solutions were given.

<div>
<div class="content wysiwyg-content">
Is there any way to create a column that defaults to a substring of another column?<br />
<br />
create table names (<br />
name varchar(256) not null,<br />
shortname varchar(7) not null default substring(name,1,7)<br />
)<br />
<br />
Thanks<br />
<br />
Mike
</div>
</div>


Is there any way to create a column that defaults to a substring of another column?

create table names (
name varchar(256) not null,
shortname varchar(7) not null default substring(name,1,7)
)

Thanks

Mike

MySQL Substring Default

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.