Cloud with rain
0 and 1 serie, black on white
pulled card
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.

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?


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 (
Gioco: allenamento con la tastiera Strumenti di codifica/decodifica URI (%-encoding) e Base64 Strumenti di calcolo online per IP e Reti
Quiz game