Strives for the bosses-CodePudding

INSERT INTO the administrator (job number, name, gender, telephone, home address, note)

VALUES (gender, names work # #, #, # # phone, # home address, # note)

Why tip # job number is invalid

CodePudding user response:

String VALUES inside with a ' 'single quotes,

CodePudding user response:

 
1 
 -INSERT INTO the administrator (job number, name, gender, telephone, home address, note) 

Work VALUES (' # # ', '#' name ', '#' gender, '#' phone, # 'home address' and '# note') 


- 2 or fetch the data from a table, the table is inserted into the administrator 
INSERT INTO the administrator (job number, name, gender, telephone, home address, note) 

Select job number, name, gender, telephone, home address, note the from list 

3 
 -INSERT INTO the administrator (job number, name, gender, telephone, home address, note) 

Select '# work #, name of' # ', '#' gender, '#' phone, # 'home address' and '# note'

CodePudding user response:

bosses

CodePudding user response:

refer to the second floor Yole response:

 
1 
 -INSERT INTO the administrator (job number, name, gender, telephone, home address, note) 

Work VALUES (' # # ', '#' name ', '#' gender, '#' phone, # 'home address' and '# note') 


- 2 or fetch the data from a table, the table is inserted into the administrator 
INSERT INTO the administrator (job number, name, gender, telephone, home address, note) 

Select job number, name, gender, telephone, home address, note the from list 

3 
 -INSERT INTO the administrator (job number, name, gender, telephone, home address, note) 

Select '# work #, name of' # ', '#' gender, '#' phone, # 'home address' and '# note'

Bosses

CodePudding user response:

Please each statement execution, one by one to solve the problem.