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 anti-virus system (http://www.grisoft.com). Version: 6.0.588 / Virus Database: 372 - Release Date: 13/2/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 flash, etc etc etc. In the categories table, I have a column called categoryvalue and categorydescription. Categoryvalue has a number value and categorydescription has, well, a description of that category. On my detail page, can I setup the SQL statement to show the description of the category and not the numerical value of the category? Does this make sense? Thanks, Justin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, Brian Power From: Mr. Justin G. Kozuch [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mySQL Help [EMAIL PROTECTED] Subject: How to construct this SQL statement? Date: Sun, 15 Feb 2004 11:56:28 -0500 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 flash, etc etc etc. In the categories table, I have a column called categoryvalue and categorydescription. Categoryvalue has a number value and categorydescription has, well, a description of that category. On my detail page, can I setup the SQL statement to show the description of the category and not the numerical value of the category? Does this make sense? Thanks, Justin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 even newer to Xcode. I am trying to write an application to use MySQL. I finally figured out how to properly add a static library (libmysqlclient.a) to my project (thanks to Markus Hitter), but I get over 13,000 errors when I build. It's as if Xcode is trying to compile the library like it was source code. I haven't added any source code to my project yet, just an #include ... in 'main.m'. I just wanted to see if I can get the library to link before I start. I tried selecting 'libmysqlclient.a' , then choosing the info button and picking different types such as compiled and archive, but I still get errors. Anybody have any suggestions? Thanks. Marty Ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 etc etc. In the categories table, I have a column called categoryvalue and categorydescription. Categoryvalue has a number value and categorydescription has, well, a description of that category. On my detail page, can I setup the SQL statement to show the description of the category and not the numerical value of the category? I think you need a JOIN: SELECT portfolio.*,categories.categorydescription FROM portfolio,categories WHERE portfolio.categories = categories.categoryvalue AND portfolio.id = $portfolioID This works if all portfolios have (at least) one related category. If some don't, you will need a LEFT JOIN. categories.categoryvalue should be a primary key. URL: http://www.mysql.com/doc/en/JOIN.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 etc etc. In the categories table, I have a column called categoryvalue and categorydescription. Categoryvalue has a number value and categorydescription has, well, a description of that category. On my detail page, can I setup the SQL statement to show the description of the category and not the numerical value of the category? Does this make sense? Could have been a bit more descriptive, but I think this is what you asked. You have two tables: portfolio - -- categories int value int categories - - categoryvalue int categorydescription char(???) *IF* I understand the description, column categories in portfolio should match a categoryvalue in categories. The query you describe doesn't seem to need anything from the portfolio table, though. If all you need is a listing from the categories table, then just ask for that column directly. e.g. Select categoryvalue, categorydescription from categories; BUT, I'm guessing that you want something from the portfolios table as well. If so: Select p.value, c.categorydescription from portfolio p JOIN categories c ON p.categories = c.categoryvalue; Change the requested column names as needed, of course. - ---Michael -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQFAL6tnjeziQOokQnARAoc4AJ9UOo+fhKhiUJkWeZOtHoZ7ice7KgCfdNua k8N7xt/j0FlGAUrwfsDGlc8= =KxiT -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 server to run. Any suggestions on what could be wrong? In the MySQL data dir you can find error log file (host_name.err). Is there error message in *.err file? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 again bash: start: command not found tried this rpm -ivh MySQL-client-3.23.58-1.i386.rpm get this file /usr/bin/mysqladmin from install of MySQL-client-3.23.58-1 conflict s with file from package mysql-server-3.23.54a-11 tried this and get ./scripts/mysql_install_db bash: ./scripts/mysql_install_db: No such file or directory mysql is installed i just cant start it or seem to do anything. does anyone have any ideas regards blair -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 PROTECTED] Subject: 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 again bash: start: command not found tried this rpm -ivh MySQL-client-3.23.58-1.i386.rpm get this file /usr/bin/mysqladmin from install of MySQL-client-3.23.58-1 conflict s with file from package mysql-server-3.23.54a-11 tried this and get ./scripts/mysql_install_db bash: ./scripts/mysql_install_db: No such file or directory mysql is installed i just cant start it or seem to do anything. does anyone have any ideas regards blair -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 table leads to loosing some records , and only helps for aother day or two then again I get same error and again table needs repair. I thought the problem might be in the linux kernel, so I upgraded to the latest kernel ( 2.4.24 SMP ) but this didn't help and the problem happened again. Then I found that mysql-4.0.18is released so I upgraded mysql but next day I found the same problem happening again :-( I am using binaries from mysql.com and debian 3.0r3 with reiserfs. The master server is 4.0.12 on freebsd/linuxthread. Harware used: Dual Intel(R) Xeon(TM) CPU 2.80GHz 2GB RAM 3ware Serial ATA RAID controller I appreciate any help. Best regards Ramy
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 would speed this up, would be: alter table MyTable drop index col, add fulltext index (col, col2); But, this makes both columns a fulltext index. We would want col a fulltext index , and col2 a standard index. Is something like this possible (if so, what syntax)? If not, any other ideas for speeding this query up? Thanks! __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 accomplish this? -- __ Check out the latest SMS services @ http://www.linuxmail.org This allows you to send and receive SMS through your mailbox. Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 working. === Disclaimer: All you do with the suggestion in this mail is you responsibillity even if your system will crash :) -Original Message- From: Claritinet.com [mailto:[EMAIL PROTECTED] Sent: zondag 15 februari 2004 20:28 To: [EMAIL PROTECTED] Subject: 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 again bash: start: command not found tried this rpm -ivh MySQL-client-3.23.58-1.i386.rpm get this file /usr/bin/mysqladmin from install of MySQL-client-3.23.58-1 conflict s with file from package mysql-server-3.23.54a-11 tried this and get ./scripts/mysql_install_db bash: ./scripts/mysql_install_db: No such file or directory mysql is installed i just cant start it or seem to do anything. does anyone have any ideas regards blair -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 2000. Sorry is this is a newbie question, this is my first work mySQL. Cheers, -- Rodrigo Galindez Information Management Assistant Center for Human Rights and Environment (CEDHA) Gral Paz 186 10 A 5000 - Cordoba - Argentina Tel/fax 54-351-4256278 [EMAIL PROTECTED] www.cedha.org.ar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: 14/2/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 http://www.mysql.com/doc/en/InnoDB_overview.html Basically, if you want transactions, you should use the InnoDB table type. You do this by adding 'type=innodb' at the end of your 'create table' command: create table MyTable ( enter table definition ) type=innodb; You can alter existing tables to innodb by issuing the command: alter table MyTable type=innodb; Or you can use the GUI MySQLCC to change table types. -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 "safe" working under SQL Server 2000. Sorry is this is a newbie question, this is my first work mySQL. Cheers, http://www.eweek.com/article2/0,4149,293,00.asp Click on the links for graphs. -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, because of online hosting costs, but our boss is not so sure of doing that, he feels safe working under SQL Server 2000. Sorry is this is a newbie question, this is my first work mySQL. Cheers, http://www.eweek.com/article2/0,4149,293,00.asp Click on the links for graphs. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- Rodrigo Galindez Information Management Assistant Center for Human Rights and Environment (CEDHA) Gral Paz 186 10 A 5000 - Cordoba - Argentina Tel/fax 54-351-4256278 [EMAIL PROTECTED] www.cedha.org.ar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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:http://lists.mysql.com/[EMAIL PROTECTED]
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:http://lists.mysql.com/[EMAIL PROTECTED]
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 NamedPipeFactory class at the time those benchmarks were taken. If it didn't, then what you are seeing is an upper-bound imposed by I/O restrictions. 4. In MySQL 4.1.1, InnoDB is able to further benefit from the query cache, as it can now use it outside of autocommit mode. 5. This was done on Windows - scalability may be different on different operating systems (Linux 2.6 and FreeBSD 5.2 are likely to be much better). 6. Interestingly, the performance of MySQL dropped by two thirds when the query cache was disabled - this sounds a bit weird as none of the other databases have this sort of mechanism in place yet performed better than 1/3 of the level of MySQL. 7. The JDBC driver has improved in performance since this test, across the board. 8. MySQL 4.1.1 adds vastly improved FULLTEXT capabilities as well as nested queries. These two additions may be of great benefit to some applications (and basing development on MySQL 4.1.x may result in being able to ship around the time 4.1 is declared production ready depending on the development time involved). I'm not sure if all aspects of this benchmark have been discussed. Heikki has said that the performance of MySQL shouldn't have changed between 4.0.0 and 4.0.16 (4.0.16 was the current version when I asked). The fact that the query cache being turned off caused such a large performance drop and that MySQL scaled so closely to Oracle even though the two engines have such different workings points to the limit in this case being the JDBC element of the test. As I've said in other threads, I can't wait for MySQL AB to release their new benchmarks - it will hopefully give us a simple, definitive source for comparison across architectures, operating systems and access methods. Regards, Chris On Mon, 2004-02-16 at 15:08, 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, because of online hosting costs, but our boss is not so sure of doing that, he feels safe working under SQL Server 2000. Sorry is this is a newbie question, this is my first work mySQL. Cheers, http://www.eweek.com/article2/0,4149,293,00.asp Click on the links for graphs. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au __ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
