U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Automatic Upgrade MySQL schema

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: Automatic Upgrade MySQL schema [message #37424 is a reply to message #37423]

Tue, 02 October 2012 12:40

mirek
Messages: 14261
Registered: November 2005

Ultimate Member

Upgrade schema, in its current state, is not meant to change column types (which is sort of unusual operation anyway and not all DBs support it easily in all cases), but only to add new columns.

That way, I believe this part of examples is relevant:

Quote:

To add a new TIMESTAMP column named d:

ALTER TABLE t2 ADD d TIMESTAMP;

Mirke

Report message to a moderator

[Message index]

		Automatic Upgrade MySQL schema By: sergeynikitin on Fri, 28 September 2012 04:48
		Re: Automatic Upgrade MySQL schema By: mirek on Tue, 02 October 2012 08:00
		Re: Automatic Upgrade MySQL schema By: sergeynikitin on Tue, 02 October 2012 12:25
		Re: Automatic Upgrade MySQL schema By: mirek on Tue, 02 October 2012 12:40
		Re: Automatic Upgrade MySQL schema By: sergeynikitin on Tue, 02 October 2012 12:56
		Re: Automatic Upgrade MySQL schema By: mirek on Tue, 02 October 2012 14:21
		Re: Automatic Upgrade MySQL schema By: sergeynikitin on Wed, 03 October 2012 10:35
		Re: Automatic Upgrade MySQL schema By: mirek on Wed, 03 October 2012 12:41

Previous Topic:	XmlNode and text
Next Topic:	List DSN in ODBC

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jun 08 01:01:46 CEST 2025

Total time taken to generate the page: 0.13819 seconds