MySQL is breaking my head

  • aleguia
  • Student
  • Student
  • aleguia
  • Posts: 67

Post 3+ Months Ago

Wowww!!!!!! That SQL stuff is being really hard to me!!! Maybe i'm not that smart guy anymore!

I'm trying to learn some SQL ONLY, only and Only to can Setup and OSCommerce Webstore.

Is there an easier way??

Can I do the database in Access 2002 to work it then in PHP?

:oops:
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Sabu
  • Beginner
  • Beginner
  • Sabu
  • Posts: 47

Post 3+ Months Ago

Buy "learn SQL in 21 days"
"SQL for dummies"

Or.. gather as many sample scripts as you can and learn through example.

oh, and
Quote:
some SQL ONLY, only and Only to can Setup and OSCommerce

What does THAT mean?
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

Ummm i don't know if you know this but I thought I would clear it up

MySQL is NOT SQL.

SQL is a standard set of instructions used to communicate with a SQL compliant database.

So the same statements should (theoretically) work on MySQL, Postgres, MS SQL etc
  • suzie
  • Guru
  • Guru
  • User avatar
  • Posts: 1134
  • Loc: England

Post 3+ Months Ago

Thanks for the explanation rabid dog !
suzie.
:)
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

aleguia wrote:

Can I do the database in Access 2002 to work it then in PHP?

:oops:


As far as I understand you want to build the database using access 2002 and have PHP retrieve records from it?

This can be done. just set up an ODBC connection for the PHP code.
  • rtm223
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 1855
  • Loc: Uk

Post 3+ Months Ago

Rabid dog is right, but if it is SQL giving you a headache, switching databases will not help.

SQL isn't really that bad. It's mildly confusing if you are trying to think in terms of a procedural programming language, because it isn't. But in terms of structure and commands, it's mostly quite simple when you get the hang of it


//Just to be super-pedantic, SQL does have dialects, so certain codes will need to be "tweaked" for portability, but apart from that it's a standard language.
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

rtm223 wrote:
Just to be super-pedantic, SQL does have dialects, so certain codes will need to be "tweaked" for portability, but apart from that it's a standard language.


Thats why I said theoreticaly, because we all know that in practise it is a different story :wink:
  • rtm223
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 1855
  • Loc: Uk

Post 3+ Months Ago

well ok, I'll let you off then :P hehe

TBH, I'm not even sure why I posted that. I think I was pointing out that the differences are <i>really</i> minor, like wildcards and stuff.

Post Information

  • Total Posts in this topic: 8 posts
  • Users browsing this forum: No registered users and 160 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.