SunQuest
           MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > MySQL Help
Reload this Page

MySQL Resources !!!

Discuss MySQL Resources !!! in the MySQL Help forum on Dev Shed.
MySQL Resources !!! MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Page 1 of 3 1 2 3 >
« Previous Thread | Next Thread » Featured Thread Featured Thread  
Thread Tools Search this Thread Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old April 2nd, 2004, 02:50 PM
expert-database expert-database is offline
Permanently Banned
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Mar 2004
Posts: 37 expert-database Negative: is most likely a SPAMMER and a traitor to the cause. 
Time spent in forums: 6 h 56 m 52 sec
Warnings Level: 10
Number of bans: 1
Reputation 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/b.../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,
Reply With Quote
  #2  
Old April 2nd, 2004, 04:28 PM
r937's Avatar
r937 r937 is offline
SQL Consultant
Dev Shed God 25th Plane (17000 - 17499 posts)
  
Join Date: Feb 2003
Location: Toronto Canada
Posts: 17,344 r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 5 Days 8 h 27 m 14 sec
Reputation Power: 891
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/...SQLTutorial.htm
__________________
r937.com | rudy.ca
Reply With Quote
  #3  
Old April 5th, 2004, 03:15 PM
expert-database expert-database is offline
Permanently Banned
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Mar 2004
Posts: 37 expert-database Negative: is most likely a SPAMMER and a traitor to the cause. 
Time spent in forums: 6 h 56 m 52 sec
Warnings Level: 10
Number of bans: 1
Reputation 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.
Reply With Quote
  #4  
Old April 5th, 2004, 03:37 PM
Sepodati's Avatar
Sepodati Sepodati is offline
Banned
Dev Shed God 19th Plane (14000 - 14499 posts)
  
Join Date: Dec 1999
Location: Afghanistan
Posts: 14,378 Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)  Folding Points: 70305 Folding Title: Intermediate FolderFolding Points: 70305 Folding Title: Intermediate FolderFolding Points: 70305 Folding Title: Intermediate FolderFolding Points: 70305 Folding Title: Intermediate Folder
Time spent in forums: 2 Months 3 Weeks 6 Days 22 h 38 m 20 sec
Reputation Power: 1784
Send a message via ICQ to Sepodati Send a message via Yahoo to Sepodati
Reply With Quote
  #5  
Old April 30th, 2004, 12:12 PM
wog wog is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Mar 2004
Posts: 2 wog User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 34 sec
Reputation Power: 0
Great help!!!
If you are completely new to mySQL, this tutorial is a MUST READ!

MySQL Basics
URL

Thanks for pointing it out to me!

WoG
Reply With Quote
  #6  
Old May 13th, 2004, 04:16 PM
rlorenzo's Avatar
rlorenzo rlorenzo is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2003
Posts: 95 rlorenzo User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 36 m 34 sec
Reputation Power: 5
what about DBDesigner4?

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

Its a free alternative to ERwin and the like.
Reply With Quote
  #7  
Old July 8th, 2004, 09:55 AM
expert-database expert-database is offline
Permanently Banned
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Mar 2004
Posts: 37 expert-database Negative: is most likely a SPAMMER and a traitor to the cause. 
Time spent in forums: 6 h 56 m 52 sec
Warnings Level: 10
Number of bans: 1
Reputation 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
Reply With Quote
  #8  
Old July 9th, 2004, 01:16 AM
hpxchan hpxchan is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jul 2004
Posts: 26 hpxchan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 37 m 21 sec
Reputation Power: 0
Send a message via AIM to hpxchan Send a message via Yahoo to hpxchan
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!
Reply With Quote
  #9  
Old July 15th, 2004, 11:46 AM
StanleyGuy StanleyGuy is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jun 2004
Posts: 134 StanleyGuy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 34 m
Reputation Power: 5
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
Reply With Quote
  #10  
Old August 15th, 2004, 09:04 AM
ricker ricker is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2004
Posts: 2 ricker User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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.
Reply With Quote
  #11  
Old August 20th, 2004, 12:19 PM
karam_chand karam_chand is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2004
Posts: 1 karam_chand User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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.
Reply With Quote
  #12  
Old October 18th, 2004, 08:37 PM
ProggerPete ProggerPete is offline
Contributing User
Dev Shed Beginner (1000 - 1499 posts)
  
Join Date: May 2003
Location: Brisbane, Australia
Posts: 1,431 ProggerPete User rank is Sergeant (500 - 2000 Reputation Level)ProggerPete User rank is Sergeant (500 - 2000 Reputation Level)ProggerPete User rank is Sergeant (500 - 2000 Reputation Level)ProggerPete User rank is Sergeant (500 - 2000 Reputation Level)ProggerPete User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 1 Week 1 Day 22 m 9 sec
Reputation Power: 23
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
Reply With Quote
  #13  
Old October 29th, 2004, 07:24 AM
r937's Avatar
r937 r937 is offline
SQL Consultant
Dev Shed God 25th Plane (17000 - 17499 posts)
  
Join Date: Feb 2003
Location: Toronto Canada
Posts: 17,344 r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level)r937 User rank is Lieutenant General (80000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 5 Days 8 h 27 m 14 sec
Reputation Power: 891
Reply With Quote
  #14  
Old October 31st, 2004, 05:17 PM
ProggerPete ProggerPete is offline
Contributing User
Dev Shed Beginner (1000 - 1499 posts)
  
Join Date: May 2003
Location: Brisbane, Australia
Posts: 1,431 ProggerPete User rank is Sergeant (500 - 2000 Reputation Level)ProggerPete User rank is Sergeant (500 - 2000 Reputation Level)ProggerPete User rank is Sergeant (500 - 2000 Reputation Level)ProggerPete User rank is Sergeant (500 - 2000 Reputation Level)ProggerPete User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 1 Week 1 Day 22 m 9 sec
Reputation Power: 23
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'
Reply With Quote
  #15  
Old November 12th, 2004, 06:20 PM
elincreible elincreible is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2004
Posts: 1