Content in SQL

• Drop All Tables in MySQL Database in One Step

  mysqldump -u[USERNAME] -p[PASSWORD] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql -u[USERNAME] -p[PASSWORD] [DATABASE]) echo 'SET foreign_key_checks = 0;'; (mysqldump
  4 views
• Finding duplicate items in sql table

  SELECT email, COUNT(email) AS NumOccurrences FROM User GROUP BY email HAVING ( COUNT(email) > 1 )==MySQL Query GROUP BY
  3 views
• Find and Replace text in the entire table using a MySQL query

  UPDATE table SET column = replace(column, 'old-text', 'new-text')
  6 views
• Update SELECT, Delete Select

  update content set param_b1 = 0,param_b2 = 1, param_i1 = 2 WHERE id IN ( SELECT * FROM (
  5 views
• Adding db user

  mysql> create database db_name; mysql> grant all on db_name.* to 'user'@'localhost' identified by 'password'; mysql> flush privileges;
  3 views
• Backup and restore mysql database

  mysqldump db_name -u root -p > file.sql mysql -u root -p db_name < file.sql
  4 views

SW development