Advertisment
Learn how to obtain and install 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.
Before you can start running your queries you need to get your client talking with your server.
This section describes the basic principles of entering commands, using several queries you can try out to familiarise yourself with how mysql works.
Now that you know how to enter commands, it's time to access a database.
Before you can start creating tables you need to have a database.
Once you have a database, it's time to make some tables.
The SELECT statement is a MUST if you plan on using databases.
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...
You've probably used mysql interactively to enter queries and view the results. You can also run mysql in batch mode.
A brief overview of the programs provided by MySQL AB and discusses how to specify options when you run these programs.
Administering a MySQL installation, such as configuring the server, managing user accounts, and performing backups.
Replication capabilities allowing the databases on one MySQL server to be duplicated on another.
This chapter tries to explain and give some examples of different ways to optimize MySQL.
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...
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....
Together, PHP & MySQL form the most widely used open source database and scripting technologies on the Web today. This book covers everything from...
This second installment covers an introduction to databases, logging on to MySQL, defininfg SQL, inserting data into a table, and modifying stored...
This third installment introduces PHP, variables and operators, user interaction and forms, control structures, and multi-purpose pages.
This final installment covers publishing MySQL data on the Web, connecting to MySQL with PHP, sending SQL queries with PHP, inserting data into the...