《MySQL必知必会》学习笔记

来源：互联网发布：php 整数求余数编辑：程序博客网时间：2024/05/18 12:02

文献：http://www.verydemo.com/demo_c152_i24040.html

MySQL必知必会学习笔记

chapter 01

SQL（发音为字母S-Q-L或sequel）是结构化查询语言（Structured Query Language）的缩写。
SQL是一种专门用来与数据库通信的语言。

chapter 02
mysql -u USER -p[PASSWORD] [-h HOST -P PORT]

chapter 03
show databases;
use DATABASE;
show tables;

desc TABLE = describe TABLE = show columns from TABLE;

show status;
show create database DATABASE;
show create table TABLE;
show grants;
show errors|warnings;
help show;

mysql> help show;
Name: 'SHOW'
Description:
SHOW has many forms that provide information about databases, tables,
columns, or status information about the server. This section describes
those following:

SHOW AUTHORS
SHOW {BINARY | MASTER} LOGS
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
SHOW CHARACTER SET [like_or_where]
SHOW COLLATION [like_or_where]
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where]
SHOW CONTRIBUTORS
SHOW CREATE DATABASE db_name
SHOW CREATE EVENT event_name
SHOW CREATE FUNCTION func_name
SHOW CREATE PROCEDURE proc_name
SHOW CREATE TABLE tbl_name
SHOW CREATE TRIGGER trigger_name
SHOW CREATE VIEW view_name
SHOW DA…………………………………………………………………………

0 0