Slight mysql insert query error

Question

Importing from one table to another.. this errors.

INSERT INTO wp_users (DEFAULT, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_status, display_name)
SELECT ID, username, password, LOWER(username), email, company_url, date_added, '0', username
FROM user
WHERE ID BETWEEN 5000 to 10000;

I just don't want the ID inserted as it's auto-incremented in wp_users so I'm using "DEFAULT".

Error: #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 'DEFAULT, user_login, user_pass, user_nicename, user_email, user_url, user_regist' at line 1

Mahmoud Gamal · Accepted Answer · 2013-02-26 06:09:21Z

1

DEFAULT, user are reserved words in MySQL, escape them. Also the predicate BETWEEN should be BETWEEN ... AND ... not BETWEEN ... TO ...:

INSERT INTO wp_users (`DEFAULT`, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_status, display_name)
SELECT ID, username, password, LOWER(username), email, company_url, date_added, '0', username
FROM `user`
WHERE ID BETWEEN 5000 AND 10000;

edited Feb 26, 2013 at 6:09

answered Feb 26, 2013 at 6:04

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

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

13 Comments

Dave Over a year ago

Thanks, but still errors :(

#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 'to 10000' at line 4

Mahmoud Gamal Over a year ago

@Dave user also a reserved word, escape it.

Mahmoud Gamal Over a year ago

@Dave Sorry again, it is WHERE ID BETWEEN 5000 AND 10000; not WHERE ID BETWEEN 5000 to 10000;

Dave Over a year ago

No problem! Now a new error haha #1054 - Unknown column 'DEFAULT' in 'field list'

Mahmoud Gamal Over a year ago

@Dave - I am working on that, just give me some minutes please. Sorry.

|

Collectives™ on Stack Overflow

Slight mysql insert query error

1 Answer 1

13 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

13 Comments

Your Answer

Sign up or log in

Post as a guest

Related