Create table with "action" column

2 posts / 0 new
Last post
reflection
reflection's picture
Offline
Last seen: 3 weeks 2 days ago
Joined: May 15 2014
Junior Boarder

Posts: 2

Sam Chou
Create table with "action" column

Hi all,

Wanted to do something simple like this:

CREATE TABLE a ( `action` TINYINT UNSIGNED ) ENGINE=infinidb DEFAULT CHARSET=utf8;
CREATE TABLE a ( "action" TINYINT UNSIGNED ) ENGINE=infinidb DEFAULT CHARSET=utf8;

I think 'action' is a reserved word... so I tried escaping using the two statements above, but infinidb won't let me. Is there any recourse other than renaming my column?

Sam

radams
radams's picture
Offline
Last seen: 1 day 19 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Create table with "action" column

 

 

Hi,

 

'action' is a reserved word, you will need to change the column name.

 

Thanks,

 

Robert