|
This tutorial will teach you how to make a connection to MySQL in Dreamweaver
www.adesdesign.net/php/tutorials/dreamweaver/connect_db.php
|
|
This online manual is meant to serve as a place to start for people not familiar with MySQL.
www.clockwatchers.com/mysql_main.html
|
|
This tutorial shows you how to use two open source, cross-platform tools for creating a dynamic Web site: PHP and MySQL. When we are finished, you will know how dynamic sites work and how they serve the content, and you will be ready to serve your own dynamic content from your site.
codewalkers.com/tutorials.php?show=9
|
|
Protect your data from crashes and the confusion of multiple user requests with a transaction-capable database.(Webmonkey.com)
hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial2.html
|
|
MySQL includes several ways to backup your important data. In this article Mitchell shows us how to backup our databases using the mysqldump utility that comes with MySQL. He looks at several examples including how to backup your database to a file, another server, and even a compressed gzip file. (devArticles.com)
www.devarticles.com/art/1/62
|
|
You've got a database containing information about employees in your company, and want to provide a search interface. The only problem? People are searching for terms like Mike, and no results are being returned because it's stored as Michael in the database. Ideally, you'd like to return results that sound like Mike, but how can you do this? (4Guys)
www.4guysfromrolla.com/webtech/tips/t103101-1.shtml
|
|
This introductory tutorial aims to teach beginners the building blocks of SQL.
www.1keydata.com/sql/sql.html
|
|
MySQL CHM (compiled HTML) manual: Features table of content, "Keyword index" for easier navigation, MSDN-like CSS. (1.15MB download)
home.balticom.lv/andryxa/mysql.chm
|
|
How do you write advanced SQL queries without knowing SQL? In this tutorial, Daren Brokenshire investigates by uncovering a simple answer!
tutorials.beginners.co.uk/read/id/31/
|
|
Question: "Can you use a Stored Procedure to open a table and copy data to a sort of virtual table (or a records set) so that you can change the values with and not affect the actual data in the actual table, and then return the results of the virtual table?" Answer: Temporary Tables.
www.sqlteam.com/item.asp?ItemID=2029
|
|
This tutorial covers building a dynamic where clause. And the really neat part is that you don't actually need to write dynamic SQL. This is soooo much simpler. (SQLTeam)
www.sqlteam.com/item.asp?ItemID=2077
|
|
This article, chock full of SQL goodness, covers creating a dynamic ORDER BY clause for your SELECT statements. (SQLTeam)
www.sqlteam.com/item.asp?ItemID=2209
|
|
Ever needed to return a string using SELECT *, LEFT(text, 150)... but it was returning incomplete words. If you need the last word to be complete, put some string functions to use and solve your problems. (SQLTeam)
www.sqlteam.com/item.asp?ItemID=2478
|
|
If you are looking for a SQL tutorial, this is the site. This SQL tutorial provides the help you need to get started using SQL. It covers the create, import, retrieve, order, update, delete, insert, and join commands.
www.baycongroup.com/tocsql.htm
|
|
This tutorial explains how to use the built-in GROUP BY function in SQL. (W3Schools)
www.w3schools.com/sql/sql_groupby.asp
|
|
This tutorial teaches how to use the SELECT statement to select data from a table in SQL. (W3Schools)
www.w3schools.com/sql/sql_select.asp
|
|
This tutorial explains how to use the built-in functions in SQL. (W3Schools)
www.w3schools.com/sql/sql_functions.asp
|
|
This tutorial describes what SQL is, and how it can be used. (W3Schools)
www.w3schools.com/sql/sql_intro.asp
|
|
This is a guide to SQL as used in Microsoft Access 97.
www.bris.ac.uk/is/selfhelp/documentation/acc97-t5/acc97-t5.htm
|
|
This document introduces SQL as used in Oracle.
www.bris.ac.uk/is/selfhelp/documentation/ora-t1/ora-t1.doc
|
|
Dynamic SQL is ugly and difficult to maintain. It would be nice to package it all into a stored procedure. Did you know that you can have dynamic SQL statements within a stored procedure? This article demonstrates how to do that! (4Guys)
4guysfromrolla.com/webtech/102300-1.shtml
|
|
This tutorial shows how you can use a stored procedure to retrieve a random record from a table. Using a Stored Procedure has many benefits over downloading the whole recordset and finding a random record from the recordset. (4Guys)
www.4guysfromrolla.com/webtech/081100-1.shtml
|
|
This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. (internet.com)
www.sqlcourse.com/
|