Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Page 1 of 2 1 2 LastLast
Results 1 to 10 of 18
  1. #1
    JR
    JR is offline
    Senior Member JR's Avatar
    Join Date
    Nov 2002
    Location
    UK
    Posts
    4,354
    Member #
    257
    i know nothing about sql except it is server query language and it is a database.

    how much different is this to microsoft access, does it have numerous tables within 1 database?

    what would more that 1 sql database be needed for?
    JR

  2.  

  3. #2
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    SQL is structured query language; by itself it is not a database. Access can use MS SQL (somebody correct me if I'm wrong) and PHP's common database is MySQL, my database of choice despite its weakness. There's also PostgreSQL and a bunch of others.
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  4. #3
    Senior Member nsr81's Avatar
    Join Date
    Oct 2002
    Posts
    1,132
    Member #
    250
    Liked
    15 times
    As filburt said, SQL stands for Structured Query Language. It is a language developed to access the database server(s). Major vendors who have SQL interfaces to their packages are Micorosft (MS SQL Server), Oracle (Oracle), and AB mySQL (mySQL Server).

    SQL is nothing like Access as Access is a flat file database instead of a DBMS (Database Management System). You can, however, translate your Access queries to SQL. But it is nothing like SQL server (or language).

    You can have as many tables within a database as you want, there is no limit. However, it is usually preferred to use different database for different projects.

    Let me know if you anyother questions
    There and Back Again :Ogre:

  5. #4
    JR
    JR is offline
    Senior Member JR's Avatar
    Join Date
    Nov 2002
    Location
    UK
    Posts
    4,354
    Member #
    257
    so you would not have to have more that 1, you could have everything such as user logins etc. in one database?

    it appears i know nothing that is why i am the 'WDF Idiot'!
    JR

  6. #5
    JR
    JR is offline
    Senior Member JR's Avatar
    Join Date
    Nov 2002
    Location
    UK
    Posts
    4,354
    Member #
    257
    also.. does this mean that if it can be used in access i could create all my tables in access and use sql to put what i need onto the webpage?
    JR

  7. #6
    Senior Member nsr81's Avatar
    Join Date
    Oct 2002
    Posts
    1,132
    Member #
    250
    Liked
    15 times
    You don't have to have more than one database. For example, database for this forum contains approximately 43 table, not counting the ones filburt might have created himself.

    No SQL and Access are different, way different. You can export/import data among the two, but you can't use SQL language to query an Access database. If your server supports it, you might be able to use Access database with your webpages through FrontPage, I think. But be warned that it will be slow, since Access is a flat file based database. Also there are some key differences between mySQL and MS SQL, that will also prevent your from exporting Access data to mySQL intact, you will have to change stuff.

    My advice to you would be to get a book on mySQL. It is not hard to learn once you have basic concepts.
    There and Back Again :Ogre:

  8. #7
    JR
    JR is offline
    Senior Member JR's Avatar
    Join Date
    Nov 2002
    Location
    UK
    Posts
    4,354
    Member #
    257
    any books that you would recommend?
    JR

  9. #8
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    Anything by http://www.sams.com/
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  10. #9
    JR
    JR is offline
    Senior Member JR's Avatar
    Join Date
    Nov 2002
    Location
    UK
    Posts
    4,354
    Member #
    257
    from http://www.webdesignforums.net/thread4839.html

    i have been on there but i dont have an american credit card lol
    any specific books?
    JR

  11. #10
    Senior Member nsr81's Avatar
    Join Date
    Oct 2002
    Posts
    1,132
    Member #
    250
    Liked
    15 times
    Sams Teach Yourself MYSQL in 24 Hours

    At amazon.co.uk http://www.amazon.co.uk/exec/obidos/ASIN/0672323494/
    There and Back Again :Ogre:


Page 1 of 2 1 2 LastLast

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 03:05 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com