Re: Problem deleteing records

will love you for this :) Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General

Re: Advise on High Availability configuration

you know that the database is in a good state, even if the filesystem itself is consistent? I don't think MyISAM gives you any guarantees in that regard. The secondary would need to run myisamcheck on the tables before taking over. Regards, Fred. -- Fred van Engen XB

Re: The biggest actual value in a Key-Field

. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List

Re: Paging!

even more ;) Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List

Re: Stumped on a query

m combinations, with n and m the number of records in table1 and table2. You really want to do this for small tables only. Consider an additional table to hold each of your 1, 3, 4, 6, ... values together with the unique id of a record in table1. Regards, Fred. -- Fred van Engen

Re: query syntax help

` A bit before that. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL

Re: Automatic conversion from `char` TO `varchar`

. Your records don't have a fixed size because of a text column. I believe this triggers MySQL to use a variable size for each column, converting char to varchar. Functionally, it shouldn't make a difference I guess? Regards, Fred. -- Fred van Engen XB Networks B.V

Re: Replication syncronization lag.

selects on the slave when an update is waiting for the long query to end. Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424

Re: How to use API to write blobs

#mysql_real_escape_string Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List

Re: How to use API to write blobs

)); } Well, whatever the reason, I guess this is what API guys are expected to use. I'll try that and see how it goes. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400

Re: How to use API to write blobs

, but there is a single line-break in the example, just after abc. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424

Re: Replication : blocking updates to slave

their account different GRANTs on the master than on the slave(s) and make sure that GRANTs (the `mysql` database) are not replicated from the master to the slaves. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2

Re: Replication : blocking updates to slave

want to be different between slaves and master. Is there another way? Not that I know of. I just looked at the startup options but couldn't find anything for this purpose. Regards, Fred. - Original Message - From: Fred van Engen [EMAIL PROTECTED] To: Eduardo D Piovesam [EMAIL

Re: Strange issue with UPDATE.

is updated automatically. Use DATETIME instead of TIMESTAMP if you don't want this to happen. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31

Re: Urgent Pl: problem with rename the field name: IN

backticks around it: alter table tbl_name change `IN` NEW mediumtext; Pl. suggest how to rename particular field name for all the tables in a database Repeat the alter table for each table. :/ Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL

Re: Exponentiation operator

On Wed, Oct 08, 2003 at 11:16:03AM +0200, Bob Brands wrote: What is the correct syntax for using a Exponentiation operator in MySQL? It's not an operator but a function. Look at EXP and POW in the docs: http://www.mysql.com/doc/en/Mathematical_functions.html Regards, Fred. -- Fred van

Re: escaping slashes not present in table?

) column has the data: `qwer'y\19o` then it knows that it should read and return 10 chars/bytes. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax

Re: Replication and Auto_Increment

an easier way, but this is (from memory) what I've used before with 3.23.xx. Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424

Re: connection error

for user: [EMAIL PROTECTED]' (using password:yes). This suggest you tried to log on with a username 'user%' instead of 'user'. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400

Re: IP Address Conversion

ints. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List

Re: Possible: Update query within another query's loop?

connection to MySQL for the outer query to prevent the inner query from messing up the outer query's result set. See the PHP manual for obtaining the connection id's from mysql_connect and using them with other mysql functions. Regards, Fred. -- Fred van Engen XB

Re: Possible: Update query within another query's loop?

Antony, On Thu, Aug 28, 2003 at 06:29:54PM +0400, Antony Dovgal wrote: On Thu, 28 Aug 2003 16:23:35 +0200 Fred van Engen [EMAIL PROTECTED] wrote: You need to make a separate connection to MySQL for the outer query to prevent the inner query from messing up the outer query's result set

Re: Possible: Update query within another query's loop?

Antony, On Thu, Aug 28, 2003 at 06:45:27PM +0400, Antony Dovgal wrote: On Thu, 28 Aug 2003 16:37:41 +0200 Fred van Engen [EMAIL PROTECTED] wrote: Please elaborate. I've already answered: On the list I just saw your 'bad advice' message without explanation. On Thu, 28 Aug 2003 17:07

Re: MySQL 3.23.54 + update

; Not in 3.23.xx. You would need to do this from a programming language or possibly by creative use of temporary tables (SELECT INTO temp ...; REPLACE INTO `Table 2`(...) SELECT * FROM temp; with appropriate locking). Regards, Fred. -- Fred van Engen XB Networks

