Re: Heap table says its Fuul?

Hi, On Mar 24, 2005, at 6:07 PM, <[EMAIL PROTECTED]> wrote: Mysql is telling me my Heap table is full.  Now I set it to 128M.   my.cnf line tmp_table_size = 128M Try changing the setting called max_heap_table_size. tmp_table_size only has to do with internal temporary tables that are used to reso

Re: Fulltext In Boolean Wildcard Questions

From: "Freddie Bingham" <[EMAIL PROTECTED]> > > (1) Why is such a query as this allowed? > > > > WHERE MATCH (text) > > AGAINST ('+s*' IN BOOLEAN MODE) > > > > This returns everything that starts with an 's', as expected > > by the syntax. > > Why is it not stopped by the mysql minimum word length?

Re: Queries inside UDF

From: Philippe Poelvoorde <[EMAIL PROTECTED]> Reply-To: "'mysql@lists.mysql.com '" To: "'mysql@lists.mysql.com '" Subject: Re: Queries inside UDF Date: Mon, 21 Mar 2005 11:05:39 + sguazt sguazt wrote: Hi! From: Philippe Poelvoorde <[EMAIL PROTECTED]> Reply-To: "'mysql@lists.mysql.com '" To:

Re: Adding an index without rebuilding all others

Hello. ALTER TABLE works in the following way: Create a new table named A-xxx with the requested structural changes. Copy all rows from the original table to A-xxx. Rename the original table to B-xxx. Rename A-xxx to your original table name. Delete B-xxx. As ALTER table creates a new tab

Re: Too many connections

Hello. May be this would be helpful: http://dev.mysql.com/doc/mysql/en/user-resources.html Jan Pieter Kunst <[EMAIL PROTECTED]> wrote: > Hello all, > > Suppose I have a LAMP server which functions good enough for daily use > by humans, but is occasionally brought to its knees

"Repairing Data" packing with zeros

Hi, I needed to repair some data that had been entered inconsistently, I was in a rush so I did it manually via SqlYOG. (too much of a rush to consider how to do it quickly!) The bad data in one column propertyID was of kind \w\w\w\d eg ONE1 \w\w\w\d\d eg ABC23 \w\w\w\d\d\d eg FGH123 when the

About column privileges, COLUMN_INSERT...

I want to allow some users to SELECT, INSERT, UPDATE all columns in a table EXCEPT 1 (last one). Is it possile in MYSQL and how? So my question is : What COLUMN_INSERT privilege does? How can I INSERT_COLUMN without having to insert whole row? Does COLUMN_INSERT = TABLE_INSERT? I've found some

More on column privileges, COLUMN_UPDATE...

http://dev.mysql.com/doc/mysql/en/grant.html Sorry for previous post - my mistake: I added record as admin and continued using that user ;-) now logged as ordinary user another problem(s) arise: MySQL Server 4.0.24, trying varoius clients (dlls) 3.23, 4.0.x, 5.x? comes with MySQL Query Browser

RE: Heap table says its Full?

I took a guess at that yesterday. I left the tmp_table_size 128M added the line max_heap_table_size 500M But to no avale. Still limited in the number to 12.7M I am using 4.1.8 as installed by Cpanel. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunm

SET question - @ or @@?

While I was RTFM to find out how long SET variables last, I noticed that my book uses @@VarName but the sample code I'm using has @ VarName. I didn't see a reference to the single @ in the SET section of my book. So, what is the difference between @@ and @? Thank you.

Re: SET question - @ or @@?

At 10:23 -0600 3/25/05, Stembridge, Michael wrote: While I was RTFM to find out how long SET variables last, I noticed that my book uses @@VarName but the sample code I'm using has @ VarName. I didn't see a reference to the single @ in the SET section of my book. So, what is the difference bet

Re: SET question - @ or @@?

- Original Message - From: "Stembridge, Michael" <[EMAIL PROTECTED]> To: Sent: Friday, March 25, 2005 5:23 PM Subject: SET question - @ or @@? > While I was RTFM to find out how long SET variables last, I noticed that my > book uses @@VarName but the sample code I'm using has @ VarName

RE: Heap table says its Full?

Ok, Never mind my last statement because I didn't change anything and it worked this morning. Next problem I copied a 21MB db to the heap and it reported 248M of data once there? Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 --

Re: "Repairing Data" packing with zeros

zzapper wrote: ONE1-> ONE0001 ABC23 -> ABC0023 FGH123 -> FGH0123 What Update Query should/could I have used? Something like this perhaps? UPDATE table_name SET propertyID = CONCAT(LEFT(propertyID, 3), LPAD(SUBSTRING(propertyID, 4), 4, '0')) WHERE propertyID REGEXP '^[A-Z]{3}[0-9]{1,3}$'; -

Re: "Repairing Data" packing with zeros

