This is a general code to use when updating an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match.
This is a general code to use when inserting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. An extention of this code would be to make sure the entry you are adding to the database doesn't already exist (to save dupicate entries). Note: This code requires you to connect to the MySQL...
Example MySql code to append Data to Field in MySql
Adding a linked server to MSSQL account - particularly a MYSQL server
This is a general code to use when deleting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. A variation of the code would be not to delete the record (as you tend to always need to restore or retrieve it sooner or later) you can add a 'status' field. If status='d' then it is...
MySQL code to connect to db. Don't forget to change the parameters.
Define few variables with your MySQL database connection settings and connect to MySQL database using mysql_connect() and mysql_select_db() functions.
If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.
Below shown how to Back Up and Restore a MySQL Database
Mysql Code example to find events made between two times not between two dates.
How to Back Up and Restore a MySQL Database
MySQL code to generate random string
PHP example for connecting to MySQL
Example code to create CSV from MySQL
PHP code example to process MySQL Timestamp
MySQL's MAX aggregate function will find the largest value in a group. here shown an example
Example code to load CSV back into mySQL
You can search and replace fields by below query in MySQL Database
How to select a random row in MySQL
Mysql function to Fetch entire result set