61. Untitled Document The full mysql Reference Manual in HTML format. http://mysql.dyntex.com

We're sorry - this site is closed for maintenance

62. MySQL (mysql) On Twitter Get updates via SMS by texting follow mysql to 40404 in the United States How to Develop Simple PHP Applications for mysql Oct 19 @ 9am PT http://twitter.com/mysql

Skip past navigation On a mobile phone? Check out m.twitter.com Skip to navigation Skip to sign in form Have an account? Sign in Username or email Password Remember me Forgot password? Forgot username? Already using Twitter on your phone? Get short, timely messages from MySQL. Twitter is a rich source of instantly updated information. It's easy to stay updated on an incredibly wide variety of topics. Join today and follow @mysql Get updates via SMS by texting follow mysql to in the United States Codes for other countries Two-way (sending and receiving) short codes: Country Code For customers of Australia Telstra Canada (any) United Kingdom Vodafone, Orange, 3, O2 Indonesia AXIS, 3, Telkomsel Ireland India Bharti Airtel, Videocon Jordan Zain New Zealand Vodafone, Telecom NZ United States (any) mysql Do you know we have a MySQL blog? Check out the recent articles http://bit.ly/aNZvSj #MySQL #blog 3:57 PM Oct 27th via bitly Don't miss the next #MySQL #Essentials webinar! How to Develop Simple #PHP Applications for MySQL - Oct 19 @ 9am PT http://bit.ly/daZ5RS

63. MySQL Databases The Net’s best collection of mysql links from your About.com Guide to Databases. http://databases.about.com/od/shareware/MySQL.htm

zWASL=1 zGL='0';zGR='ca-about-radlink'; zJs=10 zJs=11 zJs=12 zJs=13 zc(5,'jsc',zJs,9999999,'') zDO=0 Home Databases Databases Search Databases Database Basics Learning SQL Using Databases MySQL Looking for a freeware database solution for your small business? MySQL provides a surprisingly robust feature set without the price tag of commercial products. Book Review: High Performance MySQL High Performance MySQL is a wonderful reference for database administrators migrating to the MySQL platform, particularly in enterprise deployments. MySQL 5 Overview zSB(3,3) Introduction to MySQL Fed up with the world of commercial software licensing? Are you looking for a stable database platform for your organization but sweating at the hefty price tags attached to mainstream products from Microsoft and Oracle? MySQL may be for you! MySQL: The Complete Reference Vikram Vaswani's book MySQL: The Complete Reference is a wonderful technical reference for this popular open-source database platform. It's comprehensive enough for seasoned MySQL users yet clear enough for the newcomer. Building a Database-Driven Web Site Using PHP and MySQL This 10-part series of articles by Kevin Yank offers a comprehensive tutorial enabling you to create interactive web sites with MySQL.

64. MySQL - Introduction Series of tutorials that explain SQL syntax through interaction with mysql. Includes information on Joins, Administration (backups, users) and Normalisation. http://www.keithjbrown.co.uk/vworks/mysql/

Virtual Workshops Part of keithjbrown.co.uk Main Menu Server Environment MySQL PHP Databases Web Design ... Excel MySQL Databases and the SQL Language Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc, there are very few that want to use MySQL to teach the SQL syntax and with it a bit about databases for the novice. Thus these workshops are simply about that... seeing how a simple database can be created and manipulated by typing SQL statements. Knowledge of what is going on 'underneath' user friendly interfaces is pretty good to know in my opinion. The workshops themselves are in themed parts, but it is intended that the reader work their way through each, building up SQL knowledge and understanding along the way. They are also meant to be a simple, if fairly comprehensive, introduction to MySQL and to SQL in general however the MySQL Documentation Site is still the best place to go for uptodate information and advanced features and techniques.

65. MySQL On Mac OS X mysql has become one of the most popular databases for Web applications. The database is well suited for common Webrelated tasks like content management, and for implementing http://developer.apple.com/internet/opensource/osdb.html

