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: 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

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

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

¿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

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. >

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: 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: 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
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

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

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

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

Visual Basic .NET Oledb Provider

2005-06-15 Thread Leonardo Javier Belén
Hi all, I would need an oledb provider for MySQL. Do you know where I can found a good one. Thanks in advance. Leonardo J. Belén. A-AR -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

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: 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:

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

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]

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]

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.

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

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

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

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

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

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

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

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

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

[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

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

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: 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.

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

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

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: 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

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

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: 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

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

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.

Re: help with query

2003-01-14 Thread Leonardo Javier Belén
Thats good but what about a way query up and down only modifying a var, something like and hierichal search?. Leo. - Original Message - From: "CH Tsang" <[EMAIL PROTECTED]> To: "Leonardo Javier Belén" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Se

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

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: MySQL AB has reached a settlement with NuSphere Corporation

2002-11-07 Thread Leonardo Javier Belén
Can someone post the piece of News, for the folks that cant get into the page (I dont have access to web from where I am now...) Thanks, Leo. - Original Message - From: "Christopher Hicks" <[EMAIL PROTECTED]> To: "Michael Widenius" <[EMAIL PROTECTED]> Cc: "Mysql List" <[EMAIL PROTECTED]> Se

A way to get into the code to add functionality to FullText Searches

2002-11-06 Thread Leonardo Javier Belén
instead of the compiled in one. For now, I need the answer to a few things. a) am I in the right list? b) has anyone try to add it? c) where the hell registered a environmental variable? d) which is the function that actually build the index? Cheers, Leonardo Javier Belén. AFIP-AR - S

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

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: Set Path Environment

2002-09-25 Thread Leonardo Javier Belén
hope this helps. Leonardo Javier Belen. AFIP-AR Spam: sql, query, mysql - Original Message - From: "William Martell" <[EMAIL PROTECTED]> To: "MySQL Main List" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 11:38 PM Subject: Fw: Set Path Environment

Fw: A new Idea for FULLTEXT searchs

2002-09-20 Thread Leonardo Javier Belén
code (for example) without worries of indexing the tags, and allow the developer to add new functionality as RTF support and TEX. Am I int the good way or I'll need to sleep more? Leonardo Javier Belén. AFIP-AR. - Before

Re: Server shutdown

2002-09-18 Thread Leonardo Javier Belén
ox starts. Another posibility is to use the kill command: just type > ps -aux | grep mysqld and then > kill -TERM << and the last of the processes ID >> I hope this can help you to get into the fascinating world of MySQL. Leonardo Javier Belen. AFIP-AR - Original Message -

A new Idea for FULLTEXT searchs

2002-09-11 Thread Leonardo Javier Belén
r example) without worries of indexing the tags, and allow the developer to add new functionality as RTF support and TEX. Am I int the good way or I'll need to sleep more? Leonardo Javier Belén. AFIP-AR. - Before

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 --

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 ---

Cannot create tables with ODBC

2002-09-05 Thread Leonardo Javier Belén
Well, just that thing. I'm able to search, retrieve and update Mysql tables (server located on a Linux Box) but I cannot create tables, nor modify its structures. Does anyone knows why. Leonardo Belen. Afip AR PS: I tried with the last stable release of Mysql and MyODBC from MYSQL.COM.

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

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: 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

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

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: mysql password ( )

2002-08-28 Thread Leonardo Javier Belén
I dont know if it helps, but I dont decrypt, instead, I compare the crypted value on the DB against the output of the function PASSWORD() filled with the pwd I get from the user... It works for me (and I'm using APACHE and MySQL all in plain "ANSI C"). Leonardo Javier

Fw: MySQL Table size

2002-08-27 Thread Leonardo Javier Belén
work arounds, like the Innodb. I hope this will make you an idea. Leonardo Javier Bel&alefmaks;n. AFIP-AR. - Original Message - > From: "Scott Pippin" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, August 27, 2002 12:17 PM > Subject: My

Re: MySQL Table size

2002-08-27 Thread Leonardo Javier Belén
work arounds, like the Innodb. I hope this will make you an idea. Leonardo Javier Bel&alefmaks;n. AFIP-AR. - Original Message - From: "Scott Pippin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 27, 2002 12:17 PM Subject: MySQL Table size >

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. > > > __

About insatallation on Linux

2002-07-05 Thread Javier Gonzalo Gloria Medina
> Hi everybody: > Well i have all redy work with mysql instalation on > win xp = (, and for some reasons i migriate to > linux. > > i follow the typical instalation of : > > making the user and group for mysql. ok > configurate the ./config stuff with the > --prefix=/usr/local/mysql > then when

About insatallation on Linux

2002-07-05 Thread Javier Gonzalo Gloria Medina
Hi everybody: How would like to answer some newbie questions ? Well i have all redy work with mysql instalation on win xp = (, and for some reasons i migriate to linux. i follow the typical instalation of : making the user and group for mysql. ok configurate the ./config stuff with the --pre

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

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

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: 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,

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

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 --

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

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

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

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

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

xml

2002-03-09 Thread Javier Gonzalo Gloria Medina
"the best databases are made with xml, old databases like mysql, oracle and all the others, will not be functionall thanks XML standar". Well, now I´m cofused. Some one can help me with this "is that true", is XML the next generation of creating databases and tables for beast r

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

Problem

2002-02-25 Thread Ricardo Javier Aranibar León
I have a problem, when I try to connect to the Data Base [root@hvserver_tja bin]# mysql bash: mysql:command not found [root@hvserver_tja bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through '/tmp/mysql.sock' (2) [root@hvserver_tja bin]# ./mysql -h hvserver_tja -u -p Enter pass

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-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

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

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:/

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

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

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

relational tables

2002-01-13 Thread Javier Gonzalo Gloria Medina
Hi people : How I crate this relational tables with mysql. Table users | id | user name| e-mail | password | carrier| semester | table assignments | id | assignments | where the two tables must be related by id ok thanks for the help...

RE: query

2002-01-04 Thread Javier Gonzalo Gloria Medina
Hi Nathan : Thanks for the help look, I read the php.net manual and use the mysql_num_rows(); function, and I write down this script, did you think is good enough. Thank. Untitled Document " target=new_window>..:: Edit ___

query

2002-01-04 Thread Javier Gonzalo Gloria Medina
Hi: I have the next question when i program in asp a query to a database and the query doesn´t returns info you use the while not eof, and then you can control what will appear en the html page ok. There is something or a code that do the same in php4 Thanks.

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

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

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 __

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

  1   2   >