SQL--Create

<title>Sql–create</title> Sql–create

• Database operation
  

  Create Dateabase test;use test;show databases;show CREATE database test;drop database test;

  Create database if not exists test;

• table Action
  

  use test; Create  table  user1  (ID int  not  null , username varchar  (
       
        not  
        null ) engine= InnoDB 
        default  Charset=utf8; 
       

  show tables;desc user1;select * from User1; 

• Character
  

  Create database if not EXISTS test character set Gbk;alter database test character set UTF8;

  Create Table default CHARSET=GBK;

  Show create TABLE user1;
  ALTER TABLE User1 character set UTF8;
  

  Create database if not EXISTS test character set GBK;
  ALTER DATABASE test character set UTF8;
  

  GBK Old write GTK no language t_t
  

SQL--Create