MySQL implementation inserts data into a table

Use MySQL;
/ * Create raw data table * /
DROP TABLE IF EXISTS ' articleinfo ';
CREATE TABLE ' Articleinfo ' (
' id ' BIGINT UNSIGNED not NULL auto_increment PRIMARY KEY,
' title ' VARCHAR DEFAULT NULL,
' content ' VARCHAR DEFAULT NULL,
' Comment_time ' VARCHAR (DEFAULT NULL)
) Engine=innodb DEFAULT Charset=utf8 auto_increment=1;

/ * Create a stored procedure to add some data to the original data table * /
delimiter $$
drop procedure if exists proc_articleinfo;
CREATE PROCEDURE Proc_articleinfo ()
begin
declare i int;
set I=1;
While (i<=32) do
INSERT INTO Articleinfo (title,content,comment_time)
VALUES (concat (' Database Basics ', i), concat (' Learning Basics ', i%4), Date_format (now (), '%y-%m-%d%h:%i:%s '));

Set i=i+1;
End while;
End
$$
delimiter;

/* Call the stored procedure */
Call Proc_articleinfo ();

/ * Create a sub-table * /
DROP TABLE IF EXISTS ' tb_articleinfo_0 ';
CREATE TABLE ' tb_articleinfo_0 ' (
' id ' BIGINT UNSIGNED not NULL auto_increment PRIMARY KEY,
' title ' VARCHAR DEFAULT NULL,
' content ' VARCHAR DEFAULT NULL,
' Comment_time ' VARCHAR (DEFAULT NULL)
) Engine=myisam DEFAULT Charset=utf8 auto_increment=1;
CREATE TABLE ' tb_articleinfo_1 ' like ' tb_articleinfo_0 ';
CREATE TABLE ' tb_articleinfo_2 ' like ' tb_articleinfo_0 ';
CREATE TABLE ' tb_articleinfo_3 ' like ' tb_articleinfo_0 ';

/ * Create a Main Table * /
DROP TABLE IF EXISTS ' tb_articleinfo ';
CREATE TABLE ' Tb_articleinfo ' (
' id ' BIGINT UNSIGNED not NULL auto_increment,
' title ' VARCHAR DEFAULT NULL,
' content ' VARCHAR DEFAULT NULL,
' comment_time ' VARCHAR DEFAULT NULL,
index (' id ')
) Engine=mrg_myisam union= (' tb_articleinfo_0 ', ' tb_articleinfo_1 ', ' tb_articleinfo_2 ', ' tb_articleinfo_3 ') Insert_method=last DEFAULT Charset=utf8 auto_increment=1;

/* Insert data into sub-table */
Insert into Tb_articleinfo_0 (title,content,comment_time)
Select Title,content,comment_time from Articleinfo where id%4=0;

Insert into Tb_articleinfo_1 (title,content,comment_time)
Select Title,content,comment_time from Articleinfo where id%4=1;

Insert into Tb_articleinfo_2 (title,content,comment_time)
Select Title,content,comment_time from Articleinfo where id%4=2;

Insert into Tb_articleinfo_3 (title,content,comment_time)
Select Title,content,comment_time from Articleinfo where id%4=3;

Commit

/* Query Data */
SELECT * from Articleinfo;
SELECT * from Tb_articleinfo_0;
SELECT * from Tb_articleinfo_1;
SELECT * from Tb_articleinfo_2;
SELECT * from Tb_articleinfo_3;

MySQL implementation inserts data into a table