CodeIgniter Forums
Help - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Help (/showthread.php?tid=10766)



Help - El Forum - 08-12-2008

[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 ''


Help - El Forum - 08-12-2008

[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.