Different Databases?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Mr. Tech
Forum Contributor
Posts: 205
Joined: Tue Feb 11, 2003 4:18 pm
Location: Australia

Different Databases?

Post by Mr. Tech »

Hi!

Does all databases do the same thing when it somes to insertinf, showing etc. info from the database? For example, does all databases use this to select data:

Code: Select all

select this from that where this='$this' order by this
Thanks
User avatar
delorian
Forum Contributor
Posts: 223
Joined: Sun May 04, 2003 5:20 pm
Location: Olsztyn, Poland

Post by delorian »

Yes all, databases usign SQL to query the data. But some instuctions may be a BIT different in every RDBMS, so you always must check the documenation.
Mr. Tech
Forum Contributor
Posts: 205
Joined: Tue Feb 11, 2003 4:18 pm
Location: Australia

Post by Mr. Tech »

delorian wrote:Yes all, databases usign SQL to query the data. But some instuctions may be a BIT different in every RDBMS, so you always must check the documenation.
Thanks!

RDBMS? Whats that mean? Does all databases us SQL to query the data?

Thanks
User avatar
delorian
Forum Contributor
Posts: 223
Joined: Sun May 04, 2003 5:20 pm
Location: Olsztyn, Poland

Post by delorian »

Relationship Data Base Managment System or something like this.

No, not every database systems use SQL.
Mr. Tech
Forum Contributor
Posts: 205
Joined: Tue Feb 11, 2003 4:18 pm
Location: Australia

Post by Mr. Tech »

Thanks

So if I wanted to write a script that allows you to use different kinds of database, how would be the best way to do this?

Thanks again!
User avatar
delorian
Forum Contributor
Posts: 223
Joined: Sun May 04, 2003 5:20 pm
Location: Olsztyn, Poland

Post by delorian »

There isn't the best way. I can give you a piece of advice. Read the manual first (hint: search for ODBC php functions). Second, think about the script (input, output). Then write the mind map for the problem http://www.mind-mapping.com , think about it, write the script and test it. That's always work. :D
Mr. Tech
Forum Contributor
Posts: 205
Joined: Tue Feb 11, 2003 4:18 pm
Location: Australia

Post by Mr. Tech »

thx
Post Reply