How do I insert a record in SQL with reserved word "from"?

Question

I am using CodeIgniter and I've noticed that one of our fields is named "from" because the table is for saving emails. So someone used "from" which is a reserved word from database.

I've used

$this->db->query("INSERT INTO email_setting (client_id, [from], created_by) VALUES (9251 , 'mjmsample@gmail.com', 1)")

I've also tried these codes

$this->db->query("INSERT INTO email_setting e (e.client_id, e.from, e.created_by) VALUES (9251 , 'mjmsample@gmail.com', 1)")

$this->db->query("INSERT INTO email_setting ('client_id', 'from', 'created_by') VALUES (9251 , 'mjmsample@gmail.com', 1)")

All of these but no luck, is there any workaround this?

Using backticks permits you to use reserved text and space characters. — Praveen Kumar Purushothaman, May 03 '16 at 09:26

score 4 · Accepted Answer · answered May 03 '16 at 09:24

4

I don't understand why people never use backticks!

INSERT INTO `email_setting` `e` (`e`.`client_id`, `e`.`from`, `e`.`created_by`)

answered May 03 '16 at 09:24

Praveen Kumar Purushothaman

164,888
24
203
252

@fvu Which one buddy? – Praveen Kumar Purushothaman May 03 '16 at 09:25
the `"` one, which is standard (` is MySQL specific) – fvu May 03 '16 at 09:27
@fvu Ah yeah... But this is for MySQL. So backticks are the best. `:)` – Praveen Kumar Purushothaman May 03 '16 at 09:27
how to solve when insertion is done through spark dataframe having reserved keyword in dataframe ?? – supernatural Feb 28 '20 at 06:26
@potterpod What's spark dataframe? Oh, this is PHP & MySQL. Not Java & SparkQL. – Praveen Kumar Purushothaman Feb 28 '20 at 09:37

Sanooj T · Answer 2 · 2016-05-03T09:30:59.480

1

 Use `` backtick symbol to use reserved keyword in mysql.It is a good practice to add backtick to all fields. 

USE `from` with backtick instead of 'from' with single quotes.

 $this->db->query("INSERT INTO email_setting (`client_id`, `from`, `created_by`) VALUES (9251 , 'mjmsample@gmail.com', 1)"

edited May 03 '16 at 09:30

answered May 03 '16 at 09:25

Sanooj T

1,317
1
14
25

score 0 · Answer 3 · edited May 03 '16 at 10:28

0

You need to use backtick(`) quotes instead of '

edited May 03 '16 at 10:28

beerwin

9,813
6
42
57

answered May 03 '16 at 09:27

Valery K.

147
1
5

score 0 · Answer 4 · answered May 03 '16 at 09:29

You need to use back ticks for MySQL reserved keywords:

$this->db->query("INSERT INTO `email_setting` (`client_id`, `from`, `created_by`) VALUES (9251 , 'mjmsample@gmail.com', 1)")

It's a good habit to use back ticks for all MySQL-related names such as table names and columns.

How do I insert a record in SQL with reserved word "from"?

4 Answers4