- 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.
|