mysql insert value in column : int DEFAULT 0 causing error

Question

I am not able to find out what is the exact issue. When I remove index param from below mentioned query and try to insert the data it works fine, but trying to add index cause an error. Here is my table schema:

CREATE TABLE IF NOT EXISTS `address_list` (
  `email` varchar(100) NOT NULL,
  `currency_name` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `label` varchar(100) NOT NULL,
  `index` int DEFAULT 0,
  `address_type` varchar(50) NOT NULL,
  `balance` varchar(500) DEFAULT "0.0",
  `timestamp` TIMESTAMP default CURRENT_TIMESTAMP
)

and here is my insert query :

insert into address_list (email,currency_name,address,label,index,address_type) Values ('[email protected]','bitcoin','mgbtUQt7ppCEhxWmvicxrbEDYSom5kNk8X','test address',3,'wallet');

error :

ERROR 1064 (42000): 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 'index) Values ('[email protected]','bitcoin','mgbtUQt7ppCEhxWmvicxrbEDYSom5kNk8X'' at line 1

index is a reserved word, it needs to be quoted. Voting to close this question as a typo. — GMB
– GMB, Commented Nov 5, 2020 at 18:43
@GMB how is that a typo? surely it would be better to find an appropriate question to mark this a duplicate of — ysth
– ysth, Commented Nov 5, 2020 at 18:44

ysth · Accepted Answer · 2020-11-05 18:44:20Z

2

index is a reserved word in mysql; rename your column to something else, or else place it in backticks where you want to use it:

insert into address_list (email,currency_name,address,label,`index`,address_type) Values ('[email protected]','bitcoin','mgbtUQt7ppCEhxWmvicxrbEDYSom5kNk8X','test address',3,'wallet');

See https://dev.mysql.com/doc/refman/8.0/en/keywords.html

answered Nov 5, 2020 at 18:44

ysth

99.1k6 gold badges126 silver badges219 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql insert value in column : int DEFAULT 0 causing error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related