stargeek
PHP news website logo.
home    PHP scripts    articles    seo tools    links    search    contact    shop    realtors


MySQL: The Complete Reference







MySQL: The Complete Reference

MySQL: The Complete Reference 04/09/2004 04:05 PM

Overall this is a very complete reference book, of interest to different types of users of MySQL databases from database application developers to database administrators. The fact that it covers features introduced in MySQL 4 and more recent versions like ACID transactions, referential integrity, query result caching and sub-queries, makes it an excellent choice for people looking for an up to date MySQL book.




This is a GrokNews Entry: (what is grok?)





Similar Items

MySQL: The Complete Reference

Grok Headline matches for MySQL: The Complete Reference

Paradoxal Press Announces “The COMPLETE
Effect and HLSL Guide” and “The COMPLETE
HLSL Reference”, a Complete Set of
Reference Manuals for Video Game
Developers


Paradoxal Press Announces “The COMPLETE
Effect and HLSL Guide” and “The COMPLETE
HLSL Reference”, a Complete Set of
Reference Manuals for Video Game
Developers
03/28/2005 03:40 AM
Paradoxal Press (ParadoxalPress.com) is proud to announce two new titles to its 2005 lineup of computer programming books. “The COMPLETE Effect and HLSL Guide” (ISBN 0-9766132-1-2) is a complete reference manual for video game and computer graphic application developers using the Microsoft DirectX SDK. “The COMPLETE HLSL Reference” (ISBN 0-9766132-0-4) is a spiral-bound booklet serving as a quick all-in-one reference for shader developers with all the information they need at a fingertip. [PRWEB Mar 28, 2005]

The Complete Reference: Red Hat
Enterprise Linux & Fedora Edition


The Complete Reference: Red Hat
Enterprise Linux & Fedora Edition
05/21/2004 02:35 PM
Useful information for everyone from novice users to system administrators.

The Complete ATI Reference Radeon 9600
Pro/XT Voltage Modding Guide


The Complete ATI Reference Radeon 9600
Pro/XT Voltage Modding Guide
07/18/2004 07:16 AM

MySQL Reference Manual


MySQL Reference Manual 03/11/2003 01:22 AM
If you were looking for a good printed version of MySQL 4 reference manual, this is probably your best choice as it comes from the MySQL AB developers: Michael "Monty" Widenius and David Axmark.

EnGarde Secure Linux Advisory: MySQL,
MySQL-client, MySQL-shared, mod_php, php


EnGarde Secure Linux Advisory: MySQL,
MySQL-client, MySQL-shared, mod_php, php
12/16/2002 04:17 PM
"Stefan Esser from the PHP.net project discovered two vulnerabilities in MySQL which range from crashing the server to executing arbitrary code as the user under which the MySQL daemon runs (mysql)..."

SearchEnterpriseLinux: MySQL CEO: Open
Source MySQL Will Rise, Legal Foes Will
Fall


SearchEnterpriseLinux: MySQL CEO: Open
Source MySQL Will Rise, Legal Foes Will
Fall
02/01/2005 09:06 PM
"None of the legal attacks on open source or Linux have been successful. None of that stuff has gone anywhere. That's the biggest story..."

MySQL: MySQL Administrator Now Availible


MySQL: MySQL Administrator Now Availible 02/12/2004 10:10 AM
In a new note passed along to me from MarkL this morning, there's some new information about the admin tool that the MySQL folks have created.

MySQL: MySQL Administrator Announced


MySQL: MySQL Administrator Announced 01/22/2004 10:26 AM
In a startling new note from the MySQL development team, information about their newest application has been posted on their site.

MySQL: MySQL 5.0.0 Has Been Released


MySQL: MySQL 5.0.0 Has Been Released 12/26/2003 07:47 PM
"MySQL 5.0.0, a new version of the popular Open Source/Free Software Database Management System, has been released..."

MySQL: MySQL 4.0.20 Released


MySQL: MySQL 4.0.20 Released 05/20/2004 06:59 PM
"MySQL 4.0.20, a new version of the popular Open Source/Free Software Database Management System, has been released..."

MySQL: PHP and MySQL Get a Little Closer


MySQL: PHP and MySQL Get a Little Closer 02/18/2003 04:17 PM

ADC Reference Library


ADC Reference Library 04/09/2004 03:59 PM
Apple has collected various developer documentation, technotes, sample code, and so on into their new ADC Reference Library. There’s even a page on ma king the most of the new library.

Reference Resources


Reference Resources 05/13/2004 06:39 PM
Reference Resources
http://www.ReferenceResourc es.info/

Reference Resurces is a Subject Tracer™ Information Blog developed and created by the Virtual Private Library™. It is designed to bring together the latest resources and sources on an ongoing basis for reference information. We always welcome suggestions of additional sites and resources to be added to this comprehensive listing and please submit by clicking here. This site has been developed and is maintained by Marcus P. Zillman, M.S., A.M.H.A.. Additional links and resources by Marcus are available by clicking here.

MT Tag Quick Reference


MT Tag Quick Reference 08/07/2004 09:06 PM
MT Tabs, awesome sidebar reference for tags .. §…€ŒªŒ ª

movalog.com/mttabs
track this site | 4 links


The people's reference


The people's reference 09/27/2004 03:10 AM
USA Today Sep 27 2004 6:14AM GMT

SVG reference, part 2


SVG reference, part 2 09/20/2004 12:46 AM
CNET Sep 20 2004 4:09AM GMT

DAML Reference


DAML Reference 05/23/2002 10:39 PM

A New-Age Reference (washingtonpost.com)


A New-Age Reference (washingtonpost.com) 09/08/2004 10:03 PM
washingtonpost.com - One of the Internet's more fascinating social experiments was born at a time when it seemed all the dot-coms were dying. Wikipedia, a free online encyclopedia started in January 2001, has since surprised Web watchers by maturing into a popular reference site.

Web Reference Database


Web Reference Database 01/11/2004 02:41 PM
refbase 0.7 available

Web Design Reference


Web Design Reference 09/11/2004 07:07 AM
Web Design Reference
ht tp://www.d.umn.edu/itss/support/Training/Online/webdesign/

The Web Design Reference is a huge mega-reference (over 3,000 links) of information and articles about web design and development. It is dedicated to disseminating news and information with emphasis on elements of user experience, accessibility, web standards, cascading style sheets, events, books, information architecture, color, navigation and more. This site is created by the Information Technology Systems and Services of the University of Minnesota Duluth Campus.

Web Designer's Reference


Web Designer's Reference 06/05/2005 11:56 PM

WWW Reference Maker 1.3.0


WWW Reference Maker 1.3.0 06/16/2004 11:03 PM
One click captures references from browser. Automatically format in APA, MLA, Columbia styles.

"MT Tag Quick Reference"


"MT Tag Quick Reference" 08/08/2004 02:09 PM

PHP Pocket Reference


PHP Pocket Reference 05/24/2002 11:27 AM

CGM DVE Complete 2.2.4


CGM DVE Complete 2.2.4 05/10/2004 04:15 PM
A set of 134 filters, transitions and generators for use in Final Cut Pro and Final Cut Express.

Google Reference in a Sermon


Google Reference in a Sermon 07/26/2004 02:16 PM

I was sitting in church yesterday, and my mind was wandering a bit. Then I hear this from the pulpit, "....if you Google 'mikvah', under Images, you'll see that it's an ancient baptismal device...". Sure enough.

My pastor rules.

Continue reading "Google Reference in a Sermon"

Click here to comment on this entry


Best Reference Sources 2003


Best Reference Sources 2003 04/19/2004 07:08 AM
Best Reference Sources 2003 by Brian E. Coutts with Tamara McConnell
http://www.libra ryjournal.com/article/CA408332

A listing of Best Reference Sources for 2003 featuring both the traditional written publications as well as web sites.

FileMaker 7 AppleScript Reference 2.0


FileMaker 7 AppleScript Reference 2.0 06/02/2004 11:15 PM
Includes examples for FileMaker 6 and 7.

Customer reference questions.


Customer reference questions. 06/10/2004 02:38 PM

