Home > database >  SQL statements, big help.
SQL statements, big help.

Time:10-09

Field name age

CodePudding user response:

 insert into user_bak (name, age) select the name, age, from the user where id=delete id 
Delete from the user where id=delete id

CodePudding user response:

The
reference 1/f, February 16 response:
 insert into user_bak (name, age) select the name, age from the user where id=delete id 
The delete from the user where id=delete id

According to the syntax you wrote, error: 1064

CodePudding user response:

refer to the second floor qq_26763719 response:
Quote: reference 1/f, February 16 response:
 insert into user_bak (name, age) select the name, age, from the user where id=delete id 
The delete from the user where id=delete id

According to the syntax you wrote, error: 1064

You of wrong
  • Related