How does mysql and mysqli interfaces are different in PHP?
Filed under: MySQL Interview Questions, PHP Interview Questions
mysqli is the object-oriented version of mysql library functions.
So in object oriented PHP Programming mysqli is normally prefered
How do you start and stop MySQL service
Below are the command to start mysql database service on Windows
net start MySQL,
net stop MySQL
Below are the command to start mysql database service on Linux
/etc/init.d/mysql start
/etc/init.d/mysql stop
What are the differences between DROP a table and TRUNCATE a table?
DROP TABLE table_name – This will delete the table and its data.
TRUNCATE TABLE table_name – This will delete the data of the table, but not the table definition.
What is the difference between MyISAM Static and MyISAM Dynamic
MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record.