当前位置：网站首页>MySQL basic statement query

MySQL basic statement query

2022-04-23 13:06:00 【It's never too late to be alone】

Like a notebook , If you forget, check it out .

CREATE DATABASE teacher;// Create a database named teacher

DROP DATABASE student;// Delete student database 

CREATE TABLE teacher_name(
id INT(11),
name VARCHAR(25),
age INT(2)
);// stay teacher Create tables in the database teacher_name

DROP TABLE teacher_name;// Delete data table teacher_name

INSERT INTO teacher_name (id,name,age)
VALUES(002,' Teacher zhang ',23);// towards teacher_name Insert a piece of data into the table 

DELETE FROM teacher_name WHERE id = 001;// Delete teacher_name In the table id=001 The data of 

SELECT name = ' Teacher zhang ' from teacher_name;// Inquire about teacher_name  In the table name=  Mr. Zhang's data 

UPDATE teacher_name SET name = ' teacher ' WHERE name = ' Teacher he ';// take teacher_name In the table name= Mr. he revised into name =  teacher

版权声明
本文为[It's never too late to be alone]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204231303465691.html

边栏推荐

猜你喜欢

随机推荐