Working diary
Showing posts with label
MySQL
.
Show all posts
Showing posts with label
MySQL
.
Show all posts
Wednesday, 5 June 2013
Backup a table in MySQL
›
In my experiment, each experiment running needs a table in the control machine to record the global inserted files in the system. When an ex...
Tuesday, 26 June 2012
Install MySQL and Development environment in Fedora 17
›
The installation of MySQL in Fedora is easy and trivial task because the MySQL server package is available in official yum repository. It ca...
Friday, 2 March 2012
Add column to existing table
›
Many ways to add column to existing table in MySQL. If you r using GUI tools, add column to table in MySQL is easy. If you are using CLI...
Saturday, 19 February 2011
Change table properties in MySQL::
›
The most basic one is : ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT; More detailed can be found here: http:/...
Friday, 18 February 2011
Experiment Q&A............
›
When I compiled the lookup program using MySQL connector C++ statically: Q: what if I am confronted with " ld: can not found lm ...
Thursday, 17 February 2011
DELETE all of rows in a TABLE in MySQL (Refer to others' work)
›
Delete and Truncate There are two ways to delete all the data in a MySQL database table. TRUNCATE TABLE tablename; This will delete all dat...
›
Home
View web version