Following are the differences between mysql_fetch_array and mysql_fetch_object: mysql_fetch_array() -Returns a result row as an associated array or a regular array from database. mysql_fetch_object – Returns a result row as object from database.
A BLOB is a binary large object that can hold a variable amount of data. There are four types of BLOB – TINYBLOB BLOB MEDIUMBLOB and LONGBLOB They all differ…
LIKE and REGEXP operators are used to express with ^ and %. SELECT * FROM employee WHERE emp_name REGEXP "^b"; SELECT * FROM employee WHERE emp_name LIKE "%b";
No. SELECT VERSION(), CURRENT_DATE; SeLect version(), current_date; seleCt vErSiOn(), current_DATE; All these examples are same. It is not case sensitive.
Number of rows can be obtained by SELECT COUNT (user_id) FROM users;
The = , <>, <=, <, >=, >,<<,>>, <=>, AND, OR, or LIKE operators are used in column comparisons in SELECT statements.
UNIX_TIMESTAMP is the command which converts from MySQL timestamp to Unix timestamp FROM_UNIXTIME is the command which converts from Unix timestamp to MySQL timestamp.
% corresponds to 0 or more characters, _ is exactly one character in the LIKE statement.
Indexes are defined for the table by: SHOW INDEX FROM <tablename>;
LAST_INSERT_ID will return the last value assigned by Auto_increment and it is not required to specify the table name.