Re: weird difference in workbench and CLI query

Rik, Your Crystal Ball was right! How did I miss that? You get the brownie point for the day. Thanks! I knew it wasn't version discrepancy because workbench ssh's into the DB, and the script does as well, so it is running it on the native client in both cases. My sysadmin was saying it was ver

Re: weird difference in workbench and CLI query

> When I run this query in workbench: > select c.acc_number 'Accession Number', e.DateExam 'MBI Exam Date', > s.ExamDate 'SJH Exam Date' from chestcon_log c > left join exams e on CONCAT("000",c.acc_number) = e.LastWordAccNum > left join sjhreports_ s on c.acc_number = s.AccessionNumber > WHERE > c

Re: weird difference in workbench and CLI query

On 2/13/2012 10:18 AM, James W. McNeely wrote: When I run this query in workbench: select c.acc_number 'Accession Number', e.DateExam 'MBI Exam Date', s.ExamDate 'SJH Exam Date' from chestcon_log c left join exams e on CONCAT("000",c.acc_number) = e.LastWordAccNum left join sjhreports_ s on c.ac

Re: Weird UPDATE Problem

2011/10/10 09:19 -0400, Brandon Phelps If this column(s) is/are a character type now, then you would need to have the values in quotes. Note that because of implicit conversion if they had numberic values no error would be reported, but maybe the equality would not be exact.

Re: Weird UPDATE Problem

That query looks fine. What error are you getting if you execute the query from the CLI? Also is it possible that the s_id or owed columns are no longer numeric data types? If this column(s) is/are a character type now, then you would need to have the values in quotes. -Brandon On 10/10/20

Re: Weird SQL Results

mysql> select version(); +--+ | version()| +--+ | 5.1.30-community-log | +--+ 1 row in set (0.00 sec) mysql> select @@tx_isolation; +-+ | @@tx_isolation | +-+ | REPEATABLE-READ | +

Re: Weird SQL Results

Are you doing the insert and the select in different sessions, ie different connections to the server(different terminals)? This might simply be an intended symptom of isolation levels and InnoDB MVCC(multi versioning concurrency control). In addition, can you tell us what you get from: mysql>

Re: Weird SQL Results

I´d just like to know why do you wanna do a select in a record which was just inserted. Could you explain a little more? ""Tachu®"" escreveu na mensagem news:339ce61f-848a-4c83-b566-ef0e176e6...@gmail.com... > I'm having some weird issues that might be common but im not sure. I have > a ve

Re: Weird problem with mysql_query

I don't have that much experience with MySQL having mostly worked with MSSQL, but I'm sure the logic is still the same. I believe the query "select count(*) as 'count' from logins GROUP BY dawiz" will fail because "dawiz" is not a column, it's a value within the table. If I'm not mistaken, a

Re: Weird problem with mysql_query

Hi G, There is nothing weird about your results. When you do a Count(*) without a GROUP BY(someColumn) you are essentially asking MySQL how many rows are present in the table. But when you do use Group By someColum , you are asking MySql how many rows do I have of "someColumn" . It's just a go

Re: Weird result on max compared to order by

[EMAIL PROTECTED] schrieb: Hi, I did a select on a primary key.. Select max(account_id) from mytable; -- it gave me a value X I did a select with order by Select account_id from mytable order by account_id desc limit 3 -- it gave me a value of Y ( Y is the ri

Re: weird select - version 2

Hi dante, all, [EMAIL PROTECTED] wrote: [[...]] In a nutshell, i need a query intelligent enough to make a query to table_Out, see if theres a match for 'id_tA', if there is one, retrieve field "ref", otherwise go look in table_In and retrieve "ref" from there. Is it too complicated (impossib

Re: Weird behavior with date(null) and if

Baron Schwartz schrieb: > On Dec 13, 2007 4:18 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote: > >> Baron Schwartz wrote: >> >> Hi, >> >> On Dec 13, 2007 3:53 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote: >> >> >> Hi, i hit a weird behavior: >> >> select date(null); #result is null >> select if(dat

Re: Weird behavior with date(null) and if

On Dec 13, 2007 4:18 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote: > > Baron Schwartz wrote: > > Hi, > > On Dec 13, 2007 3:53 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote: > > > Hi, i hit a weird behavior: > > select date(null); #result is null > select if(date(null) is null, 1, 2); #result is 2 (no

Re: Weird behavior with date(null) and if

Baron Schwartz wrote: > Hi, > > On Dec 13, 2007 3:53 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote: > >> Hi, i hit a weird behavior: >> >> select date(null); #result is null >> select if(date(null) is null, 1, 2); #result is 2 (not null) >> select if(date(null) is not null, 1, 2); #result is 1 >> >> I

Re: Weird behavior with date(null) and if

Hi, On Dec 13, 2007 3:53 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote: > Hi, i hit a weird behavior: > > select date(null); #result is null > select if(date(null) is null, 1, 2); #result is 2 (not null) > select if(date(null) is not null, 1, 2); #result is 1 > > I use mysql version 5.0.32-Debian_7et

Re: Weird connection timed-out

Thanks Jerome. With the high number of "aborted_clients", it seems like you might have networking issues: http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html Dan

Re: Weird connection timed-out

On Tuesday 15 May 2007 02:56, Dan Buettner wrote: > Hi JM - > > Can you send us a few things? > > 1 - the exact error message you get the error code it produced is (110) which according to perror is connection time out.. > 2 - the output of "SHOW VARIABLES;" from a mysql session +---

Re: Weird connection timed-out

DB the server won't respond immediately causing the conenct to time-out.. Does your script start with an information_schema query? The frist one of those is painfully slow with MySQL. Did you try set_time_limit( 0 )? PB - JM wrote: after trying it again ang again.. maybe for the 5th t

Re: Weird connection timed-out

Hi JM - Can you send us a few things? 1 - the exact error message you get 2 - the output of "SHOW VARIABLES;" from a mysql session 3 - the output of "SHOW STATUS;" from a mysql session What have you tried so far in terms of troubleshooting that has been unsuccessful? Any recent changes on the

Re: Weird connection timed-out

after trying it again ang again.. maybe for the 5th time.. PHP will now be able to connect.. On Monday 14 May 2007 22:34, JM wrote: > Hi, > > Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to > the > DB the server won't respond immediately causing the conenct to time-o

RE: Weird error with stored function

Hi, It seems that the problem was the following: In mysql_stmt_execute() sp_cache_flush_obsolete() is called to flush the statement cache (or something similar). But the proper sp_cache_routines_and_add_tables() functions won't be called from open_tables(), because thd->lex->query_tables_own_las

Re: Weird SELECT bug in 5.0.21

On Thursday 31 August 2006 12:21, Renald Buter wrote: > The problem is that a simple 1-table query shows different answers > depending on whether you select 1 or 2 columns. Relational databases are founded on mathematical set theory. Unless you specify an ORDER BY stanza in your query, the data

Re: Weird SELECT bug in 5.0.21

On 11:34 Thu 31 Aug , Renato Golin wrote: > Renald Buter wrote: > >Odd, eh? But what's worse, the JOIN between this column and other > >columns *also* uses this truncated values and the result is bogus. > > I wouldn't say odd, as you didn't specified any order I wouldn't rely on > the order o

Re: Weird SELECT bug in 5.0.21

Renald Buter wrote: Odd, eh? But what's worse, the JOIN between this column and other columns *also* uses this truncated values and the result is bogus. I wouldn't say odd, as you didn't specified any order I wouldn't rely on the order of the output. Try ordering things for what you want and

Re: Weird error when creating a field

mes Sherwood" <[EMAIL PROTECTED]> Cc: "mysqllist" Sent: Monday, June 19, 2006 11:56 AM Subject: Re: Weird error when creating a field James, that is a "permission denied" OS error. When you run an alter table command (adding a field) MySQL builds a new table alongs

Re: Weird error when creating a field

James, that is a "permission denied" OS error. When you run an alter table command (adding a field) MySQL builds a new table alongside the old, then swaps them. Some file move/rename perations are associated with that. I would check that the mysql user on your system has full privileges on

Re: Weird error when creating a field

James Sherwood schrieb: Hello, Today we tried to create a new field on a table in one of our databases. When we tried to save the field we get the error: Error on rename of "./DBNAME/TABLENAME.MYI" to "./DBNAME/#SQL2-210-174.MYI" (Errorcode: 13) Has anyone ever seen this before? Thanks, Ja

Re: Weird M$ Pasting issue

Vinny <[EMAIL PROTECTED]> wrote on 03/29/2006 03:52:33 PM: > Hello All, > I am running across a very weird problem. > Sometimes when a person paste text from a Worddoc > into the text field of our webapp, the insert fails. Unfortunately > I am not seeing the failure in the logs. There are a lot of

RE: Weird M$ Pasting issue

If they are pasting from Word, there is a lot of Word-proprietary XML and formatting that is being pasted as well. Your insert statement may be failing because: 1) Because of the XML and formatting, the statement is going beyond the TEXT fields limit; 2) There are ' (single quotes)

Re: Weird MySQL Connection Issues

We are running mysql on a Debian system, so we shouldn't have any of those windows problems. It's really quite confusing, there were no mysql errors when we noticed the problem. The only guess we currently have is to wait until it happens again, and make sure we dump the stats to further investig

Re: Weird MySQL Connection Issues

If you are running MySQL on Windows, then I'm wondering whether you are having a problem with running out of available ports, for clients to connect to MySQL on. This may be your problem: >From the manual, 2.3.16. MySQL on Windows Compared to MySQL on Unix *** MySQL for Windows has proven it

Re: Weird behaviour of Load Data

- Original Message - From: "John Doe" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Sent: Sunday, January 15, 2006 6:15 PM Subject: Re: Weird behaviour of Load Data Rhino am Sonntag, 15. Januar 2006 23.53: I'm getting some odd behaviour

Re: weird innodb foreign key feature

I see, Thanks for information, yes correct this NO ACTION is confusing me. BTW, congratulation for your new email @oracle.com :D Heikki Tuuri wrote: Ady, NO ACTION actually means the same as RESTRICT. That is, the foreign key constraint is still enforced. The name 'NO ACTION' is from the SQL

Re: weird innodb foreign key feature

Ady, NO ACTION actually means the same as RESTRICT. That is, the foreign key constraint is still enforced. The name 'NO ACTION' is from the SQL standard. I agree that the name is confusing, but I cannot help it, because it is in the standard. Regards, Heikki Oracle/Innobase - Original

RE: Weird database files

> -Original Message- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 06:30 > To: mysql@lists.mysql.com > Subject: Re: Weird database files > > > Hello. > > > On the master we're still running 4.0.16, the s

Re: Weird database files

Hello. > On the master we're still running 4.0.16, the slaves are up to 4.1.13. If you can - upgrade the master server. Jeff McKeon wrote: >>Jeff wrote: >> >>>Had problem with our database this weekend, apparently an >> >>app did an >> >>>insert query that was huge size wise and t

Re: Weird database files

> Jeff wrote: > > Had problem with our database this weekend, apparently an > app did an > > insert query that was huge size wise and this totally boogered up > > replication downstream. Also I cant read past that point in the > > binlog using mysqlbinlog on the master server. It complains that:

RE: Weird database files

> Jeff wrote: > > Had problem with our database this weekend, apparently an > app did an > > insert query that was huge size wise and this totally boogered up > > replication downstream. Also I cant read past that point in the > > binlog using mysqlbinlog on the master server. It complains th

Re: Weird database files

Hello. Yes, these files are from some unterminated query. See: http://dev.mysql.com/doc/mysql/en/temporary-files.html You may want to use --start-position (--start-datetime) and --stop-position (--stop-datetime) to skip the problematic statement and perform necessary updates on the sla

Re: Weird delete behavior on mysql 4.0 - rows not disappearing....

Yah, I tested in SQL*Plus - one window could see inserts, updates and deletes that had been committed in another window (in which a commit or rollback had not been issued). I ran the test again - delete data from a table in one window and commit the change, and a select in the other window disp

Re: Weird delete behavior on mysql 4.0 - rows not disappearing....

