How do I pipe the Windows cmd output into mysql inserts?
i.e.
dir /w /o:n mysql -u process (INSERT INTO TABLE)
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
prog1output.txt
To use the output of one program as the input to another
dir | more
(that takes a directory listing and runs it through the more utility which
only shows you one screen of data at a time)
For more details on CMD usage go to Start - Help.
Shawn Green
Database Administrator
Unimin
Just so you know I am pretty new to all this.
I recently installed MySQL 4 on my PC. My friend gave me mysqlgui.exe to help
configure stuff. So I made several databases using it. Now I know these
databases are there, because I am running IPB on one of them, and they show up
under the data
Has the ODBC user been removed? Have you logged into mysql, mysql -uuser -p
and done show databases?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/19/04 9:44 AM
Subject: Databases not showing in cmd and mysqladmin?
Just so you know I am pretty new to all
Sounds like a permissions problem. Make sure the login you are using has
the rights to see the databases in question.
(http://dev.mysql.com/doc/mysql/en/SHOW_GRANTS.html)
You may need to GRANT yourself additional privileges.
(http://dev.mysql.com/doc/mysql/en/GRANT.html)
Respecfully,
Shawn
I guess I must be a dinosaur because I don't use either mysqladmin or
mysqlgui. So I don't know how else to help. Could it be logging in as
something else and THAT account is the one without access to the other
tables?
What do you get when you do a SHOW DATABASES from each client program?
You
Whoa, I ran SHOW DATABASES and everything came up!
Now I just have to figure out how to do that with mysqladmin
(c:/mysql/bin/mysqadmin - or that is how windows default goes anyway for MySQL 4)
Sorry, thanks for the tip. I'm new to mailing lists in general...
HI
Does any one encounter the same problem?? If load cmd in not working
in ver3.23.53, is there any alternative cmd for loading table???
Thanks
vinita
#
mysql select version();
+---+
| version() |
+---+
| 3.23.33
On Tue 2002-11-19 at 14:50:09 +1100, [EMAIL PROTECTED] wrote:
HI
Does any one encounter the same problem?? If load cmd in not working
in ver3.23.53, is there any alternative cmd for loading table???
See http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html
Bye,
Benjamin.
--
[EMAIL
Hello All,
I am using mysql on Linux - RedHat 7.1.
The basic stuff is simple, cool, too.
I am a newbie, so forgive me if this is too simple a question.
Is there a mechanism available somewhere in doing an automated update of a
field.
example.
team is a table.
wins, losses, pct are fields
]
Subject: mysql - sql - auto-update cmd?
Hello All,
I am using mysql on Linux - RedHat 7.1.
The basic stuff is simple, cool, too.
I am a newbie, so forgive me if this is too simple a question.
Is there a mechanism available somewhere in doing an automated update of a
field.
example.
team is a table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Seifuddin, Lamar T.* (LSEIFUDD) wrote:
| Hello All,
|
| I am using mysql on Linux - RedHat 7.1.
| The basic stuff is simple, cool, too.
|
| I am a newbie, so forgive me if this is too simple a question.
|
| Is there a mechanism available somewhere in
, Lamar T.* (LSEIFUDD); [EMAIL PROTECTED]
Subject: RE: mysql - sql - auto-update cmd?
Lamar,
Why store that information? You'll be constantly updating your table. I do
something similar keeping softball stats for my team. I just keep the raw
data and do all calculations, i.e. batting average, slg pct
I am having a heck of a time getting a simple c program up and running using mingw and
the mysql c api.
My makefile is simple enough I'm not sure what the -lm switch on the search compile
line is for but I saw it in someone's makefile on the web so I through it in hoping it
would work):
#
Hi Folks,
I use a shell script, to get data from a mysql database.
I use the following call
mysql -ddatabase -uusername -ppassword
file_with_sql_select file_to_get_output
I even tried mysql -e select foo from database -uusername
-ppassword file_to_get_output
but I always get as first line the
* Oliver Heinisch
Is there a way to supress headers and to get the datafields
without spaces?
(in one result there has been a TAB (0x09) between the fields).
I just want data_field_1 (0x20) data_field_2 (\n).
You can use the --skip-column-names parameter when calling the mysql client
to
Howdy:
I'm a bit new to MySQL ( and unix in general ), and I have a couple of
questions:
We're using the command:
/usr/local/bin/safe_mysqld
to startup MySQL on a Mac OSX Server 1.2.x system.
We would like to add the ability to have it do an auto check/recover
of the
Howdy:
( sorry if this is a second post, but I'm not sure if the 1st. one I sent
went out OK )
I'm a bit new to MySQL ( and unix in general ), and I have a couple of
questions:
We're using the command:
/usr/local/bin/safe_mysqld
to startup MySQL on a Mac OSX Server 1.2.x
18 matches
Mail list logo