Best Tutorials website
Latest tutorials

Advertisment

Installing MySQL

Installing MySQL

Learn how to obtain and install MySQL.


Views: 1544 | Rating star 3 | by Amy
MySQL - Miscellaneous

Introduction to MySQL

Introduction to MySQL

This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database.


Views: 1367 | Rating star | by Stephen
MySQL - Miscellaneous

Connecting to and Disconnecting from the Server

Connecting to and Disconnecting from the Server

Before you can start running your queries you need to get your client talking with your server.


Views: 1331 | Rating star | by Daniel
MySQL - Miscellaneous

Entering Queries

Entering Queries

This section describes the basic principles of entering commands, using several queries you can try out to familiarise yourself with how mysql works.


Views: 1356 | Rating star | by David
MySQL - Miscellaneous

Creating and Using a Database

Creating and Using a Database

Now that you know how to enter commands, it's time to access a database.


Views: 1342 | Rating star | by Jarry
MySQL - Miscellaneous

Creating and Selecting a Database

Creating and Selecting a Database

Before you can start creating tables you need to have a database.


Views: 1305 | Rating star | by Ben
MySQL - Miscellaneous

Creating a Table

Creating a Table

Once you have a database, it's time to make some tables.


Views: 1417 | Rating star | by Adam
MySQL - Miscellaneous

Retrieving Information from a Table

Retrieving Information from a Table

The SELECT statement is a MUST if you plan on using databases.


Views: 1280 | Rating star | by Slicer
MySQL - Miscellaneous

Getting Information About Databases and Tables

Getting Information About Databases and Tables

What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL...


Views: 1363 | Rating star | by Adam
MySQL - Miscellaneous

Using mysql in Batch Mode

Using mysql in Batch Mode

You've probably used mysql interactively to enter queries and view the results. You can also run mysql in batch mode.


Views: 1292 | Rating star | by Steve
MySQL - Miscellaneous

Using MySQL Programs

Using MySQL Programs

A brief overview of the programs provided by MySQL AB and discusses how to specify options when you run these programs.


Views: 1286 | Rating star | by Sarah
MySQL - Miscellaneous

Database Administration

Database Administration

Administering a MySQL installation, such as configuring the server, managing user accounts, and performing backups.


Views: 1338 | Rating star | by Tutorial
MySQL - Miscellaneous

Replication in MySQL

Replication in MySQL

Replication capabilities allowing the databases on one MySQL server to be duplicated on another.


Views: 1300 | Rating star | by Sarah
MySQL - Miscellaneous

MySQL Optimization

MySQL Optimization

This chapter tries to explain and give some examples of different ways to optimize MySQL.


Views: 1334 | Rating star | by Troy
MySQL - Miscellaneous

Using SELECT to retrieve data

Using SELECT to retrieve data

This tutorial deeply covers the SELECT statement of the T-SQL/SQL language. Starts from the basics - how to retrieve the values inside a column to...


Views: 1311 | Rating star | by Tutorial
MySQL - Miscellaneous

Using a MySQL database with PHP

Using a MySQL database with PHP

It's time to add some dynamic content to your website. The best choice for ease-of-use, price and support is the combination of PHP and MySQL....


Views: 1291 | Rating star | by Mark
MySQL - Miscellaneous

Build Your Own Database Driven Website Using PHP & MySQL: Part 1

Build Your Own Database Driven Website Using PHP & MySQL: Part 1

Together, PHP & MySQL form the most widely used open source database and scripting technologies on the Web today. This book covers everything from...


Views: 1248 | Rating star | by Jarry
MySQL - Miscellaneous

Build Your Own Database Driven Website Using PHP & MySQL: Part 2

Build Your Own Database Driven Website Using PHP & MySQL: Part 2

This second installment covers an introduction to databases, logging on to MySQL, defininfg SQL, inserting data into a table, and modifying stored...


Views: 1201 | Rating star | by Sean
MySQL - Miscellaneous

Build Your Own Database Driven Website Using PHP & MySQL: Part 3

Build Your Own Database Driven Website Using PHP & MySQL: Part 3

This third installment introduces PHP, variables and operators, user interaction and forms, control structures, and multi-purpose pages.


Views: 1258 | Rating star | by Donald
MySQL - Miscellaneous

Build Your Own Database Driven Website Using PHP & MySQL: Part 4

Build Your Own Database Driven Website Using PHP & MySQL: Part 4

This final installment covers publishing MySQL data on the Web, connecting to MySQL with PHP, sending SQL queries with PHP, inserting data into the...


Views: 1303 | Rating star | by Donald
MySQL - Miscellaneous