Set - 2

Question 6 :

What are ENUMs used for in MySQL?

Answer :

You can limit the possible values that go into the table. CREATE TABLE months (month ENUM 'January', 'February', 'March',…); INSERT months VALUES ('April');


Question 7 :

How are ENUMs and SETs represented internally?

Answer :

As unique integers representing the powers of two, due to storage optimizations.


Question 8 :

How do you start and stop MySQL on Windows?

Answer :

net start MySQL, net stop MySQL


Question 9 :

How do you start MySQL on Linux?

Answer :

/etc/init.d/mysql start


Question 10 :

Explain the difference between mysql and mysql interfaces in PHP?

Answer :

mysqli is the object-oriented version of mysql library functions.