This table holds latest data from an app:
mysql select * from ultimas_respuestas_snmp limit 10;
+++---+-+---++--+
| id | info_oficina | columna_donde_guardar | info_interfaz |
valorSNMP |
When using select into outfile, I can only get the table data, but I can't find
how to include the column names. I haven't been able to include the column
names into the actual return of the query, and they don't get stored in the .csv
Anyone know how to include the column names, table name,
This function is great! Anyone know how to include the column names, table
info, any extra miscellaneous info? I use SQLyog for exporting to csv and they
do include the columns, my bet is its some SQL option. The manual doesn't
specify, at least in the select syntax part.
Ariel
-Mensaje
... But I though there was a -include_column_names
option or something :)
Which way should I go?
Ariel
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 01 de marzo de 2006 10:58
Para: Ariel Sánchez Mora; mysql@lists.mysql.com
Asunto: RE: file permission
|
+-+-+-+--+---+---+--+--+--+--+-+
1 row in set (0.00 sec)
-Mensaje original-
De: CodeHeads [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 22 de febrero de 2006 17:35
Para: Ariel Sánchez Mora
CC: mysql
So far i've been able to store ip addresses as strings like you would type them
in DOS, for ex, '192.168.0.1'. This serves me great since my application uses
IP addresses as strings in all cases. I've done queries with the IP column ,
for example, select office_name from table_1 where
.
Ariel
-Mensaje original-
De: Ariel Sánchez Mora
Enviado el: lunes, 20 de febrero de 2006 10:30
Para: 'leo huang'; 'Logan, David (SST - Adelaide)'
Asunto: RE: Same question, better example
Thanks a lot Leo, that worked wonders. David Logan from HP Australia corrected
my use
I searched the other lists and couldn't find one that was more appropiate for
this question; if there is, please tell me so :)
I am monitoring networking equipment and so far I'm saving all my data in a
MySQL database (hence an email to this list). I'm using only VARCHARs because
the SNMP
mysql describe prueba;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| inte | int(2) | YES | | NULL| |
| stri | char(2) | YES | | NULL| |