Re: Intermittent deadlock/InnoDB

On Wed, 2006-05-10 at 16:26 -0700, Robert DiFalco wrote: > Version 5.0.19. > > We have no autogenerate keys. We perform a single insert and get a lock > timeout. The insert is done with a stored procedure with a single line. > The lockup happens VERY rarely and we have no idea how to reproduce it.

Re: searching for words with special chars

On 2006-04-01, at 13:17, Octavian Rasnita wrote: Hi, Is it possible to create a query that searches for records which contains words with special chars and with their english correspondents? For example, if a user searches for "mata", I want to return all the records that contain the wo

[JOB] Contract MySQL Specialist (Telecommute)

Contract MySQL Specialist (Telecommute) Los Angeles company looking for a DBA who lives, eats, and breathes MySQL and is familiar with integrating it in a LAMP environment. Ideally someone who is part of that MySQL community, gets their jollies from optimizing it, knows how hardware fits in the m

RE: PRINT statement?

>From Transact-SQL Help file: PRINT Returns a user-defined message to the client. Syntax PRINT 'any ASCII text' | @local_variable | @@FUNCTION | string_expr Arguments 'any ASCII text' Is a string of text. @local_variable Is a variable of any valid character data type. @local_variable must b

Re: PRINT statement?

I am not familiar with the PRINT command so I don't know what it does. I played with MS SQL Server once for a couple of days a few years back and that is the only contact I've ever had with SQL Server. If you can tell me what PRINT does, in detail, maybe I can suggest another alternative. --

Re: Is this a bug of stored procedure?

never mind. I found the answer: http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html On 5/10/06, tom soyer <[EMAIL PROTECTED]> wrote: Hi, I tried to pass the name of a table into a procedure and use that in a select statement. Somehow it doesn't work. Here is the code: creat

Is this a bug of stored procedure?

Hi, I tried to pass the name of a table into a procedure and use that in a select statement. Somehow it doesn't work. Here is the code: create procedure sp3(in tablename varchar(10)) begin select count(*) from tablename; end$ When the procedure is called, I got the following error: ERROR 1146 (

Is this a bug of stored procedure?

Hi, I tried to pass the name of a table into a procedure and use that in a select statement. Somehow it doesn't work. Here is the code: create procedure sp3(in tablename varchar(10)) begin select count(*) from tablename; end$ When the procedure is called, I got the following error: ERROR 1146 (

Re: PRINT statement?

I've started using the SELECT with no other clauses but I am still curious about a PRINT-like command. It is for SQL scripts. Rhino wrote: - Original Message - From: "Stephen Cook" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Sunday, May 07, 2006 3:53 AM Subject: PRINT statement? Is

Intermittent deadlock/InnoDB

Version 5.0.19. We have no autogenerate keys. We perform a single insert and get a lock timeout. The insert is done with a stored procedure with a single line. The lockup happens VERY rarely and we have no idea how to reproduce it. Here's the hostname.err data: Alarm status: Active alarms:

RE: Installing DBD::mysql - problems

Hi Connie, Looks like you have hit http://bugs.mysql.com/bug.php?id=18091 (which hasn't been fixed yet) potential solutions are documented there. Regards --- ** _/ ** David Logan *** _/ *** ITO

Installing DBD::mysql - problems

I am trying to install DBD::mysql on the following node: [EMAIL PROTECTED] cal]# uname -a Linux snv1 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 x86_64 x86_64 x86_64 GNU/Linux [EMAIL PROTECTED] cal]# more /etc/redhat-release Red Hat Enterprise Linux WS release 4 (Nahant Update 3) [EMAIL P

Re: Fulltext search for term 'c++'

I think the '+' will not get into the index in the first place. So, there's probably no way to get a search to use the index. However if you want a consistant query format for your search you could probably get the correct result by wrapping the search term in double quotes: select f1 from t1 w

RE: MySQL 5 / phpMyAdmin - SOLVED

Thanks to Ing. Edwin Cruz and George Law for pointing me in the right direction, as previous messages in this thread indicate. phpMyAdmin now working great with MySQL 5.0. Have a loot on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html try a search for "old_password" -- Amer

Fulltext search for term 'c++'

Hello all, Is there any way I can search for a term such as 'c++' using a fulltext search index? Here is the query that should return rows but it does not. I suspect that the trailing "++" are treated as wildcards and are not fulltext indexed by mysql. It seems like mysql interprets the search st

mysql workbench installation issues

Hello, I am trying to install wokbench on Linux box I am running Debian (SID). First I downloaded the file mysql-workbench-1.0.6beta-linux-i386.tar.gz, then I did: 1. $ tar xvzf mysql-workbench-1.0.6beta-linux-i386.tar.gz 2. In the created folder I ran bin$ sh mysql-workbench 3. Nothing happe

