SQL-创建表

例:

 

CREATE TABLE CUSTOMERS( 
   ID   INT              NOT NULL, 
   NAME VARCHAR (20)     NOT NULL, 
   AGE  INT              NOT NULL, 
   ADDRESS  CHAR (25) , 
   SALARY   DECIMAL (18, 2),        
   PRIMARY KEY (ID));

SHOW TABLES;

DESC customers;

posted @ 2022-05-07 18:18  `安安安安安  阅读(71)  评论(0)    收藏  举报