Re: finding out what localhost is

? By domain name? By ip? Nothing seems to work. The server should be the same as the one running your website. You are probably being blocked by their firewall as a security measure. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED

Re: MySQL running out of date

exactly what went wrong for each field. It also prevents garbage or badly formatted data from entering your database. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322

Re: Fw: Replication

/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication_Features Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31

Re: MySQL running out of date

On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote: Fred van Engen wrote: On Fri, Aug 22, 2003 at 01:16:48AM -0500, Hans van Harten wrote: that comes with neither warnings nor errors reported ... Error reports would have been nice, but why does your application supply

Re: MySQL running out of date

On Sat, Aug 23, 2003 at 02:07:36PM +0200, Hans van Harten wrote: Fred van Engen wrote: On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote: My checks might not match those of (the next version of) MySQL and at that time the difference in thoughts will pass unnoticed ! I agree

Re: compile mysql meet problem

and) installing _from_ /usr/local/mysql and also _to_ /usr/local/mysql. You should compile and install from any directory you choose, but it shouldn't be the same as the directory you specify as destination with configure --prefix. Regards, Fred. -- Fred van Engen XB

Re: Matching escaped strings

the ' in the first case because it is a string terminator. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424

Re: A final Windows MySQL PHP plea

containing a calculated value will allow you to create a good index (at the cost of making sure that the added field will remain consistent). There are lots of possibilities. Hope this helps. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL

Re: mutual declarations produce Error 1064

[TO] new_tbl_name | ORDER BY col | table_options So what it clearly tells you, is to use this (note the 'ADD'): mysql ALTER TABLE EMPLOYEE - ADD FOREIGN KEY (SUPERSSN) REFERENCES EMPLOYEE(SSN) - ON DELETE SET NULL - ON UPDATE CASCADE; Regards, Fred. -- Fred van Engen

Re: Using query file from console

name as argument. Connection id: 171359 (Can be used with mysqladmin kill) mysql So it looks like you could try the 'source' command. Copying the query through your clipboard is another option. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL

Re: Need help in querying two tables

. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http

Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

to guard the integrity of your data. TYPE = InnoDB only works if MySQL is compiled with InnoDB support, which is the default in binaries from MySQL. If you compile it yourself you need to configure --with-innodb . Regards, Fred. -- Fred van Engen XB Networks B.V

Re: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?

listed in section 2 at http://www.innodb.com/ibman.html /opt/mysql-3.23.56/libexec/mysqld: ready for connections So, look for something similar in your log. If it is there, then make sure that you have innodb configured in my.cnf. Regards, Fred. -- Fred van Engen XB

Re: MySQL multiple query in php script. (newbie)

(.) is doing here. Check for error messages in the webserver logs. } if (mysql_num_rows($result) ==0){ echo Sorry, no matching results.; } ? Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED

Re: how to limit COUNT(*)

: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED

Re: how to limit COUNT(*)

the wrong index, you can tell it from which indexes to choose by using 'USE (myindex)'. Use this e.g. to force it to use the same index as for an ORDER BY. If it decides to use NO index, I think you have a problem. Regards, Fred. - Original Message - From: Fred van Engen [EMAIL

Re: between A and B with another condition?

sample data (SELECT uid, level, name FROM members) and the results you get for the query that doesn't work. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC

Re: simple group by taking way too long..

it, but just to make sure you're aware of this. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424

Re: The difference between 1.9G and 2.2G table when create Index

van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http

Re: The difference between 1.9G and 2.2G table when create Index

On Sat, Jul 05, 2003 at 03:16:11PM +0200, Fred van Engen wrote: On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote: I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I create indexs for it, I couldn't finish after 4 hours. You mean it was still running

Re: 1999

was the first alpha release in august 1999 (few people would use that) I see no dates for 3.21.x, but it should have been the production release in the beginning of 1999 and was probably supported for a while after 3.22.x was the production release in march. -- Fred van Engen

Re: ERROR 2013:Lost connection to MySQL server

out if it crashed. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General

Re: ERROR 2013:Lost connection to MySQL server

version than 4.0.13, you could try to upgrade. InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] Well, you did that now :) I don't use InnoDB currently, so maybe someone else will respond. Regards, Fred. -- Fred van Engen

Re: SUM help needed

: GROUP BY Jobs.Job, Jobs.Sub, Jobs.Task; Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: Help me: I'm a beginner