My client is in the process of buying some software that will be used extensively across business units. As part of the process we’re talking to customer references from the tool vendors we’re considering.

When interviewing references, people don’t often know what to ask other than non-specific questions about how they like the product and how good the vendor support is. This is certainly the information you want to get, but unless you ask specific questions, you aren’t going to get specific answers.

I’ve put together some sample questions from past projects that should help anyone trying to get good information from references. Not all of these questions apply to every project, but they can be used as a good starting point for your own questionnaire.

Read more » (633 words)

Web Design Mega Reference


Web Design Mega Reference 01/07/2004 02:57 PM
Over 30,000 organized links, with an emphasis on web standards and accessibility.

Beginners Computer Reference


Beginners Computer Reference 03/19/2003 10:43 PM
From the feedback I get from time to time. I know some of you are beginner Geeks and are looking...

OpenGL Reference Manual v1.4


OpenGL Reference Manual v1.4 05/06/2004 02:28 PM

Best Online Reference Sites


Best Online Reference Sites 03/22/2005 05:09 PM
Best Online Reference Sites
http://ansernet.rcls.org/desk ref/

Best Online Reference Sites compiled by librarians in the Ramapo Catskill Library System. There are 496 links for you to choose from! This has been added to Reference Resources Subject Tracer™ Information Blog.

THX 1138 Reference Roundup


THX 1138 Reference Roundup 09/10/2004 03:07 PM
One of George Lucas' earliest films THX 1138 is rereleased in select theaters today by way of a director's cut, with the DVD set to come out next week. This cult classic film has made its way into various Star Wars tales as well, and a list of many of them are included in a new article psoted over on StarWars.com. Check it out and discover the various THX 1138 references in the Star Wars films and throughout the Expanded Universe.

Educator's Reference Desk


Educator's Reference Desk 01/02/2004 07:07 AM
Educator's Reference Desk
http://eduref.org/

This site gives access to "2,000+ lesson plans, 3,000+ links to online education information, and 200+ question archive responses. ... [It also] provides a search interface to the ERIC [Educational Resources Information Center] Database,
providing access to over one million bibliographic records on educational research, theory, and practice." The database is updated monthly and includes citations from 1966 to the present. Searchable. From the Information Institute of Syracuse (IIS).


100 3G Reference Phone Platform


100 3G Reference Phone Platform 02/18/2004 10:50 AM
3G Feb 18 2004 2:21PM GMT

The Best Online Reference Sites


The Best Online Reference Sites 01/04/2005 08:44 AM
Searchenginewatch.com - Tue Jan 4, 08:13 am GMT

The Educator's Reference Desk


The Educator's Reference Desk 12/15/2003 11:38 AM
The Educator's Reference Desk
http://www.eduref.org

The people who created AskERIC announce a new service and name to access the resources you've come to depend on for over a decade. While the U.S. Department of Education will discontinue the AskERIC service December 19th, you will still have access to the resources you've come to depend upon. Through The Educator's Reference Desk you can access AskERIC's 2,000+ lesson plans, 3,000+ links to online education information, and 200+ question archive responses. While the question answer service will no longer be active, The Educator's Reference Desk provides a search interface to the ERIC Database, providing access to over one million bibliographic records on educational research, theory, and practice.

Hey, Where'd My Internet Reference Go?


Hey, Where'd My Internet Reference Go? 11/02/2003 02:08 PM

Grok Description matches for MySQL: The Complete Reference
GrokA matches for MySQL: The Complete Reference

Chapter 7 (Replication) of High
Perforamnce MySQL is On-Line


Chapter 7 (Replication) of High
Perforamnce MySQL is On-Line
06/23/2004 05:22 PM
You can find a complete copy of the Replication chapter from High Performance MySQL (my book) over on dev.mysql.com. Read it. Learn something. Then buy a copy. Learn even more. Marvel at your new MySQL knowledge. Then send me a good resume so I can get you a job here at Yahoo. Or not. :-) About a month ago, they also posted the full text of chatper 6 (Performance Tuning). If that doesn't convince you to buy a copy,...

Forum Stories: VB script to connect to
MySQL


