Question: I am trying to insert a column with column name 00:18:e7:f9:65:a6 with the statement

```
ALTER IGNORE TABLE tblwifi_information ADD "00:18:e7:f9:65:a6" INT 

```

...but it throws an error:

```
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"00:18:e7:f9:65:a6" INT' at line 1 */

```

in Heidi SQL. I am using MySQL database.

When I try to add the column manually b going to the structure of the table it works and does not give any error but when I run this statement it does not allow me. How can I solve this?

Answer: 
I just ran your query: 

```
ALTER IGNORE TABLE tblwifi_information ADD "00:18:e7:f9:65:a6" INT 

```

and got the same error. I then ran:

```
ALTER IGNORE TABLE tblwifi_information ADD `00:18:e7:f9:65:a6` INT 

```

and it worked. Pretty sure you need to change " to `

Fail with double qoutes:
![Failed with double quotes](https://i.stack.imgur.com/qJ7VN.png)

Success with backticks:
![Success with backticks](https://i.stack.imgur.com/1DRNg.png)
To add something to the story, when querying multiple tables, you have to use following expression:

```
`tablename`.`columnname`

```

(NOT `tablename.columnname` )

I took me some time to figure it out, so I hope it helps someone :)

Example:

```
SELECT * 
FROM tb_product p
JOIN tb_brand b ON (  `p`.`tb_brand:IDbrand` =  `b`.`IDbrand` ) 
WHERE IDfamily = 2

```