Advanced Search Log In Not a Member? Support ... Open Source MySQL has become one of the most popular databases for Web applications. The database is well suited for common Web-related tasks like content management, and for implementing Web features like discussion boards and guestbooks. For a time, some developers avoided MySQL for commercial applications because it did not implement certain features, such as transactions. But this is no longer the case, and MySQL is a great choice for just about any Web-based application. MySQL Features MySQL is also undeniably stable. In both your production and serving environments, you can be reasonably confident that MySQL will be up and processing queries as long as power flows to your machine. The popularity of MySQL is a benefit as well, because if you run into difficulty, you can lean on the active community that supports MySQL. There are many mailing lists dedicated to MySQL, and most questions find quick and thorough answers. MySQL Drawbacks Lack of support for transactions used to be a drawback of MySQL, but this has been addressed. Now, on Mac OS X, you can use the MySQL InnoDB table type and have access to row-level locking and robust transaction support, as well as foreign key constraints.

66. MySQL :: The MySQL SET Datatype Articles, forums and sample code on VB+mysql programming. http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html

Skip navigation links The world's most popular open source database Login Register Developer Zone Downloads ... Interviews About the Author Mike Hillyer is a Technical Writer for MySQL AB and lives in Alberta, Canada. We are always looking for interesting articles about MySQL! Have you written something and would like to it published here? Please contact us via Related Pages: MySQL Manual: The SET Type MySQL Manual: Bit Functions The MySQL SET Datatype By Mike Hillyer One of the least commonly used of the MySQL datatypes has to be the SET datatype. The SET datatype is a string type, but is often referred to as a complex type due to the increased complexity involved in implementing them. A SET datatype can hold any number of strings from a predefined list of strings specified during table creation. The SET datatype is similar to the ENUM datatype in that they both work with predefined sets of strings, but where the ENUM datatype restricts you to a single member of the set of predefined strings, the SET datatype allows you to store any of the values together, from none to all of them. Storage The MySQL SET datatype is stored as an integer value within the MySQL tables, and occupies from one to eight bytes, depending on the number of elements available.

67. Marc Liyanage - Software - Mac OS X Packages - MySQL The mysql database server is very popular for building web applications, The first step is to download the software from the mysql.com site. http://www.entropy.ch/software/macosx/mysql/

Software Mac OS X Packages MySQL MySQL Database Server Introduction Installation Instructions Database Re-Initialization Update Instructions ... Build Instructions This page in French Chinese Introduction The MySQL database server is very popular for building web applications, it is often used in combination with the PHP language. Since version 4.0.11, I am no longer building (from source code) and hosting the MySQL binary packages because the people at MySQL started to provide very nice official binary packages. I am however still providing and updating this set of installation instructions. Installation Instructions The first step is to download the software from the mysql.com site. First go to the downloads page at http://dev.mysql.com/downloads/mysql/4.1.html . Download the Standard installer package in the Mac OS X downloads section. Installation Procedure NOTE: You must have administrator rights to perform this installation. Do this to install for the first time (see below for update instructions): Mac OS version 10.2 and higher Download the package mentioned above to your desktop. Unpack it and then double-click on the .pkg file to install it.

68. Data Conversion Between Microsoft Access And MySQL The white paper highlights the benefits of data migrating from MS Access to mysql and discusses common kinds of conversion problems users will likely experience when publishing a database on the Web. http://www.data-conversions.net/pr/access2mysql.pdf

69. MySQL Tips A weblog that provides mysql tips, solutions, and tricks. http://mysql-tips.blogspot.com/