be appreciated. mysql pager /usr/bin/less mysql tee somefile.log I guess this is documented somewhere, or try: mysql help Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400

Re: MySQL 4.0.13 GRANT syntax

] IDENTIFIED BY 'update'' at line 1 mysql Try [EMAIL PROTECTED] instead. UPDATE is a reserved word in SQL. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC

Re: MySQL - MS SQL

. It would be highly appreciated if you could send me the details at the earliest. Sorry, but I have no experience with this. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400

Re: wierd sort query, how do you do it? (sort by ip proximity guess)

); ++ | (5 | 7) ~(5 7) | ++ | 2 | ++ 1 row in set (0.00 sec) mysql Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400

Re: LAST_INSERT_ID() returns different values on different connections

. It gives you information on what you just inserted, not what someone else did with another connection. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#IDX1362 Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED

Re: Big Mistake Need Help, can I undo an action I did?

just did?? Sorry, you'll need a backup. If your backup is not recent enough and you have a binary log (e.g. for replication), you can use that log to restore the database state. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED

Re: Can't send Register ID

the manual, check return values, etc. If you're running PHP in apache, then check the error_log and use the error_log() function instead of print as I use in the code above. My code above is untested BTW. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL

Re: UPDATE query doesn't work at a PHP form

{ echo Can't perform the update. ; mysql_error(); Try this: echo mysql_error() } Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400

Re: 'delete' syntax

in MyPHPAdmin) delete * from 'item' where 'quantity_of_item_in_stock' = 10; Yes, this is incorrect syntax. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC

Re: mysql_fetch_row wrong on mysql 3.23.52

: $tanggal\n Nama file: $namafile\n ; } echo Akhir baris.\n; } else echo Gagal konek.\n; mysql_close($konek); ? Thank you very much in advance. You're welcome. Regards, Fred. -- Fred van Engen

Re: Data entered in PHP not appearing in mySQL

://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel

Re: Confused about network traffic on mysql port

tcpdump line and what do you see when you connect manually from shelbyville to herzegbol? (i.e. telnet herzegbol 3306) Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400

Re: Confused about network traffic on mysql port

just reply to unsent packets. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL

Re: SELECT HEX(abc) is broken...

it is for the latest version of MySQL. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: Autoincrement/last_insert_id race safe?

? Yes. The last inserted id is kept per connection. So unless YOU insert another record using the same connection, the last_insert_id isn't changed. Also, last_insert_id in a new connection will give you NULL, regardless of what you did in a previous connection. Regards, Fred. -- Fred van Engen

Re: Why Replication stops ?

. network problems, the replication should start again automatically. Again, you would see this in the error log. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC

Re: MySQL Daemon wont start

: './mysql/host.frm' (errno: 13) 030326 14:35:47 mysqld ended how do I correct this You don't seem to have setup the privilege tables. See http://www.mysql.com/doc/en/mysql_install_db.html for details. Regards, Fred. -- Fred van Engen XB Networks B.V. email

Re: linux problem installation

/en/mysql_install_db.html for details. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: UNION operates incorrectly

database option that will make a UNION behave properly in mySQL? Please define 'properly'. What are you trying to do? See msg 135092 for sample script if you want to see a physical example. Which message is 135092? I'm reading a mailing list, not a newsgroup. Regards, Fred. -- Fred van Engen

Re: New UNION ALL and problem with ORDER BY ?

= Users.UserID WHERE Users.UserId='2') ORDER BY 'Cars!2!CarID!hide', 'User!1!UserID!hide', Tag ; Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322

Re: UNION operates incorrectly

On Thu, Mar 20, 2003 at 10:32:07AM -0600, Dan Nelson wrote: In the last episode (Mar 20), Fred van Engen said: See msg 135092 for sample script if you want to see a physical example. Which message is 135092? I'm reading a mailing list, not a newsgroup. The mailing list software

Re: 'Invalid authorization specification' from MySql server

. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: The Security of MySQL

but by no means impossible. You give them the application that contains the password or encryption key. They just need to find it in your application then, which is more difficult but not impossible. Sue them! (that's what copyright laws are for) Regards, Fred. -- Fred van Engen

Re: Possibly bug in InnoDB with mysql 3.23.55

, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: question on select group by a 'set' field

))) as apples, sum(sign(find_in_set('pear', favourite_fruits))) as pears from Kids; This would give you all results on a single result row. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400