If you are NOT in autocommit mode, your connection (or the server, it doesn't matter which) starts a transaction *when you issue your first command*. Every command you issue on that connection is in that initial transaction until you EXPLICITLY commit or rollback (or do something else that comm

Re: Weird delete behavior on mysql 4.0 - rows not disappearing....

I believe you - I'm just a but surprised. I guess I had a singular view of how a session should work based on Oracle. I would have expected that until you execute SQL that requires a commit or a rollback, you wouldn't be in a transaction. Unfortunately, if you have connections that are read and

Re: Weird delete behavior on mysql 4.0 - rows not disappearing....

David Griffiths wrote: "No, with the default transaction isolation level, REPEATABLE READ, that's how it is supposed to work. You've started a transaction in Window B, so Window B is immune to changes made in Window A until you finish the transaction in Window B. See the manual for details h

Re: Weird delete behavior on mysql 4.0 - rows not disappearing....

"No, with the default transaction isolation level, REPEATABLE READ, that's how it is supposed to work. You've started a transaction in Window B, so Window B is immune to changes made in Window A until you finish the transaction in Window B. See the manual for details http://dev.mysql.com/doc

Re: Weird delete behavior on mysql 4.0 - rows not disappearing....

On Wed, Aug 31, 2005 at 11:18:40PM -0400, Michael Stassen wrote: > No, with the default transaction isolation level, REPEATABLE READ, that's > how it is supposed to work. You've started a transaction in Window B, so > Window B is immune to changes made in Window A until you finish the > transac

Re: Weird delete behavior on mysql 4.0 - rows not disappearing....

David Griffiths wrote: I just discovered some weird behaviour with MySQL 4.0 (4.0.24 and 4.0.18) using InnoDB. If you have two connections to mysql (I use the mysql client), one of which has autocommit turned on, an the other turned off, a row deleted from the client with autocommit turned on

Re: weird characters from mysqldump?

Actually, it came from Mysql 4.1.1 (not 4.1.3 as I mentioned earlier). When I do select queries, the data displays just fine, but when I dump, I get this garbage. Jeremy Cole wrote: Hi Steve, I'm trying to export data from mysql 4.1.3 with mysqldump. I'm getting weird characters from the system.

Re: weird characters from mysqldump?

Hi Steve, I'm trying to export data from mysql 4.1.3 with mysqldump. I'm getting weird characters from the system. Here's what I've discovered so far: ' becomes ^À^Ù, e.g. didn't becomes didnâ^À^Ùt - becomes â^À^Ó, e.g. 1-2 becomes 1â^À^Ó2 è becomes è, e.g. Entrèe becomes Entrèe What gives? Looks

Re: weird characters from mysqldump?

In the last episode (Apr 12), Steve Lefevre said: > Hey folks -- > > I'm trying to export data from mysql 4.1.3 with mysqldump. > > I'm getting weird characters from the system. Here's what I've discovered > so far: > > ' becomes ^`A^`U, e.g. didn't becomes didnÃ^`A^`Ut > > - becomes Ã^`A^'O, e

Re: Weird Query Result

Yes, It's pretty obvious now. Thank you all for the help. Mattias Håkansson - Original Message - From: "Gabriel PREDA" <[EMAIL PROTECTED]> To: Sent: Tuesday, April 05, 2005 12:15 PM Subject: Re: Weird Query Result > Not weird at all... > As you can see

Re: Weird Query Result

Mattias Håkansson wrote: Hello, I'm using MySQL 4.0.20 on Linux and I am experiencing some problems with a query result. I have the following table structure: mysql> desc gen_Lloyds_vessel; +-+--+--+-+-++ | Field | Type

Re: Weird Query Result

Not weird at all... As you can see it returnet all rows where "iImo" equals 0... that is becuase of the CAST applied... iImo is int(11) thus MySQL is casting 'FOOBAR' and the result is 0. Try: mysql> SELECT CAST('FOOBAR' AS UNSIGNED); MySQL will yell: +--+ | C

Re: Weird "@" in column name

Hello. Do you use mysql client program from the old release? Use mysql --version to check the version. "Sehn, Timothy" <[EMAIL PROTECTED]> wrote: > I am running IntranetMySQL (ie. MySQL 4.1.9) and I am getting the = > strangest error: > > mysql> use devmail > Reading table informa

Re: Weird join needs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Je ÄaÅdo Januaro 27 2005 08:40, Jigal van Hemert skribis: > > Currently I have a query that is able to return (doing a left join): > > 'A', 'B', 'E' > > 'A', 'B', 'F' > > 'C', 'D', NULL > > But I need this: > > 'A', 'B', 'E,F' > > 'C', 'D', NULL > > Ca

Re: Weird join needs

> Currently I have a query that is able to return (doing a left join): > 'A', 'B', 'E' > 'A', 'B', 'F' > 'C', 'D', NULL > But I need this: > 'A', 'B', 'E,F' > 'C', 'D', NULL > Can SQL help me in any way here ? or do I have to do it by programming ? If you use MySQL 4.1 or later take a look at http

Re: weird syntax error

How about removing the comma before the close parenthesis at the end of the statement - or adding a Primary Key clause after the comma but before the close parenthesis? Rhino - Original Message - From: "B Wiley Snyder" <[EMAIL PROTECTED]> To: Sent: Friday, January 07, 2005 3:28 PM Subje

Re: Weird server timeout problem

On Thu, 2004-12-30 at 16:19 -0700, Sasha Pachev wrote: > Dale Blount wrote: > > Hello, > > > > I've been fighting this problem for a while, and now it's time to ask > > the experts. Please also CC me on this, I'm only on the list as a > > digest. > > Dale: > > Enable the log-long-format and log

Re: Weird server timeout problem

Dale Blount wrote: Hello, I've been fighting this problem for a while, and now it's time to ask the experts. Please also CC me on this, I'm only on the list as a digest. Dale: Enable the log-long-format and log-slow-queries on your server, and see if you have some hogs that lock your table for a

Re: Weird load issues

Daniel, - Original Message - From: "Daniel Andersen" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, December 21, 2004 1:04 AM Subject: Re: Weird load issues On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote: Daniel, it is simply processing bi

Re: Weird load issues

On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote: > Daniel, > > it is simply processing big SELECT queries. Maybe their optimization > changed lately? You should tune your queries. > > You should also tune InnoDB, because you are running with the default 8 MB > buffer pool size, and it is reading i

Re: Weird load issues

rows inserted 118044, updated 760157, deleted 167945, read 1657072353 0.50 inserts/s, 1.00 updates/s, 1.50 deletes/s, 525082.23 reads/s - Original Message - From: "Daniel Andersen" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, December 20, 2004 3:1

Re: Weird load issues

> please post the complete outputs of > > SHOW PROCESSLIST; > > and > > SHOW INNODB STATUS > > during such CPU peak. > > > Daniel > > 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 a

Re: Weird problem upgrading from MySQL 4.0.21 to MySQL 4.1.7/InnoDB mysql db (D'oh)

No InnoDB here, just some old ISAM tables. Sorry about my stupidity on this one, I have only myself to blame... I have a bunch of old-school ISAM tables that need to be converted to MyISAM, is there any way to do this en-masse? (I.E. not having to go through each DB in the DBMS and ALTER TABLE t

Re: Weird load issues

Daniel, - Original Message - From: "Daniel Andersen" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, December 17, 2004 2:04 AM Subject: Weird load issues Hey, A couple days ago my SQL server started hogging the entire CPU for no reason that I can find. I'm running

Re: Weird query behaviour

--- Roger Baklund <[EMAIL PROTECTED]> wrote: > The WHERE clause describes EACH of the rows you get > in the result. No > one row can have a value in the School column equal > to "Columbia" AND > "Stamford" at the same time. You should use OR > instead of AND. > Thank you Roger. That is one of

Re: Weird query behaviour

--- [EMAIL PROTECTED] wrote: > There is nothing weird about that behavior. You > asked for all of the rows > where the School column has both of two different > values at the same time. I thought joins were difficult to comprehend ;) > Try an OR instead or use the IN() operator. > > WHERE Sc

Re: Weird query behaviour

There is nothing weird about that behavior. You asked for all of the rows where the School column has both of two different values at the same time. >> WHERE School='Columbia' and School='Stamford' if School is 'Columbia' the first part is true but the second part can't be and vice versa. Your

Re: Weird query behaviour

Stuart Felenstein wrote: [...] But if in the where statment I add: where School = Columbia and School = Stamford Nothing is returned The WHERE clause describes EACH of the rows you get in the result. No one row can have a value in the School column equal to "Columbia" AND "Stamford" at the same

Re: weird kind of join

This is the first one I tried, it works great, thanks - Original Message - From: "Gordon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "'Diana Castillo'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, September 29, 20

RE: weird kind of join

; SELECT SUBSTRING_INDEX('www.mysql.com', '.', -2); -> 'mysql.com' This function is multi-byte safe. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 12:35 PM To: Diana Castillo Cc: [EMAIL PROTECTED

Re: weird kind of join

try this (not tested): FROM table_a INNER JOIN table_b ON table_b.code LIKE concat(table_a.code,';%') or this: FROM table_a INNER JOIN table_b ON table_b.code RLIKE concat('^',table_a.code,';') http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html http://dev.mysql.

Re: Weird behavior on varchar fields

Oropeza Querejeta, Alejandro wrote: Hi, I have one table that is presenting strange behaviour, we set the varchar field for not allow nulls so, on 5% of the records the application is inserting blanks but when we select the value and we set the condition ="" it returns the same as " " and "

Re: Weird problem for TIMESTAMP feild

According to the docs (http://dev.mysql.com/doc/mysql/en/DATETIME.html) The number "1258975462" equates to the date "1258-97-54 62:00:00" which is not a valid date. That's why you get the "zero date" value. That number could also equate to a unix_timestamp() value for the date "2009-11-23 06:24

RE: Weird problem for TIMESTAMP feild

Invalid entry format for the timestamp field. Did this work before? -Original Message- From: Tariq Murtaza To: [EMAIL PROTECTED] Sent: 7/26/04 4:43 AM Subject: Weird problem for TIMESTAMP feild Hi All, I am getting very weired problem after shifting our server. here is the details:- I

Re: Weird problem with displaying and retrieving varchar

Will Richardson wrote: Hello, I have a table with 3 columns: mysql> desc srv_ref_cities; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | state_id | char(2)

RE: Weird Error message

Sent: Thursday, April 01, 2004 1:16 PM To: Jason Chuong; [EMAIL PROTECTED] Subject: Re: Weird Error message It would really help if you could tell us at least which version of MySQL you are using. It might also help to know which OS you are using and what command you issued to get this error

Re: Weird Error message

It would really help if you could tell us at least which version of MySQL you are using. It might also help to know which OS you are using and what command you issued to get this error message. Rhino - Original Message - From: "Jason Chuong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Se

Re: weird behavior of mysql 4.0.16 for pc linux

Ginger Cheng <[EMAIL PROTECTED]> wrote: >I am just wondering if anyone has seen this before querying an innoDB table: > > select count(*) from Table where field1=3; > returned 782 rows > > select count(*) from Table where field1=3 and field2 is not null; > returned 666 rows > > Here come

Re: Weird behaviour

Excuse my blindness please! Thank you, Bostjan On Monday 01 of March 2004 16:19, Michael Stassen wrote: > This is documented behavior : > > Please note: the `_' and `%' wildcards are allowed when specifying > > database names in GRANT statements that grant

Re: Weird behaviour

This is documented behavior : Please note: the `_' and `%' wildcards are allowed when specifying database names in GRANT statements that grant privileges at the global or database levels. This means that if you wish to use for instance a `_' character as par

Re: Weird behaviour

Same for version 3.23.58. On Monday 01 of March 2004 13:47, Bostjan Skufca (at) domenca.com wrote: > Hello > > I am using MySQL 4.0.18 and i have come accross weird behaviour. > > I created the databas and user like this: > CREATE DATABASE dev_project; > GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DR

Re: Weird Sorting Question. REPOST (Modified by carreraSC)

carreraSC wrote: No one has any ideas? Hi, I've got a sorting question that I can't figure out. The page in question is here: http://toolstudios.com/intera/careers/index.php I'd like it to show up like this: Accounting job 1 job 2 Engineer job 1 job 2 IT job 1 job 2 B

Re: weird replication problem with master.info being created empty

e created but be empty, and when you try "slave start" it'll tell you: "ERROR 1201: Could not initialize master info structure, check permisions on master.info" Hope that helps someone down the line! Andrew > From: "Lightware Software" <[EMAIL PROTECTE

Re: weird replication problem with master.info being created empty

Maybe you should check if the ip address resolved for the master's url is correct ? Also try using CHANGE MASTER TO MASTER_HOST='', MASTER_USER='', MASTER_PASSWORD=''; and then START SLAVE; and see what happens. regards Jurgen > Tried that, but no luck, they get r

Re: weird replication problem with master.info being created empty

f the server changing, but that isn't the case here, the hostname is the same as always (should have added that in the first place). thanks, Andrew > From: "Lightware Software" <[EMAIL PROTECTED]> > Date: Thu, 29 Jan 2004 08:53:48 +0200 > To: [EMAIL PROTECTED] > Subje

Re: weird replication problem with master.info being created empty

You need to shutdown mysql, delete the master.info and relay-log.info files and then start mysql again. The reason for this is because if the info files are present then mysql uses them as is and only recreates them from my.ini or my.cnf if absent. This should get your replication going again. re

Re: Weird

Even though Napmarilu and localhost are resolving to the same machine, they are different host names. MySQL security uses a combination of username and hostname in the form of: [EMAIL PROTECTED] That means that [EMAIL PROTECTED] is a different user than [EMAIL PROTECTED] Since you have the Co

RE: Weird

Steve, This is on Server 2003 Enterprise Edition. TCP/IP is installed, so I have not a clue. I know it should be using the IP address of the machine or the Machine name instead. Well At least I need it to function that way eventually, cause this is for a client. Chris L. White Network Administ

Re: Weird

On 13 Jan 2004, at 19:49, Chris L. White wrote: Ok I was able to use mysqlcc and as long as I keep the host name localhost it will let me in. But the name of the host should be Napmarilu or the IP number right? When you change it to either one of those it will not let you in. So how would I

Re: Weird bug in MySQL?

Michael Bacarella <[EMAIL PROTECTED]> wrote: > We're running MySQL 3.23.56 w/ InnoDB on Red Hat Linux 8.0, > compiled natively with bundled gcc: > > # gcc -v > Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs > Configured with: ../configure --prefix=/usr --mandir=/usr/share/man > -

Re: weird transaction issues

On Fri, Sep 12, 2003 at 03:16:41PM +1000, Daniel Rossi wrote: > > hi there, i am trying to use transactions on some innodb tables although a few > things i am experiencing, on one query the value appears, i refresh the page and the > value dissapears again, i am using persistant connections in ph

Re: Weird Temp File Issue

"Feesch ListMaster" <[EMAIL PROTECTED]> wrote: > I'm not sure if this is a bug report, possibly a security issue. I have > started getting "Too many connections" error, but not at times when I would > expect the database to be busy. The worrying thing is that the temp drive > gets completely filled

RE: Weird Query results.

lto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 10:01 AM To: [EMAIL PROTECTED] Subject: Re: Weird Query results. "Jeff McKeon" <[EMAIL PROTECTED]> wrote: > Version 3.23.56, for pc-linux on i686 > > When I issue query as such... > > SELECT ID, Name, date, ti

Re: Weird Query results.

"Jeff McKeon" <[EMAIL PROTECTED]> wrote: > Version 3.23.56, for pc-linux on i686 > > When I issue query as such... > > SELECT ID, Name, date, time > FROM table > WHERE Name NOT LIKE "zz%"; > > I get a result that has as it's first record, a record where the Name > field data IS LIKE "zz%" but th

Re: Weird problem with differences MySQL 3.23.38 und 4.0.12

"Axel Tietje" <[EMAIL PROTECTED]> wrote: > Hi everyone... > > I actually have two servers: > > 1. Server: MySQL 4.0.12 > 2. Server: MySQL 3.23.38 > > This query: > > SELECT o_obj, > MAX(CASE WHEN o_key = '69B96431' THEN o_val END) AS _69B96431, > MAX(CASE WHEN o_key = '69B96431' TH

Re: Weird problem with differences MySQL 3.23.38 und 4.0.12

Some of the values passed to the CASE expressions are NULL. There was a bug in handling NULL in CASE that was fixed in MySQL 4.0.8: http://www.mysql.com/doc/en/News-4.0.8.html Note the last item on the page. I believe this explains the differences that you are seeing. At 16:28 +0200 6/12/03, Axel

Re: Weird Host Problem

Nick Stuart <[EMAIL PROTECTED]> wrote: > Ok, seem to have an odd problem here. Using MySQL 4.0.12-max-nt-log on > Windows 2000 server. When ever I issue a show process list all the host ids > are of the machine that I am connecting from. So if I do 'SHOW PROCESSLIST' > from ip ***.***.***.189 al

RE: Weird locking/blocking issues

> > I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with > linuxthreads > > (2.2.3) and still encounter the 'strange threading' > behavior described in J. > > Zawodny's blog. > > > > Here's the situation... > > > > 1/ there are three threads which lock and then write to two > different > >

Re: Weird locking/blocking issues

On Tue, Jan 28, 2003 at 01:20:16PM -0500, Grigor, Peter wrote: > Heya Folkth: > > I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads > (2.2.3) and still encounter the 'strange threading' behavior described in J. > Zawodny's blog. > > Here's the situation... > > 1/ there are th

  1   2   >