[SOLVED] Create Sequence

[june_c21]

hi, i got this error... anyone please help. thanks

 

SQL query:

 

CREATE SEQUENCE language_id_seq

 

MySQL said: 

 

#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 'SEQUENCE language_id_seq' at line 1

[tippy_102]

I don't think mySQL has SEQUENCE. You can set your field to AUTO_INCREMENT.

[roopurt18]

Google search:

http://www.google.com/search?hl=en&client=firefox-a&rls=com.ubuntu%3Aen-US%3Aofficial&hs=KBO&q=mysql+create+sequence&btnG=Search

 

According to the top couple hits, a sequence is an Oracle ID field that auto increments.  In MySQL you would do something like this:

 

  CREATE TABLE IF NOT EXISTS `users` (
    `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    # OTHER FIELDS
  )

 

Can you elaborate more on what you're trying to do?

[june_c21]

ok. i think i get what you mean. thanks again