MySQL

43 Items

Sort by Date | Title

Using SQL to Manage Data By Paul Dubois 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 By Christian Wenz 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 By Stephen B. Morris 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 By Stephen B. Morris 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 By Ben Forta 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 By Arie D. Jones Nov 3, 2009 This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).

SQL Fundamentals (Video Training): Introduction to MySQL Interfaces By Arie D. Jones 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 By Sams Publishing 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 By Sams Publishing 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 By Luke Welling, Laura Thomson Dec 8, 2008 Here are the basics of Ajax programming for PHP and MySQL applications.

Accessing Your MySQL Database from the Web with PHP By Luke Welling, Laura Thomson 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 By Paul Dubois 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 By Julie C. Meloni Jul 15, 2008 Learn the design process behind a simple discussion forum.

Creating an Online Storefront in PHP, MySQL and Apache, Part 3 By Julie C. Meloni Jul 7, 2008 Learn the design process behind a simple discussion forum.

Creating an Online Storefront in PHP, MySQL and Apache, Part 2 By Julie C. Meloni 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 By Julie C. Meloni Jun 25, 2008 Learn the design process behind a simple discussion forum.

PHP's Building Blocks: Data Types, Literals, Variables, and Constants By Ellie Quigley, Marko Gargenta 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 By MySQL AB 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 By Chris Newman Aug 18, 2006 Chris Newman explains how to use a SELECT statement to fetch records from a MySQL database.

Alternatives to LAMP By David Chisnall 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 >