Category Archives: MySQL
Sequel Pro
Sequel Pro is a database management app for MySQL databases. Sequel Pro supports importing and exporting data from popular files including CSV and XML. Sequel Pro started as a fork of the abandoned CocoaMySQL project, with future plans to expand to other database engines including SQLite and PostgreSQL.
Reference: http://code.google.com/p/sequel-pro/
Adding CURRENT_TIMESTAMP into MySQL Table
ALTER TABLE mytable
ADD dt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
on update CURRENT_TIMESTAMP;