RE: Can I set UNIX_TIMESTAMP() as default?

Nicholas, just found something on google: "In general, this cannot be done. Default values cannot be the return of a MySQL function (as much as I'd love to use NOW() for default values!). However, there's one loophole. When inserting, not specifying a value for the first timestamp field in a ta

Re: Sum of counts

You could you use UNION to make this all execute in a single query. On 5/10/06, Rhino <[EMAIL PROTECTED]> wrote: Hi Chris, Joerg, and everyone else following this discussion, Joerg, you are correct; the best way to sum the tables is individually and then add the sums together with program logic

Can I set UNIX_TIMESTAMP() as default?

I would like an integer field to capture the current date as a Unix Timestamp by default. But this will not be accepted at all. I get the error "invalid default value for [field name]" Is there a workaround? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: SQL:2003 standard

Hello Peng, please have a look at http://www.wiscorp.com/SQLStandards.html There you can download all you need. With best regards, Roland. Peter Brawley wrote on 10.05.2006 16:51: > Peng Yi-fan wrote: >> Hi, >> >> It seems that ISO do not support SQL:2003 standard for free but I really >>

RE: MySQL 5 / phpMyAdmin

Have a loot on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Regards! -Mensaje original- De: Amer Neely [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 10 de Mayo de 2006 12:39 p.m. Para: MySQL List Asunto: MySQL 5 / phpMyAdmin I've finally got MySQL 5.0 going on my

RE: MySQL 5 / phpMyAdmin

try a search for "old_password" -Original Message- From: Amer Neely [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 10, 2006 1:39 PM To: MySQL List Subject: MySQL 5 / phpMyAdmin I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin 2.8.0.3 is now giving me grief. It giv

MySQL 5 / phpMyAdmin

I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin 2.8.0.3 is now giving me grief. It gives me this error: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. #1251 - Client does not support authentication protocol requested by server; con

Re: Sum of counts

Hi Chris, Joerg, and everyone else following this discussion, Joerg, you are correct; the best way to sum the tables is individually and then add the sums together with program logic of some kind, such as might be found in a script or application program or stored procedure. I'm afraid I jump

Re: slow query

I think you are right about O log N performance when finding matching records within the index - however, the index doesn't contain all the data, so the mysql server has to hit the table as stored on disk to find what you were actually asking for (select *). That becomes time consuming as it s

Re: Reporting child tables referencing a parnet table

Ben Clewett wrote: Unfortunately I get: mysql> SELECT -> c.table_schema,u.table_name,u.column_name,u.referenced_column_name -> FROM information_schema.table_constraints AS c -> INNER JOIN information_schema.key_column_usage AS u -> USING( constraint_schema, constraint_name )

Unknown option --install

I am trying to install two MySQL servers to run as Windows XP services. One for work with php-gtk+ as mysqld1, MySQL 3.23.55 on port 3306 and another as mysqld2, MySQL 5.0.20 on port 3308 for PHP5 development and testing. I'm following the manual's instructions in section 5.13.1.2. Starting

Re: Sum of counts

Hi Chris, all, Re-inserting Chris' original question: | I want to get a total of entries from four tables which all match a | particular id. The result for the id I'm testing (21) should be 233. | In my naivety, I thought something like this would work: | | select count(a.id) + count(b.id) + cou

Re: slow query

Thanks for the response, Dan. I did try ORDER BY on the table. Didn't help -- I presume because the query is using an index. Unfortunately, the point of my current development is to show searches against millions of contacts, so the suggestion about working with other user_ids isn't too practic

Re: Reporting child tables referencing a parnet table

Unfortunately I get: mysql> SELECT -> c.table_schema,u.table_name,u.column_name,u.referenced_column_name -> FROM information_schema.table_constraints AS c -> INNER JOIN information_schema.key_column_usage AS u -> USING( constraint_schema, constraint_name ) -> WHERE c.constrai

Re: SQL:2003 standard

Peng Yi-fan wrote: Hi, It seems that ISO do not support SQL:2003 standard for free but I really need a copy. Does anyone know where I can download it? Or does anyone have it? Any type will be just OK. There is a 2002 draft at http://xml.coverpages.org/SQLX-5wd-14-xml-2002-08.pdf. PB

Re: Reporting child tables referencing a parnet table

Ben,: Dear MySQL, Can you please tell me if there is a way of listing all child tables which have a foreign key reference to a parent? Find children of db.table: SELECT c.table_schema,u.table_name,u.column_name,u.referenced_column_name FROM information_schema.table_constraints AS c INNER JOI

Re: Need help in recreating .MYD files

*Ok Daniel,* ** * Thank you.* ** *regards,* *bala* **

Re: slow query

I would expect the problem to be that the further down in the data you go by using OFFSET, the more records the mysql server has to scan in order to get to what you want. This will produce a fairly linear slowdown the further in you go - it just takes time to check through 1,000,000 matching r

SQL:2003 standard

Hi, It seems that ISO do not support SQL:2003 standard for free but I really need a copy. Does anyone know where I can download it? Or does anyone have it? Any type will be just OK. Peng

Re: batch installation of mysql 5.0

On 5/10/06, kamaya <[EMAIL PROTECTED]> wrote: Hi, I want to install mysql 5.0 in batch mode. That is, I want to avoid interaction with windows while installing mysql 5.0. Is there anyone who has an idea? I have used NSIS from Nullsoft to create a custom install of MySQL, just created a conf

Reporting child tables referencing a parnet table

Dear MySQL, Can you please tell me if there is a way of listing all child tables which have a foreign key reference to a parent? Therefore I can find and delete a child row, then delete the parent without getting: "a foreign key constraint fails" Regards, Ben Clewett -- MySQL General Mai

~Replication errors~

Hi, Iam getting the following error on my Mysql Slave server. This happened when my disk space got full and there was no space left on the device. I managed to free up some space and then ran mysql> STOP SLAVE mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000110', MASTER_LOG_POS=850202232;

Re: 1' and '1' or '1

Tahnks all for your responses (so many) I am reading up on it now -- Dave - Original Message - From: "Johan Lundqvist" <[EMAIL PROTECTED]> To: Sent: Wednesday, May 10, 2006 10:26 AM Subject: Re: 1' and '1' or '1 Hi Dave, 1st: Never, never, never store passwords in plain text!! Just

Re: how to restart mysql and apache?

Hi, If it is your default apache /usr/sbin/apachectl start and mysql /etc/init.d/mysql.server start This might help you out. Daniel da Veiga wrote: On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: found this: /etc/rc.d/init.d/mysqld restart /etc/rc.d/init.d/httpd2 restart I thin

Re: 1' and '1' or '1

Hi Dave, 1st: Never, never, never store passwords in plain text!! Just don't do it. Store a hash of the password (ie md5 or something else). 2nd: Never pass any input from the Internet directly into a query without first checking it for sql injection. Take a look at Wikipedia article for a

Re: 1' and '1' or '1

At 9:53 +0100 10/5/06, Critters wrote: A user was able to log into my site using: 1' and '1' or '1 in the username and password box. I ran the query SELECT * FROM members WHERE name = '1' and '1' or '1' AND password = '1' and '1' or '1' And it returned all rows. Interesting - I found just

RE: comparing postgis with mysql

Hi, I'm a GIS developer, who specialises in the architecture of geospatial databases. PostGIS (a derivitive of PostGreSQL) has been developed with spatial data in mind, and as such is primarily for this use. I have tried MySQL with Spatial extensions, whose implementation is very good I must say,

Re: 1' and '1' or '1

Search the web for something called "sql injection" and do some reading. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.da

Re: 1' and '1' or '1

On Wednesday 10 May 2006 09:53, Critters wrote: > Hi > A user was able to log into my site using: > 1' and '1' or '1 > in the username and password box. > > I ran the query > > SELECT * FROM members WHERE name = '1' and '1' or '1' AND password = '1' > and '1' or '1' > > And it returned all rows. Ca

Re: 1' and '1' or '1

Quoting Critters ([EMAIL PROTECTED]): > SELECT * FROM members WHERE name = '1' and '1' or '1' AND password = '1' and > '1' or '1' > And it returned all rows. Can someone explain to me why this happens, > and if the steps I took (replacing the ' with a blank space when the > user submits the login

RE: 1' and '1' or '1

What page architecture are you using: PHP, ASP, .Net 1.1 or .Net 2.0 or are you using one of the standard CMS packages (Mambo, Plone, etc) ?? If you are using ASP.net 2.0 with MySQL (I am using this), I have managed to implement the Membership / Role providers in my site using MySQL as the provide

Re: MySQL server has gone away. Suddenly.

Hello everyone, This problem seems to be solved... > The problem i'm experiencing is that at certain moments, the connection > between my perlscripts and the database gets disconnected. [...] > I thought the query at that spot would be wrong, but it turns out that > this alone is not causing th

1' and '1' or '1

Hi A user was able to log into my site using: 1' and '1' or '1 in the username and password box. I ran the query SELECT * FROM members WHERE name = '1' and '1' or '1' AND password = '1' and '1' or '1' And it returned all rows. Can someone explain to me why this happens, and if the steps I too

batch installation of mysql 5.0

Hi, I want to install mysql 5.0 in batch mode. That is, I want to avoid interaction with windows while installing mysql 5.0. Is there anyone who has an idea?

Re: novice on SQL

> Hi John, right the problem boils down to this: sitetable tasktable ID taskidtaskid Changes ---- 11010100 21110120 SELECT sitetable.ID, tasktable.Changes FROM sitetable,tasktabl