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)

By Mike Brook and Ray Yao

About This Book This book covers all basic MySQL syntaxes, it contains about 300 examples, 300 outputs and 300 explanations . 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 syntax dictionary 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 ( from a to z ) @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: and much more...... 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

• Format: Paperback
• Language: English
• ISBN: B0CRQ2XP69
• ISBN13: 9798874183479
• Release Date: January 2024
• Publisher: Independently published
• Length: 168 Pages
• Weight: 0.88 lbs.
• Dimensions: 9.7" x 0.4" x 7.4"