Surf 11 » MySQL - SQL To Add a Column to a Table
Finding the best waves on the web.
October 03, 2006
Here's a simple SQL statement to add a varchar column of size 100 to a table:
ALTER TABLE tablename ADD COLUMN columnName varchar(100);
Related Entries
- Change size of a varchar column with mysql
- Alter Table Add Column on SQL Server
- MySQL Access Denied error 1044
- High availability MySQL on Amazon EC2
- MySQL ERROR 1016 (HY000): Can't open file
- MySQL Optimization Hints
- SELECT NULL Rows with MySQL
- My MySQL Backup Script
Comments
On at viney sakhuja wrote:
1
thanks a lot .i dnt have words to say thanks.
On at illness wrote:
2
owCAKl site! good such with Go Hi! on Great a work. ,
- Solved: Could not perform unpadding invalid pad byte
- Getting Started - Making AJAX Applications Crawlable - Google Code
- Our Collectors : Jon Masamitsu's Weblog
- Ponemon Cost of a Data Breach
- jsPerf: JavaScript performance playground
- Updating OpenSSH over SSH with yum CentOS
- betali.st
- How to Version HTML5 Database openDatabase()
Subscribe to our RSS Feed: 
XML
XML