INSERT INTO ... SELECT

I have to copy some records from one table into the same table is it posible? my sql is like this: INSERT INTO equipamento_componentes (cod_equipamento_componentes, cod_tipo, numero, data_colocacao, cod_componente) SELECT '', 'C', 65, NOW(), EQ.cod_componente FROM equipamento_componentes EQ WH

uppercase field constraints

can i create a constraint to a field so that every data entered to that field (string) be stored in uppercase, if is posible can anybody give me an example or point me to a link with documentation. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib