Hi,
I have to make an insert from a table to another, example:
Insert into table1 (select * from table2)
If a field of table2 is empty or NULL, i'd like it to automatically insert the DEFAULT value.
I've tried it, but it doesn't work, the only way it inserts the DEFAULT is when i specify it in the INSERT statement, but i can't make it this way, i have to make a SELECT * because my tables have over than 400 fields.
Can you help me?
Thanks!
I have to make an insert from a table to another, example:
Insert into table1 (select * from table2)
If a field of table2 is empty or NULL, i'd like it to automatically insert the DEFAULT value.
I've tried it, but it doesn't work, the only way it inserts the DEFAULT is when i specify it in the INSERT statement, but i can't make it this way, i have to make a SELECT * because my tables have over than 400 fields.
Can you help me?
Thanks!