MySql Statements and clauses CheatSheet

Category:


MYSQL Statements and clauses

  1. ALTER DATABASE
  2. ALTER TABLE
  3. ALTER VIEW
  4. ANALYZE TABLE
  5. BACKUP TABLE
  6. CACHE INDEX
  7. CHANGE MASTER TO
  8. CHECK TABLE
  9. CHECKSUM TABLE
  10. COMMIT
  11. CREATE DATABASE
  12. CREATE INDEX
  13. CREATE TABLE
  14. CREATE VIEW
  15. DELETE
  16. DESCRIBE
  17. DO
  18. DROP DATABASE
  19. DROP INDEX
  20. DROP TABLE
  21. DROP USER
  22. DROP VIEW
  23. EXPLAIN
  24. FLUSH
  25. GRANT
  26. HANDLER
  27. INSERT
  28. JOIN
  29. KILL
  30. LOAD DATA FROM MASTER
  31. LOAD DATA INFILE
  32. LOAD INDEX INTO CACHE
  33. LOAD TABLE...FROM MASTER
  34. LOCK TABLES
  35. OPTIMIZE TABLE
  36. PURGE MASTER LOGS
  37. RENAME TABLE
  38. REPAIR TABLE
  39. REPLACE
  40. RESET
  41. RESET MASTER
  42. RESET SLAVE
  43. RESTORE TABLE
  44. REVOKE
  45. ROLLBACK
  46. ROLLBACK TO SAVEPOINT
  47. SAVEPOINT
  48. SELECT
  49. SET
  50. SET PASSWORD
  51. SET SQL_LOG_BIN
  52. SET TRANSACTION
  53. SHOW BINLOG EVENTS
  54. SHOW CHARACTER SET
  55. SHOW COLLATION
  56. SHOW COLUMNS
  57. SHOW CREATE DATABASE
  58. SHOW CREATE TABLE
  59. SHOW CREATE VIEW
  60. SHOW DATABASES
  61. SHOW ENGINES
  62. SHOW ERRORS
  63. SHOW GRANTS
  64. SHOW INDEX
  65. SHOW INNODB STATUS
  66. SHOW LOGS
  67. SHOW MASTER LOGS
  68. SHOW MASTER STATUS
  69. SHOW PRIVILEGES
  70. SHOW PROCESSLIST
  71. SHOW SLAVE HOSTS
  72. SHOW SLAVE STATUS
  73. SHOW STATUS
  74. SHOW TABLE STATUS
  75. SHOW TABLES
  76. SHOW VARIABLES
  77. SHOW WARNINGS
  78. START SLAVE
  79. START TRANSACTION
  80. STOP SLAVE
  81. TRUNCATE TABLE
  82. UNION
  83. UNLOCK TABLES
  84. USE
  85. String Functions

  86. AES_DECRYPT
  87. AES_ENCRYPT
  88. ASCII
  89. BIN
  90. BINARY
  91. BIT_LENGTH
  92. CHAR
  93. CHAR_LENGTH
  94. CHARACTER_LENGTH
  95. COMPRESS
  96. CONCAT
  97. CONCAT_WS
  98. CONV
  99. DECODE
  100. DES_DECRYPT
  101. DES_ENCRYPT
  102. ELT
  103. ENCODE
  104. ENCRYPT
  105. EXPORT_SET
  106. FIELD
  107. FIND_IN_SET
  108. HEX
  109. INET_ATON
  110. INET_NTOA
  111. INSERT
  112. INSTR
  113. LCASE
  114. LEFT
  115. LENGTH
  116. LOAD_FILE
  117. LOCATE
  118. LOWER
  119. LPAD
  120. LTRIM
  121. MAKE_SET
  122. MATCH    AGAINST
  123. MD5
  124. MID
  125. OCT
  126. OCTET_LENGTH
  127. OLD_PASSWORD
  128. ORD
  129. PASSWORD
  130. POSITION
  131. QUOTE
  132. REPEAT
  133. REPLACE
  134. REVERSE
  135. RIGHT
  136. RPAD
  137. RTRIM
  138. SHA
  139. SHA1
  140. SOUNDEX
  141. SPACE
  142. STRCMP
  143. SUBSTRING
  144. SUBSTRING_INDEX
  145. TRIM
  146. UCASE
  147. UNCOMPRESS
  148. UNCOMPRESSED_LENGTH
  149. UNHEX
  150. UPPER
  151. Date and Time Functions

  152. DDDATE
  153. ADDTIME
  154. CONVERT_TZ
  155. CURDATE
  156. CURRENT_DATE
  157. CURRENT_TIME
  158. CURRENT_TIMESTAMP
  159. CURTIME
  160. DATE
  161. DATE_ADD
  162. DATE_FORMAT
  163. DATE_SUB
  164. DATEDIFF
  165. DAY
  166. DAYNAME
  167. DAYOFMONTH
  168. DAYOFWEEK
  169. DAYOFYEAR
  170. EXTRACT
  171. FROM_DAYS
  172. FROM_UNIXTIME
  173. GET_FORMAT
  174. HOUR
  175. LAST_DAY
  176. LOCALTIME
  177. LOCALTIMESTAMP
  178. MAKEDATE
  179. MAKETIME
  180. MICROSECOND
  181. MINUTE
  182. MONTH
  183. MONTHNAME
  184. NOW
  185. PERIOD_ADD
  186. PERIOD_DIFF
  187. QUARTER
  188. SEC_TO_TIME
  189. SECOND
  190. STR_TO_DATE
  191. SUBDATE
  192. SUBTIME
  193. SYSDATE
  194. TIME
  195. TIMEDIFF
  196. TIMESTAMP
  197. TIMESTAMPDIFF
  198. TIMESTAMPADD
  199. TIME_FORMAT
  200. TIME_TO_SEC
  201. TO_DAYS
  202. UNIX_TIMESTAMP
  203. UTC_DATE
  204. UTC_TIME
  205. UTC_TIMESTAMP
  206. WEEK
  207. WEEKDAY
  208. WEEKOFYEAR
  209. YEAR
  210. YEARWEEK
  211. Mathematical and Aggregate Functions

  212. BS
  213. ACOS
  214. ASIN
  215. ATAN
  216. ATAN2
  217. AVG
  218. BIT_AND
  219. BIT_OR
  220. BIT_XOR
  221. CEIL
  222. CEILING
  223. COS
  224. COT
  225. COUNT
  226. CRC32
  227. DEGREES
  228. EXP
  229. FLOOR
  230. FORMAT
  231. GREATEST
  232. GROUP_CONCAT
  233. LEAST
  234. LN
  235. LOG
  236. LOG2
  237. LOG10
  238. MAX
  239. MIN
  240. MOD
  241. PI
  242. POW
  243. POWER
  244. RADIANS
  245. RAND
  246. ROUND
  247. SIGN
  248. SIN
  249. SQRT
  250. STD
  251. STDDEV
  252. SUM
  253. TAN
  254. TRUNCATE
  255. VARIANCE
  256. Flow Control Functions

  257. ASE
  258. IF
  259. IFNULL
  260. NULLIF
  261. Command-Line Utilities

  262. omp_err
  263. isamchk
  264. make_binary_distribution
  265. msql2mysql
  266. my_print_defaults
  267. myisamchk
  268. myisamlog
  269. myisampack
  270. mysqlaccess
  271. mysqladmin
  272. mysqlbinlog
  273. mysqlbug
  274. mysqlcheck
  275. mysqldump
  276. mysqldumpslow
  277. mysqlhotcopy
  278. mysqlimport
  279. mysqlshow
  280. perror
  281. Perl API - using functions and methods built into the Perl DBI with ySQL
  282. available_drivers
  283. begin_work
  284. bind_col
  285. bind_columns
  286. bind_param
  287. bind_param_array
  288. bind_param_inout
  289. can
  290. clone
  291. column_info
  292. commit
  293. connect
  294. connect_cached
  295. data_sources
  296. disconnect
  297. do
  298. dump_results
  299. err
  300. errstr
  301. execute
  302. execute_array
  303. execute_for_fetch
  304. fetch
  305. fetchall_arrayref
  306. fetchall_hashref
  307. fetchrow_array
  308. fetchrow_arrayref
  309. fetchrow_hashref
  310. finish
  311. foreign_key_info
  312. func
  313. get_info
  314. installed_versions

  315. ast_insert_id
  316. looks_like_number
  317. neat
  318. neat_list
  319. parse_dsn
  320. parse_trace_flag
  321. parse_trace_flags
  322. ping
  323. prepare
  324. prepare_cached
  325. primary_key
  326. primary_key_info
  327. quote
  328. quote_identifier
  329. rollback
  330. rows
  331. selectall_arrayref
  332. selectall_hashref
  333. selectcol_arrayref
  334. selectrow_array
  335. selectrow_arrayref
  336. selectrow_hashref
  337. set_err
  338. state
  339. table_info
  340. table_info_all
  341. tables
  342. trace
  343. trace_msg
  344. type_info
  345. type_info_all
  346. Attributes for Handles
  347. PHP API - using functions built into PHP with MySQL

  348. ysql_affected_rows
  349. mysql_change_user
  350. mysql_client_encoding
  351. mysql_close
  352. mysql_connect
  353. mysql_create_db
  354. mysql_data_seek
  355. mysql_db_name
  356. mysql_db_query
  357. mysql_drop_db
  358. mysql_errno
  359. mysql_error
  360. mysql_escape_string
  361. mysql_fetch_array
  362. mysql_fetch_assoc
  363. mysql_fetch_field
  364. mysql_fetch_lengths
  365. mysql_fetch_object
  366. mysql_fetch_row
  367. mysql_field_flags
  368. mysql_field_len
  369. mysql_field_name
  370. mysql_field_seek
  371. mysql_field_table
  372. mysql_field_type
  373. mysql_free_result
  374. mysql_get_client_info
  375. mysql_get_host_info
  376. mysql_get_proto_info
  377. mysql_get_server_info
  378. mysql_info
  379. mysql_insert_id
  380. mysql_list_dbs
  381. mysql_list_fields
  382. mysql_list_processes
  383. mysql_list_tables
  384. mysql_num_fields
  385. mysql_num_rows
  386. mysql_pconnect
  387. mysql_ping
  388. mysql_query
  389. mysql_real_escape_string
  390. mysql_result
  391. mysql_select_db
  392. mysql_stat
  393. mysql_tablename
  394. mysql_thread_id
  395. mysql_unbuffered_query

Comments (0)

Post a Comment