Page 1 of 3 123 Last
  • Jump to page:
    #1
  1. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    37
    Rep Power
    0

    Lightbulb MySQL Resources !!!


    This is the interesting MySQL Resources for Developers ,I hope they serve them .

    MySQL IDE's

    MySQL Turbo Manager
    http://www.mentattech.com

    MySQL Manager
    http://ems-hitech.com/mymanager

    MySQL-Front
    http://www.mysqlfront.de

    DbVisualizer
    http://www.ideit.com/products/dbvis

    MySQL WebAdmin

    PHPMyAdmin
    http://www.phpmyadmin.net/home_page

    MySQL Datamanager
    http://www.edatanew.com

    Data modeling tools

    DeZign for databases
    http://www.datanamic.com

    Tutorials

    SQL Tutorial
    http://w3.one.net/~jhoffman/sqltut.htm

    MySQL and PHP Tutorial
    http://www.vtwebwizard.com/tutorials/mysql/index.html

    Perl/MySQL Tutorial
    http://www.hotwired.com/webmonkey/ba...tutorial1.html

    MySQL Basics
    http://www.analysisandsolutions.com/code/mybasic.

    Others

    dorcMan
    http://www.dorcMan.org

    MyCart
    http://open.appideas.com/MyCart

    PHPCommunityCalendar
    http://open.appideas.com/Calendar


    Regards,
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    excellent idea, now a sticky post

    hey, that SQL tutorial by jim hoffman disappeared several years ago

    here's a mirror of one of the latest versions:
    http://riki-lb1.vet.ohio-state.edu/m...QLTutorial.htm
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    37
    Rep Power
    0
    Books Resources

    Beginning Databases with MySQL
    Author(s): Neil Matthew, Richard Stones
    Publisher: Wrox Press Inc.

    Create Dynamic Web Pages Using PHP and MySQL
    Author(s): David Tansley
    Publisher: Addison-Wesley

    Managing & Using MySQL
    Author(s): George Reese, Randy Jay Yarger, Tim King
    Publisher: O'Reilly & Associates, Inc.

    MySQL Tutorial
    Author(s): Luke Welling, Laura Thomson
    Publisher: SAMS

    MySQL Pocket Reference
    Author(s): George Reese
    Publisher: O'Reilly & Associates, Inc.
  6. #4
  7. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    -- Cigars, whiskey and wild, wild women. --
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    2
    Rep Power
    0

    Great help!!!


    If you are completely new to mySQL, this tutorial is a MUST READ!

    MySQL Basics
    http://www.analysisandsolutions.com/code/mybasic

    Thanks for pointing it out to me!

    WoG
  10. #6
  11. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    95
    Rep Power
    12
    what about DBDesigner4?

    http://www.fabforce.net/dbdesigner4/

    Its a free alternative to ERwin and the like.
  12. #7
  13. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    37
    Rep Power
    0

    Thumbs up


    New releases :

    MySQL Turbo Manager 3.1
    http://www.mentattech.com

    New Products :

    TOAD for MySQL Preview Release
    http://www.quest.com

    New MySQL Database Server :

    Production 4.0.20
    http://dev.mysql.com/downloads/mysql/4.0.html

    Beta 4.1.3
    http://dev.mysql.com/downloads/mysql/4.1.html

    Alpha 5.0.0
    http://dev.mysql.com/downloads/mysql/5.0.html

    New Books :

    High Performance MySQL
    Author(s): Jeremy Zawodny, Derek J. Balling
    Publisher: O'Reilly & Associates, Inc.

    MySQL Enterprise Solutions
    Author(s): Alexander Pachev
    Publisher: Wiley, John & Sons, Incorporated
  14. #8
  15. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2004
    Posts
    26
    Rep Power
    0
    wow im in love with this sticky... i was about to ask a rather newbish question (after all, i am newbish as far as mysql is concerned), but then i read the 'TAASC MySQL Basics' tutorial for a few paragraphs, and my problem is solved. thanks!!!

    im currently using the PHP5 and MySQL Bible (Authors: Tim Converse, Joyce Park, Clark Morgan; Publisher: Wiley Publishing), and really I only bought that particular book because it was the only php5+mysql book at the local bookstore, but it turned out to be very informative (so far; im not done! ), although you are expected to know a little about programming and computers in general, which is not mentioned anywhere outside or inside the book, as far as I can tell.

    EDIT: It has case studies!
  16. #9
  17. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2004
    Posts
    134
    Rep Power
    11
    TWO BOOKS THAT HAVE BEEN INFINITELY VALUABLE:

    MySQL - The Definitive Guide
    Author: Paul DuBois

    MySQL Cookbook
    Author: Paul DuBois


    The cookbook especially, it's filled with realworld uses for everything in PHP and sooo many ideas on how to solve problems and structure queries. The first one is an all encompassing MySQL reference, which is great to have around.

    Paul DuBois, the author of both, is one of the people who created MySQL, so it's obvious why these books are great!

    -Mark
  18. #10
  19. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2004
    Posts
    2
    Rep Power
    0

    MySQL Tools


    DBACentral for MySQL
    http://www.microolap.com/dba/mysql/dbacentral/
    MySQL administration and developement solution. Supports gui forms, domains, has Access-like interface paradigm.

    MicroOLAP Database Designer for MySQL
    http://www.microolap.com/dba/mysql/designer/
    Visual CASE tool for database design, modeling, creation, modification and reverse engineering.
  20. #11
  21. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2004
    Posts
    1
    Rep Power
    0

    MySQL GUI


    MySQL Administrator
    http://www.mysql.com/products/administrator/
    Powerful visual administration console from MySQL AB.

    SQLyog
    http://www.webyog.com
    Fast and compact MySQL GUI. Very strong in migration, database synchronization and structure synchronization.
  22. #12
  23. No Profile Picture
    Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    May 2003
    Location
    Brisbane, Australia
    Posts
    1,442
    Rep Power
    29
    Anyone got some links dealing with ASP.Net & MySQL? I'm having a devil of a time trying to work out how to connect to MySQL from ASP.Net.
    Like the answers I give? Why not ask me directly at my forum. I'm always glad to help.

    Javascript scripts and tips can be found at Dynamic Tools.
    Check out DynamicTable, the best javascript table sorter around.
    Get reliable and affordable hosting at www.thinksmarthosting.com
  24. #13
  25. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
  26. #14
  27. No Profile Picture
    Contributing User
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    May 2003
    Location
    Brisbane, Australia
    Posts
    1,442
    Rep Power
    29
    I figured out how to connect to MySQL from ASP.Net. Here's the code
    Code:
    Dim MyConString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=SiteDB;UID=root;PASSWORD=;"
    		
    		Dim myConnection As New OdbcConnection(MyConString)
        myConnection.Open()
    
    		test.Text = "ServerVersion: " + myConnection.ServerVersion + ControlChars.Cr + "State: " + myConnection.State.ToString()
    
    		Dim sql = "SELECT * FROM en_tblcliententities"
    		Dim myCommand As New OdbcCommand(sql, myConnection)
    		Dim myReader As OdbcDataReader
        myReader = myCommand.ExecuteReader()
        
    		While myReader.Read()
    				databaseOutput.Text = databaseOutput.Text + myReader.GetString(3) + ", " + myReader.GetString(4) + "<BR>"
        End While
    
        myReader.Close()
    
    		MyConnection.Close()
    You'll need to download and install 'MySQL ODBC 3.51 Driver'
    Like the answers I give? Why not ask me directly at my forum. I'm always glad to help.

    Javascript scripts and tips can be found at Dynamic Tools.
    Check out DynamicTable, the best javascript table sorter around.
    Get reliable and affordable hosting at www.thinksmarthosting.com
  28. #15
  29. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2004
    Posts
    1
    Rep Power
    0
    I like this one. I connect to it to Live MySQl databases on the web. Great reporting tool!

    http://www.dbxtra.com
    Last edited by r937; November 12th, 2004 at 08:27 PM.
Page 1 of 3 123 Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo