September 09, 2010, 01:43:29 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  Home Help Media Affiliates Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Add Column in Mysql Table  (Read 3632 times)
0 Members and 1 Guest are viewing this topic.
urparekh
Junior Member
*

Reputation: 0
Offline Offline
Posts: 5
Referrals: 0

Awards
« on: June 15, 2008, 08:05:03 AM »

Hello

Can anyone tell me how can I add column to mysql table using jdbc?

Any help regarding this is appreciated.
Logged
Javaforums.net :: a community about Java software development.
« on: June 15, 2008, 08:05:03 AM »

 Logged
Arkie
Javaforums.net Admin
Senior Member
*

Reputation: 16
Developer @ Javaforums.net
Offline Offline
Posts: 2620
Referrals: 13

WWW Awards
« Reply #1 on: July 05, 2008, 05:48:27 PM »

You could do something like this:

Code
GeSHi (javascript):
  1. String query = "ALTER TABLE engineeringserver ADD someColumn VARCHAR(255)";
  2. ResultSet result = stat.executeQuery(query);
Created by GeSHI 1.0.7.20
Logged

Java and .NET developer

To students: It doesn't matter how hard you've studied; the material won't be on the exam anyway.

Fan of http://www.retardedweblogger.com
Oh man, too much stuff to do in so little time.

http://img222.imageshack....707/arkietomatoesmall.jpg
Blizzcon 2k9 Grubby and Cassandra Ng engaged ! <3
Triple D, eerste Denken Dan Doen
Javaforums.net :: a community about Java software development.
   

 Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Your Ad Here
Powered by MySQL Powered by PHP Powered by SMF 1.1.10 | SMF © 2006-2009, Simple Machines LLC
TinyPortal v0.9.8 © Bloc
Valid XHTML 1.0! Valid CSS!
Page created in 0.23 seconds with 33 queries.

Google visited last this page Yesterday at 10:10:24 PM