UBBFriend: Email This Page to Someone!

DevShed Discussion Forums   MySQL   change datatype    profile | register | preferences | faq | search

Author	Topic:   change datatype
hkccm Member	posted March 07, 2000 06:32 AM             I have already assigned a DATATYPE eg. userid VARCHAR(20) now, I want to change it to VARCHAR(40) what should i type in MySQL?
Kyuzo Member	posted March 07, 2000 06:34 AM             ALTER table table_name MODIFY userid varchar(40);
masood Member	posted March 07, 2000 06:35 AM          alter table TABLENAME change column userid varchar(40) something like that. check the manual for correct syntax...

All times are MST (US)	next newest topic | next oldest topic
Administrative Options: Close Topic | Archive/Move | Delete Topic
	Hop to: Select a Forum List of Forums: ApacheBeginnersSecurityOpen Source DiscussionXMLWAP/WMLPostgreSQLBanner AdvertisingExchange/OutlookGraphicsHTML / DHTMLJava ServletsJavaScriptMidgardMySQLPHPPerlPythonSearch EnginesWeb HostingZope

Copyright © 1997-2000 ngenuity. All rights reserved.

Powered by: Ultimate Bulletin Board, Version 5.41a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998 - 1999.