LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 01-30-2004, 04:06 PM   #1
286
Member
 
Registered: Nov 2003
Location: London
Distribution: SuSE
Posts: 130

Rep: Reputation: 15
Could anyone recommend me a book for MySQL study?


as tittle. I want to learn MySQL from very beginning. is there any nice book suitable for the people like me? thanks
 
Old 01-30-2004, 04:50 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,986
Blog Entries: 11

Rep: Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880
How about a good book on
PostgreSQL? :) Like learning
a "real SQL database" ;}

O'Reily, "Practical PostgreSQL"


Cheers,
Tink
 
Old 01-30-2004, 04:51 PM   #3
Crashed_Again
Senior Member
 
Registered: Dec 2002
Location: Atlantic City, NJ
Distribution: Ubuntu & Arch
Posts: 3,503

Rep: Reputation: 57
Is MySQL a figment of my imagination? Its not "real"?
 
Old 01-30-2004, 05:21 PM   #4
286
Member
 
Registered: Nov 2003
Location: London
Distribution: SuSE
Posts: 130

Original Poster
Rep: Reputation: 15
what is the difference between MySQL and PostgreSQL ? i see a lot books come with MySQL, and many websites contribute with MySQL. I m not familiar with PostgreSQL? can you give me a comparision between them? thanks upstairs!
 
Old 01-30-2004, 06:47 PM   #5
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
I'm sure Tinkster was just expressing a particular prefference

As for the differences I'm sure there's loads but once you're start in a camp you kinda of get blinkered by the tent flaps, anyway not really in position to in depth compare them (or to care too much hey I'm easy) but for what it's worth

Beginning Databases With MySql published by Wrox you can't really go wrong nice introduction, it's paper and you can flick through pages where you want to go (if it's still published)
 
Old 01-31-2004, 12:11 AM   #6
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,986
Blog Entries: 11

Rep: Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880
Quote:
Originally posted by Crashed_Again
Is MySQL a figment of my imagination? Its not "real"?
It may be faster than Postgres, but it STILL lacks
features that Postgres has supported for YEARS.
It supports less SQL 92 and 99 features than
Postgres.

Quote:
From the MySQL features list
Expanded support for subqueries

Subqueries allow you to use the result of one query as a component of a larger query. The MySQL server already supports some forms of this technique, such as INSERT INTO ... SELECT ..., and this support will be expanded in version 4.1 to include nested SELECT queries, which is one of the most-requested features from our users.
/me chuckles ...

Then there's transaction safety, restore failed
table updates (after power-failure) from log...

Guess the speed must come from some source :)


Cheers,
Tink
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP/MySQL guest book.... MikeFoo1 Programming 1 12-13-2004 11:36 PM
Recommend a good book for PHP and mySQL vharishankar Programming 7 11-19-2004 06:55 AM
Recommend a book to learn linux linmix General 16 09-12-2004 11:07 AM
who can recommend a good PHP book for me? Warchief Programming 1 07-24-2003 12:02 AM
Would you recommend this book? lhoff Linux - General 5 11-16-2001 07:23 PM


All times are GMT -5. The time now is 10:05 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration