Home > Articles > Data > MySQL

MySQL

43 Items

Sort by Date | Title

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.
Working with Arrays in PHP and MySQL
Nov 20, 2012
This chapter presents the most important problems you’ll have to solve when working with arrays—and, of course, solutions for these problems.
End-to-End JPA Collections with MySQL, Part 2
May 1, 2012
Stephen Morris provides simple, end-to-end working code illustrating how to modify JPA collection code. Also, the area of MySQL stored procedures is looked at, using some simple examples in this the concluding part of a two-part series.
End-to-End JPA Collections with MySQL, Part 1
Apr 30, 2012
Having difficulty getting your JPA collection code up and running? Stephen Morris demonstrates an end-to-end, working example of a JPA collection in this first part of a two-part series.
Working with MariaDB
Sep 24, 2011
In this chapter, you learn how to connect and log in to MariaDB, how to issue MariaDB SQL statements, and how to obtain information about databases and tables.
SQL Fundamentals LiveLessons (Video Training): ANSI SQL Select Statement
Nov 3, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
SQL Fundamentals (Video Training): Introduction to MySQL Interfaces
Oct 26, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
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.
PHP and MySQL Web Development: Ajax Basics
Dec 8, 2008
Here are the basics of Ajax programming for PHP and MySQL applications.
Accessing Your MySQL Database from the Web with PHP
Sep 30, 2008
In this chapter, learn how to access a database from the Web using PHP, read from and write to the database, and filter potentially troublesome input data.
Data Types in MySQL
Aug 16, 2008
Learn the types of data values that MySQL can handle and the issues involved in working with those types.
Creating an Online Storefront in PHP, MySQL and Apache, Part 4
Jul 15, 2008
Learn the design process behind a simple discussion forum.
Creating an Online Storefront in PHP, MySQL and Apache, Part 3
Jul 7, 2008
Learn the design process behind a simple discussion forum.
Creating an Online Storefront in PHP, MySQL and Apache, Part 2
Jul 2, 2008
In Part 2 of this chapter, you’ll learn the design process behind a simple discussion forum; specifically, displaying the topic list.
Creating an Online Storefront in PHP, MySQL and Apache, Part 1
Jun 25, 2008
Learn the design process behind a simple discussion forum.
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.
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.
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.
Alternatives to LAMP
Jun 2, 2006
The LAMP configuration (Linux, Apache, MySQL, and PHP) is familiar to the open source universe. But just because this combination of products is comfortable, that doesn't mean that it provides the best solution for your systems. David Chisnall suggests some alternatives that might make a better match for your needs.

Page 1 2 3 Next >