Forum Stories: VB script to connect to
MySQL
09/07/2004 03:34 AM

IPv6 on Fedora Core mini-HOWTO.


IPv6 on Fedora Core mini-HOWTO. 09/09/2004 10:06 PM
IPv6 on Fedora Core mini-HOWTO. Now we just need Teredo.

Notes and Tips: MySQL GUI Apps


Notes and Tips: MySQL GUI Apps 01/26/2004 10:18 AM
We compiled a little list of graphical applications for use working with MySQL databases.

Notes and Tips: MySQL Vulnerability


Notes and Tips: MySQL Vulnerability 07/12/2004 11:01 AM
Some versions of MySQL are vulnerable to a remote attack that can completely compromise security.

God Uses MySQL


God Uses MySQL 11/10/2003 11:40 PM
There was a lot of reaction to my recent post about MySQL at Sabre, most of which I don't have the time or interest to respond to. Too many people just Don't Get It and Never Will. But I was inspired to visit the church sign generator and make the image you see with this post. I think it's amusing. :-) Anyway, life would be so much easier if people stopped trying to think of MySQL in terms of...

MySQL to XML - XML to MySQL


MySQL to XML - XML to MySQL 10/02/2002 06:05 PM
Insert XML in MySQL and export MySQL to XML. The class XMLFile and my other class such as MySQL Connection, MySQL RecordSet and MySQL Log are required.

MySQL 4.0.18


MySQL 4.0.18 05/06/2004 06:50 PM
The world’s most widely used open source database.

TCB-mysql-0.2


TCB-mysql-0.2 05/26/2004 04:50 PM

MySQL 5.0


MySQL 5.0 12/29/2003 11:50 PM

Changes in release 5.0.0 (Development): MySQL has released an alpha of version 5.0. They include support for stored procedures, but no views yet.

C lick here to comment on this entry


MySQL 4.1.1 Now Available!


MySQL 4.1.1 Now Available! 12/07/2003 12:48 PM
MySQL's newest offering, MySQL 4.1.1, has been released. Their second alpha development release for the current version is now available in source/binary for the major platforms. There are new features galore, a more secure authentication scheme and support of multiple table spaces by MySQL's transa

Using MySQL from PHP


Using MySQL from PHP 03/06/2004 02:00 AM
One of PHP's prime benefits is its close integration with databases, especially MySQL. Having explained the basics of MySQL, John Coggeshall turns his attention to demonstrating how to use MySQL from PHP.

XAO-MySQL-1.01


XAO-MySQL-1.01 11/13/2003 12:45 AM

MySQL GOES GPL


MySQL GOES GPL 06/12/2002 06:22 AM
"We have always considered ourselves committed members of the Open Source and Free Software communities," said Monty Widenius, project leader on MySQL. Moving to the GNU General Public License (GPL) is a way to show this". It is the latest beta (version 3.23.19) and all new releases that is being GPLed.

MySQL Log


MySQL Log 09/28/2002 03:31 AM
Add and show the log provide by other classes such as MySQL Connection and MySQL Recordset

Use MySQL.


Use MySQL. 03/11/2003 10:45 AM
If you’re using Movable Type, use MySQL. If you have something against MySQL, use something else, but don’t use DB files. Note: Here comes the rant....

PHP vs mysql


PHP vs mysql 10/02/2002 01:58 PM

MySQL 4.0.16 now available!


MySQL 4.0.16 now available! 11/05/2003 10:36 PM
MySQL AB, developer of the world's most popular open source database, has released 4.0.16, the current production release of MySQL. Users with previous versions are encouraged to download this release.

MySQL Collection


