Click here to Skip to main content
15,914,162 members
Search within:


How to create new Column to existing table in mysql?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
MySQL
How to create new Column to existing table in mysql?
Posted
Updated 6-Aug-10 21:31pm
v2
Add a Solution

1 solution

you can use something like this
ALTER TABLE table_name ADD new_column_name VARCHAR(60);


here is the ref manual[^]
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
1072 - Key column 'UserID' doesn't exist in table
How do I create a new workbookconnection for an existing pivtotable?
Mysql:create table con PHP now table
Creat table in database with user input and link it with table that already exists in PHP and SQL
How to sum two columns to create a new column in mysql
How to change mysql column from html table with php scripting
MySQL table to JSON?
Key column 'users_id' doesn't exist in table and key column 'purchase_id' doesn't exist in table
Create a new table from an existing table for each distinct value of a particular column and name the new table with this distinct value
Adding column with primary key in existing table

Advertise
Privacy
Cookies
Terms of Use
Last Updated 7 Aug 2010
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-05-30:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900