|CareBear\||toanducit : Do you mean drop tables?|
|CareBear\||toanducit : Or delete rows?|
|fowlduck||Xgc: I just found out that the product already included such a diagram, argh!!!!|
|CareBear\||toanducit : Did you read "DROP TABLE Syntax" in the manual? I just looked it up and it is very simple.|
toanducit : dro ptable name1, name2, name3 etc.
No, bedtime, need to get up again in oh two hours. :\
|StuBo||Any body know what repair with keycache means for a mysql process state|
|emp_m||it appears that nested sets are the best way to deal with hierarchal data in sql, is this correct?|
|StuBo||help....my db is taking hours doing a repair with keycache :(|
|vice-versa||StuBo: how many records?|
|StuBo||vice-versa: a few million|
from what Im reading on the web it could be doing it for many hours
about 26 million I think
all I did was add a new field to that table.....
the new filed isnt an index but some of the other fields do
|vice-versa||yeah, it could even be days :(|
|StuBo||would it bugger my db or table up if I killed the process|
bugger it...im just going to kill it....I can't wait for days
|vice-versa||dunno, but I've read references of others stopping the process to use myisamchk and or change to change myisam_max_sort_file_size and myisam_max_extra_sort_file_size|
|StuBo||yeah....incressing their size might make it do a repair filesort as appose to repair keycache|
|vice-versa||worth a try imo|
does anyone wrote some batch record adding script ?
if im in my shell linux box what do i have to type to perform this command?
i need to create a script so that i can automatically input the commands in my script file and to manipulate my mysql
i forgot the syntax of mysql in shell scripting in linux
|preaction||mysql -e"run this command"|
|toanducit||I have two table: aaaa_test1, bbbb_test 1. How do I drop 2 table in one statement?|
|preaction||drop aaaa_test1; drop bbbb_test 1;|
or! start transaction; drop; drop; commit;
though i doubt drop can be transactioned
|toanducit||Do you have other solution?|
|preaction||why? this sounds like an xy problem|
|_syphilis_||how do i change a view's definer?|