RE: How to delete records after particular position ?

I believe the syntax is Delete from MyTable Where MyCriteria LIMIT HowMany. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -Original Message- From: Manisha Sathe [mailto:[EMAIL PROTECTED] Sent:

Concat fields

Good morning to all. How can I combine the elements from many text fields into one text field. I have a table. ID(auto inc) eventID data ID is unique eventID is repeated data represents what happened at this event. I would like to return all of the data for a given event ID, sorted

RE Concat fields

Thank you for your response, Egor. My question is whether or not it is possible to concatenate the fields without knowing the event ID. pseudo SQL Select concat(data from all grouped fields) from foo group by (eventID); God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web

RE: Concat fields

If I am not running 4, is there another way to achieve the same result as GROUP_CONCAT(myField) ? God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. Microneil research Sortmonster Anti Spam GOD BLESS AMERICA! To God Be The Glory! -- MySQL

Multiple Connections

Good morning to all. I am using the mySQL connector to connect to the mySQL database. My question concerns the session between the DB and the client. How is the session maintained? In other words, how does the DB know that it is communicating with my specific connection? Here is why I ask.

RE: Multiple Connections

So this means that my DB driver is somehow using the same connection when I ask it to create 2 different ones? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 12:13 PM To: [EMAIL PROTECTED] Subject: Re: Multiple Connections Paul McNeil

Unique Key question

Good morning. I have a table with field name DATA type tinytext. The table is already populated. I need DATA to be unique. It seems that MySQL doesn't look at the uniqueness of a field in a binary fashion. Example (chosen because I think it is just plain odd) june = Júne If I query as -

Unique Key

Thanks to all for helping me sort this out. I am setting the field to tinyblob vs tinytext. Thanks again. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. Microneil research Sniffer Anti Spam Sortmonster Research GOD BLESS AMERICA! To God Be The

Very strange database behavior

Good morning to all. I have a very strange problem in my database and am trying to track down whether it is a JAVA problem or a mySQL problem. I have a table that is supposed to accept only unique data, however, at this time, the PK for that information is set to the auto incrementing ID field.

RE: Very strange database behavior

? God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 11:49 AM To: 'Paul McNeil '; 'MySQL General

RE-strange DB behavior

Thanks to all who posted help. I found my error, in my code. Sad sad pumpkin. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -- MySQL General Mailing List For list archives:

Create Temporary Table, incorrect rows

Good day to all. I have a table and want to find duplicate info in the table. I know duplicated info exists by running the following... Select count(*) from myTable - 141123 Select distinct(myData) from myTable - 1411000 So I created a temporary table to store distinct records and want to do a

Temporary Table update

I added a LIMIT clause to my create table command and now all data is present. Is the 1000 row limit a standard that must always be overridden? God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -- MySQL

RE: Create Temporary Table, incorrect rows

, 2004 11:11 AM To: Paul McNeil; MySQL General Subject: Re: Create Temporary Table, incorrect rows A more direct way to find dupes ... SELECT id, COUNT( id ) AS cnt, FROM myTable GROUP BY id HAVING cnt 1 PB - Original Message - From: Paul McNeil To: MySQL

RE: Create Temporary Table, incorrect rows

11:05 AM To: [EMAIL PROTECTED] Subject: Re: Create Temporary Table, incorrect rows On Tuesday 06 July 2004 15:30, Paul McNeil might have typed: When I run this it says that the temp table has only 1000 rows. Why? Are you using mysqlcc? -- MySQL General Mailing List For list archives: http

RE: connectorJ huge table problem

Dude. I wouldn't post your server ip here. ouch. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -Original Message- From: Leonardo Francalanci [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004

RE: Full text search problem

Good morning. Not knowing too much about PHP it looks like you are searching for `name`,`colour`,`gender`,`breed`,`location`,`description` Where there is a whitespace in the name. Could you use, $query_results = sprintf(SELECT * FROM dogslost WHERE `name` LIKE '% %', $crit_results); God Bless

RE: Group Query

You can use a Left Outer Join. Left Outer Join will include all that matches as well as that which doesn't. The resulting NULL entries for the count will evaluate to 0. SELECT COUNT(B.Booking_ID), U.User_Location FROM Users U LEFT OUTER JOIN Bookings B ON U.User_ID = B.User_ID GROUP

RE: MySQL SQL Case Stetement

I have used the CASE statement for ordering many times. It's very useful... SELECT myDATA, CASE WHEN data2 = SomeValue THEN 0 ELSE WHEN data2 = SomeOtherValue THEN 1 ELSE 2 END AS mySort from MyTable Where myConstraints. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web

RE: DBI and last_insert_id()

You wrote $pk = $dbh-last_insert_id(); I believe you can get the created ID with the query, Select @@IDENTITY; This returns the last created ID from the connector object. Peace -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: DBI and last_insert_id()

last_insert_id() should work. You are updating using @bind_values. What is the text of that? Does it indeed create a record? God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -Original Message-

Multiple Queries

RE - I have a situation where, within a PHP loop, I am creating over one hundred SQL statement (INSERTS and UPDATES). Would it cut any overhead to send 20 ; seperated queries in one mysql_query() statement, and therefore only execute mysql_query() 5 times for 100 statements, as opposed to sending

Oops

In my last post I noted that I am using Opta driver. Wrong. That was my Ms SQL driver. I am using mysql-connector-java-2.0.14-bin Sorry for confusion. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory!

Last Modified

If your table contains a timestamp field, it will update each time the row is altered. Otherwise I don't think it's possible. You Wrote - Hello I am using PHP, MySQL. How would I query MySQL to display the last time a table was last modified/changed/or updated. For example I have a user

Last Modified

---I see the type timestamp. Should I leave value, attributes...blank. Do I just query this field and format as need via DATE()? --- Yes. This field is a date actually. It will update each time the record is modified or when a record is created. You can query it as a normal datetime field.

Update problem

You have to use UPDATE MyTABLE set MyTABLE.1 = myValue. Otherwise you are saying that the numeric value 1 = some other numeric value. God Bless GOD BLESS AMERICA! To God Be The Glory! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE - Order By Problem

I have never done anything like this but after looking at the spec's I have a possible direction for you In String functions there is LOCATE(substr,str,pos) The first syntax returns the position of the first occurrence of substring substr in string str. The second syntax returns the position

Order Problem

Andy Eastham put me on the right track for this solution. I just ran the following and it works so please give him the credit. I tested with 'van der Plas' and 'McNeil' SET @tmp = 'van der Plas'; SELECT @tmp, Reverse( SUBSTRING_INDEX(Reverse(@tmp),' ',1) ) as myOrder FROM MyTable;

Re Select problem

Are you spitting out an output of the query string to verify that the data from the form is making it to the query correctly? GOD BLESS AMERICA! To God Be The Glory! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Select double value

Good morning to all. I have a problem with a workaround but I wanted to know if others have run into this. Table DATA Column strength [double] When I select strength from DATA and the result is a non zero amount it returns correctly 3.256498 however if it is a 0 amount I get 0. The