1.選擇數據庫 USE
剛鏈接到MySQL時，沒有數據庫打開供你使用，而我們需要選擇一個數據庫，才能進行以下的操作。
方法：USE語句
USE Mdatabase;
如此，才能打開數據庫，讀取其中的數據
2.顯示信息 SHOW
MySQL從內部表中提取信息
SHOW database;
返回可用數據庫的一個列表
SHOW tables;
返回數據庫內的表的列表
SHOW columns from table;
顯示表列
3.創建表 CREATE TABLE
基本語法：
//by LMY
CREATE DATABASE 數據庫名; /*創建數據庫*/
USE 數據庫名; /*連接數據庫*/
CREATE TABLE 表名1
(
列名1 數據類型 要求,
列名2 數據類型 要求,
列名3 數據類型 要求,
.......
PRIMARY KEY (主鍵) /*注意，此處沒有逗號*/
);
以我的數據庫作業作為栗子：
（環境，MySQL workbench）
要求：
創建一個名為”my_own_movie_database“的數據庫，之后，建如下幾個表，之后把相應輸入插入
首先，打開workbench，添加一個新的SQL文件
之后，在新的文件中寫入sql語句
寫入相應sql語句，寫完，你會在左側發現，有了一個新的數據庫，點進去，還可以看到你建的表
完整代碼如下：
drop database if exists `my_own_movie_database`;
create database `my_own_movie_database`;
USE `my_own_movie_database`;
CREATE TABLE `movieexec` (
`name` char(30) DEFAULT NULL,
`address` varchar(100) DEFAULT NULL,
`cert` int(11) NOT NULL DEFAULT "0
",
`netWorth` int(11) DEFAULT NULL,
PRIMARY KEY (`cert`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Data for table "movieexec"
#
INSERT INTO `movieexec` VALUES ("Calvin Coolidge","Fast Lane",123,20000000),("Merv Griffin","Riot Rd.",199,112000000),("Stephen Spielberg","123 ET road",222,100000000),("Ted Turner","Turner Av.",333,125000000),("George Lucas","Oak Rd.",555,200000000),("Jane Fonda","Turner Av.",567,200000000);
#
# Source for table "movies"
#
CREATE TABLE `studio` (
`name` char(30) NOT NULL DEFAULT "",
`address` varchar(100) DEFAULT NULL,
`presC` int(11) DEFAULT NULL,
PRIMARY KEY (`name`)
) ;
#
# Data for table "studio"
#
INSERT INTO `studio` VALUES ("MGM","MGM Boulevard",123),("Fox","Fox Boulevard",199),("Disney","Disney Boulevard",222),("USA Entertainm","USA Entertainm Boulevard",333),("Paramount","Paramount Boulevard",555);
CREATE TABLE `movies` (
`title` char(100) NOT NULL DEFAULT "",
`year` int(11) NOT NULL DEFAULT "0",
`length` int(11) DEFAULT NULL,
`movieType` char(10) DEFAULT NULL,
`studioName` char(30) ,
`producerC` int(11) DEFAULT NULL,
PRIMARY KEY (`title`,`year`),
foreign key(studioName) references studio(name) on delete cascade
) ;
#
# Data for table "movies"
#
INSERT INTO `movies` VALUES ("Empire Strikes Back",1980,111,"drama","Fox",555),("Gone With the Wind",1938,null,"drama","MGM",123),("Logan"s run",1977,120,"drama","MGM",888),("Pretty Woman",1990,119,"drama","Disney",999),("Star Trek",1979,132,"sciFic","Paramount",444),("Star Trek: Nemesis",2002,116,"sciFic","Paramount",321),("Star Wars",1977,124,"sciFic","Fox",555),("Terms of Endearment",1983,132,"drama","MGM",123),("The Man Who Wasn"t There",2001,116,"comedy","USA Entertainm",777),("The Usual Suspects",1995,106,"drama","MGM",999);
#
# Source for table "moviestar"
#
CREATE TABLE `moviestar` (
`name` char(30) NOT NULL DEFAULT "",
`address` varchar(255) DEFAULT NULL,
`gender` char(1) DEFAULT NULL,
`birthdate` date DEFAULT NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Data for table "moviestar"
#
INSERT INTO `moviestar` VALUES ("Alec Baldwin","Baldwin Av.","M","1977-06-07"),("Debra Winger","A way","F","1978-05-06"),("Harrison Ford","Prefect Rd.","M","1955-05-05"),("Jack Nicholson""s","X path","M","1949-05-05"),("Jane Fonda","Turner Av.","F","1977-07-07");
#
# Source for table "starsin"
#
CREATE TABLE `starsin` (
`movieTitle` char(100) NOT NULL DEFAULT "",
`movieYear` int(11) NOT NULL DEFAULT "0",
`starName` char(30) NOT NULL DEFAULT "",
PRIMARY KEY (`movieTitle`,`movieYear`,`starName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Data for table "starsin"
#
INSERT INTO `starsin` VALUES ("Empire Strikes Back",1980,"Harrison Ford"),("Star Wars",1977,"Carrie Fisher"),("Star Wars",1977,"Harrison Ford"),("Star Wars",1977,"Mark Hamill"),("Terms of Endearment",1983,"Debra Winger"),("Terms of Endearment",1983,"Jack Nicholson"),("The Usual Suspects",1995,"Kevin Spacey");
#
# Source for table "studio"
#
4.插入數據 INSERT
基本寫法：
INSERT INTO 表名1 VALUES (數據1，數據2，數據3.....),(數據1，數據2......)....；
最后，運行，快捷鍵：Ctrl +Shift+Enter
（這個地方我愣是到這門課都快學完了，才知道怎么運行…哭死了，前半學期裝不上軟件，后半學期天天迷為什么建不了表…）
建完表之后，可以看到，表中的內容
到此這篇關于MySQL語句匯總整理 的文章就介紹到這了,更多相關MySQL語句整理 內容請搜索服務器之家以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持服務器之家！
原文鏈接：https://blog.csdn.net/qq_52109814/article/details/121771413
