[OT] Suggestion of query manager

Hi people! Can anyone suggest a query manager on linux environment - like Heidisql? I using MySQL Navigator: http://www.bookofjesus.org/images/fl8ze90wpgyt87bkp5.png Thanks! -- Marcelo de Assis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

find date an time of a table update

Hi, I didn't find a way to know the time and date of the last update of table, not the data but the table info itself. Is this possible? I want to use this info in order to show it in a web page. Mysql 4.1 Apache Myisam Regards Marcelo Fabiani -- MySQL General Mailing List For

Re: help with insert +php

Chris W escribió: Marcelo Fabiani wrote: Here is the code: . . . $result = mysql_query($sq)or die ("problema Leyendo Tabla");; . . . Why are there two ; at the end of that line? I'm really not sure what if anything that will do but I would remove it just in case.

Re: help with insert +php

John Meyer escribió: Try this $retval = mysql_query($sql) or die(mysql_error()) To at least get an idea of what MySQL thinks is the error. The is no error in the insert it adds the row, but in addition add's two more rows with no data, only the auto_increment ; Example: Adds 1 Ma

Re: help with insert +php

[EMAIL PROTECTED] escribió: Marcelo, The usual advice is to echo out the query string and examine it for syntax. Assuming it has form data in it for the variables, then try copying/pasting it into the mysql client and run it from there. Let us know how that goes. David Already done

Re: help with insert +php

06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Marcelo Fabiani [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 1:06 PM To: mysql@lists.mysql.com Subject: help with insert +php I'm trying to insert some data to my our web database, but when Insert the data, it inser

help with insert +php

uot;; $sq = "SELECT * FROM empresas"; $result = mysql_query($sq)or die ("problema Leyendo Tabla");; echo ""; echo "Nombre EmpresaNitDireccionTelefono"; while ($row=mysql_fetch_row($result)){ echo

using like

arch with more tha one char , for example "aud", and in the table there is one math "auditoria". Hope someone can help me, sorry for my english Regards Marcelo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

increasing max_connections

or variables should be measured, studied? Is there an equation that can I have a base for this decision? I'd be very thankful for any assistance! Regards []'s Marcelo Mazon - [EMAIL PROTECTED] Diretoria de Informática - UNESC Universidade do Extremo Sul Catarinense Criciúma - Sant

Thread safeness

hreads or not? 3. Just using mysqlclient_r instead of mysqlclient is enough to get thread safeness? Thanks for any help, Marcelo. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump

Something like that: SELECT - INTO OUTFILE '' FROM Table etc etc ; Marcelo Araujo On Wednesday 25 February 2004 21:50, Lorderon wrote: > Hello All, > > How can I dump selected rows into a file (using a query or mysqldump)? > > i.e, I want to dump only the row

Re: Experiment with MySQL User Defined Functions in Java

it out and send some > feed back my way. Please keep in mind that this is alpha code, so you > probably don't want to test on your production data. > > http://freshmeat.net/projects/judf/?topic_id=66 > > Cheers, > -- Eric Herman > Seatle, WA > [EMA

unknow SQL Error!

Hi People, Please, how are the error whit my sql? I receive this message when I execute it in phpMyAdmin 2.5.0: My sql host server is the portlandsql. Erro comando SQL : CREATE TABLE nuke_contactbook( uid int( 11 ) DEFAULT '0' NOT NULL , contactid int( 11 ) NOT NULL AUTO_INCREMENT , firstnam

newbie help

o receive empty values. In the query the field is not surranded by ' ' ( since it's a number ). does anyone can explain to me what is happening ? how can I leave that field empty on the form. Also the same thing is happening with a date field. !

mysql connection with VB

Hi list, I am developing a program in visual basic, ans as I am brand new to mysql database, I would like to know from you which are the proper ways to access the database from my vb program. I know there could be using odbc, but I would rather not to use it at all. We´re working for windows, but

stored procedures and triggers

Hello list, Here in my company people are concerned about which database to choose to start implementing a new application client-server. As the only person here with large experience in this field of activity is me, I am not very much inclined to our mysql due to its lack of resources like trigge

crash

Hi Guys ! : attached is the log report after crashing every time i send a sql query (see log file ) this query works fine with other keywords in the where match against-clause . its a bug its a feature? please help me LOG FILE SAYS: tonic:~ # mysqld got signal 11; This could be because you

Porting from MsSQL to MySQL (VERRY XML RELATED)

something like select 1 as tag, null as parent, login as [info!1!first_name!element] from user_info FOR XML EXPLICIT Without the FOR XML EXPLICIT statement this returns a the following recordset: TAG PARENT info!1!first_name!element 1 NULL Marcelo 1 NULL Pablo WITH the FOR XM

MyODBC 3.51 driver - General SQL error

. Thanks in advance, = --- Marcelo Muzilli Support Analyst Datacom/Access Ericsson Serviços de Telecomunicaçoes Ltda. +55 11 6224-8935 [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http:/

MySQL Client/Server problem

Thanks in advance, Marcelo Muzilli Support Analyst Datacom/Access Ericsson Serviços de Telecomunicaçoes Ltda. +55 11 6224-8935 [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings

MyODBC 3.51 driver - General SQL error

. Thanks in advance, = --- Marcelo Muzilli Support Analyst Datacom/Access Ericsson Serviços de Telecomunicaçoes Ltda. +55 11 6224-8935 [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http:/

MySQL Client/Server problem - AGAIN, sorry!!!

Thanks in advance, = --- Marcelo Muzilli Support Analyst Datacom/Access Ericsson Serviços de Telecomunicaçoes Ltda. +55 11 6224-8935 [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings

MySQL Client/Server problem

Thanks in advance, Marcelo Muzilli Support Analyst Datacom/Access Ericsson Serviços de Telecomunicaçoes Ltda. +55 11 6224-8935 [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings

Importing data to Excell

I have a table in my database, witch have a column thas is float(12,3), when i try to make a filter width that column i get an error message that says "Column PRPRVEND1 can't be used in criteria". Can someone tell me how to solve this problem? ---

Update Question

How can i do an update a column in a table width the fields of another table i would like to do the folowing query: UPDATE enc_oper set estado = "N", quant_prod = 1 * opera.quantidade whe re encomenda = 20010004580 and posicao = 1 and opera.codigo = enc_prod.opera; But i dont kn

strip

Can someone tell me how i can get(or can someone send me) the strip command for SCO Open Server 5.0.5? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

using libmysqlclient

Thanks for your help, but i needed a litle more help, I tried to do that and it almost worked bu i still got this error gcc -O2 -g -o mysql1 mysql.c -L/usr/local/mysql/lib -lmysqlcl ient -lnsl -lgthreads -lz -lcrypt -lsock et -lm Undefined first referenced symbol

using libmysqlclient

I'm trying to use libmysqlclient as described in the manual to compile another program in SCO Open Server Release 5.0.5, whe i tri to do gcc -O2 -g -o mysql1 mysql.c -L/usr/local/mysql/lib -lmysqlcl ient -lnsl i get this messages can someone help me. Undefined first