Cloud with rain
.:G
G:.
0 and 1 serie, black on white
pulled card
myjsp.feelinglinux.com
ver. 1.1.9-4
Hallo, welcome to my world.
Here you can find some stuff about computer science.
<<< Enjoy your visit! >>>
0 and 1 serie, white on black

QUIZ GAME: Database

            Written: Maryna Pylnyk, 18/03/2017     

MySQL Server: Did you know that you can check the common errors of MySQL, used the following command on shell?
shell> perror 126 127 132 134 135 136 141 144 145|grep MySQL

MySQL error code 126: Index file is crashed
MySQL error code 127: Record file is crashed
MySQL error code 132: Old database file
MySQL error code 134: Record was already deleted (or record file crashed)
MySQL error code 135: No more room in record file
MySQL error code 136: No more room in index file
MySQL error code 141: Duplicate unique key or constraint on write or update
MySQL error code 144: Table is crashed and last repair failed
MySQL error code 145: Table was marked as crashed and should be repaired
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html

Mysql. These expressions are equivalent?

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
and
SHOW FULL PROCESSLIST ?





Mysql. NULL is the same thing as an empty string ''?




MySQL : Which of these storage engine doesn't support TEMPORARY tables?





Mysql. We created a table "table1". I want to create TEMPORARY table with the same name - Can I do that?






Mysql. For synchronous data replication What would you use?







Advertisement


Is this article useful to you?
Share this article or put a "like" (top-right corner).
Thank you very much!


You need to enable the cookies and to accept the privacy policy to use the "share" and "like" functionalities.
Remove the cookie \"cookieconsent_status\" to change your choice.

 

Tools (myjsp.feelinglinux.com)
Gioco: allenamento con la tastiera Strumenti di codifica/decodifica URI (%-encoding) e Base64 Strumenti di calcolo online per IP e Reti
QUIZ GAME
Quiz game

Search @myjsp.feelinglinux.com

Advertisement