All pastes #16331 Raw Edit

lug

public sql v1 · immutable
#16331 ·published 2005-06-29 15:02 UTC
rendered paste body
 CREATE TABLE `calendar` (`date_id` smallint( 6 ) unsigned NOT NULL AUTO_INCREMENT ,`date` date NOT NULL default '0000-00-00',`weekend` tinyint( 1 ) unsigned NOT NULL default '0',`holiday` tinyint( 1 ) unsigned NOT NULL default '0',`Y` smallint( 4 ) unsigned NOT NULL default '0',`M` tinyint( 2 ) unsigned NOT NULL default '0',`D` tinyint( 2 ) unsigned NOT NULL default '0',`WD` tinyint( 1 ) unsigned NOT NULL default '0',`W` tinyint( 2 ) unsigned NOT NULL default '0',PRIMARY KEY ( `date_id` ))## Dumping data for table 'calendar'#INSERT INTO `calendar` ( `date_id` , `date` , `weekend` , `holiday` , `Y` , `M` , `D` , `WD` , `W` )VALUES ("1", "2005-01-01", "1", "0", "2005", "1", "1", "6", "53")MySQL zwrócił komunikat: Dokumentacja#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `calendar` (`date_id`, `date`, `weekend`, `holiday`