Re: interface to python?

/database/ http://www.python.org/topics/database/modules.html http://sourceforge.net/projects/mysql-python Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC

Re: Replication bug?

://lists.mysql.com/php/unsubscribe.php -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: Replication and the function now()

of the value, this causes a difference in my 2 databases. In my 3.23.52 binlog I see this before each time related update: SET TIMESTAMP=1039489014; Each time with the current timestamp of course. I haven't checked if it is actually used by the slave however. Regards, Fred. -- Fred van Engen

Re: Replication and the function now()

Remi, Michael, On Fri, Jan 03, 2003 at 11:39:44AM -0500, Michael T. Babcock wrote: Fred van Engen wrote: SET TIMESTAMP=1039489014; Each time with the current timestamp of course. I haven't checked if it is actually used by the slave however. If it is used, I would imagine its

Re: query requiring two results from one table?

, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424

Re: Select and Sort?

. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: Select and Sort?

optimization and it gives you another column in your result set (which you may or may not want). Regards, Fred. Fred van Engen wrote: On Tue, Dec 10, 2002 at 03:32:13PM +0500, Tariq Murtaza wrote: I want to achieve recordset like below (sorting category by Name and including 'Others' at the end

Re: adding values together

. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: Get last auto incremented id - newbie

INTO B VALUES(LAST_INSERT_ID(), ...); You need one query per table. LAST_INSERT_ID is kept per connection, not per table, so you can safely use it like this. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel

Re: root priv help

@localhost; And restart your MySQL daemon again. I never tried this, but I guess it should work. Good luck! Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere

Re: error: 'Access denied for user: 'root@localhost' (Using password: NO)'

to ask you for a password. I have never set up and administered MySql myself, so i don't know exactly what to expect but this is definitely not right. thanks for all your help Nothing unexpected so far. Regards, Fred. -- Fred van Engen XO Communications B.V

Re: Unique Indexes across multiple columns

for all of the four columns... MySQL said: Duplicate entry '127-30-127-1' for key 2 Did you check with a SELECT if there really is a duplicate 127.30.127.1 ? Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED

Re: Problem when inserting a record - auto_increment field gets max integer value instead of next id

, query) -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: Problem when inserting a record - auto_increment field gets max integer value instead of next id

auto_increment ID. I believe there is also a command you can use to reset the auto_increment ID, but you would still need to take care to not insert negative values. Regards, Fred. -Original Message- From: Fred van Engen [mailto:[EMAIL PROTECTED]] Sent: 05 June 2002 12:50

Re: Reaching the unique id after inserting with auto increment

filter needs sql,query -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: A dash in user or host confuses the grant statement

. Or use quotes around the hostname: grant all on *.* to my-user@my-host.com; Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424

Re: Max 127 records

. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: The table 'SQLb73d_0' is full

SQL_BIG_RESULT doesn't work in 3.22.x, though it is accepted by the parser. You don't mention which version you use. 'set SQL_BIG_TABLES' works fine in 3.22.x. Note that if I'm correct, you're using a very old version of MySQL. You might consider an upgrade. Fred. -- Fred van Engen

Re: Hi, Help!

mailed your root password to an open mailing list. Take care. You might want to change your password now. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax

Re: SELECT LAST_INSERTID() very sloooow

. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

Re: how to create a table with column name 'key'?

(`key` varchar(255), value varchar(255)); You might want to reconsider using reserved names like this because you will need to use the back-quotes in all your queries. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2

Re: Error 1062: Duplicate entry '127' for Key 1

) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel

Re: Why is mysql locking tables on insert

on MyISAM tables and only if you have never deleted any rows from them. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424

Re: Problem with LAST_INSERT_ID();

(NULL, 10); Any other value for ID_ordine will not assign an auto_increment value. ( excuse me for my English, it's under construction) ;-) Your English is fine. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED

Re: Problem with LAST_INSERT_ID();

, Fred. What does your INSERT query look like? It should specify NULL for ID_ordine, e.g.: INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10); Any other value for ID_ordine will not assign an auto_increment value. -- Fred van Engen XO

Re: how force mysql to use certain indexes

efficient on MERGE tables than on other tables. The feature is documented in some text in the manual about JOIN syntax. An 'ignore index' can be used as well. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg

Re: Merge Tables Oversight

this was fixed in MySQL 3.23.36 and later. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands

  1   2   >