DESCRIBE table_name;… Read more

Use this for MySQL

SELECT COUNT(*) FROM table_name;… Read more

Here is how can you find the number of rows in a result set in PHP:

$result = mysql_query($any_valid_sql, $database_link);
$num_rows = mysql_num_rows($result);
echo “$num_rows rows found”;… Read more

SELECT CURDATE();
SELECT CURRENT_DATE();
SELECT CURTIME();
SELECT CURRENT_TIME();… Read more

The generic syntax for GRANT is as following

GRANT [rights] on [database] TO [username@hostname] IDENTIFIED BY [password]

Now rights can be:
a) ALL privilages
b) Combination of CREATE, DROP, SELECT, INSERT, UPDATE and DELETE etc.

We can grant rights on all databse by using *.* or some specific database by … Read more

The generic syntax for revoke is as following

REVOKE [rights] on [database] FROM [username@hostname]

The REVOKE statement enables system administrators to revoke privileges from MySQL accounts.

Now rights can be:
a) ALL privileges
b) Combination of CREATE, DROP, SELECT, INSERT, UPDATE and DELETE etc.

We can grant rights on all … Read more

CHAR is a fixed length data type. CHAR(n) will take n characters of storage even if you enter less than n characters to that column. For example, “Hello!” will be stored as “Hello! ” in CHAR(10) column.

VARCHAR is a variable length data type. VARCHAR(n) will take only the required … Read more

AES_ENCRYPT() and AES_DECRYPT()… Read more

string md5(string)

It calculates the MD5 hash of a string. The hash is a 32-character hexadecimal number.… Read more

The MySQL provides a LOAD DATA INFILE command. You can load data from a file. Great tool but you need to make sure that:

a) Data must be delimited
b) Data fields must match table columns correctly… Read more