CREATE table if not EXISTS test(
id INT not NULL auto_increment ,
name VARCHAR ( 10 ) not null ,
age INT NOT null ,
sex CHAR ( 1 ) not null ,
PRIMARY KEY ( id)
)
CREATE table aaa LIKE test1;
CREATE table bbb as SELECT id, name , age from test1;
ALTER table test RENAME TO test1;
ALTER TABLE test1 MODIFY sex VARCHAR ( 10 ) NOT null ;
ALTER TABLE test1 CHANGE sex genered VARCHAR ( 10 ) NOT null ;
ALTER TABLE test1 ADD adress VARCHAR ( 20 ) NOT NULL ;
ALTER table test1 DROP adress;
DROP TABLE aaa;
drop table bbb;
INSERT into test1 VALUES (
5 , 'dfdsf' , 18 , 'sdfsd' , 'fsdsdf' )
INSERT INTO bbb select id, name, age from test1;
drop table stu;
TRUNCATE table t_student;
delete from test1 where id= 6 ;
UPDATE test1 set name= 'xzc' where id= 7 ;
UPDATE test1 set name= 'ls' , genered= 'hhh' where id= 5 ;
SELECT * from test1 ;
SELECT * from test1 where id> 6 and age> 30 ;
SELECT * from test1 where id> 7 or age> 20 ;
SELECT DISTINCT age from test1;