Mysql数据库基础操作

基本操作

#数据库
CREATE DATEBASE Stu
USE Stu
DROP DATABASE Stu
SHOW DATABASES

#数据表
SHOW TABLES
CREATE TABLE IF NOT EXISTS studnts(
	Id int(8) NOT NULL PRIMARY KEY,
	name varchar(20) NOT NULL,
	status tinyint(1) NOT NULL DEFAULT 1
	
);
DROP TABLE students
DESC students
#删除
DELETE FROM goods WHERE id=1 #id IN[1,2,3]
							 ORDER BY 
UPDATE goods SET price=300 WHERE price<300

SELECT id,name FROM goods
 WHERE name LIKE '%小米%'

Navicat