Remove everyting before last / slash in mysql
[code lang=”php”]UPDATE `table` SET `column` = SUBSTRING_INDEX(`column`,’/’,-1);[/code] From: AAA/BBB/CCC To: CCC
Tag: mysql
Copy one column from one table to another table column – MySql.
Copy one column from one table to another table column – MySql. [code language=”sql”] UPDATE `table` , `table_2` SET table_2.HQ_ID = table.HQ_ID WHERE table_2.name = table.name [/code]
MySQL: Duplicate id into other column in the same table in MySQL
Duplicate id into other column in MySQL. [code language=”sql”] UPDATE contest_cat SET pid = id [/code]
MySQL: Fixing MySQL crashed tables in SSH command line
[code language=”sql”] mysqlcheck –auto-repair –check -u username -p dbpassword [/code]
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]