A TLAs Complete the table in the library, using the parameters tables to specify
tables = Test.tb1.id.3
First create three structures to complete the same child table Tb1_0, Tb1_1, tb1_2
CREATE TABLE ' tb1_0 ' (
' id ' int () NOT NULL auto_increment,
' name ' varchar (255) DEFAULT null,
' age ' int (one) D Efault NULL,
PRIMARY KEY (' id ')
) Engine=innodb DEFAULT Charset=utf8;
Then use TB1 to insert
INSERT into TB1 values (9, ' a ',);
INSERT into TB1 values (ten, ' a ',);
INSERT into TB1 values (one, ' a ', 20);
Querying a child table, data has been taken by ID column table storage
MySQL [test]> SELECT * from Tb1_0;
+----+------+------+
| id | name | age |
+----+------+------+
| 9 | A | |
+----+------+------+
MySQL [test]> select * from Tb1_1;
+----+------+------+
| id | name | age |
+----+------+------+ | | |
+----+------+------+
MySQL [test]> select * from Tb1_2;
+----+------+------+
| id | name | age |
+----+------+------+
| | |
+----+------+------+
Primary Table Query
MySQL [test]> SELECT * from tb1 where ID =11;
+----+------+------+
| id | name | age |
+----+------+------+
| | 20 |
Limit
1, multirow Insert no table
MySQL [test]> INSERT INTO TB1 values (1, ' a ',), (2, ' B ', D), (3, ' C ',), (4, ' d ',), (5, ' E ',, (6, ' f ',), (7, ' G ', 20) , (8, ' h ',);
MySQL [test]> SELECT * from Tb1_1;
+----+------+------+
| id | name | age |
+----+------+------+
| 1 | A | |
| 2 | b | |
| 3 | C | |
| 4 | D | |
| 5 | E | |
| 6 | F | |
| 7 | G | |
| 8 | H | |
| 10 | A | |
+----+------+------+
2. Statements that do not add table fields are not supported
MySQL [test]> SELECT * from TB1;
ERROR 1146 (42S02): Table ' test.tb1 ' doesn ' t exist
select * from tb1 where name = ' a ';
ERROR 1146 (42S02): Table ' test.tb1 ' doesn ' t exist
MySQL [test]> select * from tb1 where age =;
ERROR 1146 (42S02): Table ' test.tb1 ' doesn ' t exist
MySQL [test]> update tb1 set age=30 where age =20;
ERROR 1146 (42S02): Table ' test.tb1 ' doesn ' t exist
MySQL [Test]<span id= "Transmark" ></span>> Delete from TB1 where age=20;
ERROR 1146 (42S02): Table ' test.tb1 ' doesn ' t exist
MySQL [test]> update tb1 set age=30;
ERROR 1105 (07000): Proxy warning-syntax Forbidden
3, after the update, the data will not move, still in the atomic table
MySQL [test]> Update tb1 set id=12 where ID =11;
MySQL [test]> SELECT * from Tb1_2;
+----+------+------+
| id | name | age |
+----+------+------+ | | |
+----+------+------+