gistfile1.txt

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database bagoshite;
Query OK, 1 row affected (0.02 sec)

mysql> use bagoshite
Database changed

mysql> create table pileopoo (turd varchar(10));
Query OK, 0 rows affected (0.12 sec)

mysql> insert into pileopoo(turd) values ("MySQL MySQL MySQL MySQL");
Query OK, 1 row affected, 1 warning (0.04 sec)

mysql> select * from pileopoo;
+------------+
| turd       |
+------------+
| MySQL MySQ |
+------------+
1 row in set (0.00 sec)

mysql> drop table pileopoo;
Query OK, 0 rows affected (0.05 sec)

mysql> create table pileopoo (turd date);
Query OK, 0 rows affected (0.10 sec)

mysql> insert into pileopoo(turd) values ('2039-100-100');
Query OK, 1 row affected, 1 warning (0.02 sec)

mysql> select * from pileopoo;
+------------+
| turd       |
+------------+
| 0000-00-00 |
+------------+
1 row in set (0.01 sec)