If i want to add something into a table with just the mysql command.
Is this possible.
Like
./mysql -p -u root test insert into...
Something like this.Is that possible and how in that case.
Johan Vikerskog
Technician - CAE Tools Support
Research Technology Development
Johan Vikerskog (ECS) wrote:
If i want to add something into a table with just the mysql command.
Is this possible.
Like
./mysql -p -u root test insert into...
Something like this.Is that possible and how in that case.
echo insert into... | ./mysql -p -u root test
or
cat filename | ...
But i want dont want to type in the password. I want to have the password in the
command file.
//Johan
-Original Message-
From: Alexander Wagner [mailto:[EMAIL PROTECTED]]
Sent: den 5 juli 2001 12:57
To: Johan Vikerskog (ECS); [EMAIL PROTECTED]
Subject: Re: [PHP] Batch job in UNIX
Johan Vikerskog (ECS) wrote:
But i want dont want to type in the password. I want to have the
password in the command file.
--password=whatever_it_is instead of -p ?
If that doesn't help, try ./mysql --help
regards
Wagner
--
Madness takes its toll. Please have exact change.
--
PHP
But i want dont want to type in the password. I want to have
the password in the command file.
echo insert into... | ./mysql -p -u root test
or
cat filename | ...
Perfectly right. And a mysql --help would have told you that you can call it
(combined with the above) like this:
echo
On 05-Jul-01 Johan Vikerskog (ECS) wrote:
If i want to add something into a table with just the mysql command.
Is this possible.
Like
./mysql -p -u root test insert into...
mysql -e cmd
mysql -B cmd
mysql somescript.sql
cat many*.sql | mysql
-- also look at --
mysql --help
--
Don
On 05-Jul-01 Johan Vikerskog (ECS) wrote:
But i want dont want to type in the password. I want to have the password in
the command file.
No, you don't.
Put your user name password in ~/.my.cnf
(as explained in the fine manual).
--
Don Read [EMAIL
7 matches
Mail list logo