Using encode function with insert statement : Insert « Insert Update Delete « MySQL Tutorial

1. MySQL Tutorial
2. Insert Update Delete
3. Insert

mysql>
mysql>
mysql> CREATE TABLE UserAccounts
    -> (
    ->    UserID SMALLINT NOT NULL PRIMARY KEY,
    ->    Password VARCHAR(20) NOT NULL
    -> );
Query OK, 0 rows affected (0.02 sec)

mysql>
mysql>
mysql> INSERT INTO UserAccounts VALUES (101, ENCODE('pw101', 'key101'));
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> select * from UserAccounts;
+--------+----------+
| UserID | Password |
+--------+----------+
|    101 | ?*       |
+--------+----------+
1 row in set (0.00 sec)

mysql>
mysql>
mysql> drop table UserAccounts;
Query OK, 0 rows affected (0.00 sec)

mysql>