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 | nom
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, oth
ect, I'll be able to
store it? That should work... 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án
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 or
| x| x| x | 0 | x | x
|
+-+-+-+--+---+---+--+--+--+--+-+
1 row in set (0.00 sec)
-Mensaje original-
De: CodeHeads [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 22 de febrero de 2
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 ip='10.100
I used +0.
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
mysql> describe prueba;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| inte | int(2) | YES | | NULL| |
| stri | char(2) | YES | | NULL| |
+---+-+-
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 agen
