Re: Syntax for Compound "IF" Statements?

I did a lot of homework on IF statements recently. Below are copies of some of the scripts I'm using now. This first example draws on a database filled with the names of the world's continents, oceans, nations and states, each given an ID in a field named IDArea. Each page on my site has an echo s

Problem with embedded server

Hello, I am coding a windows application with MySQL 4.1 C API but I cannot get the embedded server to run. With a remote server the application works just fine, so starting the embedded server is the only problem. getcwd(CWD, MAX_PATH); sprintf(BaseDir, "--basedir=%s\\", CWD); sprintf(DataDir,

Syntax for Compound "IF" Statements?

Thanks to the people who helped me with my IF statement question last night. Now I need to carry it one step further to a compound 'IF' statement. Again, can't find much information in the manuals -- Several people sent me "IF (Adopted=1, 'Y', 'N') AS Adopted FROM Animal" and it works great.

Re: download Mysql4 for Redhat9.0

I recommend you use the Intel compiled version of the MySQL pre-compiled binaries for maximum speed. For x86 32bit architecture Linux, you should use: http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.8-pc-linux-i686-icc-glibc23.tar.gz/from/pick You'll also need to install the Int

download Mysql4 for Redhat9.0

Hi, Can anybody tell me where can I download Mysql4 rpm for Redhat9.0? I cannot confirm the specific version in rpmfind.net is for Redhat9.0/ Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB and Transactions

Andre Matos wrote: Hi List, Let's suppose that I have this sequence of events: - create a connection "1" -- start a transaction --- create a new connection "2" insert a new record "named B" --- close the connection "2" --- insert a new record "named A" -- rollback - close the connection "1" Th

RE: InnoDB and Transactions

Assuming that the record "named B" is insterted using connection "2", and the transaction is started and rolled back using connection "1", that record should not be rolled back. You can experiment with things like that easily from multiple terminal windows or a graphical client. -Original

InnoDB and Transactions

Hi List, Let's suppose that I have this sequence of events: - create a connection "1" -- start a transaction --- create a new connection "2" insert a new record "named B" --- close the connection "2" --- insert a new record "named A" -- rollback - close the connection "1" This sequence will

mysql_init() issue on HPUX

I'm new to the mySql product. I have installed the mySql binaries on my HPUX machine and followed the instructions. I tested that the command line 'mysql' is working and I can create databases, users and import data. I wrote a simple C program that does mysql_init(NULL) and then connects to t

Re: Replication suddenly stops on mysql 4.1.7 with Slave_IO_Running: No

We've had very good performance with the official mysql-icc-binaries, so I upgraded to 4.1.8 last weekend since there is no official 4.1.9 binary on the mysql.com-site... It didn't help with my problems, I still have replication-crashs almost every other hour. I put a fresh snapshot from the ma

Re: SELECT and UPDATE together, with LIMIT? (incremental external indexing)

[EMAIL PROTECTED] wrote: Your solution is as good as any I can think of. If your source tables are InnoDB you could wrap your SELECT/UPDATE processing in a transaction to help make it even more robust. It might speed things up if you omit the offset to your LIMIT clause and just do: Yes, they ar

RE: MySQL Error 1251 / phpMyAdmin

I don't know much about the windows side of things so these are the only resources I could find. >From the http://www.phpadmin.net site FAQ [1.17a] I cannot connect to the MySQL server. It always returns the error message, "Client does not support authentication protocol requested by server; cons

Stored procedure debugger

Anybody have any recommendations for a stored procedure editor/debugger? We are developing a test program with 5.x.x and procedures to see if it'll work for us stuck trying to get variables sorted out, and without a proper debugger it's extremely hard thanks in advance -- MySQL General Mailing

Re: SELECT and UPDATE together, with LIMIT? (incremental external indexing)

Nick Arnett <[EMAIL PROTECTED]> wrote on 02/07/2005 02:06:30 PM: > I'm considering the best strategy for updating large tables that I'm > indexing with Lucene. I'm > indexing in chunks of 5000 items at a time, which I select with > LIMIT statements and an incremental > multiplier (SELECT blah

Re: Cygwin Compiled Version of MySQL Client

[EMAIL PROTECTED] wrote: "A. Clausen" <[EMAIL PROTECTED]> wrote on 02/07/2005 01:35:31 PM: I'm having a problem with the default Win32 mysql client program running in the Cygwin environment, in that it writes CRLF pairs out, causing some Bash scripts that I'm running on both a Linux box and a Wi

Re: Cygwin Compiled Version of MySQL Client

"A. Clausen" <[EMAIL PROTECTED]> wrote on 02/07/2005 01:35:31 PM: > I'm having a problem with the default Win32 mysql client program running > in the Cygwin environment, in that it writes CRLF pairs out, causing > some Bash scripts that I'm running on both a Linux box and a Win2k box > to give

SELECT and UPDATE together, with LIMIT? (incremental external indexing)

I'm considering the best strategy for updating large tables that I'm indexing with Lucene. I'm indexing in chunks of 5000 items at a time, which I select with LIMIT statements and an incremental multiplier (SELECT blah FROM foo LIMIT 0, 5000; SELECT blah FROM foo LIMIT 5000, 5000; etc.). After

Re: MySQL Error 1251 / phpMyAdmin

The short answer is, download the php source and add --with-mysql=/your/path/to/mysql to your build options. The long answer is in the directions in the php manual . Michael GH wrote: I am still new to the PHP scene could you tell me how I "rebuil

Cygwin Compiled Version of MySQL Client

I'm having a problem with the default Win32 mysql client program running in the Cygwin environment, in that it writes CRLF pairs out, causing some Bash scripts that I'm running on both a Linux box and a Win2k box to give garbled results. I wondered if there's a Cygwin compiled version that out

InnoDB crash and runaway rollback - help pls

Hi, I'm looking for two things - help understanding why InnoDB crashed on our server this morning, and help speeding up recovery from that crash. We are running 4.0.21 binaries on Fedora Core 2 (Tettnang) Linux, 2.6.5-1.358smp. I'll explain what happened We spent the weekend importing all o

Re: MySQL Error 1251 / phpMyAdmin

I am still new to the PHP scene could you tell me how I "rebuild" the PHP with the client library... On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen <[EMAIL PROTECTED]> wrote: > > You have mysql 4.1.8, but your php was built with the library for an earlier > version, which, as the error mess

Re: How do I create a database?

To get into the command line of MySQL, use the mysql client (type "mysql" at the bash prompt). The super user is 'root' (not the same as the *nix root user). The default is no password. If you're using the Administrator or Query Browser from a remote host, you won't be able to use them until you

Re: MySQL Error 1251 / phpMyAdmin

You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current

Re: max key file length

Ingo Strüwing <[EMAIL PROTECTED]> wrote: Hi Sirisha, Am Donnerstag, den 27.01.2005, 08:41 + schrieb sirisha gnvg: > hai, > I tried the command "myisamchk -d -v ".It gives the output containing data > file length,key file length,max key file length of a myisam table.I supposed > to use the

Re: ft_stopword_file

> * Searching "New England" brings up all entries with "england", > regardless of new. > * Changing the stoplist to blank (and doing a "REPAIR TABLE") > generates the same results. > * Also changing it to a blank custom stopword list has the same results. > * Searching only on "New" finds no entry

ft_stopword_file

This is with regards to MySQL 4.1.9-standard-log installed via RPM's on Fedora Core 3. The documentation says that changing the ft_stopword_file to a blank variable or a custom file overrides the internal stopword list on fulltext searches. However, in my testing, this merely *adds to* the stopwo

MySQL Error 1251 / phpMyAdmin

I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary

Re: No more room in index file (136) - but index is not full?

Hello. I'm not sure, but this is really strange for me. I suggest you to reproduce the problem on the latest release (4.1.9 now). Use official binaries. Also, you may try mysqld-max. Work with backups of your table. Dump it and then import to the new instance of MySQL (4.1.9 or 4.1.9-max).

Re: How do I create a database?

Hello. See: http://dev.mysql.com/doc/mysql/en/create-database.html "Pakman" <[EMAIL PROTECTED]> wrote: > [-- multipart/alternative, encoding 7bit, 0 lines --] > >[-- text/plain, encoding quoted-printable, charset: iso-8859-1, 13 lines > --] > > I am a newbie at this, but

RE: How do I Put a 'Literal' Value in a Report Column?

see 12.2 Control Flow functions of MySQL manual select name, if(adopted=0,'N','Y') from animal; > -Original Message- > From: Sue Cram [mailto:[EMAIL PROTECTED] > Sent: Monday, February 07, 2005 2:58 AM > To: mysql@lists.mysql.com > Subject: How do I Put a 'Literal' Value in a Report Colu

Re: How do I Put a 'Literal' Value in a Report Column?

"Sue Cram" <[EMAIL PROTECTED]> wrote on 02/07/2005 02:57:59 AM: > This is a pretty basic question, but I'm learning SQL from a book > and it's very very frustrating! > > I'm writing a report listing animals from our shelter and whether > they have been adopted. I am selecting the animal name

Re: How do I Put a 'Literal' Value in a Report Column?

On Monday 07 February 2005 07:57, Sue Cram might have typed: > I'm writing a report listing animals from our shelter and whether they have > been adopted. I am selecting the animal name field and a field called > 'adopted' from a table called 'animal'. The values in 'adopted' are > either: 1 (m

How do I Put a 'Literal' Value in a Report Column?

This is a pretty basic question, but I'm learning SQL from a book and it's very very frustrating! I'm writing a report listing animals from our shelter and whether they have been adopted. I am selecting the animal name field and a field called 'adopted' from a table called 'animal'. The va

Slow query log?

I've added the following line to my.cnf in order to activate the logging of slow queries: [mysqld] log-long-format log_slow_queries=/var/log/slow-queries.log long_query_time=20 The mysql server version is 4.1.9, but all I see in slow-queries.log the following: # [EMAIL PROTECTED]: mmareuser[mma

Re: [PHP-DB] mysqli connection problem

Denis Gerasimov wrote: Hello, This question was asked many times, but I can't find a good answer. I am getting this error message while trying to connect to MySQL server (PHP + PEAR::DB_DataObject): "Can't connect to local MySQL server through socket '' (111)" (notice '' - is that right?) Does anyo

mysqli connection problem

Hello, This question was asked many times, but I can't find a good answer. I am getting this error message while trying to connect to MySQL server (PHP + PEAR::DB_DataObject): "Can't connect to local MySQL server through socket '' (111)" (notice '' - is that right?) Does anyone have any ideas

Re: No more room in index file (136) - but index is not full?

Does nobody have any ideas on this? It's quite perplexing. It's MySQL "Ver 14.6 Distrib 4.1.5-gamma", if it makes a difference. Jon Ribbens <[EMAIL PROTECTED]> wrote: > I am getting Error 136 "No more room in index file" on a table, > but the table does not appear to be full in any way. As you can

How do I create a database?

I am a newbie at this, but I have managed to install the MYSQL Essential, MYSQL Administrator and the MYSQL Query browser, but now I have come up with the problem when opening the Adminstrator, of connecting to "my stored connection" and "server host", I thought that there would be a way of

Re: REPLACE INTO //add or update?

It simple... if mysql_affected_rows == 2 ---> update (because replace make DELETE and INSERT) else if mysql_affected_rows == 1 > insert Gabriel PREDA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC

Re: REPLACE INTO //add or update?

On Mon, 7 Feb 2005, Bjorn van der Neut wrote: > Hello Everyone, > > Can someone tell me If you can find out if the replace into function has > done an insert or an update? It actually never does an update, it always INSERTs. It either does an insert or delete(s) followed by an insert. -- MySQ

Re: what happen if exceed max connection in innodb

Hi Chenri, > 1. is this value for one database or for overall mysql connections? The value is for overall mysql connections... so it's not for one database. > 2. i'm unable to generate 100 connections, i don't have 100 workstations yet, > how do i test it? Why would you ? > 3. what w

REPLACE INTO //add or update?

Hello Everyone, Can someone tell me If you can find out if the replace into function has done an insert or an update? Thanxx Bjorn TTV The Victory http://www.thevictory.nl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMA

Re: what happen if exceed max connection in innodb

Hello. > 1. is this value for one database or for overall mysql connections? This values is for overall mysql connections. > 2. i'm unable to generate 100 connections, i don't have 100 workstations yet, >how do i test it? You may write a perl script, for example. > 3. what will

Re: Hierarchial Data Structure

Hi! Am So, den 06.02.2005 schrieb Daniel Kasak um 23:55: > Auyon Bhattacharya wrote: > > >I am new to this. I have been trying to implement a hierarchial data > >structure in Mysql 5.0, on Windows NT with PHP. Can anyone tell me if > >I wish to retrieve an information such as the list of fore-fat

RE: Syntax diagram, where is it located in the doc?

> -Original Message- > From: Jeremy Cole [mailto:[EMAIL PROTECTED] > Sent: den 4 februari 2005 22:24 > To: Thomas Sundberg > Cc: mysql@lists.mysql.com > Subject: Re: Syntax diagram, where is it located in the doc? > > Hi Thomas, > > > I'm looking for the syntax diagram for MySQL and can'