MySQL

Different quote marks

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 53

Reputation: rouse is an unknown quantity at this point

Solved Threads: 1

rouse

Offline

Junior Poster in Training

Different quote marks

Nov 21st, 2008

I am new to MySQL and did not notice this before. In order to get the query to work I have to use two different quote marks. Notice that the single quotes on the left where I list the column names are from the keyboard key with the tilde `~ and the single quotes on the right are from the keyboard key with the double quotes ‘ “. This seems strange to me. What am I missing?
Thanks!

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE `indiant1_indiantreaty`.`events`
(`recordNum` INT (6) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'unique record number',
`Type` VARCHAR(20) NOT NULL COMMENT 'xxxxx Could be an enumeration',
`eventName` VARCHAR(255) NOT NULL COMMENT 'The name of event',
`aka` VARCHAR(255) NOT NULL COMMENT 'Another name of the event',
`DATE` DATE NOT NULL COMMENT 'Date of the event',
`site` VARCHAR(255) NOT NULL COMMENT 'site of the event',
`description` TINYTEXT NOT NULL COMMENT 'description of the event',
`Signers` VARCHAR(255) NOT NULL COMMENT 'A list of signers',
`links` VARCHAR(255) COMMENT 'A list of significant links of signer',
`extra1` VARCHAR(255) COMMENT 'Temporary extra column',
`extra2` VARCHAR(255) COMMENT 'Temporary extra column',
`extra3` VARCHAR(255) COMMENT 'Temporary extra column'
) ENGINE = MYISAM COMMENT = 'Indian Signers Table';
CREATE TABLE `indiant1_indiantreaty`.`events`
(`recordNum` INT (6) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'unique record number',
`Type` VARCHAR(20) NOT NULL COMMENT 'xxxxx Could be an enumeration',
`eventName` VARCHAR(255) NOT NULL COMMENT 'The name of event',
`aka` VARCHAR(255) NOT NULL COMMENT 'Another name of the event',
`date` DATE NOT NULL COMMENT 'Date of the event',
`site` VARCHAR(255) NOT NULL COMMENT 'site of the event',
`description` TINYTEXT NOT NULL COMMENT 'description of the event',
`Signers` VARCHAR(255) NOT NULL COMMENT 'A list of signers',
`links` VARCHAR(255) COMMENT 'A list of significant links of signer',
`extra1` VARCHAR(255) COMMENT 'Temporary extra column',
`extra2` VARCHAR(255) COMMENT 'Temporary extra column',
`extra3` VARCHAR(255) COMMENT 'Temporary extra column'
) ENGINE = MYISAM COMMENT = 'Indian Signers Table';

Last edited by peter_budo; Nov 28th, 2008 at 12:22 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Jan 2007

Posts: 24

Reputation: sasankasekhar is an unknown quantity at this point

Solved Threads: 3

sasankasekhar sasankasekhar is offline

Offline

Newbie Poster

Re: Different quote marks

Nov 22nd, 2008

1). You probably donot have the
`indiant1_indiantreaty` database
or
2). you already have the `events` table.

I ran your query and it showed no errors except for the database `indiant1_indiantreaty` didnot exist.

If it is case 1., create your database first, then execute the statement

If it is case 2. Drop table `event` and execute the query.

I hope I am correct and did not miss out anything.

Regards ...

IF SOMEONE FEELS THAT THEY HAD NEVER MADE A MISTAKE IN THEIR LIFE, THEN IT MEANS THEY HAD NEVER TRIED A NEW THING IN THEIR LIFE

•

Join Date: Dec 2007

Posts: 53

Reputation: rouse is an unknown quantity at this point

Solved Threads: 1

rouse

Offline

Junior Poster in Training

Re: Different quote marks

Nov 22nd, 2008

The query is valid. The issue is the type of single quotes you have to use. Can you see the difference between ` and ' in the query example?
When I just use ‘ throughout the query I get an invalid query. I hope that makes sense.