List:General Discussion« Previous MessageNext Message »
From:Srini Bhamidipaty Date:April 9 1999 4:21pm
Subject:Creating a SQL script to generate tables.
View as plain text  
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.

Thread
How to switch users.Srini Bhamidipaty9 Apr
  • Re: Problem connecting to db in MySql from Java codeDavid Halsted15 Sep
Re: How to switch users.Fred Lindberg9 Apr
  • RE: How to switch users.Srini Bhamidipaty9 Apr
RE: How to switch users.Fred Lindberg9 Apr
  • Creating a SQL script to generate tables.Srini Bhamidipaty9 Apr
    • RE: Creating a SQL script to generate tables.Jay Miller9 Apr
      • RE: Creating a SQL script to generate tables.Srini Bhamidipaty9 Apr
        • Re: Creating a SQL script to generate tables.Thimble Smith9 Apr
Re: Creating a SQL script to generate tables.Fred Lindberg9 Apr
  • FAQ vs Manual (was: Re: Creating a SQL script...)S. Whitmore10 Apr
Re: FAQ vs Manual (was: Re: Creating a SQL script...)Fred Lindberg10 Apr
  • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Ed Carp11 Apr
  • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Michael Widenius11 Apr
    • Re: FAQ vs ManualPeter F. Brown11 Apr
      • Re: FAQ vs Manualjonathan michaels11 Apr
  • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Ed Carp11 Apr
  • Re: FAQ vs Manual (was: Re: Creating a SQL script...)kalle volkov11 Apr
    • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Steve Edberg11 Apr
      • Re: FAQ vs ManualPaul DuBois11 Apr
        • Re: FAQ vs ManualIsabelle Poueriet18 Apr
  • Re: FAQ vs ManualEd Carp11 Apr
    • Re: FAQ vs ManualPaul DuBois11 Apr
    • Re: FAQ vs Manualjonathan michaels12 Apr
      • Re: FAQ vs ManualPaul DuBois12 Apr
  • Re: FAQ vs ManualEd Carp11 Apr
  • Re: FAQ vs ManualEd Carp12 Apr
    • Re: FAQ vs ManualIsabelle Poueriet18 Apr
  • Re: FAQ vs ManualFred Read12 Apr
    • Re: FAQ vs Manualjonathan michaels13 Apr
  • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Fred Read12 Apr
    • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Isabelle Poueriet18 Apr
  • Re: FAQ vs ManualRichard Reina13 Apr
  • Re: FAQ vs ManualFred Read13 Apr
  • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Ed Carp13 Apr
    • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Vivek Khera14 Apr
  • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Fred Read13 Apr
    • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Micheal Mc Evoy13 Apr
  • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Ed Carp13 Apr
  • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Ed Carp14 Apr
    • Re: FAQ vs Manual (was: Re: Creating a SQL script...)jonathan michaels15 Apr
      • Re: FAQ vs Manual (was: Re: Creating a SQL script...)Darrell Shifflett15 Apr
Re: FAQ vs Manual (was: Re: Creating a SQL script...)Fred Lindberg12 Apr
  • More about my FAQ...S. Whitmore13 Apr
    • Re: More about my FAQ...Fred Read13 Apr
    • Re: More about my FAQ...Ed Carp13 Apr
Re: FAQ vs Manualluuk13 Apr