All pastes #609068 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-07-08 17:27 UTC
rendered paste body
 SQL query: Documentation

CREATE TABLE `columns_priv` (
`Host` char( 60 ) NOT NULL default '',
`Db` char( 64 ) NOT NULL default '',
`User` char( 16 ) NOT NULL default '',
`Table_name` char( 64 ) NOT NULL default '',
`Column_name` char( 64 ) NOT NULL default '',
`Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`Column_priv` set( 'Select', 'Insert', 'Update', 'References' ) NOT NULL default '',
PRIMARY KEY ( `Host` , `Db` , `User` , `Table_name` , `Column_name` )
)

MySQL said: Documentation
#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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Column_priv`