MySQL Table Editor extension released. wysiwygwebbuilder.com 9 Aug 2013 | 03:53 pm

The MySQL Table Editor can be used to view, add, edit or delete records of a MySQL table. There is also a built-in search option.

OpenTracker – Lean and mean PHP Bittorrent Tracker phpcode.mypapit.net 10 May 2007 | 03:48 pm

Opentracker is the most simple php bittorrent tracker that I came across. It only requires a single MySQL table to function and it is a fully compliant bittorrent tracker as outlined by Bram Cohen. I...

[MySQL] How to remove duplicate rows- the fast way de77.com 7 May 2012 | 06:12 am

Below you can two simple and fast method do remove duplicate rows from a MySQL table. Method 1 Let’s create a new unique index, like this: Method 2 Create a new table and copy content from old tab...

Magento invoices mysql table located php4u.co.uk 24 Aug 2010 | 08:26 pm

If you’re looking where Magento stores its invoices, first step was to locate table sales_order_invoice, but such table doesn’t exists. Good starting point is always a Magento API, which shows you a ...

Installation: Production vs. Sandbox easyapns.com 1 Jan 2010 | 05:21 pm

Once you are successfully receiving registrations in your `apns_devices` MySQL table, you will need to make a manual change for devices that you wish to use your development certificate. By default al...

Installation: MySQL Database easyapns.com 1 Jan 2010 | 05:15 pm

There are two different files that can be used for creating the MySQL tables you will need for Easy APNS to function. However, you will only need to use ONE of them. The primary file is named 'apns.sq...

Private chat room script codingmix.com 4 Jan 2012 | 10:47 pm

Finally my private chat room is ready! I`we used jQuery, PHP and 2 MySQL tables to write this script. This is the first version, this is some kind of beta version, because I hadn`t test it yet, becaus...

Insert into multiple MySQL tables with one-to-one relationship rndblog.com 21 Jun 2011 | 06:14 am

I have been asked if there is a way to insert data into two MyISAM tables that connected by a one-to-one relationship in one MySQL query. For example: mysql> CREATE TABLE `user` ( `id` int(10) unsigne...

Formatting date values returned from MYSQL table to more readable format including time goranmitev.com 2 Mar 2011 | 04:17 am

MySQL : Altering Huge Tables adminlinux.blogspot.com 7 Dec 2010 | 11:31 pm

You have a huge mysql table - maybe 100 GB. And you need to run alter on it - to either add an index, drop an index, add a column or drop a column. If you run the simple mysql "alter table" command, y...