MySQL Adding New Field to Existing Database Table
ALTER TABLE existingtable ADD newfieldname VARCHAR(255);........
M2Crypto.SSL.Checker.WrongHost: Peer certificate subjectAltName does not match host, expected fedora-archive.ip-connect.vn.ua, got DNS:mirror.ip-connect.vn.ua
You are using Centos 5 which is deprecated so nothing in yum will work until you follow this post to use the vault:
http://realtechtalk.com/Centos_59_Working_Vault_Repo_file-1921-articles
yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* epel: fedora-archive.ip-connect.vn.ua
Traceback........
Create Table with structure of another existing table
Create Table with structure of another existing tableOk, this has many valid uses such as if you need to create backups or the ability to undo changes, you would want to create new tables with the same structure as another. Here is how you do it.
[i:7ed9581493]
Also remember Indexes such as PRIMARY KEYS [b:7ed9581493]will not be preserved[/b:7ed9581493] so you will have to readd them manually.[/i:7ed9581493]
[code:1:7ed9581493]CREATE TABLE NewName AS SEL........
ADD PRIMARY KEY to Table
ADD PRIMARY KEY to TableHere is an example of readding a PRIMARY KEY with an AUTO_INCREMENT field:
[b:40986c2a8b]First make the field NOT NULL[/b:40986c2a8b]
[code:1:40986c2a8b]
ALTER TABLE tableName MODIFY FieldNAME INT(18) NOT NULL;
[/code:1:40986c2a8b]
[b:40986c2a8b]Create The Primary Key[/b:40986c2a8b]
[code:1:40986c2a8b]ALTER TABLE tableName ADD CONSTRAINT PRIMARY KEY(FieldName);[/code:1:40986c2a8b........