calculated field

2005-01-21 Thread Javier
ield1 = field2 + field3, but I can't discover this option in Mysql. It's possible to make it ? Any other idea about it ? Thanks in advance Javier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Dump FK

2003-08-31 Thread Javier
Hi I've a DB using InnoDB tables and FK. If dump DB and try to import the resulting text file I receive many errors because at import time mysql try to import tables that have FK on tables not yet imported. How could I dump/import telling MySQL to order dump tables having in mine FK to avoid err

Re[2]: Dump FK

2003-08-31 Thread Javier
On 01/09/2003 at 1:01 Chris Nolan wrote: >Hi! > >If you have a look at the documentation at www.innobase.com, you'll find >somewhere it mentions a few directives that you can use to turn off FK >checking for a temporary period. The solution to your problem is there. > Thanks for your reply. I o

Sum function question

2002-02-20 Thread Javier
it only works on numbers, ( the number of occurrences of key field, is unknown) Thanks in advance for any advice that you might have. Javier - Scanned for all known viruses by Messagelabs -- - Before posting, please check

Sum function question

2002-02-20 Thread Javier
- Original Message - From: Javier <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 2:47 PM Subject: Sum function question > Hi, i have a table like this > > Key Field-1 > A string1 > A string2 > A

Sum function question

2002-02-27 Thread Javier
use the Sum function but it only works on numbers, ( the number of occurrences of key field, is unknown) Thanks in advance for any advice that you might have. Javier Diaz IT Developer - Scanned for all known viruses by Messagelabs

Order By and Use Index

2002-03-12 Thread Javier
the same? What is the default order, that MySQL use if for this table, I make : SELECT * FROM table1 thanks in advance Javier Diaz IT Developer - Scanned for all known viruses by Messagelabs -- - Before posting, please check

C API Question

2002-03-20 Thread Javier
to this function? , Can I execute several MySQL instructions in one only call to mysql_query() function? If it is possible, which is the best way to do this? Thanks in advance Javier Diaz IT Developer - Scanned for all known viruses by Messagelabs

What is the best way to do this

2002-04-29 Thread Javier
that? What is the best way for it? Thanks Javier Diaz IT Developer - Scanned for all known viruses by Messagelabs -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Cross querying databases (again)

2002-04-30 Thread Javier
If your default is '0', I think, the new query should work. Thanks Javier - Original Message - From: Donna Robinson <[EMAIL PROTECTED]> To: Javier <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 7:14 PM Subject: Re: Cross querying databases (again) > Hi,

How I can do this

2001-10-26 Thread Javier
KK I need to obtain a result in the following form: A TTYYRR B FFKK How can i do this? Thanks for any help! Javier Javier Diaz IT Developer *** This message has been scanned for all known viruses by MessageLabs. This message is intended for the stated recipients

Re: How I can do this

2001-10-29 Thread Javier
english, Javier - Original Message - From: Jeremy Zawodny <[EMAIL PROTECTED]> To: Javier <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, October 28, 2001 5:13 AM Subject: Re: How I can do this > On Fri, Oct 26, 2001 at 10:04:44AM +0100, Javier wrote: > >

Question About Integration

2001-04-27 Thread javier
thout problems. How reliable is MySQL ? Is MySQL able to handle all my information in the same way as MS-SQLSERVER ? Thanks for clearing up and for your ideas. Good Luck, Javier Barbieri - Before posting, please check:

Problems with indexes on Date/DateTime fields

2006-01-05 Thread Javier Diaz
tion running on linux. Any help will be really appreciated. Thanks Javier ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are address

RE: Problems with indexes on Date/DateTime fields

2006-01-05 Thread Javier Diaz
FORCE INDEX as what we really need to do are DELETE operations, and it seems FORCE INDEX is valid only for SELECT statements. Basically we have a huge database where we track different operations and every day we need to do some maintenance and delete records which are older than specific date. Thx J

RE: Problems with indexes on Date/DateTime fields

