Hi,
I have a scenario:
I have created a database and also created tables in that database. I have
created another database for testing purposes. I want to create tables in
test database similar to that which are in my first database.
Is it possible to create a SQL script on one editor and run that script to
generate tables in the database.
If this is possible I can save a lot of time in creating my test database.
Please let me know if such feature is available in MYSQL.
Thanks in advance
Srini Bhamidipaty.
-----Original Message-----
From: Fred Lindberg [mailto:lindberg@stripped]
Sent: Friday, April 09, 1999 10:49 AM
To: mysql@stripped
Subject: RE: How to switch users.
On Fri, 9 Apr 1999 10:49:20 -0500, Srini Bhamidipaty wrote:
>Mysql> mysql_real_connect(host localhost,user user1,passwd);
>ERROR 1064: You have an error in your SQL syntax near
>'mysql_real_connect(host localhost,user mali,passwd)' at line 1
These are C API commands, not usable in the mysql client. They are
functions you use from within a C program to connect to a server.
As far as I know, you cannot switch identity at the mysql> prompt. Quit
mysql, and start it again:
% mysql -u user1 -p
Yes, you have to define "user1" in the grant tables. You need to read
the manual for info on how to set up new users. The manual is included
in the distribution and available on line via the link below.
-Sincerely, Fred
(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread1590@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.
