SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Thread: database

  1. #1
    SitePoint Addict
    Join Date
    Oct 2010
    Posts
    323
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    database

    good morning,
    please i have no knowledge about data base mangement, but have html and css, please what do i have to learn so has to manage product feeds from affiliates site.
    really keen on learning thanks

  2. #2
    SitePoint Wizard
    Join Date
    Feb 2009
    Posts
    1,006
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, we must start somewhere:

    SQL Tutorial


  3. #3
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    Location
    France, deep rural.
    Posts
    6,869
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    I learned from the docs bundled with my mysql installation, really stuck in my head - though I did read each line carefully.

  4. #4
    SitePoint Addict
    Join Date
    Oct 2010
    Posts
    323
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    please wats docs bundle

  5. #5
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    Location
    France, deep rural.
    Posts
    6,869
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    That is a very good question, it has been so long ago that I have to just point you to the mysql documentation site.

    Here is the html version MySQL :: MySQL 5.1 Reference Manual

    but you might be as well downloading the .chm help file locally in your own language: MySQL :: MySQL Documentation: MySQL Reference Manuals

    Section 3 of the manual is a basic tutorial - but it does not have the exact degree of complexity that I remember.

    Once you have worked through the examples in the manual, if you have any further questions you can ask here, or, ask in the dedicated sitepoint **mysql forum.

    (**I am supposing that you are using mysql for your first attempts as using sql)

    Once you have grasped the basics of how sql works and the basic terminology used you will be able to ask more focussed questions.

    The basic principle with using the LAMP stack is that you make sure that your sql statements do what you expect, return the data you expect and then get PHP to interact with mysql on your behalf so that data is returned to your webpage matching your expectations.

    The line between PHP and Mysql tends to get blurry when you are just starting out - so it is important to clearly separate them in your mind.

    Off Topic:

    Paste a url and it looks up the page title - crikey that is new and clever, like that a lot!
    Last edited by Cups; Mar 25, 2011 at 05:48. Reason: ot comment

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,328
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Cups View Post
    but you might be as well downloading the .chm help file locally in your own language: MySQL :: MySQL Documentation: MySQL Reference Manuals
    i don't see any chm files on that page

    i have one but it's 5.0.3 alpha from 2005

    i've never seen a later one anywhere, so if you can find one, please do let me know

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  7. #7
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    Location
    France, deep rural.
    Posts
    6,869
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    oops, apologies - it will have to be webpages or pdf file then, sorry about that.

    My chm file is 5.0.68 from 2008 - you are welcome to that if you want.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •