DelphiFAQ Home Search:
General :: Databases :: mysql
General information about mysql - how to get around the differences between version 3.33 an 4, how to do stuff that you think you need a nested query for etc.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

How can I rename table names and column names in mysql

If only a few changes are necessary, you can just go through a web administration tool like phpAdmin.

If you have many names to change, you could write a script (possibly even generate a script by a tool) and execute it like this:

mysql DATABASENAME -uUSERNAME -pPASSWORD <SCRIPTFILE

The script would contain the SQL commands as shown here:

alter table orgs change o_id org_id int(11);
 alter table orgs change o_name org_name varchar(64);
 rename table orgs organizations;
 

Generated 20:00:32 on Jun 26, 2017