MySql Statements and clauses CheatSheet

Posted by test | Posted on 7:19 PM

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

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

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

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

  261. ASE
  262. IF
  263. IFNULL
  264. NULLIF
  265. Command-Line Utilities

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

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

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

Comments (0)

Post a Comment

Subscribe to: Post Comments (Atom)