4.数据库表相关操作

1.创建表

CREATE TABLE News (
  id INT,
  category INT,
  title VARCHAR (256),
  author VARCHAR (32),
  tag VARCHAR (256),
  content TEXT,
  -- 存储大型文本
  creator VARCHAR (32),
  createdate TIMESTAMP,
  updator VARCHAR (32),
  updatedate TIMESTAMP,
  isdel SMALLINT
)