Rating Thread / Thread Starter	Last Post	Replies	Views
weird results: (null!=null)?? I've got this select: select * from table1,table2 where table1.field1=table2.field1 and table1.field2=table2.field2 and it does not return any rows... alex	09-28-2006 03:33 AM Murdoc	6	69
Defect Transactions isolation level "carlo" <spammer.rea... (AT) googlemail (DOT) com> wrote: Thanks for your reply, but lets put your comment to the test.. ! ;-) 1. Transactions... carlo	09-27-2006 07:32 PM carlo	0	66
Defect Transactions isolation level "carlo" <spammer.rea... (AT) googlemail (DOT) com> wrote: Thanks for your reply, but lets put your comment to the test.. ! ;-) 1. Transactions... carlo	09-27-2006 07:30 PM carlo	0	63
Defect Transactions isolation level "carlo" <spammer.rea... (AT) googlemail (DOT) com> wrote: Thanks for your reply, but lets put your comment to the test.. ! ;-) 1. Transactions... carlo	09-27-2006 07:28 PM carlo	0	58
Defect Transactions isolation level "carlo" <spammer.rea... (AT) googlemail (DOT) com> wrote: Thanks for your reply, but lets put your comment to the test.. ! ;-) 1. Transactions... carlo	09-27-2006 07:26 PM carlo	0	74
how see connected user? Hallo, Some times my Db crash or say to many connections. I'd like to see who cause that. How can I see who is connected to mysql? Thank you in... _mario.lat	09-27-2006 06:44 PM Axel Schwenke	1	79
Inserting (almost) duplicate rows! Part II This is a follow-up to my previous thread (as Google Groups deosn't seem to be working properly) Sorry Jerry, I probably didn't explain myself... strawberry	09-27-2006 05:29 PM strawberry	0	78
Inserting (almost) duplicate rows! I'm thinking about creating a button in my (php built) contacts page called something like "New contact at same address". I can probably figure out... strawberry	09-27-2006 02:03 PM Jerry Stuckle	1	71
how can I count enum values You might want to add ORDER BY regdate at the end of that query Captain Paralytic	09-27-2006 08:22 AM Captain Paralytic	0	86
how can I count enum values Hows about SELECT date_format( regdate, '%M %Y' ) month, sum( state = 'good' ) good, sum( state = 'bad' ) bad, sum( state = 'very bad' )... Captain Paralytic	09-27-2006 08:04 AM Captain Paralytic	0	70
how can I count enum values I have a table like this: id car state regdate =========================== 1 toyota good 2006-04-01 2 toyota good 2006-04-05 3... rbaba99@caramail.com	09-27-2006 07:11 AM rbaba99@caramail.com	0	78
sort on column type enum Hi all I have a column of type enum('A', 'AP', 'CR', 'D', 'DL', 'H', 'HD', 'HH', 'R', 'S', 'PL'). i want to sort the result by 'DL', 'H','A',and the... vjyanand@gmail.com	09-27-2006 03:37 AM Kai Ruhnau	1	84
Multiple query variables based on str_word_count Greetings: I am attempting to split an input string using the str_word_count function to return multiple single word query variables. I can create... Jeff Gardner	09-27-2006 12:29 AM Jeff Gardner	2	59
MYSQL connection persistence through an execve() syscall Hi everybody, I migrate some C programs from a legacy isam to mysql. I can not change the program logic, because there are over than 300.000 lines of... cuffiette	09-26-2006 10:02 PM Jerry Stuckle	1	61
solution found to appearance of slash characters in sql string Thanks nicholas for your comments (and peters) but i found the solution. Staring me in the face for a week was a spelling error. And it's here above... digger440uk	09-26-2006 08:31 PM digger440uk	0	76
Does MySQL support a "true" boolean column? It doesn't (after setting sql_mode to strict_all_tables). However, it accepts the value 2. So you can use views (see... Lee Peedin	09-26-2006 04:24 PM Radoulov, Dimitre	2	103
Administrator Options Grayed Out Running MySQL administrator 1.2.3.rc on Windows Server 2003, connecting into version 5.0.24a of MySQL. All of the administrator options are not... mousemo@hotmail.com	09-26-2006 11:26 AM mousemo@hotmail.com	0	69
HELP: FUNCTION and PROCEDURE best practices.... No not really the same. If you have C# Function foo(int x, int y) you can call it as foo(var1,var2) With the .NET libraries for MySQL. If... daniel@mfaconsulting.com	09-26-2006 10:48 AM daniel@mfaconsulting.com	0	72
HELP: FUNCTION and PROCEDURE best practices.... Its not a question of marking them as IN or OUT or INOUT.... CREATE PROCEDURE `sp_test01`(IN _var1 INT, IN _var2 INT, OUT _Ret INT) BEGIN START... daniel@mfaconsulting.com	09-26-2006 08:54 AM Jerry Stuckle	1	81
for alexp SELECT name FROM `table` ORDER BY ABS( `age` -43 ) ASC LIMIT 1 Of course, this doesn't account for ties. To do that I guess you could have this... strawberry	09-26-2006 08:33 AM strawberry	0	199
good but.. Looks good but doesn't work :( I think it's because the nested select isn't returning the age. Any ideas? alexp	09-26-2006 07:46 AM alexp	0	158
HELP: FUNCTION and PROCEDURE best practices.... Hi All, Got a best practices question.... I often have to write PROCEDURES that return a value (because it needs to have a transaction in it)...and... daniel@mfaconsulting.com	09-26-2006 06:59 AM Jerry Stuckle	1	60
Postgresql Vs. Mysql -- Need advice Hi Database Gurus, Not to start a war among fanatics, but I just wanted to get honest opinion/advise of smart folks like you about this. We are...	09-26-2006 06:55 AM Jerry Stuckle	1	81
Controlling user access This one has me stumped: we have a fairly small database (it has only a single table) containing records entered over a couple of years. The records... Leslie Houk	09-26-2006 04:07 AM Duane Phillips	9	93
how to discard rows of a text file which does not satisfies foreign key constraint and continue with the rest Hi All, I am loading data to a child table from a text file. the text files also contains data not referenced by parent key. while loading the... Devi	09-26-2006 01:35 AM Devi	0	67
Deletes to replicated table not working Hi all, I have a MySQL server running 4.1.20 on Red Hat AS 4 that is replicated to 2 other RHEL AS 4 servers running the same MySQL version. Here is... Chris	09-25-2006 03:12 PM Chris	0	70
Need mysqldump help Hi All, Trying to use mysqldump and I just can't get anywhere. Not sure if this is part of the problem but, I am doing this on a local install... SergioQ	09-25-2006 02:06 PM SergioQ	0	81
Won't bring back Dates correctly.. My sql query will not seem to bring back dates in the correct order. It will brin them back in a semi-order. Here is the query and what it brings... aquanutz@gmail.com	09-25-2006 01:42 PM Axel Schwenke	2	85
Help writing a query Hi, I would be greatful if someone could help me in writing a query. I have a table as follows: NAME AGE Bob 44 Mary 59 James ... alexp	09-25-2006 01:15 PM PleegWat	1	79
Won't bring back Dates correctly.. My sql query will not seem to bring back dates in the correct order. It will brin them back in a semi-order. Here is the query and what it brings... aquanutz@gmail.com	09-25-2006 11:57 AM aquanutz@gmail.com	0	68
Help writing a query Hi, I would be greatful if someone could help me in writing a query. I have a table as follows: NAME AGE Bob 44 Mary 59 James 32 I... alexp	09-25-2006 11:12 AM alexp	0	80
Help writing a query Hi, I would be greatful if someone could help me in writing a query. I have a table as follows: NAME AGE Bob 44 Mary 59 James 32 I... alexp	09-25-2006 11:09 AM alexp	0	79
Accomplish 2 tasks in one pass On Mon, 25 Sep 2006 09:10:05 -0500, "Peter H. Coffin" <hellsop (AT) ninehells (DOT) com> wrote: Thanks Peter, An archive routine is exactly what... Lee Peedin	09-25-2006 10:49 AM Lee Peedin	1	117
mySQL C API vector binding support? Hello, I have a "slight" problem with the mySQL C API. I want to bind vectors for output/input prepared statements. However, the C API does... The\|Godfather	09-25-2006 04:22 AM Axel Schwenke	1	86
Easy Just type: ../mysql -h x.x.x.x -D dbtest -u root -p No need for SSH. Cheers, Dragomir Stanchev The\|Godfather	09-25-2006 03:35 AM The\|Godfather	0	222
please help - mysterious extra characters appearing in SQL update This is a real strange problem. I have some asp code (javascript) that sends a simple update sql command to mysql 5. my sql is this UPDATE Users SET... digger440uk	09-24-2006 10:01 PM Nicholas Sherlock	1	78
OPENSVN https://opensvn.csie.org/viewcvs.cgi/?root=TinyCollection Dikkie Dik	09-24-2006 05:07 PM Dikkie Dik	0	212
How can I make mysqld find the table 'mysql.host' on Fedora Core 4? I am having trouble using google groups. My apologies if this appears multiple times I'm trying to get mysql working on Fedora Core 4. Actually... tomzam	09-24-2006 12:25 PM tomzam	0	72
How can I make mysqld find the table 'mysql.host' on Fedora Core 4? Please forgive me if this message posts rwice to this group. (having trouble using google groups) I'm trying to get mysql working on Fedora Core 4.... tomzam@gmail.com	09-24-2006 11:51 AM tomzam@gmail.com	0	75
How can I make mysqld find the table 'mysql.host' on Fedora Core 4? I'm trying to get mysql working on Fedora Core 4. Actually trying to start the program mysqld without fatal errors. I posted this message first on... tomzam@gmail.com	09-24-2006 11:35 AM tomzam@gmail.com	0	87
Clear MySQL History - Remotely Peter H. Coffin wrote: I know it's not relevant to the OP's situation, I was just pointing out that such a situation is not necessarily "crazy" as... mdavila78	09-24-2006 03:15 AM Bill Karwin	5	88
Anonymous accounts on Windows. Where are they? First: I'm a newbie with MySQL. I downloaded the MYSQL Essentials, version 5.0.24a and installed on my Windows XP machine. I'm reading the manual at... Gustaf	09-23-2006 05:41 PM Gustaf	2	70
Re: -bin files in /var/lib/mysql-500 Alexander Skwar wrote: Yes, you can delete these, unless you need them for replication support or for data recovery. ... Bill Karwin	09-23-2006 05:24 PM Bill Karwin	0	100
strange myODBC / ADO / speed problem...help! Hello, I've been running a web site powered by mySQL 4.0 on a Windows 2003 Server, which is working rather well. The largest query took about 1... vanwout@gmail.com	09-23-2006 11:52 AM Thomas Bartkus	3	92
rand() Thanks for the ideas, I was thinking a solution might be to create a temporary table, copy in all the records, and pull the displayed... Gary	09-23-2006 11:50 AM Gary	2	229
Clear MySQL History Remotely Hi there, I was wondering if it's possible to Clear MySQL's History Remotely. Considering that you only have root access to the database but... mdavila78	09-23-2006 11:48 AM mdavila78	0	76
COUNT(*), datatype TEXT and temp disk tables Hi, I'm trying to tune this application where we're seeing something like 65% of temp tables wind up getting created on disk. We're using a lot of...	09-22-2006 11:46 AM toby	4	83
MySQL remote connection Hi everyone, I'm trying to setup a connection using MySQL query browser to a remote database. I have a user account setup on my linux server named... GeekyChicky79	09-22-2006 10:55 AM GeekyChicky79	0	82
Replace localhost Unix socket connection by Localhost TCP/IP connection Hi I would like to know how don't use unix socket when i set the hostname of the mysql database to localhost. It seems that when you set the hostname... Damien Desmarets	09-22-2006 10:32 AM Jerry Stuckle	4	94
Matching Skillsets I've got a database which defines job candidates and jobs. Each candidate has a set of skills each with a ability score and a experience score. Each... battle.chris@gmail.com	09-22-2006 06:44 AM strawberry	2	80

Page 111 of 128

111

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off