Posted by lampinterview on May 14, 2008
A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types are TINYBLOB, BLOB,
MEDIUMBLOB, and LONGBLOB. These differ only in the maximum length of the values they can hold. The four TEXT types are
TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. BLOB columns are treated as binary strings (byte strings).
TEXT columns are treated as non-binary strings (character strings). BLOB columns have no character set, and sorting
and comparison are based on the numeric values of the bytes in column values. TEXT columns have a character set, and
values are sorted and compared based on the collation of the character set.
Posted in MYSQL | Tagged: MYSQL | No Comments »
Posted by lampinterview on May 14, 2008
Yes,easyphp include webserver,php and mysql
Posted in MYSQL | Tagged: MYSQL | 1 Comment »
Posted by lampinterview on May 14, 2008
mysql_create_db() is used to create database in mysql.
Posted in MYSQL | Tagged: MYSQL | No Comments »
Posted by lampinterview on May 14, 2008
Use set_time_limit() php function for setting up execution mysql time limit.
Posted in MYSQL, PHP | Tagged: Execution time, MYSQL, PHP | 2 Comments »
Posted by lampinterview on May 14, 2008
You can use prepare() execute method or auto execute method in PEAR. It is just for quotes, but all the html characters to be stored in db.
Posted in MYSQL, PHP | Tagged: Double quotes, MYSQL, PEAR, PHP, Single quotes | 2 Comments »
Posted by lampinterview on May 7, 2008
– LIMIT
eg: select * from ‘tablename’ where ‘condition’ LIMIT 1;
Posted in MYSQL | Tagged: limit, MYSQL | No Comments »
Posted by lampinterview on May 7, 2008
– through DISTINCT function.
eg: select DISTINCT ‘fieldname’ from ‘tablename’ where ‘condition’
Posted in MYSQL | Tagged: DISTINCT, MYSQL, unique values | No Comments »
Posted by lampinterview on May 7, 2008
using mysql_insert_id() function.
Posted in MYSQL | Tagged: MYSQL, insert, mysql_insert_id | No Comments »
Posted by lampinterview on May 7, 2008
Posted in MYSQL | Tagged: binary, BLOB, MYSQL | No Comments »
Posted by lampinterview on May 7, 2008
The commands to know the structure of a table using MySQLÂ is DESCRIBE table_name;
Posted in MYSQL | Tagged: command, DESCRIBE table_name, MYSQL, PHP, structure, table | No Comments »