MySQL: Fixing MySQL crashed tables in SSH command line
[code language=”sql”] mysqlcheck –auto-repair –check -u username -p dbpassword [/code]
Tag: PHP
MySQL: Get the next Auto increment id of a table
[code language=”php”] $result = mysql_query("SHOW TABLE STATUS LIKE ‘".$table_name."’ "); $row = mysql_fetch_array($result); $next_id = $row[‘Auto_increment’]; [/code]
MySQL: Fetching distinct records from table HAVING COUNT greater than 3
[code language=”sql”] SELECT city, COUNT(id) AS id FROM YourTable GROUP BY city HAVING COUNT(id) > 3 [/code]