- Rodrigo A. de Brito Bastos rodrigo...@gmail.com wrote
Hey guys!
Is there a way to export a table into a txt file but delimited *with comma*?
Hello!
you can use this syntax:
select * from ae_a222
where ano=2009 and dia_juliano between '1' and '365'
into outfileC:\\Documents and
- machiel.richards machiel.richa...@gmail.com wrote
How can we do this when running in a cron script?
Hi!
You can use following command in a shell script running from cron:
echo select * from table into outfile '/path/to/output/file' fields
terminated by '|'; | mysql
. but this is a primary feature !
Very Thanks.
Nicola
When I do the tests on frontpage, it doesn't seem to do anything.
what test are you talking about?
I am reading the Book PHP and MYsql for dummies and it talks of a test you can do to
see if PHP and SQL are talking with each other.
On the Mysqladmin it tells me that my odbc driver 3,.51 not
Hi guys
this question has probably been answered a million times but I can't seem to find
anything in the Archives:
I am trying to install mysql on XP to use with PHP for a web site that I am working on.
I have done everything that the books are telling me but I can't seem to get either
PHP
hi all,
just a newbie question.
can i use a (win) gui mysql client, if i have
a firewall installed between my intranet and
mysql server. how?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
HI,
I have the following table:
desc keywords_news;
++--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| id_keyword | int(11) | | PRI | 0 | |
|
Hi,
I'm using two Mysql 3.23.36 with Innobase tables on two machines running
Redhat 7.0.
I'm trying to use replication in a simple master/slave configuration,
but while it works
when I use MyIsam tables, if one of the two machines tries to use
Innobase tables
the replication doesn't work,
