Droping multiple tables by a pattern in the table name
Hello, I'm using mysql 4.1.14-standard. I would like to drop multiple tables in one or few queries. I don't have an easy way to predict their names (I have a way to find their names, but it's by using software and I prefer doing it with mysql). All of the table names have a fixed part which I know, and I thought of using the fixed, known part of the names to delete all of these tables at once. Can someone lead my to the way doing it with a mysql queries? I thought of using the combination of 'SHOT TABLES LIKE '%regexp%'; and DROP, but I don't know how to combine them. Thanks ahead, Yair. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Edit utf-8 tables via the client
Hello, I'm using mysql-standard-4.1.14 and mysql-client-4.1.14 on a RH9 machine, I have utf-8 tables with hebrew data. When using the client I see the hebrew as question marks. I would like to view and edit the data via the client. I've tried using a terminal that is surely able to view unicode. Any suggestions? Yair. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
An existing table
Hello, Is there a way to add a column to an existing table in a mysql database? couldn't find it on the guide. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php