Have you tried running this from the mysql monitor?
-Original Message-
From: Andre MATOS
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 7/8/04 5:33 PM
Subject: RE: Scripts - ERROR
Hi,
I tried but didn't work. He
Hi,
I tried but didn't work. Here is my script:
#
# @Name : NTT_dbcreator.2004-06-07.v1-001.andre.sql
# @DESCRIPTION : NTT Database Creator
# @CREATED : Jun 07, 2004 by Andre Matos - [EMAIL PROTECTED]
# @VERSIO
not sure if it's what you're looking for...
but you can always do mysql>"system -uuser1 -ppassword mailto:[EMAIL PROTECTED]
Sent: Thursday, July 08, 2004 10:21 AM
To: [EMAIL PROTECTED]
Subject: Scripts
Hi List,
Let's suppose that I have a script to create one database (tables,
indexes, etc).
H
Have you tried writing the script using the source command?
drop database;
create database;
source populate_db;
-Original Message-
From: Andre MATOS
To: [EMAIL PROTECTED]
Sent: 7/8/04 12:20 PM
Subject: Scripts
Hi List,
Let's suppose that I have a script to create one database (table
* Enrique Andreu
> Hello, I think I have explained bad. I want to pass
> the arguments to the sql script.
> The argument is for the sql script.
>
> For example:
> myscript.sql should be:
> GRANT ALL PRIVILEGES ON *.* TO &1@'%'
> where &1 would be parameter 1
>
> I want to do something like that:
>
Hello, I think I have explained bad. I want to pass
the arguments to the sql script.
The argument is for the sql script.
For example:
myscript.sql should be:
GRANT ALL PRIVILEGES ON *.* TO &1@'%'
where &1 would be parameter 1
I want to do something like that:
dos>mysql mysql -u root -p < myscript
If it's going to be a simple batch file then use %1, %2, ... inside the
script to get the parameters passed to it.
Or better install & use a real scripting language like perl. ;-)
Lian Sebe, M.Sc.
Freelance Analyst-Programmer
www.programEz.net
> -Original Message-
> From: Enrique Andreu
JR wrote:
> To setup your table see: http://www.mysql.com/doc/C/R/CREATE_TABLE.html
>
> I do not believe that mysql will read the foxpro db format. Dump your
> foxpro table data into a text file and use mysqlimport to pull the data
> into your mysql table. See:
> http://www.mysql.com/doc/m/y/mysq
To setup your table see: http://www.mysql.com/doc/C/R/CREATE_TABLE.html
I do not believe that mysql will read the foxpro db format. Dump your
foxpro table data into a text file and use mysqlimport to pull the data
into your mysql table. See:
http://www.mysql.com/doc/m/y/mysqlimport.html
As far a
Manuel Dugué wrote:
>
> Hi,
> I created some Scripts of the Type *.sql. In these Scripts there are pure
> SQL Statements, seperated by a ';'. How can I execute those Scripts
> (automated) in mySQL?
mysql -u ... -p.. -h ... < scr1.sql
etc.
> Is there a possibility to make one Script, that start
ursday, April 05, 2001 8:50 PM
To: Santiago LLobet
Cc: [EMAIL PROTECTED]
Subject: Re: SCRIPTS IN DIFFERENTS DATABASES
On Thu, 5 Apr 2001, Santiago LLobet wrote:
> Hi,...
>
> We've got a MySQL server running with a lot of different databases that
have the same table-structu
On Thu, 5 Apr 2001, Santiago LLobet wrote:
> Hi,...
>
> We've got a MySQL server running with a lot of different databases that have the
>same table-structure.
>
> Does anybody knows how to make an SCRIPT that performs an administrative task
>(like ALTER TABLE 'table_name') in all the d
Hi,
I have had the same problem.
After deinstalling the last DCE Patch PHSS_19739 everything works okay.
Best regards
Andre
On 18-Jan-01 [EMAIL PROTECTED] wrote:
>>Description:
> I downloaded the binary for mysql-3.23.30-gamma-hp-hpux10.20-hppa1.1.
> And followed the following procedure :-
13 matches
Mail list logo