MySQL Cheat Sheet, Cover all Basic MySQL Syntaxes, Quick Reference Guide by Examples: MySQL Programming Syntax Book, Syntax Table & Chart, Quick Study Workbook (Cheat Sheet Series)

About This Book
This book covers all basic MySQL syntaxes, almost each syntax entry lists a program example and result output. We can quickly reference the most helpful programming syntaxes, such as common command syntax, various function syntax, query statement syntax, database command syntax, datatable command syntax……; all these syntaxes are very useful for database administration.
We can take this book as a basic syntax manual because its entries are arranged alphabetically so that we can easily reference the important syntax.
Nowadays or in the future, the MySQL Syntax Book can provide great help for coding both in our study and our work.

Table of Contents

Syntax Chart
@variable syntax:
* syntax:
abs() syntax:
acos() syntax:
adddate() syntax:
addtime() syntax:
all syntax:
alter table … add column … syntax:
alter table … add primary key (…) syntax:
alter table … add unique(…) syntax:
alter table … change … syntax:
alter table … drop column … syntax:
alter table … modify… syntax:
alter table … rename to … syntax:
alter view … as select … syntax:
and syntax:
and… or… syntax:
and not… syntax:
any syntax:
as syntax:
asc syntax:
ascii syntax:
asin() syntax:
atan() syntax:
atan2() syntax:
auto_increment syntax:
avg() syntax:
between … and… syntax:
bigint() type syntax:
bin() syntax:
binary() syntax:
binary() type syntax:
bit() type syntax:
blob type syntax:
bool type syntax:
boolean type syntax:
call procedure syntax:
case syntax:
cast() syntax:
ceil() syntax:
ceiling() syntax:
char() syntax:
char() type syntax:
char_length() syntax:
character_length() syntax:
coalesce() syntax:
comment syntax:
concat() syntax:
concat_ws() syntax:
connection_id() syntax:
conv() syntax:
convert() syntax:
cos() syntax:
cot() syntax:
count() syntax:
create database if not exists … syntax:
create procedure syntax:
create table if not exists … syntax:
create view … as select … from … syntax:
curdate() syntax:
current_date() syntax:
current_time() syntax:
current_timestamp() syntax:
current_user() syntax:
curtime() syntax:
database() syntax:
date type syntax:
date() syntax:
date_add() syntax:
date_format() syntax:
date_sub() syntax:
datediff() syntax:
datetime() type syntax:
day() syntax:
dayname() syntax:
dayofmonth() syntax:
dayofweek() syntax:
dayofyear() syntax:
dec() type syntax:
decimal() type syntax:
default syntax:
degree() syntax:
delete from … where … syntax:
desc syntax:
describe table syntax:
distinct syntax:
div syntax:
double() type syntax:
drop database if exists … syntax:
drop procedure if exists procedure syntax:
drop table if exists … syntax:
enum() type syntax:
exists syntax:
exp() syntax:
explain … syntax:
extract() syntax:
field() syntax:
find_in_set() syntax:
float() type syntax:
float() type syntax:
floor() syntax:
from_days() syntax:
format() syntax:
grant syntax:
greatest() syntax:
group by … syntax:
having syntax:
hour() syntax:
if() syntax:
ifnull() syntax:
in syntax:
inner join syntax:
insert into … values (…) syntax:
instr() syntax:
int() type syntax:
integer type syntax:
is not null syntax:
is null syntax:
isnull() syntax:
……
……
year() syntax:
yearweek() syntax:

Appendix
MySQL Database Commands Chart
MySQL Table Commands Chart
MySQL Operation Commands Chart
MySQL Data Type Chart
MySQL Field Modifier Chart
MySQL System Function Chart
MySQL Numeric Function Chart
MySQL Datetime Function Chart
MySQL Complete Command Chart