skip to main skip to sidebar MySQL Tips Snippets of MySQL tips, solutions, examples, tutorials, and even benchmarks Friday, January 02, 2009 PHPBB Convert poster_ip to real IP address in phpbb_posts table Let's say you see an offending user on your website and you have their IP and you'd like to see if they're a registered poster on your PHPBB forum. The problem is that the poster_ip field in the phpbb_posts table is encoded. Here's an example to convert it back and search for an offending IP, let's say in this case it's 255.255.255.255: SELECT * from nuke_phpbb_posts where inet_ntoa(conv(poster_ip, 16, 10)) = '255.255.255.255'; Posted by Tech Journalist at 11:31 AM Labels: phpbb poster_ip convert ip Friday, May 13, 2005 ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key If in Mysql get the message "ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key" when trying to drop a primary key, then do the following: (let's say the table is 'your_table' and the primary key column w/ auto_increment is 'the_column'): alter table your_table change the_column the_column int unsigned;

70. TAASC: MySQL Basics -- A Helpful MySQL Tutorial Jun 28, 2010 Stepby-step mysql installation (and upgrade) tutorial for Windows. SQL commands for creating databases. Tips for fixing error messages. http://www.analysisandsolutions.com/code/mybasic.htm

THE ANALYSIS AND SOLUTIONS COMPANY Home Advantages Databases Websites ... Web Design Errors MySQL Basics A Helpful MySQL Tutorial Introduction Welcome. This MySQL tutorial is a guide for new MySQL users, providing a reference of very basic , step by step, instructions on how to get started. This MySQL help page also gives more advanced users assistance in upgrading and running multiple versions of MySQL on a computer at the same time. MySQL is an SQL based relational database management system (DBMS) that runs under a broad array of operating systems. MySQL is frequently used by PHP and Perl scripts. The SQL commands discussed in this tutorial apply to MySQL operating under all operating systems. Only the installation instructions are Windows specific. The focus is on Windows XP Professional and Windows 2000 Professional machines. We'll be covering the installation of MySQL versions 5.0.51b, 4.1.16 as well as how to configure everything so they'll all be able to run on your system at the same time. Plus, the data directories will be moved to another location in order to make backups easier. If you only want to install one version of MySQL, ignore the instructions relating to the other versions. If your operating system or versions of MySQL are different, the instructions should still work, but keep an eye out for slight differences, like which working directory you'll need to be in.

71. MySQL | HowtoForge - Linux Howtos And Tutorials Which mailclient (suggestion please) ? Date/time format in /var/log/secure; send email to a local domain but mailbox are an /etc/mailname (dovecot postfix) http://www.howtoforge.com/howtos/mysql

LXer FAQForge Subscription Contribute ... Howtos Navigation Howtos Linux CentOS Debian ... Site Map/RSS Feeds User login Username: Password: Remember Me? Create a new account Request new password Who's online There are currently 7 users and 2368 guests online. HowtoForge Forums Getting PHP to work with Cherokee Reverse Proxy - Varnish ... website domain ... News Linux authentication login with USB device 6 of the Best Free Linux Camera Tools Adoption of Unity is the Most Significant Change Ever for Ubuntu, Says Mark Shuttleworth Adoption of Unity is the Most Significant Change Ever for Ubuntu, Says Mark Shuttleworth ... more Recent comments Thanks a lot! It works 1 day 59 min ago Re: One package has changed... 1 day 6 hours ago Re: Snort HOWTO 1 day 13 hours ago oh yes,... its a HUGE difference. 1 day 17 hours ago Struggling with walk through 1 day 22 hours ago A little error at step 9 2 days 35 min ago Allowing FTP and TLS Sessions 2 days 1 hour ago A suggested fix for international users 2 days 9 hours ago I did everything in this tutorial, still not working 2 days 16 hours ago Re: Theme 2 days 19 hours ago Newsletter Subscribe to HowtoForge Newsletter and stay informed about our latest HOWTOs and projects.

72. TAASC: MySQL Basics -- A Helpful MySQL Tutorial Explains how to install, maintain, and use the mysql server on Windows systems. http://www.analysisandsolutions.com/code/mysql-tutorial.htm

THE ANALYSIS AND SOLUTIONS COMPANY Home Advantages Databases Websites ... Web Design Errors MySQL Basics A Helpful MySQL Tutorial Introduction Welcome. This MySQL tutorial is a guide for new MySQL users, providing a reference of very basic , step by step, instructions on how to get started. This MySQL help page also gives more advanced users assistance in upgrading and running multiple versions of MySQL on a computer at the same time. MySQL is an SQL based relational database management system (DBMS) that runs under a broad array of operating systems. MySQL is frequently used by PHP and Perl scripts. The SQL commands discussed in this tutorial apply to MySQL operating under all operating systems. Only the installation instructions are Windows specific. The focus is on Windows XP Professional and Windows 2000 Professional machines. We'll be covering the installation of MySQL versions 5.0.51b, 4.1.16 as well as how to configure everything so they'll all be able to run on your system at the same time. Plus, the data directories will be moved to another location in order to make backups easier. If you only want to install one version of MySQL, ignore the instructions relating to the other versions. If your operating system or versions of MySQL are different, the instructions should still work, but keep an eye out for slight differences, like which working directory you'll need to be in.

73. MySQL Articles High Performance mysql, Second Edition is the definitive guide to building fast, reliable systems with mysql. Written by noted experts with years of http://onlamp.com/onlamp/general/mysql.csp

Sign In/My Account View Cart O'Reilly Home Community ... About We've expanded our LAMP news coverage and improved our search! Search for all things LAMP across O'Reilly! Search Search Tips var addthis_pub = 'odewahn'; News Optimization, Backups, Replication, and more by O'Reilly Media High Performance MySQL, Second Edition is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. Learn advanced techniques in depth so you can bring out MySQL's full power. The second edition is completely revised and greatly expanded, with deeper coverage in all areas. Learn more. Brian Aker's Vision for a Livable Design, Looking at MySQL as OSCON Approaches by James Turner With me today is Brian Aker, Director of Technology for MySQL. Brian is the author of Running Weblogs w/ Slash. He's also leading a tutorial at O'Reilly's Open Source Convention, July 21-25, in Portland, Oregon... MySQL forks: could Drizzle be the next of the new generation of relational database?

74. MySQL - Simple English Wikipedia, The Free Encyclopedia mysql is a database system used by many websites on the Internet. http://simple.wikipedia.org/wiki/MySQL

75. Installare MySQL | Database | ASPItalia.com Tutorial su come installare e configurare mysql, importare dati da Ms Access ed utilizzarlo con Php e Asp.net. http://www.aspitalia.com/articoli/db/mysql.aspx

@import url(http://gui.aspitalia.com/styles/aspitalia.css); my.ASPItalia.com ASP.NET e web Silverlight .NET Framework Windows Phone 7 e mobile ... Tags Dall' archivio articoli Installare MySQL di Andrea Zani , in Database il 5 febbraio 2001 alle 08:00 Archiviato in Database MySQL Commenti ( piace a non piace a 2 pagine in totale: Le soluzioni alternative sono numerose. Tra queste spiccano, in ambiente Windows, database professionali come Microsoft Server SQL 7 e Oracle, capaci di soddisfare qualsiasi esigenza presente e futura, nonostante il prezzo da pagare per le licenze di questi prodotti non sia proprio basso. Eppure anche in ambiente Windows esistono alternative molto valide e dal prezzo ridottissimo se non addirittura nullo, come MySQL. MySQL nel dettaglio Dove prelevare tutto quello che ci occorre www.mysql.com Iniziamo scaricando il server. Andando nella pagina Downloads e scegliendo come sistema operativo Win32, possiamo scaricare l'ultima versione shareware che ha dimensione intorno ai 5 megabytes, oppure, la versione che io consiglio, l'ultima versione beta stabile di circa 10 megabytes. Riassumendo per i neofiti del MySQL, i pacchetti indispensabili per il funzionamento di questo database sul nostro computer per le pagine ASP sono i seguenti:

76. MySQL Gotchas Jul 12, 2008 When working with the mysql ™ database server I have repeatedly encountered situations where the results of various actions have been http://sql-info.de/mysql/gotchas.html

sql-info.de Start MySQL Resources MySQL MySQL vs ... Notes Examples ... PostgreSQL About Contact Site-Info Search: Powered by Linux Apache PostgreSQL 9.0.1 MySQL Gotchas Next MySQL Gotchas Notes 1. This is not an "anti-MySQL" list, although it does contain critical comments; 2. MySQL is continually improving and some of the points listed here are no longer valid for recent versions; 3. This list is regularly updated, but may not always reflect the latest developments (unfortunately I've been busy the past couple of months and haven't had time for the site at all; watch this space ;-). Note to Slashdot readers: this page deals with issues related to MySQL 4.1 and earlier, not 4. There's a list for PostgreSQL too. 5. There aren't similar lists for other RDBMS. Yet. 6. Oh yes, this page may not render well in Internet Explorer, run along and get yourself a proper browser. Table of Contents 1. General SQL 1.1. NULL, or when NULL IS NOT NULL 1.3. ENUM 1.4. Case sensitivity in CHAR / VARCHAR fields ... 6.1. External Links It's not a bug - it's a gotcha. A "gotcha" is a feature or function which works as advertised - but not as expected. When working with the MySQL â„¢ database server I have repeatedly encountered situations where the results of various actions have been unexpected and/or contrary to the behaviour generally expected of an SQL relational database. The cause can usually be traced to implementation details which are documented in the manual. I have created this list in order to further a better understanding of the MySQL database server and hopefully save others unnecessary headscratching.

77. PHP: Mysql_query - Manual mysql_query() sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier. http://www.php.net/mysql_query

@import url("/styles/site.css"); @import url("/styles/mirror.css"); @import url("/styles/print.css"); downloads documentation faq getting help ... my php.net s earch for in the all php.net sites this mirror only function list online documentation bug database Site News Archive All Changelogs just pear.php.net just pecl.php.net just talks.php.net general mailing list developer mailing list documentation mailing list PHP Manual Function Reference Database Extensions Vendor Specific Database Extensions ... query Last updated: Fri, 29 Oct 2010 view this page in Brazilian Portuguese French German Japanese Polish Romanian Persian Spanish Turkish Other (PHP 4, PHP 5) Send a MySQL query Description resource string $query resource Parameters query An SQL query The query string should not end with a semicolon. Data inside the query should be properly escaped The MySQL connection. If the link identifier is not specified, the last link opened by is assumed. If no such link is found, it will try to create one as if was called with no arguments. If no connection is found or established, an level error is generated.

78. RISORSE.NET - Guida MySQL, Libri Su MySQL E Hosting MySQL <- MySQL: Il DBMS Open Guida all installazione e configurazione di mysql su Windows e Linux. Propone articoli di approfondimento, recensioni di hosting e libri sul programma. http://www.risorse.net/mysql/

Tecnologie HTML CSS DHTML ... Analisi Per tutti .: Magazine .: Editor .: Appunti .: Gratis ... Home page Partner Comunicati stampa Proposte di viaggio Accessori palmari versione stampabile Livello di difficoltà: MySQL è il database open source per eccellenza. Cresciuto molto in questi anni, è diventato il DBMS più utilizzato dalla comunità open source e apprezzato anche da chi scrive pagine con tecnologie diverse da PHP e su server diversi da Linux. Guida MySQL, Libri su MySQL e hosting MySQL MySQL: il DBMS open source per eccellenza Risorse.net Altre puntate della guida saranno pubblicate nei giorni a venire... CONOSCENZE CONSIGLIATE PER IL TUTORIAL: SQL Installare MySQL su Linux Come installare MySQL su server Linux Installare MySQL su Windows Come installare MySQL su server Windows Configurare MySQL su Linux e Windows Come configurare MySQL su server Linux e Windows Tipi di campi I vari tipi di campi previsti Guida a PhpMyAdmin Come amministrare MySQL con PhpMyAdmin SQL di base Le regole basilari del linguaggio SQL Gli operatori di confronto Confrontare diversi campi di una tabella all'interno di una query Operatori matematici di base: somma, sottrazione, moltiplicazione, divisione ecc.

79. MySQL Cheat Sheet Selecting a database mysql USE database; Listing databases mysql SHOW DATABASES; Listing tables in a db mysql SHOW TABLES; Describing the format of a http://www.nparikh.org/unix/mysql.php

Neal Parikh Home Notes Quotes About Selecting a database: Listing databases: Listing tables in a db: Describing the format of a table: Creating a database: Creating a table: Load tab-delimited data into a table: Inserting one row at a time: Retrieving information (general): Reloading a new data set into existing table: Fixing all records with a certain value: Selecting specific columns: Retrieving unique output records: Sorting: Date calculations: Pattern Matching: Extended Regular Expression Matching: Counting Rows: Grouping with Counting: Selecting from multiple tables: Currently selected database: Maximum value: Auto-incrementing rows: Adding a column to an already-created table: Removing a column: ALTER TABLE syntax available at mysql.com.) Batch mode (feeding in a script): Backing up a database with mysqldump: MySQL's docs

80. MySQL | Freshmeat.net mysql is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries. http://freshmeat.net/projects/mysql

Login Signup Lost password? document.write(''); dfp_tile++; Home Articles Browse Projects by Tag Submit new Project ... Projects MySQL Download More Information MySQL MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries. Tags Database Database Engines/Servers Licenses GPL Operating Systems Mac OS X Windows Windows Windows ... All releases Recent releases 06 Oct 2010 15:39 Changes: This release contains an updated InnoDB plugin. Bugs were fixed for replication, partitioning, log flushing, views, and various SQL functions. 5.5.6-rc 21 Sep 2010 10:17 Bugfixes security fixes 5.5.x Changes: This release contains various security fixes and bugfixes in the areas of replication, Performance Schema tables, and partitioning. 24 Aug 2010 12:36 Changes: This release updates the InnoDB Plugin to version 1.0.11, changes behavior regarding the 'LOAD DATA INFILE' statement in a statement-based replication environment, and contains various changes regarding partitioning. 27 Jul 2010 21:58 Bugfixes 5.1.x

Page 4     61-80 of 145    Back | 1  | 2  | 3  | 4  | 5  | 6  | 7  | 8  | Next 20