SQL syntax error in sql query

Question

I have this query:

SELECT `post`.`id` AS `posts_id,
       `categories`.`id` AS `category_id`,
       `title`,
       `contents`,
       `date_posted`,
       `categories`.`name
  FROM `post`
 INNER JOIN `categories` ON `categories`.`id` = `post`.`cat_id`

And it yields this 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:

'categories.idAScategory_id,title,contents,date_posted,cat' at line 1

Don't expect us to click links we can't trust - post (the relevant part of) the query here instead. EDIT: Just like Tomalak has done for you. — Widor
– Widor, Commented Sep 19, 2011 at 15:26

Kokos · Accepted Answer · 2011-09-19 15:26:18Z

1

You are missing backticks ` at various locations:

SELECT `post`.`id` AS `posts_id`, `categories`.`id` AS `category_id`,
    `title`,`contents`,`date_posted`,`categories`.`name`
    FROM `post`
    INNER JOIN `categories` ON `categories`.`id` = `post`.`cat_id`

answered Sep 19, 2011 at 15:26

Kokos

9,1715 gold badges29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dennefyren · Accepted Answer · 2011-09-19 15:26:49Z

1

You have forgotten to end "`".

Try this:

SELECT `post`.`id` AS `posts_id`, `categories`.`id` AS `category_id`,
        `title`,`contents`,`date_posted`,`categories`.`name`
        FROM `post`
        INNER JOIN `categories` ON `categories`.`id` = `post`.`cat_id`

answered Sep 19, 2011 at 15:26

Dennefyren

3441 gold badge2 silver badges9 bronze badges

Collectives™ on Stack Overflow

SQL syntax error in sql query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related