Interview Questions & Answers

This can be done in two ways... Open your "my.ini" (my.cnf in linux) file within the MySQL installation directory, and look for the text "sql-mode". Find: # Set the SQL mode to strict sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" Replace with: # Set the SQL mode to strict sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" Or, you can run an SQL query within your database management tool, such as phpMyAdmin: SET @global.sql_mode= ...

Chmod() is used for changing permissions on a file. Syntax: Chmod(file, mode) Mode here specifies the permissions as follows: * The first number is always zero * The second number specifies permissions for the owner * The third number specifies permissions for the owner's user group * The fourth number specifies permissions for everybody else Possible values (to set multiple permissions, add up the following numbers) * 1 = execute permissions * 2 = write permissions * 4 = read permissions Example: // everything for owner, read for owner's grou...