I want to learn SQL - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 6 (permalink) Old 06-12-2003, 03:00 PM Thread Starter
 
Join Date: Nov 2002
Posts: 5,831
I want to learn SQL

i wnat to learn SQL, what is a free one you guys can recommend?? Are there any that i can use MS Access with??? (besides MS SQL Sever)

EDIT: I would like this to run on a windows machine as well...

and any recommended websites that speak n00bie language about SQL?


thanks
trey

Last edited by trey85stang; 06-12-2003 at 03:03 PM.
trey85stang is offline  
Sponsored Links
Advertisement
 
post #2 of 6 (permalink) Old 06-12-2003, 04:19 PM
Warden
 
Join Date: Mar 2000
Location: McKinney, TX
Posts: 3,174
MySQL, its the most popular free SQL database there is. Another is postgres. and there are a few others, but MySQL has the most support.

MS Access is a database, just a crappy one. I am not sure what you mean by "use with MS Access". You either use Access or something else.
chris is offline  
post #3 of 6 (permalink) Old 06-12-2003, 04:50 PM Thread Starter
 
Join Date: Nov 2002
Posts: 5,831
i mean use access as a "client" a front end, with the SQL being a backend.
trey85stang is offline  
 
post #4 of 6 (permalink) Old 06-12-2003, 05:08 PM
No Cerveza... No Trabajo
 
01WhiteCobra's Avatar
 
Join Date: Jun 2002
Location: Where's my beer?
Posts: 21,924
Quote:
Originally posted by trey85stang
i mean use access as a "client" a front end, with the SQL being a backend.
Only way to learn SQL is to write SQL. If you are using Access as a front end, you won't be learning SQL (Structured Query Language).

You need to be learning why this does what it does...

SELECT DISTINCT Profiles.* FROM Profiles
INNER JOIN
(Select RECORDNO from floorplans
INNER JOIN bathroom_lookup ON floorplans.bathroom_id = bathroom_lookup.bathroom_id
INNER JOIN bedroom_lookup ON floorplans.bedroom_id = bedroom_lookup.bedroom_id
where
convert(int,floorplans.price1) >= 200
AND convert(int,floorplans.price2) <= 300
)FLRPLAN
ON FLRPLAN.RECORDNO = Profiles.RECORDNO
INNER JOIN Amenities ON Profiles.RECORDNO = Amenities.RECORDNO
WHERE (Profiles.property_visible = 1)
AND ( zip = '75234' or zip = ' 75244' or zip = ' ' )
AND profiles.year_built >= 1800
order by prop_ranking desc
01WhiteCobra is offline  
post #5 of 6 (permalink) Old 06-12-2003, 05:23 PM Thread Starter
 
Join Date: Nov 2002
Posts: 5,831
ok, i dont understand that... I understand a small amount of it that is familier from access.

i have mysql now.. any good sites that can get me started creating a small DB??

Is this mainly done through the command line w/ mysql? I can ditch access, its no big deal.. just thought it might help learning it.. but if not.. i can ditch it.

thanks
trey
trey85stang is offline  
post #6 of 6 (permalink) Old 06-13-2003, 07:56 AM
Warden
 
Join Date: Mar 2000
Location: McKinney, TX
Posts: 3,174
Here is a good web based front end,

www.phpmyadmin.net

There are many windows GUI Mysql Managers, I like MySQL Studio from Premiumsoft but you have to buy it, They have a demo though.
chris is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome