Re: vi.recover in show databases output?

In the last episode (Jan 15), Justin Lundy said: > When I open over nine connections to mysql I see vi.recover in my show > databases output. The existing connections stay open and continue to > operate. No new database connections can be made at this point. I should > be seeing the mysql, phpd

vi.recover in show databases output?

When I open over nine connections to mysql I see vi.recover in my show databases output. The existing connections stay open and continue to operate. No new database connections can be made at this point. I should be seeing the mysql, phpdig and test databases when performing the query but I on

repost w/code : can mysql work in Windows but not Solaris?

Is there any reason you can see why the fulltext php/mysql code below works OK on my win2k php4.3.6. mysql 4.1.3 pc but does *not* work when put on a Solaris Server with php5 mysql 4.1.6 ? That is what happens...I'm suspicious of the accent characters in the code but I am not sure if there's any

Replication between different versions

Hello everybody, I want to setup replication between Mysql 4.0.15 in SuSE as master and 4.1.8a-1 of Debian as slave. According to their reference manual it should work so far, but are there any compatibility issues to be expected? Besides, is 4.1.8a-1 from Debian identical to 4.1.8 directly from

RE: Plus sign doesn't concatenate strings in MySQL?

At 20:32 -0500 1/15/05, Dave Merrill wrote: Let me ask a slightly different question: Is there a string concatenation operator in mysql when it's *not* running in ansi mode? Or is the only way to accomplish that to use CONCAT? I think I'm hearing that there is no operator, only CONCAT. Right? Right

InnoDB race condition inserting into a table with a unique constraint

MySQL 4.1.8 I have an InnoDB table with a unique constraint: CREATE TABLE TEST ( ID bigint NOT NULL auto_increment, NAME varchar(100) NOT NULL, VALUE varchar(100), PRIMARY KEY (ID), UNIQUE KEY IX_NAME (NAME)) ENGINE=InnoDB Given a particular unique name, I need to either find the existing

RE: Plus sign doesn't concatenate strings in MySQL?

Let me ask a slightly different question: Is there a string concatenation operator in mysql when it's *not* running in ansi mode? Or is the only way to accomplish that to use CONCAT? I think I'm hearing that there is no operator, only CONCAT. Right? Dave Merrill -- MySQL General Mailing List

RE: MySQL 4.1.8 and storing east characters

I just noticed that in the link I sent you Japanese utf8 characters are indeed only 3 bytes long. So much for that idea. > I am inserting data into mySQL via this script: > http://www.feedsfarm.com/tmp.phps > > I've set default-character-set=utf8 > > When I output the data to the browser (see

RE: MySQL 4.1.8 and storing east characters

So its just the Japanese titles which aren't working? The Greek and Cyrillic looked ok to me. If that's the case then the causes which occur to me would be: 1. The web browser doesn't have a Japanese font (I don't know if I have one or not so I can't check that) 2. Japanese characters are lon

Re: MySQL 4.1.8 and storing east characters

How are you inserting the data into mysql? LOAD DATA INFILE? Be sure the client you are using to import the data is using the utf8 character set: SET CHARACTER SET utf8 or --default-character-set=utf8 The best way to check whether the data was inserted into mysql correctly is to use the mysql

RE: Plus sign doesn't concatenate strings in MySQL?

Um, I know that probably seemed a bit random, but I got a msg from someone saying that was how it worked; it certainly wasn't something I thought, hence the '???'. Your reply leads me to believe that was a private email not sent to the list. Dave Merrill > >??? > > > >SELECT 'asdf' . 'qwer' > > >

Re: Plus sign doesn't concatenate strings in MySQL?

Starting with 4.0, MySQL can be made to respect the standard of || as the concatenation operator with the PIPES_AS_CONCAT sql-mode. You may want to read section 1.5, "MySQL Standards Compliance", in the manual . There are some options to m

RE: Plus sign doesn't concatenate strings in MySQL?

At 8:51 -0500 1/15/05, Dave Merrill wrote: ??? SELECT 'asdf' . 'qwer' ...gives "Error Code : 1064, You have an error in your SQL syntax..." I also can't find any reference to this use of periods in the docs. Mostly we document how MySQL works, not all the things that you could possibly try that won

Re: Plus sign doesn't concatenate strings in MySQL?

