数据库mysql

• 创建数据库
  • CREATE DATABASE 数据库名;
• 删除数据库
  • drop database <数据库名>;
• 选择数据库
  • mysql -u root -p
  • Enter password:**
  • mysql> use RUNOOB;
  • Database changed
  • mysql>
• 数据类型
  • 如图

    

• 创建数据表
  • 实例
  • CREATE TABLE IF NOT EXISTS runoob_tbl(
  • runoob_id INT UNSIGNED AUTO_INCREMENT,
  • runoob_title VARCHAR(100) NOT NULL,
  • runoob_author VARCHAR(40) NOT NULL,
  • submission_date DATE,
  • PRIMARY KEY ( runoob_id )
  • )ENGINE=InnoDB DEFAULT CHARSET=utf8;
• 删除数据表
  • root@host# mysql -u root -p
  • Enter password:***
  • mysql> use RUNOOB;
  • Database changed
  • mysql> DROP TABLE runoob_tbl;
  • Query OK, 0 rows affected (0.8 sec)
  • mysql>
• 插入数据
  • INSERT INTO table_name ( field1, field2,...fieldN )
  • VALUES
  • ( value1, value2,...valueN );
• 查询数据
  • SELECT column_name,column_name
  • FROM table_name
  • [WHERE Clause]
  • [LIMIT N][ OFFSET M]
• 修改
  • UPDATE table_name SET field1=new-value1, field2=new-value2
  • [WHERE Clause]
• 删除
  • DELETE FROM table_name [WHERE Clause]