database
minglotus
这个作者很懒,什么都没留下…
展开
-
数据库 PCC OCC
For isolation characteristic of transaction management in database, two mechanisms are used: PCC and OCC. PCC(Pessimistic Concurrency Control): get lock before access; application: competitive race原创 2015-05-11 17:42:08 · 1277 阅读 · 0 评论 -
One Importance Difference between Stored Procedure and Stored Function
Stored Function returns a single scalar value, not query results; while Stored Procedures return query results.原创 2015-05-23 11:24:18 · 251 阅读 · 0 评论 -
SQL script comment
use /**/ pairs原创 2015-05-23 11:39:37 · 219 阅读 · 0 评论 -
MySQL exit prompt when typing a wrong command
sometimes we meet with continuous mysql > mysql > in MySQL command line mode just type \c after the prompt is OK原创 2015-05-23 17:14:55 · 265 阅读 · 0 评论 -
Grant Super privilege to DB user
I grant all privilege on a database to a user, however, I still cannot carry out a stored procedure. The error information is Access denied: you need (at least one of) the SUPER privilegess for this原创 2015-05-23 12:18:08 · 489 阅读 · 0 评论 -
MySQL权限管理
sql的权限可以按照column来给原创 2015-05-23 21:15:08 · 226 阅读 · 0 评论 -
Php link to MySQL
how can php get ajax parameter? Connection failed on Mac OS X: php + MySQL: Error message: Warning: mysqli::mysqli():(HY000/2002):No such file or directory in /Library/WebServer/Documents/php/getDB原创 2015-05-24 08:37:01 · 330 阅读 · 0 评论 -
MySQL Database storage engine
I occasional knows that MySQL Database Storage Engine differs though they share a common database name. To see the storage engine of database, use show [storage] engines; command is okHere is my data原创 2015-05-24 18:57:57 · 374 阅读 · 0 评论 -
Error met at attempts to write stored procedure in MySQL[SOLVED]
Error Information: No database Selected Forget to pass database name parameter and company name parameter to my sql script原创 2015-05-23 11:23:59 · 210 阅读 · 0 评论 -
OS X Import data from local file to MySQL
Syntax: LOAD DATA LOCAL INFILE ‘absolute path’ INTO TABLE table-name FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’ IGNORE 1 ROWS; IF the local modifier原创 2015-05-23 17:30:56 · 275 阅读 · 0 评论 -
A new concept: dynamic SQL
dynamic SQL is a concept corresponding to static query.原创 2015-05-23 11:36:30 · 200 阅读 · 0 评论 -
MySQL Union
Syntax: select column1 [, column2] from table1[,table2] [where condition] union select column3 [, column4] from table3[,table4] [where condition] Usage Prerequisite: each table must have th原创 2015-05-22 22:27:17 · 346 阅读 · 0 评论 -
MySQL how to show table in a database
use show tables command; don’t forget to change to that database before use the command原创 2015-05-23 15:33:53 · 643 阅读 · 0 评论 -
Confusing conditions about MySQL script
after an error happens, I have to use \g to end a command line explicitly rather than just a semicolon; after modify a script and run it again, I will meet with Fail to open file xxx: error 2原创 2015-05-23 16:30:32 · 383 阅读 · 0 评论 -
Move vim cursor to a specific column
Try a number followed by a pipe to get to the specific column in that line.原创 2015-05-23 17:01:53 · 305 阅读 · 0 评论 -
MySQL the DATE, DATETIME and TIMESTAMP Types
The Date type is used for values with a data part but no time part, MySQL retrieves and displays DATE values in ‘YYYY-MM-DD’ format. The supported range is ‘1000-01-01’ to ‘9999-12-31’.The DATETIME typ原创 2015-05-23 16:48:15 · 278 阅读 · 0 评论 -
Two methods to show warning information in MySQL
Problem clarification:After executing a statement in MySQL, feedback information is Query OK, 0 rows affected, 7 warning (xxx.xx sec). However, it didn’t show any warning information.Solution: run s原创 2015-05-23 19:32:04 · 350 阅读 · 0 评论 -
Problem to be solved for MySQL create view
The select statement cannot contain a subquery in the from clause Then what if I need a list of contents from a subquery? Create a view or table I cannot really understand the following three原创 2015-05-23 20:46:55 · 343 阅读 · 0 评论 -
Use of delimiter on Stored Procedure in MySQL
not known yet. To be known further.原创 2015-05-23 11:03:21 · 236 阅读 · 0 评论 -
Word List for 5.24
plethora n.过多,过剩,过量 to be continued…原创 2015-05-24 16:44:43 · 266 阅读 · 0 评论