On Fri, 25 Mar 2005 12:03:26 -0500, wrote: >zzapper wrote: > >> ONE1-> ONE0001 >> ABC23 -> ABC0023 >> FGH123 -> FGH0123 >> >> What Update Query should/could I have used? > >Something like this perhaps? > >UPDATE table_name SET propertyID = CONCAT(LEFT(propertyID, 3), >LPAD(SUBSTRING(prop

using between

Hello Is there a way when searching for a range of values for a particular field that mysql would not have to look at the entire table ... I'm guessing with some type of composite key or something? ... e.g. SELECT aField FROM aDatabase WHERE aVariable BETWEEN field1 AND field2; Field1 and field

Segmentation fault while executing Mysql application.

Hello sir, I have written an application by using MySQL API for retrieving result of simple query "select * from Table_Name" but there are some modification in compilation process for getting desire results. Modification or Alteration are: 1. I have Installed full packages of MySQL

Re: using between

At 01:48 PM 3/25/2005, you wrote: Hello Is there a way when searching for a range of values for a particular field that mysql would not have to look at the entire table ... I'm guessing with some type of composite key or something? ... e.g. SELECT aField FROM aDatabase WHERE aVariable BETWEEN field

Re: Heap table says its Full?

Hello. Setting this variable has no effect on any existing MEMORY table, unless the table is re-created with a statement such as CREATE TABLE or TRUNCATE TABLE, or altered with ALTER TABLE. [EMAIL PROTECTED] wrote: > I took a guess at that yesterday. > > I left the > tmp_table_s

Re: adding an incremented count from page hits

On Wednesday 23 March 2005 20:00, Chip Wiegand wrote: > count=count+1; <--- This is the added bit ---> > ?> > --- > The count doesn't increment in the database. The table has a column called > 'count'. > Two things: variables start with a

RE: using between

Well, we have this db with various ip address ranges and the country of origin associated with each ... the format is: countryOfOrigin FromIP ToIP --- -- US some lower boundsome upper bound Canada

re: using one query to save data in 4 tables

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am curious if this would be possible, and which version of mysql would be needed. Basically, I want to store a user in one table, then get the id for the user I just saved, and store three more rows, each in a different database, using the user's i

RE: using between

Have you considered just doing a parse on the the IP ranges and having 8 columns in your database, then write your query to work inside the 8 columns Cols = from_zone, from_net, from_subnet, from_node, to_zone, to_net, to_subnet, to_node Then just parse the ip you are looking up and write your q

MySQL C API problems

I'm having some difficulty with a program I wrote which uses the MySQL C api. I'm trying to migrate my server from version 4.0 to version 4.1. I have no difficulty connecting to the server using the mysql.exe command line utility, but when I try to connect from my program using the same paramete

Re: MySQL C API problems

Password hashing was changed in 4.1 to improve authentication security, but this complicates backward compatibility. See the manual for details: Your best bet is to link your app against

Fulltext boolean question

Hi, How can I limit the results of a fulltext search to the entries that only have the keywords I'm searching for? I'm searching the title field of a product database and I only want results if the title has all of the words specified. I tried putting the word AND between each word and mysql res

mysqlconnecernet not closing connections w/2003

We have a quote server on both a 2003 server and an XP machine. The quote server is an asp.net server. The XP machine is closing the connections without a problem. For some reason the mysqlconnecernet is not closing the connections when used on the 2003 server. It connection count climbs to

Re: Fulltext boolean question

Try using: "+dragon +ice +blue" I'm fairly sure that's in the FULLTEXT search portion of the online docs. Chris Ed Lazor wrote: Hi, How can I limit the results of a fulltext search to the entries that only have the keywords I'm searching for? I'm searching the title field of a product database and

Re: MySQL C API problems

On Fri, 25 Mar 2005, Michael Stassen wrote: > Password hashing was changed in 4.1 to improve authentication security, but > this complicates backward compatibility. See the manual for details: > >

RE: Fulltext boolean question

Oh hey, very cool - thanks. I was assuming that + and AND were the same thing, guess not =) -Ed -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Friday, March 25, 2005 4:21 PM To: mysql@lists.mysql.com Subject: Re: Fulltext boolean question Try using: "+dragon +ice +blu

Re: MySQL C API problems

On Fri, 25 Mar 2005, Andrew Prock wrote: > On Fri, 25 Mar 2005, Michael Stassen wrote: > > > Password hashing was changed in 4.1 to improve authentication security, but > > this complicates backward compatibility. See the manual for details: > >

2 MySQL Errors

I can't figure out why I get an error message relating to fiels "borderstates" and "bordernotes" when I try to create a new table. One is VARCHAR, the other TEXT, and both are NULL, like almost every field on the table. Can someone tell me what I'm doing wrong? Thanks. SQL-query: CREATE TABLE `

Re: 2 MySQL Errors

On Fri, Mar 25, 2005 at 07:27:47PM -0800, David Blomstrom wrote: > I can't figure out why I get an error message relating > to fiels "borderstates" and "bordernotes" when I try > to create a new table. One is VARCHAR, the other TEXT, > and both are NULL, like almost every field on the > table. > >

Recovering Lost Database

If you accidentally drop a database instead of a database TABLE in phpMyAdmin, is there any way to recover the lost database, or is it gone forever? Thanks. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://ma

Re: Recovering Lost Database

In the last episode (Mar 25), David Blomstrom said: > If you accidentally drop a database instead of a database TABLE in > phpMyAdmin, is there any way to recover the lost database, or is it > gone forever? Only if you have a backup... -- Dan Nelson [EMAIL PROTECTED] -- MySQL G

Re: Recovering Lost Database

--- Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Mar 25), David Blomstrom said: > > If you accidentally drop a database instead of a > database TABLE in > > phpMyAdmin, is there any way to recover the lost > database, or is it > > gone forever? > > Only if you have a backup... Th

MySQL Create Table Error

Can someone tell me what I'm doing wrong? When I first tried to create this table, I got an error message pointing out two fields that looked perfectly fine to me. I couldn't figure it out, so I just deleted the fields - but it then fingered two different fields. I deleted them, and now it says the

Re: MySQL Create Table Error

Please ignore this thread. I think my main problem is I need glasses! --- David Blomstrom <[EMAIL PROTECTED]> wrote: > Can someone tell me what I'm doing wrong? When I > first > tried to create this table, I got an error message > pointing out two fields that looked perfectly fine > to > me. I cou