Kangry.com [insert cool graphic here]
home | Topics | Logout | Search | Contact | ?? Kangry ?? | Bandwitdh
Topics:
DVR
nvrec
Mplayer
Links
Misc
Commands
Humor

Name

Password

New user

uploaded files
(links)-> (Parent)->MySQL Via PHP Cheat Sheet (quickref),php+xml submited by Russell Sun 04 Dec 05
Edited Fri 22 Jul 11
Web kangry.com
MySQL Via PHP Cheat Sheet I actually have most of this , I normaly just copy the snippet I need from a program I made previously. But it could be handy to have it all in the same place.
Debugging techniques for PHP programmers[IBM]
A few XML & PHP Tutorials
POG - A PHP Code Generator
Create dynamic images using PHP(tutorial)
Max table sizes for Mysql (AKA The table is full error)
More notes on full tables,
This command will adjust the table to allow a larger size (assuming the underling OS will allow it )
ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn;
I used 300 for my AVG_ROW_LENGTH because I calculated my average to be about 260 bytes/row. YMMV
*WARNING* if you are doing this because the table is too big.. THIS WILL TAKE A LONG TIME.. COULD BE HOURS. during this time you will be able to query the table, but *NOT* update records.


Replys:
Import spreadsheet (csv) data into mysql database (Russell)

Add comment or question...:
Subject:
Submited by: NOT email address. Leave blank for anonymous    (Spam Policy)

Enter Text: (text must match image for posting)




This file (the script that presented the data, not the data itself) , last modified Wednesday 03rd of December 2014 09:40:39 AM
your client: CCBot/2.0 (http://commoncrawl.org/faq/)
current time: Wednesday 28th of June 2017 03:04:13 AM