Category: How to ?

Allow invalid date in MySQL

Just in case you absolutely have to insert a date in MySQL that does’nt exist, eg 2014-02-30, you can run MySQL server in a special mode that authorizes such dates : mysqld –sql-mode=”ALLOW_INVALID_DATES” MySQL will only check that the month is in the range from 1 to 12 and the day is in the range

Continue Reading →

Tmux for the impatient

New session : tmux Attach to a session : tmux a Detach : Ctrl+b d Scroll : Ctrl+b PgUp/PgDown (quit with q) also can use mouse after first page up or down Copy mode : Ctrl+b [ (quit with q) Split horizontally : Ctrl+b “ Split vertically : Ctrl+b % Switch pane : Ctrl+b arrow key Resize pane :

Continue Reading →