- Optimizing and Tuning Your MySQL Database
- Sep 20, 2002
- This lesson gives you pointers for optimizing and tuning your database so that you get the most bang for your buck.
|
- PHP and MySQL Web Development: Ajax Basics
- Dec 8, 2008
- Here are the basics of Ajax programming for PHP and MySQL applications.
|
- PHP's Building Blocks: Data Types, Literals, Variables, and Constants
- Jan 19, 2007
- Marko Gargenta and Ellie Quigley discuss the basic building blocks of all languages: data types. They teach how to work with different types of numbers, strings, and booleans. Variables, HTML forms, and constants are also covered.
|
- Retrieving Data Using the MySQL SELECT Statement
- Aug 18, 2006
- Chris Newman explains how to use a SELECT statement to fetch records from a MySQL database.
|
- Sams Teach Yourself JavaScript and Ajax Video Learning: A JavaScript Library for Ajax
- Mar 4, 2009
- This video excerpt is lesson 23 from Sams Teach Yourself JavaScript and Ajax: Video Learning.
|
- Sams Teach Yourself PHP and MySQL Video Learning: Working with Numbers
- Mar 2, 2009
- This video excerpt is lesson 5 from Sams Teach Yourself PHP and MySQL: Video Learning Starter Kit.
|
- Selecting Data from Your MySQL Tables
- Sep 6, 2002
- This sample chapter starts to teach you how to get data into, out of, and removed from your tables. No knowledge of the SQL syntax is assumed, but when you're through with this lesson you will be able to get everything out of your tables, sorted and delineated in exactly the manner you wanted.
|
- Setting up a PostgreSQL Database
- Jun 8, 2001
- Learn to set up a PostgreSQL database and use that database to store information that will be made available to Web browsers.
|
- SQL Fundamentals (Video Training): Introduction to MySQL Interfaces
- Oct 26, 2009
- This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
|
- SQL Fundamentals LiveLessons (Video Training): ANSI SQL Select Statement
- Nov 3, 2009
- This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
|
- Transactions in MySQL
- Sep 21, 2001
- MySQL now has the capability to execute transactions. In this article, Paul Dubois, the author of MySQL and Perl for the Web explains this new feature and how it works with DBI.
|
- Using Arrays in PHP
- May 30, 2003
- Explore the function and potential of using arrays. You will learn how to sort arrays and manipulate them to exhaust their potential in association with your goal.
|
- Using Arrays in PHP and MySQL Web Development
- May 25, 2001
- In this chapter from PHP and MySQL Web Development, authors Luke Welling and Laura Thomson demonstrate how to use arrays. Learn everything from what an array is, to the different types of arrays and how to sort them.
|
- Using GTK+ to Build GUI MySQL Applications—A Tabular Report
- Jul 19, 2001
- Matt Stucky, author of MySQL: Designing User Interfaces, shows you how to use two very popular GPL tools to create Linux database applications the way you may be used to with SQL Server and Visual Basic.
|
- Using MySQL Client Programs
- Jul 23, 2004
- This chapter discusses general principles that are common to most MySQL client programs. It also describes how to use several specific types of clients. Sample questions with detailed answers are provided at the end of the chapter to help you prepare.
|
- Using MySQL Programs
- Sep 15, 2006
- Let the creators of MySQL give you a brief overview of the command-line programs provided by MySQL. They also discuss the general syntax for specifying options when running these programs.
|
- Using MySQL Programs
- Sep 24, 2004
- This chapter provides a brief overview of the programs provided by MySQL AB and discusses how to specify options when you run these programs.
|
- Using SQL to Manage Data
- Apr 29, 2013
- SQL is the means by which you tell the server how to perform data management operations, and fluency with it is necessary for effective communication. This chapter covers how to use SQL to manage data, including
changing the SQL mode to affect server behavior, referring to elements of databases, using multiple character sets, creating and destroying databases, tables, and indexes, obtaining information about databases and their contents, retrieving data using joins, subqueries, and unions, using multiple-table deletes and updates, performing transactions that enable statements to be grouped or canceled, setting up foreign key relationships, and using the FULLTEXT search engine.
|
- Using the MySQL Client Library to Write Your Own Programs
- Jan 10, 2003
- Write your own client programs in C with the MySQL Client Library. Follow these guidelines to maintain consistency with existing client programs in the MySQL distribution, as well as modularity and reusability of your code. Create a series of programs from a simple server connection to an interactive query.
|
- Why MySQL?
- Apr 11, 2003
- Explore an Open Source (GPL) Standard Query Language (SQL) database that is fast, reliable, easy to use, and suitable for applications of any size. Learn the important SQL commands and how to automate database interaction with Perl and the DataBase Independent interface (DBI).
|