MySQL simple operation statement

--MySQL Database operation
/* Create database */
Create database database_username;

/* Create table *
/*create table Table name  
Field name data type Set primary key
Field name data type Is it empty
*/
create table database_username (
Id int primary key,
Name varchar(20) not null,
age int not null,
sex varchar(2) not null
);

/* Add data */
/*insert into Table name The number （ID,NAME,age,sex） Corresponding fill in */
insert into database_username values(1,' Guan yu ',118,' male ');

insert into database_username values(2,' zhaoyun ',112,' male ');

/* Delete statements */
/*delete from Table name From where Field name =‘’   ---- Delete age as 112 Information about the year-old */
delete from database_username where age=112;

/* to update */
/*update Table name set Field name =‘’ From where Field name =‘’*/
update database_username set NAME=' Li Bai ' where Name=' Guan yu '
update database_username set age=100 where age=112;

/* Query statement */
/*select Query all from */
select * from database_username;

/*select Name from Table name Where to find Name =‘’ order（ Ascending order ） by Name */
select ID,NAME,age from database_username  where NAME=' Guan yu ' order by age;

/* Open the watch lock ( Insert... Directly into the table , Delete )*/
select * from  database_username for update;

/* year - month - Japan    when ： branch ： Second time period query */
select * from mes.rmp_msg_detail a 
where a.send_time between to_date('2018/10/18 16:46:00','yyyy-mm-dd hh24:mi:ss')
and to_date('2018/10/18 16:48:00','yyyy-mm-dd hh24:mi:ss');