[codespook]

This is an easy one for those with more experience:) I decided tonight in my free time to start playing around. I installed apache on CentOS, then installed mysql. Created database on mysql. But when I try to create a table, it either gives me the > prompt again like it's waiting for something or gives me a syntax error. I looked on mysql's website, which would be the obvious, but I'm better at examples instead of what they have. But here is my code.

First I use USE test;

CREATE TABLE entries {
'id' int NOT NULL AUTO_INCREMENT, 'title' NOT NULL, 'date' date NOT NULL default '0000-00-00', 'title' NOT NULL, 'subject' NOT NULL, 'context' NOT NULL, 'PRIMARY KEY(id) };

I don't know if it is 100% needed to put the varchar() with the fields since it should be implied to put anything there. But maybe I'm wrong in this?

Maybe most people use phpmyadmin. But I want to do it from the command line. Thanks!

This post has been edited by macosxnerd101: 04 January 2013 - 11:40 PM
Reason for edit:: Code tags are BBCode, not XML. Please [code] Code goes here [/code]

[macosxnerd101]

The SQL Syntax uses parentheses instead of curly braces. Also, it is correct to put the varchar with the field definitions, as you are defining their types.

Also, formatting your code properly will make it easier to read (with the fix from braces to parentheses):

CREATE TABLE entries (
    'id' int NOT NULL AUTO_INCREMENT, 
    'title' NOT NULL, 
    'date' date NOT NULL default '0000-00-00', 
    'title' NOT NULL, 
    'subject' NOT NULL, 
    'context' NOT NULL, 
    'PRIMARY KEY(id) 
);

Beyond that, if you are encountering errors, please post them exactly as they appear.

[Dormilich]

it’s also a good idea to have a look at the appropriate Manual section. it might be somewhat confusing at first, but follows a definite logic.

@mac: are you sure ' are valid for column names?

This post has been edited by Dormilich: 05 January 2013 - 05:47 AM

[codespook]

I tried it with the () and also with and without the '. But still syntax error.
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 line 2

Thanks!

[codespook]

Fixed it. I forgot to put the varchar like it needs. ONce I did that and left out the ' it went fine:)
Thanks again!

[macosxnerd101]

Quote

@mac: are you sure ' are valid for column names?

I don't remember off the top of my head. I was just indenting code.

[Atli]

Dormilich, on 05 January 2013 - 12:46 PM, said:

@mac: are you sure ' are valid for column names?

For the record: No, they are not. Those are only used for values, not identifiers. Only the back-ticks, `, are valid quotes for identifiers. (Except when in ANSI_QUOTES mode, but that's not enabled by default.)