Hello
I created a sample table as shown in the images. The create table statement is given as –
Code:
CREATE TABLE `test` (
`id` int(11) NOT NULL default '0',
`name` char(20) default NULL,
`date_nasc` date default NULL,
PRIMARY KEY (`id`)) TYPE=MyISAM
Using the Insert/Update window of SQLyog, the following SQL scripts are generated –
Code:
insert into `test`.`test` ( `id`, `name`, `date_nasc` ) values ( '1', 'Luciano', NULL );
update `test`.`test` set `id`='2', `name`='Pitto', `date_nasc`=NULL where id='1';
This is what I expect. Please check the create table stmt. of your table. To set a columns value NULL, set the
focus on the column and press Alt+N.
BTW, which version of SQLyog you are using?