MySQL Collection 10/22/2002 05:54 PM
Functions of Log +---- log() // Create a log file +---- addLog() // Append one line in the log file +---- show() // Show de log content in HTML format Properties of Connection +---- application // Name of application +---- host // IP or Name of MySQL Server +---- login // Login MySql +---- senha // Password MySQL +---- db // Database +---- admMail // E-mail of Admin +---- log // Instance o log object +---- conID // ID of MySQL Connection Functions of Connection +---- connection() // Inicialize +---- connect() // Conect with MySQL Server return de conID +---- close() // Close Connection Function of RecordSet +---- checkSql() // Protect sql from DROP, CREATE and other +---- select() // Select Query +---- setRow() // Fetch array +---- getLastID() // Return the last inserted ID +---- getFieldName() // Return a name o field +---- fieldsCount () // Number of Fields +---- recordCount() // Number of records +---- exec() // Execute a Inser, Update, Delete and others SQL +---- erase() // Delete one record by ID +---- erases() // Delete various records by Array (Such as checkbox) +---- comboBox() +---- comboBoxBin() +---- insert() // Generate a Insert SQL sentence with POST data +---- update() // Generate a Update SQL sentence with POST data +---- getForm() // Get POST data

MySQL wrapped 1.4


MySQL wrapped 1.4 08/20/2004 08:20 AM
Another C++ wrapper for the MySQL C API.

Novell and MySQL


Novell and MySQL 10/30/2002 05:08 PM
via MySQL.org: "Novell and MySQL AB, developer of the world’s most popular open source database, today announced that Novell will...

eBay to use MySQL?


eBay to use MySQL? 02/10/2004 02:49 AM
As reported by The Industry Standard, eBay is buying mobile.de, a large German on-line auto classifieds site. In case you didn't already know, mobile.de has been a long-time user of MySQL on their site. Not only do they run MySQL, but from what I've heard they've managed to push it very, very hard. Good stuff....

CGI / MySQL Programmer


CGI / MySQL Programmer 12/29/2003 06:53 PM
Neteffekt e.K. - Germany, Saarland, Saarbrücken (2003-12-29)

MySQL: The Complete Reference

The following phrases have been identified by the grok system as matching this entry: mysql perforamnce tips "you need the process privilege" mtop fedora connect to mysql remotely fedora nss-mysql howto

















Also check out:


Grok

Ipod Porn on the
Rise

Brief Abstract of
Wikipedia's
Mesothelioma Cancer
page

Get first aid
instructions in your
cell phone

IE is crap
JSPWiki gains
podcasting support

Using ext/mysqli
Part 1

PHP Class 'MySQL
Optimizer' released

YahooFinance: MySQL,
Zend Join Forces to
Strengthen Open
Source Web
Development

D.Net CMS Beta
Released

ADTmag: Open-Source
MySQL DBMS Adds
Clustering Tech

PHP Class 'Form
Classic' released

qpopper-mysql 0.13
released

Adding & Changing
Data in MySQL

Content Architect/IT
Analyst

Perl Application
Developer

Perl IS developer
Intermediate
Developer for an
online market
research company

Senior Perl
Developer wanted in
MN!!

OO CGI/mod_perl
developer

Immediate
Opportunities for
E-Commerce &
Transaction
Processing Co.

Perl / Mason
Application
Architect

PHP and Apache 2.0
PHP Class 'My Query
Report' released

PHP Class 'Email
Sender' released

PHP Class 'MySQL
Operations' released

Implement Bayesian
inference using PHP,
Part 1

PHP Class 'Browse
Edit' released

PHP Class 'Image to
PHP' released

PHP Class 'reGlobal'
released

PHP Class 'gonxtabs'
released

PHP Class 'PHP
Figlet' released

PHP Class 'MySQL
Backup Pro' released

Aqsis Renderer
release 0.9.1
Source, Windows
binary, RPM

PHP Class 'ADSI
Access' released

Switches look to
security to
recapture lost
luster

Tech group urges
action on health
care mandates

Sun kills UltraSparc
V, Gemini chips

Microsoft reins in
Longhorn for 2006
launch

Accounting questions
delay Salesforce IPO

Lindows to Change
Name

BugMeNot.com
Speed Sensing
Traffic Light

Smooth As Silk on
Square Wheels

Happy Birthday,
Internet!

The Exploratorium
System/360 Turns 40
Real Life X-Files
Early Usenet Posts
See the Ether
To the Moon!
Electronic Data
Coverage Insurance

The Endless Mountain
Life With Fedora
Field
FrooglePEG
what is grok?