摘要：
MariaDB表(CREATE,DROP,RENAME,ALTER)InnoDBis atransaction-safe engine (see Chapter 26, “Managing TransactionProcessing”). It does not support full-te... 阅读全文
posted @ 2016-03-19 21:17
李庆喜
阅读(298)
评论(0)
推荐(0)
摘要：
MariaDB INSERT,UPDATE,DELETEINSERT插入一整行(jlive)[crashcourse]>DESC customers;+--------------+-----------+------+-----+---------+----------------+| Fi... 阅读全文
posted @ 2016-03-19 20:50
李庆喜
阅读(366)
评论(0)
推荐(0)
摘要：
MariaDB Full-Text SearchingCREATE TABLE productnotes( note_id int NOT NULL AUTO_INCREMENT, prod_id char(10) NOT NULL, note_date... 阅读全文
posted @ 2016-03-19 19:52
李庆喜
阅读(319)
评论(0)
推荐(0)
摘要：
MariaDB Combined Queries(jlive)[crashcourse]>SELECT vend_id,prod_id, prod_price FROM products WHERE prod_price SELECT vend_id,prod_id, prod_price F... 阅读全文
posted @ 2016-03-19 19:37
李庆喜
阅读(71)
评论(0)
推荐(0)
摘要：
MariaDB JOIN JOIN两张表(jlive)[crashcourse]>SELECT vend_name,prod_name, prod_price FROM vendors, products WHERE vendors.vend_id = products.vend_idORDE... 阅读全文
posted @ 2016-03-19 15:46
李庆喜
阅读(237)
评论(0)
推荐(0)
摘要：
MariaDB Subqueryprod_id ==>order_num(jlive)[crashcourse]>SELECTorder_num FROMorderitems WHERE prod_id = 'TNT2';+-----------+| order_num |+---------... 阅读全文
posted @ 2016-03-19 15:26
李庆喜
阅读(120)
评论(0)
推荐(0)
摘要：
MariaDB Grouping(jlive)[crashcourse]>SELECT vend_id,COUNT(*) AS num_prods FROM products GROUP BY vend_idWITH ROLLUP;+---------+-----------+| vend_i... 阅读全文
posted @ 2016-03-19 14:14
李庆喜
阅读(236)
评论(0)
推荐(0)
摘要：
MariaDB 求和，最大值，最小值，平均数-----------------------------------------------Functions Description-----------------------------------------------AVG() Retu... 阅读全文
posted @ 2016-03-19 13:54
李庆喜
阅读(307)
评论(0)
推荐(0)
摘要：
MariaDB Text,Time,Numeric ManipulationFunction字符操作函数Commonly Used Text-Manipulation Functions---------------------------------------------------Fun... 阅读全文
posted @ 2016-03-19 13:18
李庆喜
阅读(103)
评论(0)
推荐(0)
摘要：
MariaDB Calculated Fields合并查询列(jlive)[crashcourse]>SELECTConcat(RTrim(vend_name), ' (', RTrim(vend_country), ')')AS vend_title FROM vendors ORDER B... 阅读全文
posted @ 2016-03-19 13:06
李庆喜
阅读(110)
评论(0)
推荐(0)
摘要：
MariaDB 正则匹配规则正则" title="MariaDB 正则">----------------------------------------------------------------Class Description-------------------------... 阅读全文
posted @ 2016-03-19 00:03
李庆喜
阅读(291)
评论(0)
推荐(0)
浙公网安备 33010602011771号