MySQL Operation Note

1. Create a database

Create database 'db _ message ';

 

2. Create a data table
Code

Create table 'db _ message'. 't_ message '(
'Intmessageid' int not null AUTO_INCREMENT COMMENT 'id ',
'Strcontent' VARCHAR (500) not null comment' message content ',
Primary key ('intmessageid ')
) ENGINE = InnoDB;

3. insert data

Insert into 'db _ message'. 't_ message' ('intmessageid', 'strcontent') VALUES (NULL, '1st message ');

 

4. Batch insert data

 

Code

Replace into uchome_config (var, datavalue) VALUES ('sitename', 'xx net'), ('siteallurl', ''), ('template', 'green '), ('adminemail ', 'webmaster @ localhost: 100'), ('timeoffset', '8'), ('licensed ', '0'), ('destoginfo ', '0'), ('mibeiian ', ''), ('headercharset', '0'), ('allowrewrite', '0'), ('onlinehold ', '123 ')