mysql> insert into user values (3,select name *from person,'');
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 'select name *from person,'')' at line 1
mysql> insert into user values (3,select name from person,'');
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 'select name from person,'')' at line 1
mysql> insert into user (userid,username,password) values (3,select name from person,'');
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 'select name from person,'')' at line 1
mysql> select name from person;
+----------+
| name |
+----------+
| Divide |
| s撒啊 |
| 苏东坡 |
| 苏东坡 |
| 苏东坡 |
| sasasasa |
| sasasasa |
+----------+
7 rows in set
mysql> select name,sysdate from person;
1054 - Unknown column 'sysdate' in 'field list'
mysql> insert into user (username) values (select name from person;
);
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 'select name from person' at line 1
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 ')' at line 1;
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 'select name from person' at line 1
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 ')' at line 1
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 '1064 - You have an error in your SQL syntax' at line 1
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 'the manual that corresponds to your MySQL server version for the right syntax to' at line 1
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 'the manual that corresponds to your MySQL server version for the right syntax to' at line 1
mysql> insert into user(username) value(select name from person)
;
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 'select name from person)' at line 1;
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 'select name from person)' at line 1
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 '1064 - You have an error in your SQL syntax' at line 1
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 'the manual that corresponds to your MySQL server version for the right syntax to' at line 1
mysql> insert into user(username) values
(select name from person);
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 'select name from person)' at line 1;
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 'select name from person)' at line 2
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 '1064 - You have an error in your SQL syntax' at line 1
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 'the manual that corresponds to your MySQL server version for the right syntax to' at line 1
mysql> insert into user(username) values ("wq");
Query OK, 1 row affected
mysql> insert into user(username) values (select name from person
);
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 'select name from person)' at line 1;
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 'select name from person
)' at line 1
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 '1064 - You have an error in your SQL syntax' at line 1
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 'the manual that corresponds to your MySQL server version for the right syntax to' at line 1
mysql> insert into user(username)
select name from person;
Query OK, 7 rows affected
Records: 7 Duplicates: 0 Warnings: 0;
Query OK, 7 rows affected
Records: 7 Duplicates: 0 Warnings: 0
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 'Query OK, 7 rows affected
Records: 7 Duplicates: 0 Warnings: 0' at line 1
mysql> insert into user(userid,username) values ( '1',(select name from person));
1242 - Subquery returns more than 1 row
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 'select name *from person,'')' at line 1
mysql> insert into user values (3,select name from person,'');
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 'select name from person,'')' at line 1
mysql> insert into user (userid,username,password) values (3,select name from person,'');
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 'select name from person,'')' at line 1
mysql> select name from person;
+----------+
| name |
+----------+
| Divide |
| s撒啊 |
| 苏东坡 |
| 苏东坡 |
| 苏东坡 |
| sasasasa |
| sasasasa |
+----------+
7 rows in set
mysql> select name,sysdate from person;
1054 - Unknown column 'sysdate' in 'field list'
mysql> insert into user (username) values (select name from person;
);
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 'select name from person' at line 1
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 ')' at line 1;
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 'select name from person' at line 1
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 ')' at line 1
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 '1064 - You have an error in your SQL syntax' at line 1
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 'the manual that corresponds to your MySQL server version for the right syntax to' at line 1
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 'the manual that corresponds to your MySQL server version for the right syntax to' at line 1
mysql> insert into user(username) value(select name from person)
;
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 'select name from person)' at line 1;
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 'select name from person)' at line 1
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 '1064 - You have an error in your SQL syntax' at line 1
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 'the manual that corresponds to your MySQL server version for the right syntax to' at line 1
mysql> insert into user(username) values
(select name from person);
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 'select name from person)' at line 1;
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 'select name from person)' at line 2
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 '1064 - You have an error in your SQL syntax' at line 1
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 'the manual that corresponds to your MySQL server version for the right syntax to' at line 1
mysql> insert into user(username) values ("wq");
Query OK, 1 row affected
mysql> insert into user(username) values (select name from person
);
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 'select name from person)' at line 1;
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 'select name from person
)' at line 1
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 '1064 - You have an error in your SQL syntax' at line 1
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 'the manual that corresponds to your MySQL server version for the right syntax to' at line 1
mysql> insert into user(username)
select name from person;
Query OK, 7 rows affected
Records: 7 Duplicates: 0 Warnings: 0;
Query OK, 7 rows affected
Records: 7 Duplicates: 0 Warnings: 0
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 'Query OK, 7 rows affected
Records: 7 Duplicates: 0 Warnings: 0' at line 1
mysql> insert into user(userid,username) values ( '1',(select name from person));
1242 - Subquery returns more than 1 row
mysql>
后来才知道,查询数据要被()包起来