Quoting Tony Weeg <[EMAIL PROTECTED]>: > > has anyone on here ever had to add a column or change a column's > properties. My database already has like 15 million rows of data in it? > > if so, how the HECK did you do it?
ALTER TABLE table ADD COLUMN column datatype; Never done it on something larger as 8 million rows and it takes some time, but it is not something that ought to break anything. Just remember that this will most likely exclusively lock your table, and that CF (or any other web language) is not the right tool for it, but you need the native DB management tools. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
