July 08, 2012
Marking South migrations as new
How to mark some South migrations as new.
Entries tagged “databases”
June 15, 2012
Using tsql
How to use the tsql command.
April 09, 2011
Show MySQL Storage Engines
If you have ever wanted to know the storage engine type of every table in …
June 18, 2010
Change MySQL Database Encoding
To change MySQL table column encoding: ALTER TABLE artists CHANGE [fieldname] [fieldname] [fieldtype] CHARACTER SET …
August 17, 2009
Show MySQL Database Encoding
To get the current mysql database encoding, issue the following sql query: SHOW VARIABLES LIKE …
June 16, 2009
Storing an IP in MySQL
Summary Datatype:int(4) unsigned Storing IP:INET_ATON('192.168.1.39') Getting IP …