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     

Hint. MySQL Server: If you are comparing FLOAT or DOUBLE columns with numbers that have decimals, you cannot use equality (=) comparisons. This problem is common in most computer languages because not all floating-point values can be stored with exact precision. In some cases, changing the FLOAT to a DOUBLE fixes this.
https://dev.mysql.com/doc/refman/5.7/en/problems-with-float.html?ff=nopfpls

MySQL : Which one of the following query is correct:

a) UPDATE table SET field1=3, field2=4 WHERE field0 = 10
b) UPDATE table SET field1=3 AND field2=4 WHERE field0 = 10





MySQL : Is the following statement correct?

CREATE TABLE new_table1 LIKE table1;



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






Mysql. Is there the difference between these two query?

INSERT INTO table1 (phone) VALUES (NULL);
INSERT INTO table1 (phone) VALUES ('');





Mysql. Is it possible to create index for view?



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