At 18:04 +0100 2005/01/15, Jochem van Dieten wrote: On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote: Each language is going to have its own personality. If they all did things the same way, we wouldn't have the wealth of different ones to choose from. DBMS's are not languages, they a

mysql 4.1.x and openbsd: client library problem

hello guys, after compiling and installing mysql 4.1.9 from sources, the database server seems to work fine, but everything from client/ seems to somehow "hardcode" the client library path into the binary. when e.g. trying to start "mysqladmin" it goes: # mysqladmin

Re: Plus sign doesn't concatenate strings in MySQL?

On Sat, 15 Jan 2005 11:37:02 -0500, Dave Merrill wrote: > > This is my first foray into different flavors of sql, and I'm discovering > how incompatible they really are. I expected that core basics would be the > same, with each manufacturer adding some proprietary extensions, and failing > to sup

Re: Plus sign doesn't concatenate strings in MySQL?

Jochem van Dieten wrote: On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote: Each language is going to have its own personality. If they all did things the same way, we wouldn't have the wealth of different ones to choose from. DBMS's are not languages, they are implementations. Might no

Re: Plus sign doesn't concatenate strings in MySQL?

On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote: > > Each language is going to have its own personality. If they all did > things the same way, we wouldn't have the wealth of different ones to > choose from. DBMS's are not languages, they are implementations. > Might not be a good i

RE: Plus sign doesn't concatenate strings in MySQL?

As I said in my msg, I found out that I was wrong, '+' isn't ANSI, it's just microsoft. But mysql doesn't support the ANSI standard '||' either. Go figure... This is my first foray into different flavors of sql, and I'm discovering how incompatible they really are. I expected that core basics wou

Re: Plus sign doesn't concatenate strings in MySQL?

At 07:37 -0500 2005/01/15, Dave Merrill wrote: I thought string concatenation w '+' was totally standard SQL. Hmmm, this is the first I've heard of "+" being used for concatenation (in SQL). Then again, I've never used MS SQL Server. :-) Each language is going to have its own personality. If th

MySQL 4.1.8 and storing east characters

Hi, Iâve recently upgraded to MySQL 4.1.8 for the UTF-8 support. Iâve updated my previous data which was Western European languages, now Iâd like to get to grips on more exotic dialects such as Korean, Japanese and deep East languages such as Greek and Romanian. The problem is I keep

Re: Insert if Update failed without Select

Please also note hat UPDATE returns the number of records updated. If your UPDATE returns 0, you know that the record does not exist, and you might want to INSERT instead. At 2005-01-15 14:54, you wrote: At 2005-01-15 14:48, you wrote: Without using Select statement, how can I execute Insert SQL

Re: Insert if Update failed without Select

At 2005-01-15 14:48, you wrote: Without using Select statement, how can I execute Insert SQL statement if Update action is failed? I may be asking for too much. If Select statemnet have to be used to determine the existence of a recordset, what is an efficient way to execute Insert if Update is

RE: Plus sign doesn't concatenate strings in MySQL?

??? SELECT 'asdf' . 'qwer' ...gives "Error Code : 1064, You have an error in your SQL syntax..." I also can't find any reference to this use of periods in the docs. Have you tried it? Can you point me to something that says it ought to work? BTW, I'm trying this w mysql 4.1.7-nt-max on win2k, i

Insert if Update failed without Select

Hi, Without using Select statement, how can I execute Insert SQL statement if Update action is failed? I may be asking for too much. If Select statemnet have to be used to determine the existence of a recordset, what is an efficient way to execute Insert if Update is failed? I m using MySQL 5.0

RE: Strip off leading and trailing spaces once in db?

UPDATE my_table SET my_column = TRIM(my_column), my_other_column = TRIM(my_other_column) etc... Dave Merrill > Is it possible to remove all trailing and leading spaces for selected > fields once the data has already been loaded? > > Steve -- MySQL General Mailing List For list archives: h

Plus sign doesn't concatenate strings in MySQL?

I'm just starting to look at MySQL, been working w SQL Server. I just noticed that in MySQL, you can't concatenate strings with '+', like you can in SQL Server. In other words, in SQL Server SELECT 'asdf' + 'qwer' gives 'asdfqwer', but in MySQL, it gives 0. For MySQL, you seem to have to u

Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections

Jose, you must commit also the read transaction. http://dev.mysql.com/doc/mysql/en/InnoDB_consistent_read.html Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http: