Re: -help

It would be easier to answer a specific question -- Rhino - Original Message - From: "Terry Spencer" <[EMAIL PROTECTED]> To: Sent: Sunday, March 05, 2006 6:41 PM Subject: -help Terry Spencer Haigh Consultancy Services Tel: +44 (0)116 262 3966 Fax: +44 (0)116 262 3946 (L

-help

Terry Spencer Haigh Consultancy Services Tel: +44 (0)116 262 3966 Fax: +44 (0)116 262 3946 (Leciester Office) Fax: +44 (0)870 052 4572 (Terry) Mob: +44 (0)7796108244 www.haigh-cs.co.uk

Re: Help on sql statement (not MySQL specifik)

I'm glad to hear that your data isn't corrupt! That would have complicated your life a bit, at least in the short term The additional information you have supplied helps me understand a bit better but I still don't really understand enough. I'll try to ask some specific questions that will

Re: Help on sql statement (not MySQL specifik)

Hi Thank You for all Your efforts I'll try once again to clarify my problem My tabel (t_temp) isn't corrupt but is the result form a join from two other tables 1) t_base, with id's and basic info of patients. 2) t_events. with id (of the patient in question) and the type of the event. As a pat

Re: 1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool!

Charles Walmsley wrote: I don't think [EMAIL PROTECTED] should be used for sales. Is there a policy about this? My impression was that most people feel that the small number of product advertisements that are directly related to MySQL are OK. That's only an impression, but that's how I feel

Re: Boolean searches on InnoDB tables?

Daevid, - Original Message - From: ""Daevid Vincent"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, March 04, 2006 9:54 AM Subject: Boolean searches on InnoDB tables? I just discovered this: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html Which

Importing CSV file into MySQL DB - Newbie Question

I have a CSV file that I want to import into a MySQL DB table. The file contains 15 fields. The able to import into will contain those same 15 fields, plus an auto-generated Primary Key fields. Since this is the first time I'm working with mysqlimport, I created a small test table to start wi

viewing number of current connections

is there a way to view the current number of connections in mysql? I'm developing a PHP / MySQL app and would like to be able to debug a few performance problems. Ideally, I'd like to be able to query the number of current connections via the mysqli interface and make decisions based upon t

Problem mysql 4.1 to mysql5 -

I have two FC4 computers I believe to be set up identically, I installed mysql5 in both, the first one made the change without a hitch but the second refuses to install with the error message: "./bin/mysqld: error while loading shared libraries: libstdc++.so.5: cannot open shared object fil

data backup

hi all... what's the best way to periodically back up mysql data? so that databases and tables can be still usable even after a mysql upgrade? thanks... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help on sql statement (not MySQL specifik)

You're absolutely right that I'd need some good luck for this query to work for every possible data value that the table could continue. I realized the combination of 'group by id' and 'select id, type' was not very good SQL - 'select id, ' would be a much more standard construction to go with

Re: Help on sql statement (not MySQL specifik)

Rhino wrote: I don't really understand _why_ you want to do this but here is a query that gives the result you want: select id, case type when 4 then 4 else null end as type from Soren01 group by id; The GROUP BY ensures that you get one row for each value of id; the case expression in the Se

Re: Help on sql statement (not MySQL specifik)

I agree with Michael. If your data is actually messed up, the right solution is to fix the data and prevent it from getting messed up again FIRST. Writing SQL that compensates for the messed up data is often possible but doesn't fix the problem; you'll still need to fix the data and the sooner

Re: Help on sql statement (not MySQL specifik)

I don't really understand _why_ you want to do this but here is a query that gives the result you want: select id, case type when 4 then 4 else null end as type from Soren01 group by id; The GROUP BY ensures that you get one row for each value of id; the case expression in the Select says that

Re: Help on sql statement (not MySQL specifik)

Søren Merser wrote: Hi, I'll try I need one record for each id in the tabel, i.e. NO duplicate id's with TYPE set to 4 or NULL Now, the TYPE of id 2 is 4 so I peserve it; As id 2 has more than one entry I have to delete it/them Id's with TYPE = NULL (id 1,4,5)is kept Id 5 (and 6) has two rec

Re: Logging (wrong) passwords by mysqld

> is there a reason that the unknown passwords can't simply be reset? yes, because not all clients are currently known and resetting them would possibly break the application(s) -- Manuel Schmitt - Geschäftsführer - manit

Re: Logging (wrong) passwords by mysqld

> having an application log actual passwords (whether the login was > successful or not) is a major security risk, hence no self-respecting, > security-conscious application will do this. all that should be logged > is the username attempted, along with a login success/failure > indication, never t

Can I use mySQL Administrator on server version 3.23.58

I am running mySQL database version 3.23.58, but I'm using mySQL Administrator 1.1.9 for scheduled backups. When connecting to the database I get a message saying that this version of database is not supported and I might get unexpected behaviour. Am I OK to use this version of mySQL Administr

Logging (wrong) passwords by mysqld

Hi, I'am searching for a way to have mysqld log all passwords which clients are using ("trying") while connecting. As to the documentation and to my trials neither the error log nor the general query log contain passwords, only the usernames. I already tried to get them via ethereal, but this sh

Re: Help on sql statement (not MySQL specifik)

Hi, I'll try I need one record for each id in the tabel, i.e. NO duplicate id's with TYPE set to 4 or NULL Now, the TYPE of id 2 is 4 so I peserve it; As id 2 has more than one entry I have to delete it/them Id's with TYPE = NULL (id 1,4,5)is kept Id 5 (and 6) has two records, none of which h

Re: Help on sql statement (not MySQL specifik)

I think he wants to update rows where != 4 to null that is, update TYPE setting TYPE to null where TYPE != 4 -Ron Rhino wrote: - Original Message - From: "Søren Merser" <[EMAIL PROTECTED]> To: Sent: Sunday, March 05, 2006 9:12 AM Subject: Help on sql statement (not MySQL specifik)

Re: Help on sql statement (not MySQL specifik)

- Original Message - From: "Søren Merser" <[EMAIL PROTECTED]> To: Sent: Sunday, March 05, 2006 9:12 AM Subject: Help on sql statement (not MySQL specifik) Hi Could someone please help me out here? TABLE: RECNO| ID |TYPE - 1

is this safe against sql-injection?

Can somebody give me some general hints how to prevent sql-injection? I always go this way to build my queries: function clean_mysql_string($string) { $clean_string = stripslashes($string); $clean_string = htmlentities(strip_tags(($clean_string)));

Help on sql statement (not MySQL specifik)

Hi Could someone please help me out here? TABLE: RECNO| ID |TYPE - 1| 1|NULL 2| 2|4<-KEEP AS IS 3| 2|6<- DROP 4| 3