Help

[eluser]nandish[/eluser]
Am trying to create column in a table, the name of the column is key, but its not allowing to create,its a predefined variable or key in mysql


alter table tbl_users_log change hey Key varchar(40) NULL default ''

[eluser]arume[/eluser]

Code:

ALTER TABLE tbl_users_log CHANGE hey `Key` VARCHAR(40) NULL DEFAULT ''

But I don't recommend you that name. I advise you to use lower case letters and to choose a not predefined word.