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, 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, 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        |
+------+------------+-----------+------------+----------+--------+------+-------------+
row in set (0.00 sec)

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

mysql>
mysql>



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo Insert Update Delete
» Quotation Mark