> You mean stored procs and functions are not dependent on tables?
They can, but not "have to" use tables.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development que
> You mean stored procs and functions are not dependent on tables?
They can, but not "have to" use tables.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development que
You mean stored procs and functions are not dependent on tables?
On 6/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Stored procedures and functions are not associated with tables. Triggers
are, and I
don't know about those.
Ananda Kumar wrote:
> Hi All,
> Will the rename of table from y to
Stored procedures and functions are not associated with tables. Triggers are, and I
don't know about those.
Ananda Kumar wrote:
Hi All,
Will the rename of table from y to x cause for all the stored procs,
functions on this table to be come invalid?
regards
anandkl
On 6/14/07, Brian Dunning
Hi All,
Will the rename of table from y to x cause for all the stored procs,
functions on this table to be come invalid?
regards
anandkl
On 6/14/07, Brian Dunning <[EMAIL PROTECTED]> wrote:
Many thanks to all who took the time to reply. :) :)
--
MySQL General Mailing List
For list archive
Many thanks to all who took the time to reply. :) :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes, that will lock up the table while the change is being made. One
technique you can use is to rename the table and create a new to catch
the incoming data.
RENAME TABLE x TO y;CREATE TABLE x LIKE y;
By putting both commands on 1 line, it will execute almost immediately.
Then you can alter t
Brent Baisley wrote:
Yes, that will lock up the table while the change is being made. One
technique you can use is to rename the table and create a new to catch
the incoming data.
RENAME TABLE x TO y;CREATE TABLE x LIKE y;
By putting both commands on 1 line, it will execute almost immediately.
Hi Brian,
Brian Dunning wrote:
...if I add a column to a table with 40,000,000 records, will it cause
that table to hang for any significant amount of time, and prevent other
transactions? It's a MyISAM table and I was going to add a varchar(20)
column, NULL. It's a very busy table, constant s
...if I add a column to a table with 40,000,000 records, will it
cause that table to hang for any significant amount of time, and
prevent other transactions? It's a MyISAM table and I was going to
add a varchar(20) column, NULL. It's a very busy table, constant
searches and inserts.
--
My
10 matches
Mail list logo