2006-01-05 Thread Javier Diaz
hat is the case we will need to re-visit a few queries Thx Javier -Original Message- From: Aftab Khan [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 11:25 To: Javier Diaz Subject: RE: Problems with indexes on Date/DateTime fields I agree. Some time full table scan is faster than

RE: Problems with indexes on Date/DateTime fields

2006-01-05 Thread Javier Diaz
have based on date fields are not using the indexes in the way we were expecting. I would like also ask if is valid to expect that the results of the Explain statement for a query like this SELECT * FROM TABLE-X WHERE [CONDITIONS] Are valid for the equivalent DELETE FROM TABLE-X WHERE [CO

Re: Unbelieveable with 4 Gbytes - MySQL 5 only 350 concurrent mysql connection... on Linux Redhat 9

2006-02-24 Thread Javier Armendáriz
Can you tell us about your config parameters? Probably you must set up your max_connections, max_user_connections http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html Ady Wicaksono escribió: I have MySQL 5 installed on My Machine, But it could handle only max about 350 concurren

Re: Issue With Subqueries

2011-11-09 Thread Javier Yévenez
name that the field db2.table1.field1, maybe you have to use an alias for each table: try: mysql> select count(distinct A.field1) from db2.table1 A where field1 not in (select B.field1 from db1.table1 B); -- Javier

MySQL for Excel 1.2.1 has been released

2014-03-27 Thread Javier Treviño
The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.1.  This is a maintenance release for 1.2.x.   MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables yo

RE: C API : Problem using multi-statements

2005-05-06 Thread Javier Diaz
Hi Instead of use two INSERT statements, try something like this: INSERT INTO Table table1 VALUES (list of values1), (list of values2) -Original Message- From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED] Sent: 06 May 2005 17:19 To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject:

unauthenticated user

2004-01-20 Thread Javier Tacón
with DNS servers (attacks) ? Can I debug to know more about this threads ? Thanks in advance. Javier Tacón ([EMAIL PROTECTED]) - Developer AZ Interactive, SL - (+34) 93 507 http://www.azinteractive.com <http://www.azinteractive.

RE: unauthenticated user

2004-01-20 Thread Javier Tacón
Well, this has been fixed, for your info, it was a problem from our DNS's with the reverse name process. Greets. Javier Tacon -Mensaje original- De: Javier Tacón [mailto:[EMAIL PROTECTED] Enviado el: martes, 20 de enero de 2004 11:23 Para: [EMAIL PROTECTED] Asunto: unauthenti

Re: Logging Data: Should I use MyIsam or InnoDB?

2005-01-19 Thread Javier Armendáriz
== Cuando todo esta bajo control, es que no vamos suficientemente deprisa ======== Javier Armendáriz [EMAIL PROTECTED]

Rows Counter

2004-06-28 Thread Javier Diaz
B-2 : : : : : : where A, B are real columns and Counter in just a consecutive for each row in the query result. Thanks Javier This e-mail has been scanned for all viruses by Star Internet. The service is po

Concurrency Question

2004-07-02 Thread Javier Diaz
tables to another server ?? We would appreciate a lot any ideas Thanks a lot Javier This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proa

RE: Concurrency Question

2004-07-05 Thread Javier Diaz
? I would appreciate any ideas you can have, we really need this ASAP. Thanks Javier` -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 02 July 2004 10:42 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Concurrency Question Javier Diaz <[EMAIL PROTEC

RE: Concurrency Question

2004-07-05 Thread Javier Diaz
stem And that we are doing a LOT MORE INSERTs by second, I'm afraid maybe the only solution is go back to MyISAM :-( By the way this figure of 167 revolutions/second is based on what kind of hard disk? thanks Javier -Original Message- From: Marc Slemko [mailto:[EMAIL PROTECTED] Se

Connect with MySQL Control Center

2003-03-30 Thread Javier Gonzalez
Hi !! I just installed MySQL CC, in localhost it works fine. But I cant connect it with my remote MySQL database (server). The mistake may be that im not sure in the HOST field, please someone helpme. Thanks Javier (from Buenos Aires) P.S. Sorry for my terrible english.

Edit my database in Server

2003-03-31 Thread Javier Gonzalez
Hi. In novice in this, can you tell me how application uses to edit your databases in your server (not in local). Did someone uses MySQL Control Center I cant configure it to works in remote. PS My english sucks

problems with the daemon

2002-02-10 Thread Javier Gloria
hi i´m starting with linux and i want to install the daemon of mysql... please help. i all ready read the documentation and the man pages but i dont understand ... help _ Do You Yahoo!? Get your free @yahoo.com address at http:/

problems with the daemon

2002-02-12 Thread Javier Gloria
hi i=B4m starting with linux and i want to install the daemon of mysql...= =20 please help. i all ready read the documentation and the man pages but i dont understand= ... help _ Do You Yahoo!? Get your free @yahoo.com address a

insert and select

2002-03-15 Thread Javier Gloria
Hi: how i can insert and select information at the same time. first i want to insert the information relative to the client and after that i need to select the same information on the same query. that is possible _ Do You Yahoo!? G

What is wrong in this query???

2002-03-27 Thread Javier Armendáriz
Can someone tellme the problem in this query?? Is there any problem updating two tables in the same query??? update alumno, alumnocurso set alumno.nombre='Blas', alumno.apellidos='Martinez Maertinez', alumno.nacimiento='1990-09-12', alumno.telefono = '6', alumnocurso.incorpora

adding users to mysql

2002-03-29 Thread Javier Gloria
hi: i have the next question. how can i add a user to mysql with the console or shell ? how can i do the same posses from a php script or application from the Internet? thanks _ Do You Yahoo!? Get your free @yahoo.com address at

adding users to mysql

2002-03-29 Thread Javier Gloria
hi: i have the next question. how can i add a user to mysql with the console or shell ? how can i do the same posses from a php script or application from the Internet? thanks _ Do You Yahoo!? Get your free @yahoo.com address at

mysql forum

2002-04-02 Thread Javier Gloria
Hi everybody: where i can find a forum than works with php,mysql. for my site. or the source code for one. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --

Server speed working with databases and apache

2002-05-28 Thread Javier Armendáriz
Javier Armendáriz [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

RE: Left join?

2002-06-05 Thread Javier Campoamor
I find a web site with complex queries? Thank you Javier > -Mensaje original- > De: Cal Evans [mailto:[EMAIL PROTECTED]] > Enviado el: martes 4 de junio de 2002 22:48 > Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Asunto: RE: Left join? > > > SELECT DISTINC

Incorrect replication user time

2002-07-03 Thread Javier Trujillo
updated to 3.23.51 and replication works fine excepts this. Any sugestion?. Sorry for my limited English. Javier. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

change name of one column

2002-08-14 Thread javier asd
MySQL > Hi, I would like to change the name of one column of > a > table. > > I did: > ALTER TABLE name_table ALTER COLUMN old_column > RENAME > new_column > > but it did not work due to don't understand a RENAME > after ALTER COLUMN. > > > Could someone help me? > > Thanks a lot. > > > __

Inno DB Question

2002-09-02 Thread Javier Diaz
('t1','test1')"); Q_ODBC->ExecSQL(); Q_ODBC->SQL->Clear(); Q_ODBC->SQL->Add("INSERT INTO regn_info VALUES('t2','test2')"); Q_ODBC->ExecSQL(); Q_ODBC->SQL->Clear(); Q_ODBC->SQL->Add("ROLLBACK"); Q_ODBC-

RE: Inno DB Question

2002-09-02 Thread Javier Diaz
w for the ODBC connection is working fine, but the same code using TSQLQuery (dbExpress Component) dosen't work. Do you have any idea what can be the reason? Thanks Javier -Original Message- From: Tod Harter [mailto:[EMAIL PROTECTED]] Sent: 02 September 2002 15:58 To: Javier Diaz Subjec

RE: Inno DB Question

2002-09-03 Thread Javier Diaz
')"); Conn->ExecuteDirect("COMMIT"); But I don't know why is impossible to do the same using the normal TSQLQuery. I already sent the message to the borland newsgroups. Thanks Javier -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: 02

Insert date format

2002-09-03 Thread Javier Campoamor
27;-', 2), '-', -1), '-', SUBSTRING_INDEX('03-05-2002', '-', 1)), '%Y-%m-%d' ); I have searched in the manual, the list and in the DuBois' book, but I haven&#

RE: Insert date format

2002-09-03 Thread Javier Campoamor
ged is an open source framework and I wouldn't like to touch that code. The framework provides a way to modify the dates from/to the database defining native database functions in a config file. Anyway, the problem is alredy solved, but I still have the dude if I there is a better

RE: Display information

2001-02-16 Thread Javier Muniz
select id,lot_id,lot_type from scrap_table where id >= 1932 order by id limit 10; select id,lot_id,lot_type from scrap_table order by id limit 1932,10; either should work, i think the first would be faster but I'm not positive how MySQL would handle the second in terms of optimization. -jm

RE: seemingly anomalous behaviour in Selects entered manually vs. in a script

2001-02-21 Thread Javier Muniz
What are you intending to do with $peek? You only use it once and it's sucking up one of your rows. -jm -Original Message- From: Warren [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 5:33 PM To: [EMAIL PROTECTED] Subject: seemingly anomalous behaviour in Selects entered m

RE: :mysql

2001-03-05 Thread Javier Muniz
You must have at least the mysql client libraries installed to use DBD::mysql. -jm -Original Message- From: John Tsangaris [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 1:36 PM To: mysql Subject: DBD::mysql I am trying to install DBD::mysql on a server which does not have mys

INNER JOIN problem

2001-03-12 Thread Javier Armendáriz
Attack ships on fire off the shoulder of Orion. I watched C-beams glitter in the darkness at Tan Hauser Gate. All those moments will be lost in time like tears in rain. Time to die. === Javier Armendáriz [EMAIL PROTECTED] --

About Access MDB import in MYSQL

2001-03-13 Thread Javier Garcia
Hi I'm newbie in MySql. I'm trying to import an access MDB into MySql and access it with PHP. Also have instaled MyODBC. When calling MySQLAdmin cant find a data transformation service like MS SQL. Any clue? P.D. Be patient with my English. Thanks javier [EMAIL PROTECTED]

Importing ACCESS into MYSQL

2001-03-14 Thread Javier Garcia
Hi Does anybody know how to import MDB's into MYSql. Thanks Javier

Re: Membership management

2001-03-14 Thread Javier Garcia
Hi I'm newbie but see a PHP GuestBook in PHPBuilder.com Bye javier Dear All, Can someone recommend a PHP/MySQL script for managing membership forms using PHP and MySQL? I need something like a dbmanager which was available by Selena, but it was in perl with flat text dat

Re: INFO

2001-03-15 Thread Javier Armendáriz
MySQLGui is a good option in graphical mode, there are other command line clients too At 19.40 14/3/01 +0100, you wrote: >can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on >win nt ? >thank you in advance. >regards. > >Andrea GIGLIOTTI > >G&B Net S.n.c. >Via Bagni Caldi,

Error codes list

2001-10-21 Thread Javier Armendáriz
Hi Maybe it is in the manual, but i can´t find it in the way i need. Does anybody know where to find a complet list of MySQL error codes with number and descripcion in order to make a library for handling and reporting alerts to users in php Thanks a lot

Re: Error codes list

2001-10-21 Thread Javier Armendáriz
manual, but i can´t find it in the way i need. >Does anybody know where to find a complet list of MySQL error codes with >number and descripcion in order to make a library for handling and >reporting alerts to users in php > > >Hola Javier, > >Yes it is in the manual -

Re: foxpro conversion

2001-11-14 Thread Javier Bertoli
e URL) that works quite nice... Saludos Javier /* -- */ "He that will not reason is a bigot, He that cannot reason is a fool, &qu

MYSQL + MOSIX

2001-11-16 Thread Javier Oliva
#from node3 > > It is possible to make this experiment. > Somebody has proven it. > JAVIER OLIVA > PUNTA ARENAS - CHILE = Javier Oliva F. [EMAIL PROTECTED] http:\\www.patagoniatuerca.cl __

Getting id asignet to an insert

2001-11-30 Thread Javier Armendáriz
Hi everybody: Can anybody tellme how can y get the id asigned to a record in the moment i insert data in the database? I need to storage transaction requests, the mysql database assigns an unique id (auto increment) to that record, and i need it to continue saving data in another table. Is ther

PHP + MySQL problem (strange behavior)

2001-12-05 Thread Javier Muniz
rom? PHP or MySQL? They're pretty commonly used in unison so I'd imagine something like this should work fairly smoothly. I've also posted this to the PHP list in case there's someone there that's encountered this before. Javier Muniz Chief Technology Of

RE: MySQL can't tell the difference between two databases???

2002-01-15 Thread Javier Armendáriz
What happens if you try select * from db1.products and select * from db2.products;??? Doing that does the same? > -Mensaje original- > De: Nuno Gonçalves [mailto:[EMAIL PROTECTED]] > Enviado el: martes, 15 de enero de 2002 13:24 > Para: Mailing list MySql > Asunto: Re: MySQL can't tell

RE: MySQL can't tell the difference between two databases???

2002-01-15 Thread Javier Armendáriz
* from tab1; +++ | id | name | +++ | 1 | javier | +++ 1 row in set (0.00 sec) mysql> use db1; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select

Problem with latest solaris 8 binary distribution?

2002-01-29 Thread Javier Muniz
need to install from source? Thanks, Javier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EM

Problem compiling mysql-3.23.52

2002-09-07 Thread Javier Suarez
]: Leaving directory `/opt/src/apache/mysql-3.23.52' make: *** [all-recursive-am] Error 2 The system is Suse 8.0 and the Glibc is the glibc-2.2.5-38 Any solution or should I install the RPM from Suse? :-( Thanks Javier Suarez ---

Problem compiling mysql-3.23.52

2002-09-09 Thread Javier Suarez
ake[1]: Leaving directory `/opt/src/apache/mysql-3.23.52' make: *** [all-recursive-am] Error 2 The system is Suse 8.0 and the Glibc is the glibc-2.2.5-38 Any solution or should I install the RPM from Suse? :-( Thanks Javier Suarez --

Select IN and NOT IN

2002-10-07 Thread Javier Campoamor
missing something or this cannot be done with MySql. I think that this could be done with a Temp table, but I need to do it in only a query. Any idea about how to do it? Regards Javier *Note: The tables are simplified because they were named in Spanish and there were more tables used to filter

RE: query help

2002-10-08 Thread Javier Campoamor
7;, 'fg00914', '' Is this rigth? Please, if you find a good resource for complex queries advise me. I also have the DuBois book, and I need more advanced for advanced queries with mySql. Regards Javier > -Mensaje original- > De: Michael Knauf/Niles [mailt

RE: MySQL On Unix

2001-04-23 Thread Javier Armendáriz
Hi, You must install MyODBC in your Unix system, and the MyODBC module for windows. Once it is done, make a new connection trought this module whit de ODBC default fort, the machine name, user, pass and database. It was all I did and it worked correctly Javier

Re: multiple-(BLOB)column, primary key for pre-v 3.23 db

2001-06-19 Thread Javier Armendáriz
way for do the same in a better way? Thanks Javier Armendáriz [EMAIL PROTECTED] Brian Warn wrote: > Hello, > > I want to use two text columns as my primary key. From the DuBois book, I see that >I cannot do this since my v. 3.22.32 tables are ISAM, and BLOB and TEXT columns >ca

Off-topic, but database

2001-01-10 Thread Javier Armendáriz
ms glitter in the darkness at Tan Hauser Gate. All those moments will be lost in time like tears in rain. Time to die. ======= Javier Armendáriz [EMAIL PROTECTED] - Before posting, please chec

Re: configuration

2001-01-16 Thread Javier Armendáriz
be lost in time like tears in rain. Time to die. ======= Javier Armendáriz [EMAIL PROTECTED] - Original Message - From: "funky gao" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: martes, 16 de enero de 2001 13:41 Subject: configurat

Mangled queries

2001-01-18 Thread Javier Muniz
problem or heard of something, please let me know as I'd really like to get this fixed. Cheers, Javier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (

RE: AND on a many to many table, with arbitrary ANDs

2001-01-31 Thread Javier Muniz
| 1 War and Peace | 1 Tale of Two Cities | 1 then selecting from that subset for count = 2; if anyone can think of a way to do it with left joins, or a way to do it without select into, i'd be very curious to see the solution :0 cheers, Javier -Orig

Re: localhost

2006-06-16 Thread Javier Carlos Viegas
--- Karl Larsen <[EMAIL PROTECTED]> escribió: > I'm trying to use mysql on Linux type Fedora > Core 4 and it works > part way but I have no guess how to fix this > problem. Here is what happens: > > [EMAIL PROTECTED] ~]$ mysql > Welcome to the MySQL monitor. Commands end with ; > or \g. >

¿mysql_stmt_bind_param under windows bug?

2006-06-26 Thread Arias Gonzalez, Javier
environment. I tried installing version 4.1.20 and linking my program with the new library but the result is the same. Is that a bug of windows version? Can anyone help? Thanks in advanced Javier Arias

mysql_stmt_bind_param error

2006-07-24 Thread Arias Gonzalez, Javier
environment. I tried installing version 4.1.20 and linking my program with the new library but the result is the same. Is that a bug of windows version? Can anyone help? Thanks in advanced Javier Arias

Multiple-Column Indexes Question

2006-08-03 Thread Arias Gonzalez, Javier
EX name (first_name,last_name)" and perform a query like: "select * from test where first_name='bbb' and last_name='aaa'" C) It is irrelevant the order of the index definition. Thanks in advanced Javier

Need to install MySQL extensions for php...

2005-08-02 Thread Javier Carlos Viegas
called "MySQL extension" How can i install those? Do i missed some configuration options?? Thanks for any help provided. Javier __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! ¡Abrí tu cuenta

A question about stored procedures

2005-10-06 Thread Leonardo Javier Belén
Hi all, I am wondering if I can construct a query string inside a stored procedure and then execute it. I mean, what I want to do is given a set of IN parameters, be able to construct a huge where statement out of them an then complete the query string to execute. Is that possible? because if t

Problems with a full backup

2005-03-12 Thread Javier Ballesteros Correa
Hi! I'm learning mysql and I have a problem when i make a full backup with mysqldump. I have a lot of table rows written in spanish. In the backup file (.sql) I have problems with certain spanish characters like: á --> Ãi é --> é í --> Ã- ú --> ú and so many others like that. However, when I mak

inserting special characters

2005-05-10 Thread Javier Ballesteros Correa
Hi, everybody! I have a problem working with MySQL and C++ Builder 6. I can´t find the solution and I hope that maybe somebody can help me. I use the ZEOS components (6.1.5) to connect the MySQL database (version 4.1.11) with C++ Builder. The fact is that everything goes rigth except when I try to

Re: inserting special characters

2005-05-10 Thread Javier Ballesteros Correa
Hi, Mr. Paharenko, Here are the results: character_set_client | latin1 character_set_connection | latin1 character_set_database | latin1 character_set_results| latin1 character_set_server | latin1 character_set_system | utf8 character_sets_dir | C:\Archivos de programa\My

Re: MySQL as document storage?

2004-01-07 Thread Leonardo Javier Belén
May be there is an option on the Commercial Market, BasisPlus from OpenText. I worked quite a lot with it but, sincerely, I prefer a MySQL table with references to files on the File System. A lot faster, and cheaper Now there is true that I use to work with sgml files and I still prefer them.

Re: Can MySQL 4.0.14 store HTML? Among other things....

2003-08-14 Thread Leonardo Javier Belén
I think that the thing that really matters here is if we can do an sgml index (fulltext) on a MYISAM table, and if not how to achieve that goal (a really big one). - Original Message - From: "Jay Blanchard" <[EMAIL PROTECTED]> To: "Machiste' N. Quintana" <[EMAIL PROTECTED]>; <[EMAIL PROTECT

Problem importing data

2004-12-09 Thread Leonardo Javier Belén
Hi all, I am experiencing a fairly bizarre problem: in MySQL 4.1.7 (Windoze version), when importing data from a file with semicolon-separated data, I get random default values for the datetime fields. This turns the data obviosly unusable. The same import on the same machine but with the 4.0.

ODBC Connector for Windows - how to handle large resultsets?

2004-07-22 Thread Leonardo Javier Belén
Hi all, I have a problem with the ODBC Connector since I need to handle very large resultsets. when I try a simple search on a 5Millon table, it tries to send all the info to the client hanging it before i can see a simple row. So is there a way to force the driver to use use_resultset ins

A possible bug

2004-07-27 Thread Leonardo Javier Belén
Hi all, I am using MySQL ver. 4.1.3-beta on Windows 2000 pro and I found that, whenever i try to export data using the "into outfile" clause of the select command the server hangs and i need to restart the service. Has anyone faced the same problem, and if it is, how have you resolve it? I

Re: A possible bug

2004-07-28 Thread Leonardo Javier Belén
elsen" <[EMAIL PROTECTED]> To: "Leonardo Javier Belén" <[EMAIL PROTECTED]> Sent: Wednesday, July 28, 2004 9:34 AM Subject: SV: A possible bug Hi Leonardo i had a similar problem, it was with InnoDB tables, so i changed these values: # Set buffer pool size to 50-8

Re: innodb and fulltext

2003-09-04 Thread Leonardo Javier Belén
Actually I think it can be done, but I need some help on the hooks on MySQL and the approval of Heikki... The matter is that I can be an interesting mental exercise and I think that it is missing to be a real 'de facto' world wide product. Any help? Leo. - Original Message - From: "electrot

deleting mysql users

2003-10-10 Thread Alejandro Javier Pomeraniec
Hi !! Whenever i create a database user using GRANT command, mysql add a register inside the user table in mysql database. I've noticed that if i use REVOKE to revoke all privileges from that user, mysql does not delete the register from user table, but denies every permission for that user. Wh

Re: deleting mysql users

2003-10-10 Thread Alejandro Javier Pomeraniec
Thanks !! Do you happen to know why mysql decided not to erase those users?? On Fri, 10 Oct 2003 17:07:12 +0300 Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > Alejandro Javier Pomeraniec <[EMAIL PROTECTED]> wrote: > > > > Whenever i create a database user usi

problem with query

2003-11-04 Thread Leonardo Javier Belén
Hi ALL! I have a problem with this query, because it keeps failing and I dont know why (it says that the concat statement is wrong but there is nothing on the online docs...) select st.id, concat(st.required), st.name from states st, agenda ag left outer join ag.id=concat("AGE",st.required) w

[ot] connection process is very slow under WIN NT 4.0

2004-03-16 Thread Leonardo Javier Belén
Hi I realize that this is may be off topic, but the remote connection times to MySQL under Windows NT 4.0 is really slow, while under Unix is quite responsible. Does anyone faced this problem and found a proper solution? because the project needs to reside on Windows and otherwise management wi

Arguments to fight against Ms SQL Server and Oracle

2004-04-13 Thread Leonardo Javier Belén
Hi folks! I am sorry to bother but I need your help. At work I need to upgrade the data management the place is using (very old FOXPRO DOS) with something more modern. The use is only to store data and run multiple querys in a post mortem fashion. The data source is a Ms SQL server so manage

Is there a way to make mysql sgml aware?

2004-05-05 Thread Leonardo Javier Belén
Hi folks, Is there a way to make mysql sgml aware or any plan to do it in the near time? Leonardo J. Belen mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql quer

help with query

2003-01-13 Thread Leonardo Javier Belén
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is anothe

help with query

2003-01-13 Thread Leonardo Javier Belén
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is anothe

help with query

2003-01-13 Thread Leonardo Javier Belén
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is anothe

help with query

2003-01-13 Thread Leonardo Javier Belén
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is anothe

Re: help with query

2003-01-14 Thread Leonardo Javier Belén
Thanks but actually I'm looking for a way to return all the relations upwards and downwards of a term. no matter the position (so I need general query to do that. Any ideas? Thanks in advance. Leo. - Original Message - From: "Anthony Richardson" < To: "Leonard

  1   2   >