# Error in MySQL

**URL:** <https://forum.kirupa.com/t/error-in-mysql/315362>\
**Category:** programming\
**Created:** [October 24, 2010, 6:13am UTC](https://forum.kirupa.com/t/error-in-mysql/315362 "2010-10-24T06:13:36Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![freshy](https://avatars.discourse-cdn.com/v4/letter/f/71c47a/32.png) [@freshy](https://forum.kirupa.com/u/freshy)\
**Post date:** [October 24, 2010, 6:13am UTC](https://forum.kirupa.com/t/error-in-mysql/315362/1 "2010-10-24T06:13:36Z")

</div>

I am using MySQL Server 5.1. I am practicing the exercise in Kirupa. I create a database - kirupa, and a table - users. I add the following in the query:

CREATE TABLE users (  
id INT NOT NULL AUTO\_INCREMENT PRIMARY KEY,  
name VARCHAR(70),  
location VARCHAR(20),  
date DATE NOT NULL  
);

I have this error:

Error 1064 (42000): 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’“Granville barnett”,location=“Bradford”,date=CURDATE()'at line2

after adding this:

INSERT INTO users SET  
name=”Granville Barnett”,  
location=”Bradford”,  
date=CURDATE();

What goes wrong ?