Re: Linux Installation (make) problem

2002-08-01 Thread Francisco Reinaldo
Hi, I recomend you to use the pre-compiles binary distribution. You won't have to build it and it worked for me. This is the link for the Intel platform: http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-3.23.51-pc-linux-gnu-i686.tar.gz Bye and Good Luck. ---

Re: Running an SQL file from the command line

2002-08-01 Thread Francisco Reinaldo
mysqlsms.sql Also if you are inside the application mysqlsource sms.sql Bye and Good Luck! --- Scott Pippin [EMAIL PROTECTED] wrote: I need to run a file called sms.sql from the command line. Is this possible and what is the syntax? Thanks in advance.

AIX 4.3 Installation of Binary file does not work because libz. (Still unresolved).

2002-07-30 Thread Francisco Reinaldo
Hi, I wanted to summarize my problem again so if somebody had the same issue can help me. O.S. IBM AIX 4.3.3 MySQL Binary Distribution: 3.23.46 When I run ./scripts/mysql_install_db, I got this error: exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150

Re: why does MySQL need to access the internet? my firewall wants to know

2002-07-29 Thread Francisco Reinaldo
Hi, Are you sure that is trying to access the internet. It may be trying to open the port, remember that MySQL needs 3306 (by default) to communicate with the server. I think if you just open that port, everything will be ok. Bye and Good Luck. --- Matthew K. Gold [EMAIL PROTECTED] wrote: Hi,

Re: order by date

2002-07-29 Thread Francisco Reinaldo
Hi, Change the alias to date_format(date,'%D %M %Y') AS mydate, so you are sure that you sort by the date field not my the formatted date. Be aware that if you sort my the formatted string, MySql is going to treat it as a string and therefore sort it as a string. 11th July 2002 2st July 2002

Re: Need help with Tables/Attributes

2002-07-27 Thread Francisco Reinaldo
Hello Nitesh, You can find that and more at... http://www.mysql.com/doc/A/L/ALTER_TABLE.html Good Luck, --- Nitesh Divecha [EMAIL PROTECTED] wrote: Hello All, I need help with tables. I have created my table with some attributes in it. I need to modify my table attributes, can any

Re: Query problem

2002-07-27 Thread Francisco Reinaldo
Hi, Use LEFT JOIN instead of =. In a 1:m relationship, only records that match in both tables are selected. With L.J., the master is always selected even if the record is not present in the child. Master Id 1 2 3 4 5 Children FK_id Value 1 V1 1 V2 2 V3 Select id, value from

Re: Re: IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.

2002-07-25 Thread Francisco Reinaldo
Victoria, I am using mysql-3.23.49-ibm-aix4.3.3.0-rs6000.tar.gz, which is the latest version posted on your site. Also, when I try to compile mysql-3.23.51.tar.gz, I get the following error executing the make command: my_gethostbyname.c, line 81.5: 1506-068 (S) Operation between types struct

IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.

2002-07-24 Thread Francisco Reinaldo
Hi, When I try to execute scripts/mysql_install_db, I get some errors about some libraries missing: exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module

Re: Select Problem

2002-07-22 Thread Francisco Reinaldo
Hi, Use LEFT JOIN instead = Bye and Good Luck! --- Mark Colvin [EMAIL PROTECTED] wrote: I want to select from three tables where there may or may not be a record in the third table. Table 1 and 2 have a one to one relationship and table 1 and 2 both have a one to many relationship with

Re: Network access?

2002-07-22 Thread Francisco Reinaldo
Hi, If you mean how to connect to a MySQL server from a remote machine in a local network, you only need to include the computer (or ip address) of the server in the HOSTNAME. You also have to make sure that the user in the connection string, has permission to access the database, you should go

Re: Hello I am new to the list..

2002-07-22 Thread Francisco Reinaldo
Hi, Mailing list: http://lists.mysql.com/ Joining three tables could be something like this. Select * from t1 INNER JOIN t2 ON t1.id = t2.id INNER JOIN t3 ON t2.id = t3.id I highly recomend you to read some basic SQL books before you carry on with your project. Trial and error is not always

RE: MySQL in different OSes

2002-07-17 Thread Francisco Reinaldo
From MySQL manual: http://www.mysql.com/doc/M/o/Moving.html http://www.mysql.com/doc/U/p/Upgrading-to-arch.html I have tried and it works in HP-Solaris and LINUX, but I tend to agree with Cal, my recomendation is to use an alternative procedure such as dumping and importing. Bye and Good

Re: help me with this query

2002-07-17 Thread Francisco Reinaldo
these situations -Arul - Original Message - From: Francisco Reinaldo [EMAIL PROTECTED] To: Arul [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Cc: Arul [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 3:27 AM Subject: Re: help me with this query Hi, Select companyid, count

RE: Use MySQL and Visual Basic 6.0

2002-07-16 Thread Francisco Reinaldo
Hi, This is not related with your issue but if you want to do serious development, don't use Windows 98 in any of its versions. It is going to give a lot of problems. Bye and Good Luck. --- Matthew Scarrow [EMAIL PROTECTED] wrote: I've built a whole program with vb6 and mysql database back

Re: help me with this query

2002-07-16 Thread Francisco Reinaldo
Hi, Select companyid, count(*) from CompanyServices where serviceid = 1 or serviceid = 2 or serviceid = 3 group by companyid having count(*) = 3 Bye and Good Luck. --- Arul [EMAIL PROTECTED] wrote: Hi All The Table design goes like this Company Table companyid

Re: select query

2002-07-15 Thread Francisco Reinaldo
Hi, Sorry but MySQL does not support subqueries yet. Bye and Good Luck! --- Narcis GRATIANU [EMAIL PROTECTED] wrote: When I try this: SELECT article, dealer, price FROM shop s1 WHERE price=(SELECT MAX(s2.price) FROM shop s2 WHERE s1.article =

Re: Help - query suggestion needed - interesting case

2002-07-15 Thread Francisco Reinaldo
Hi, Since subqueries are not allowed in MySQL, this is what I would do: Create a temporary table with the id's containing multiple dates. Inner join your table with the temporary table. Even if MySQL allowed subqueries, this is what will probably happen behind the scene. Bye and Good Luck!

Re: Query realted to Mysql access.

2002-07-11 Thread Francisco Reinaldo
No1. Sounds like a permission problem. Make sure that you have that domain in the list of computer allowed to connect to MySQL. Refer to MySQL manual to get more information about this. No2. PC based application won't run on Linux unless you run them under an PC-emulator which I don't even know

Re: Mysql certification

2002-07-11 Thread Francisco Reinaldo
Dough! They started behaving like big corporations already; certification, consulting, etc, etc. :-) --- Defryn, Guy [EMAIL PROTECTED] wrote: I was wondering if anybody heard about a possible release of books that help you prepare for the Mysql certification? Cheers

Re: Database documentation

2002-07-09 Thread Francisco Reinaldo
Hi, These tools are not open source: http://www.thekompany.com/products/dataarchitect/ You can download the evaluation. It supports MySQL directly: http://www.datanamic.com/download/download_dezign.html If you are not familiar with database methodology and relation entity diagrams, I

Re: UDF, Can anyone please help?

2002-07-08 Thread Francisco Reinaldo
Hi Miles, Could you explain the same thing with a some sample data? I does not need to be your data. I think that what you want to do is this but I am not sure. Field1 Field2 A 1 A 1 A 2 A 3 B 1 B 1 B 2 C 2 C 2 C 4 C 4 When you say last

Re: RecordCount

2002-06-24 Thread Francisco Reinaldo
Some database providers implementation always return -1 no matter the amount of records is returned. That happens to ADO too for certain cursors. The best way to go to count records is Count(*), prepare a query like Select count(MyField) from MyTable Where ... and then get the value. I hope it

Re: Binary data mysqldump and restore.

2002-06-24 Thread Francisco Reinaldo
If I remember correctly from the manual, you can dump your data generating the SQL statements (this is what you are doing) and your file will have a bunch of INSERTS. Your problem is that those inserts will have something like SET YourBinaryField = 'a-bunch-of-characters'. The problem is that

Re: JDBC driver problem

2002-06-20 Thread Francisco Reinaldo
Which driver are you using? I use mm.mysql-2.0.4-bin.jar Which IDE are you using? If you are using JBuilder 5, you have to go to required library and add one pointing to that file. If you are building a jar file from your classes, you have to make sure that you tell the library to include this

Re: Left Join Query Too Slow

2002-06-20 Thread Francisco Reinaldo
Hola Javier, It is difficult to tell because you did not include the table structures, relationships, indices, etc. But... at a first glance we is killing you query anyways is this: FROM Bill b, Hour h The poor db engine is probably creating a huge temporary table with all

RE: I'd like to use MySQL with WindowsXP.

2002-06-18 Thread Francisco Reinaldo
Why don't you try to download MySQL from www.mysql.com? Maybe your CD-copy is corrupted. Good luck! --- Dean Harding [EMAIL PROTECTED] wrote: It sure does work on XP. I'm using it right now... What error does it give, or if no errors, what happens when you try to run it? Dean Harding.

Re: Database Structure

2002-06-18 Thread Francisco Reinaldo
How are you connecting to MySQL?, through MySQL ODBC I am assuming. I might happen that the ODBC driver for MySQL does not implement ADOX functionality. Have you tried to take a look to the MySQL++ API? You might have to create your own dll (or COM component) to modify the database structure

RE: Is the order same?

2002-06-14 Thread Francisco Reinaldo
Hi, I would not rely on the insertion order if I were you. Honestly, I don't know how MySQL deals with it but servers such as Microsoft SQL Server or even Access won't provide a deterministic order unless you sort using sort by. I recomend you to use sort by anyways if you need the result sets

Re: Creating Tables/Keys from PowerDesigner Sql

2002-06-14 Thread Francisco Reinaldo
Well, that would depend if the SQL script generated by your designer is compatible with MySQL, some type names may be different. Good Luck! --- [EMAIL PROTECTED] wrote: I generated an SQL script of my datamodel in PowerDesigner which I'd like to import into mySql to create my tables, keys,

Re: Can I connect to a MySQL Database on a unix platform from a PC?

2002-06-13 Thread Francisco Reinaldo
Hi, I've been able to connect from an Windows XP to a HP Solaris and LINUX. Make sure that you can ping the UNIX computer from yours. Then replace the computer name in the connection string (most of the time is localhost) for the UNIX computer's ip address (you can use the name if you have DNS

RE: setting up two instances of mySQL

2002-06-13 Thread Francisco Reinaldo
Hi Chris, I am Tom, you know your manager, did you say that I am wrong!!! Just kidding :-). Well I cannot find any good reason for having two databases in two different instance. Do you have two Oracles or Microsoft SQL Server instances in the computer? Nope. The only reason when that is

Re: table is read only when DB copied from Win to UNIX

2002-06-13 Thread Francisco Reinaldo
434 7582 - Original Message - From: Francisco Reinaldo [EMAIL PROTECTED] To: Tonu Samuel [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 12:14 AM Subject: Re: table is read only when DB copied from Win to UNIX Thanks for the tip but I have added

table is read only when DB copied from Win to UNIX

2002-06-12 Thread Francisco Reinaldo
Hi, I have an installation of MySQL in Windows and another one in UNIX Solaris 2.7. I need to move the databases across system and I have manually ftped a database directory from the Windows MySQL to the UNIX MySQL. Fine, I can see the database, show tables works, selects works. The whole nine

table is read only when DB copied from Win to UNIX

2002-06-12 Thread Francisco Reinaldo
Hi, I have an installation of MySQL in Windows and another one in UNIX Solaris 2.7. I need to move the databases across system and I have manually ftped a database directory from the Windows MySQL to the UNIX MySQL. Fine, I can see the database, show tables works, selects works. The whole nine

Re: table is read only when DB copied from Win to UNIX

2002-06-12 Thread Francisco Reinaldo
to Windows. I'll keep trying though but if somebody already knows the solution, please let me know. Thanks. --- Tonu Samuel [EMAIL PROTECTED] wrote: On Wed, 12 Jun 2002, Francisco Reinaldo wrote: Fine, I can see the database, show tables works, selects works. The whole nine yards? Nope! I