12-31-2011, 07:00 PM
Hi, how do you add a column to multiple tables at once? Is it possible?
01-02-2012, 01:04 AM
If you mean with one SQL statement, no, it's not possible.
If you mean with one Stored Procdefure, yes, it is.
If you mean with a handful of PHP/JSP/ASP statements, yes, it is.
But the very fact you are asking this question makes me thing you may have a bad database design. For example, if you have one table for each user or something like that, you have a bad design. You might want to show us at least an outline of your DB schema.
Powered by vBulletin® Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. All rights reserved.