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     

When we invoke the command "mysql":
shell> mysql -h host -u user -p our_password_visible
the good rule is not specify the password.
MySql asks to insert the password which are not visible:
shell> mysql -h host -u user -p
Enter password:********


Mysql. Is it possible to create index for view?


Mysql. There are three tables : table1, table2 e table3.
Each table has four fields: field1,field2,field3,field4

table1.field2: foreign key with table2.field1
table1.field3: foreign key with table3.field1
Is the query below correct?

SELECT
   table1.field1,
   table3.field2,
   table2.field2,
   table1.field4
FROM
   table1
LEFT JOIN table2 ON
   table1.field2 = table2.field1
LEFT JOIN table3 ON
   table1.field3 = table3.field1





MySQL : What the result is of the query

SELECT IF(3<2,2,3);







Mysql. These expressions are equivalent?

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
and
SHOW FULL PROCESSLIST ?





MySQL : Which one of the following operations is not correct:







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