Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tore Bleken
  Where is Tore Bleken?
 Stokke
 Norway
 Tore Bleken
 To: Pratik Singh
  Where is Pratik Singh?
 Kota
 India
 Pratik Singh
 Tags
Subject: RE: mysql structure update
Thread ID: 395421 Message ID: 395424 # Views: 55 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, January 14, 2014 8:12:07 PM         
   


> HI
>
> Need mysql structure update without drop table. because if i drop table all data also drop.
>
> i need my existing table still alive and missing fields add in table so that table data also saves and missing fields add in table
> how is possible
>
> i found many code from google uncle but all code first drop table and make new. that i lost data.
>
>
>
> Regard
> Pratik
>
> Learning never ends

You must have used wrong words on Google.

http://www.tech-recipes.com/rx/378/add-a-column-to-an-existing-mysql-table/

There's a fine line between helping and adding to the confusion.

How to create sample data

ENTIRE THREAD

mysql structure update Posted by Pratik Singh @ 1/14/2014 8:01:32 PM
RE: mysql structure update Posted by Tore Bleken @ 1/14/2014 8:12:07 PM
RE: mysql structure update Posted by Pratik Singh @ 1/14/2014 8:27:49 PM
RE: mysql structure update Posted by Pete Sass @ 1/14/2014 8:21:38 PM
RE: mysql structure update Posted by Vivek Deodhar @ 1/15/2014 6:31:12 AM