Postgres to mysql api

Dear Friends What is the mysql api for the follow postgress api PQresultStatus() PQntuples() PQresStatus PQclear() PQgetValue() PQerrorMessage() PQnfields() PQfname() PQfnumber() PQfsize() PQfmod() Regards and thanks in advance Luiz --- Outgoing mail is certified Virus Free. Checked by AVG

How to construct this SQL statement?

Hi All, I need with an SQL statement. I have two tables in my database (mySQL): portfolio and categories. In the portfolio table, I have a column called categories, and there is a number value int here depending on where the item is placed in my portfolio. So value 1 is web design, value 2 is

RE: How to construct this SQL statement?

Select protfolio.ID, categories.description from protfolio inner join categories on protfolio.categories = categories.categoryvalue I think this is what you are looking for. You'll get a much better response form the forum if you include the table definitions with your question. Good luck,

Mac: Trouble linking library

Hi everyone, I am trying to write an application on the Macintosh to use a mysql database. I tried posting this to the xcode reflector, but didn't get a response. I'm hoping that someone here is familiar with xcode and can help me solve my problem: Preface: I am fairly new to writing code and

Re: How to construct this SQL statement?

* Mr. Justin G. Kozuch I have two tables in my database (mySQL): portfolio and categories. In the portfolio table, I have a column called categories, and there is a number value int here depending on where the item is placed in my portfolio. So value 1 is web design, value 2 is flash, etc

Re: How to construct this SQL statement?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 15 February 2004 10:56, Mr. Justin G. Kozuch wrote: Hi All, I need with an SQL statement. I have two tables in my database (mySQL): portfolio and categories. In the portfolio table, I have a column called categories, and there is a

Re: mysql ended

Russell Jolly [EMAIL PROTECTED] wrote: Description: Downloaded, installed, and tried to run mysql server 4.0.18 on Red Hat ES 3x and recieved the following error: Starting mysqld daemon with databases from /var/lib/mysql 040214 12:08:16 mysqld ended I can't get the mysql

3.23 redhat 9 server install

hi, i have installed the redhat 9 server with php, apache 2, perl and of course mysql 3.23.54. my problem is i can't access it or start it or anything. so i tried to reinstall and it says its already there. find /usr/ -name mysql_safe tried this and i get nothing tried this start mysql server

RE: 3.23 redhat 9 server install

Try /usr/bin/safe_mysqld The mysqld_safe is 4.0.x version. Also, try reading the installtion instructions and check out the manual online at mysql.com -James -Original Message- From: Claritinet.com [mailto:[EMAIL PROTECTED] Sent: Sunday, February 15, 2004 11:28 AM To: [EMAIL

Table Corruption

Hi, After setting up a slave mysql server ( 4.0.17 ) on an SMP linux box ( kernel 2.4.18 SMP ). I noticed that one of my large tables ( 300MB ) started to corrupt regularly ( every day or two day max ). I discover its corruption after getting the error Got error 127 from table handler. Repairing

Fulltext and standard index, together?

Hi, We have this situation: select * from MyTable where match (col) against (foo) limit 10; takes 1s, but: select * from MyTable where match (col) against (foo) and col2 = 15; takes ~4s. col is a text field w/fulltext index, and col2 int unsigned w/standard index. So, what I was thinking

FOEIGN KEY

Can a field in one table be a foreign key of another table's field which is also a foreign key of a third table? Maru _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

client and server question

I've got an iBook running gentoo and MySQL version 4.0.17 and it's on the same router with my desktop running gentoo and MySQL version 4.0.17. I would simply like to use the iBook as a mysql client and have it connect to the mysql server running on my desktop. What is the simplest way to

RE: 3.23 redhat 9 server install

Try to download the newer version of mysql, redhat has a newer 1 on his site (or mirrors) Best Regards, HuMPie @ Grunn.Org mrtg.grunn.org Dutch mirror of MRTG www.webdns.info Dutch private DNS hoster === Motto: Writing software is more fun than

transaction

Dear Friends Does mysql version 4.0.x support the follow sql commands begin transaction commit rollback Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.588 / Virus Database: 372 - Release Date: 13/2/2004 -- MySQL

Re: transaction

Luiz Rafael Culik Guimaraes wrote: Dear Friends Does mysql version 4.0.x support the follow sql commands begin transaction commit rollback Regards Luiz Yes. Your time would have been better spent searching on the MySQL web site or in the documentation that posting that question here. --

Performance Benchmarks

List, Is there a site where I can see performance benchmarks on mySQL vs. MS SQL Server 2000 ? We plan to migrate a database that's now running under SQL Server 2000 to mySQL, because of online hosting costs, but our boss is not so sure of doing that, he feels safe working under SQL Server

Re: transaction

CanIt Vote for ID 3429Daniel I searched all myql 4.0 what new page and did found any reference, is their other page Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.588 / Virus Database: 372 - Release Date:

Re: transaction

Luiz Rafael Culik Guimaraes wrote: Daniel I searched all myql 4.0 what new page and did found any reference, is their other page Regards Luiz Press Release: http://www.mysql.com/press/release_2002_11.html Documentation: http://www.mysql.com/doc/en/InnoDB_transaction_model.html

Re: Performance Benchmarks

Rodrigo Galindez wrote: List, Is there a site where I can see performance benchmarks on mySQL vs. MS SQL Server 2000 ? We plan to migrate a database that's now running under SQL Server 2000 to mySQL, because of online hosting costs, but our boss is not so sure of doing that, he feels

Re: Performance Benchmarks

Daniel, Whoa, very impressive ! ! ! Thanks, gonna print that graphs :) Daniel Kasak wrote: Rodrigo Galindez wrote: List, Is there a site where I can see performance benchmarks on mySQL vs. MS SQL Server 2000 ? We plan to migrate a database that's now running under SQL Server 2000 to mySQL,

Database user access

Hi, Is it possible to allow one user to access MySQL using for example PHP but stop him when he tried to access MySQL directly? Thanks -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Database user access

Hi, Is it possible to allow one user to access MySQL using for example PHP but stop him when he tried to access MySQL directly? Thanks -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Performance Benchmarks

Ahh, the infamous JDBC benchmark. :-) There's been much commentary on this in the past. There are some things to consider: 1. The native APIs for each DB will be faster. 2. The DB, App Server and Web Server were all on one box. 3. I'm not sure if the MySQL JDBC driver supported the