Welcome To Snipplr
Everyone's Recent Snippets Tagged mysql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
Substitute new_ placeholder in the second line with your new prefix. Run it: http://www.yoursite.com/rename.php and wait until it responds with an OK, usually after a couple of seconds. Delete the rename.php script. Edit the configuration.php file...
0
937
posted 14 years ago by beneberle
The current time, converted from UNIX timestamp to use in MySQL DATETIME
0
993
posted 14 years ago by koko
Syntax used to create a table in MySQL. Replace column names as appropriate. Primary key should also be modified to suite needs.
2
731
posted 14 years ago by dkynyc
ASP
MySQL: Preventing "Unable to convert MySQL date/time value to System.DateTime" (Invalid Date Data).
Changing the connection string in the web.config to allow zero date and converting it prevents this error.
0
971
posted 14 years ago by jink
Add the System.Data config settings for MySql. Update the version to number referenced.
0
732
posted 14 years ago by jink
A simple PHP object which connects to a mysql database, selects fields, creates users and more..
0
892
posted 14 years ago by djstaz0ne
How to add an auto-incremented column to an existing table without ex- and reimporting.
0
966
posted 14 years ago by simondiercks