1 Topic by MattF (edited by MattF 2007-12-23 14:02)

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Topic: MySQL help needed

Just wondering if I could ask a favour of someone? smile I'm not too sure what the MySQL syntax for this dbupdate script would be, so is there any chance someone might be able to convert this PgSQL syntax to MySQL?

Thanks ever so much in advance..... big_smile

http://outgoing.bauchan.org/unix/downlo … update.txt


Edit: Wasn't sure if programming was the correct forum for this, so my apologies in advance if it's not. smile

MattF's Website

2 Reply by dmspilot00 (edited by dmspilot00 2007-12-23 23:34)

  • Registered: 2007-01-19
  • Posts: 24

Re: MySQL help needed

The only difference I can see is the SERIAL columns. The equivalent of "SERIAL" in MySQL is "INT NOT NULL AUTO_INCREMENT". However, you can't have more than one auto_increment column in one table in MySQL, so you'll have to change your disp_position to something else. Other than that it should work fine.

3 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: MySQL help needed

Cheers. That's a devil with the two auto increment bits ain't it. big_smile Thanks ever so much. smile

MattF's Website