Insert single quotation mark by using the double quote

Insert single quotation mark by using the double quote : Quotation Mark : Insert Update Delete MySQL TUTORIALS

MySQL TUTORIALS » Insert Update Delete » Quotation Mark »

Insert single quotation mark by using the double quote


mysql>
mysql> CREATE TABLE Employee(
    ->     id            int,
    ->     first_name    VARCHAR(15),
    ->     last_name     VARCHAR(15),
    ->     start_date    DATE,
    ->     end_date      DATE,
    ->     salary        FLOAT(8,2),
    ->     city          VARCHAR(10),
    ->     description   VARCHAR(15)
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql>
mysql>
mysql> select * from Employee;
Empty set (0.00 sec)

mysql>
mysql>
mysql> Insert into employee (first_name)value("Keith's");
Query OK, 1 row affected (0.00 sec)

mysql>
mysql>
mysql> select * from Employee;
+------+------------+-----------+------------+----------+--------+------+-------------+
| id   | first_name | last_name | start_date | end_date | salary | city | description |
+------+------------+-----------+------------+----------+--------+------+-------------+
| NULL | Keith's    | NULL      | NULL       | NULL     |   NULL | NULL | NULL        |
+------+------------+-----------+------------+----------+--------+------+-------------+
1 row in set (0.00 sec)

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

mysql>
mysql>