CodeHint


MySQL (5 items)


There is no links at all!


    SELECT
SELECT * FROM posts
  Edit
mysqldump -u root -p -venqKc --single-transaction --routines --triggers mydb > mydb.sql

Exports database to sql format

  Edit
  Create log for each query
SET GLOBAL general_log=1;
SET GLOBAL general_log_file='/tmp/mylog.log';
SET GLOBAL log_output='file';
  Edit
  my.cnf Location
LINUX = /etc/my.cnf
MAC = /usr/local/etc/my.cnf
  Edit
  SELECT LAST_INSERT_ID()

Get last id

  Edit