MySQL for Excel 1.2.1 has been released

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

Re: Issue With Subqueries

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

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

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

this 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

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

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

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

Problems with indexes on Date/DateTime fields

. 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 addressed. If you have received

RE: Problems with indexes on Date/DateTime fields

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 Javier

RE: Problems with indexes on Date/DateTime fields

if that 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 using

RE: Problems with indexes on Date/DateTime fields

] Are valid for the equivalent DELETE FROM TABLE-X WHERE [CONDITIONS] Thanks a lot for your help Javier -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 14:39 To: Javier Diaz Cc: Aftab Khan; mysql@lists.mysql.com Subject: Re: Problems with indexes on Date

A question about stored procedures

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

Need to install MySQL extensions for php...

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 ya! - http

Visual Basic .NET Oledb Provider

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]

inserting special characters

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

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

RE: C API : Problem using multi-statements

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

Problems with a full backup

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 make

calculated field

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

esta bajo control, es que no vamos suficientemente deprisa Javier Armendáriz [EMAIL PROTECTED]

Problem importing data

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

Re: A possible bug

[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-80% of your computer's memory set-variable

A possible bug

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?

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

RE: Concurrency Question

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

RE: Concurrency Question

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] Sent: 05 July 2004 17:58

Concurrency Question

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

Rows Counter

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

Is there a way to make mysql sgml aware?

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

Arguments to fight against Ms SQL Server and Oracle

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

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

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

unauthenticated user

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

RE: unauthenticated user

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

Re: MySQL as document storage?

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

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)

deleting mysql users

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.

Re: deleting mysql users

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 using GRANT command, mysql add

Re: innodb and fulltext

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:

Dump FK

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

Re[2]: Dump FK

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 only

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

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

Edit my database in Server

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

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

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: Leonardo Javier BelÈn [EMAIL PROTECTED

Re: help with query

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] Sent: Tuesday, January 14, 2003 11:30 AM Subject: Re

help with query

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

help with query

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

help with query

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

help with query

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

Re: MySQL AB has reached a settlement with NuSphere Corporation

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

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

, 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 - SQL, SQL, QUERY, MYSQL, SQL, SQL

RE: query help

, 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 [mailto:[EMAIL PROTECTED]] Enviado el: martes, 08 de octubre de 2002 14:48 Para

Select IN and NOT IN

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 the calls, but they are not related

Re: Set Path Environment

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 This is more information regarding the Path for my

Fw: A new Idea for FULLTEXT searchs

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 posting, please check: http

Re: Server shutdown

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 - From: Shravan Durvasula [EMAIL PROTECTED] To: MySQL HELP

A new Idea for FULLTEXT searchs

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 posting, please check: http

Problem compiling mysql-3.23.52

`/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 - Before posting, please

Problem compiling mysql-3.23.52

`/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 - Before posting, please

Cannot create tables with ODBC

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: Inno DB Question

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 September 2002 20:06 To: [EMAIL PROTECTED] Subject: Re: Inno DB Question Javier, it may be that the dbExpress

Insert date format

-%d' ); I have searched in the manual, the list and in the DuBois' book, but I haven't found a single function to parse my date to the mySQL date. Is that rigth? Is there no function to parse from any date to the mySQL date? Regards Javier

RE: Insert date format

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 solution. Regards Javier

Inno DB Question

? Thanks a lot Javier Diaz -- This e-mail is intended for the named addressee only. It may contain confidential and/or privileged information. If you have received this message in error, please let us know and then delete this message from your system. You should

RE: Inno DB Question

VALUES('t2','test2')); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(ROLLBACK); Q-ExecSQL(); And now 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

Re: mysql password ( )

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 Belén. AFIP-AR - Original

Re: MySQL Table size

work arounds, like the Innodb. I hope this will make you an idea. Leonardo Javier Beln. AFIP-AR. - Original Message - From: Scott Pippin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 12:17 PM Subject: MySQL Table size Which Operating Systems limit MySQL to a 2GB

Fw: MySQL Table size

work arounds, like the Innodb. I hope this will make you an idea. Leonardo Javier Beln. AFIP-AR. - Original Message - From: Scott Pippin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 12:17 PM Subject: MySQL Table size Which Operating Systems limit MySQL

change name of one column

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

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

About insatallation on Linux

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 i run the

Incorrect replication user time

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

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 DISTINCT(mi.interest_id), COUNT(*) AS count

Server speed working with databases and apache

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

Re: Cross querying databases (again)

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, u r my hero. I never, never

What is the best way to do this

-m. Is it possible to do 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

mysql forum

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

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

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

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

C API Question

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

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

Order By and Use Index

? Is not 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

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 results. THANKs JAVIER GLORIA

Sum function question

to 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

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

Sum function question

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 - Scanned for all known viruses by Messagelabs -- - Before posting, please check

Sum function question

- 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 string3 B string1 B string 2 I

problems with the daemon

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

problems with the daemon

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

Problem with latest solaris 8 binary distribution?

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 [EMAIL PROTECTED

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

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 the

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

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 * from tab1

query

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.

RE: query

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. html head titleUntitled Document/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body

PHP + MySQL problem (strange behavior)

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 Officer Granicus, LTD. Tel: (415) 522-5216 Fax: (415) 522-5215

Getting id asignet to an insert

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

MYSQL + MOSIX

=6 And Respond DATAID 6 #from node1 10#from node1 9 #from node2 7 #from node2 7 #from node3 8 #from node3 6 #from node3 It is possible to make this experiment. Somebody has proven it. JAVIER OLIVA PUNTA

Re: foxpro conversion

Javier /* -- */ He that will not reason is a bigot, He that cannot reason is a fool, He that dares not reason is a slave

Re: How I can do this

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: Hi, I need do the follow

  1   2   >