Search / 40 posts tagged mysql table

table_syncer version 0.2.0 has been released! tool to synchronize data across databases Changes: ## 0.2.0 2009-09-39 * Now prompts you if you use --commit [so you don't do it on accident] * Minor code cleanups :)

DevShed continues their series focusing on the CodeIgniter framework with the seventh part - a look at interacting with the database to update, delete and insert rows from your application. read more

Gigantic IN Clauses By Gerry Narvaja — September 24th, 2008 at 11:11 am Posted in MySQL Tags: filesort • in clause • MySQL • sql • temporary table Over the last few weeks I’ve been looking at several customers’ slow query logs, and I found in many of them an odd type of query.

With DrasticGrid, you can easily put a MySQL database table or view on a Web page, complete with editing, sorting, and pagination capabilities, and support for adding and deleting records. DrasticGrid is one of three controls from DrasticData -- the others are a tag cloud and Google Maps controller,

Why You Want to Switch to MySQL 5.1 By Sheeri Cabral — August 10th, 2008 at 9:23 am Posted in Group Blog Posts • MySQL • Non-Tech Articles Tags: alter table • auto increment • autoincrement • auto_increment • innodb • logging • MySQL • mysql 5.1 • online alter table • online logging • prepared

How to create, see and update table comments so your database scheme is somewhat self documenting

PHP and MySQL are one of the most used technologies on the web today. By using about 7 different script files we can add, update, and delete rows from a MySQL table. Example of completed project: Download the Simple PHP MySQL Table Editor. Lets get started.

PHP and MySQL are one of the most used technologies on the web today. By using about 7 different script files we can add, update, and delete rows from a MySQL table. Example of completed project: Download the Simple PHP MySQL Table Editor. Lets get started.

Sun Bundles MySQL Database, GlassFish App Server — Sun Microsystems — InformationWeek - In one of the first results of its $1 billion purchase of MySQL, Sun Microsystems (NSDQ: JAVA) has packaged the popular open source database with its GlassFish application server and is offering the two as a $65,000-per-year bundle.

InnoDB is a storage engine that uses MVCC (described shortly) to provide ACID-compliant transactional data storage using row-level locking.  MVCC stands for Multi-Version Concurrency Control.  It is how InnoDB allows multiple transactions to look at a data set of one or more tables and have a consistent view of the data.