Hi,
Try with
mysql > select 'oer bv' REGEXP '(^b|[[:blank:]])(!?v|$v)';
Thanks
ViSolve DB Team
- Original Message -
From: "Mike van Hoof" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Monday, January 08, 2007 5:40 PM
Subject: Re: MYSQL REGEXP help
Hello,
this doesn't work:
mysql> SELECT
Vitaliy Okulov a écrit :
> Здравствуйте, mysql.
>
> Hi all. I searching mysql backup script, which detect type of table &
> use mysqlhotcopy for MyISAM or mysqldump --single-transaction for
> InnoDB.
> Also save structure of table in file.
> And support recovery for dumped db an tables.
> Somebody
altendew wrote:
What do you mean assemble the SQL in Code.
I am using MYSQL 4.1 and PHP.
Ah. Looking closer, I see that you're not using an outside variable in
the CASE bit. Sorry about that. Should have read closer.
In your FROM clause, you could have stuff like:
FROM bonus b
JOIN bonu
What do you mean assemble the SQL in Code.
I am using MYSQL 4.1 and PHP.
Daniel Kasak wrote:
>
> altendew wrote:
>
>> Im trying to create one query here. I know why its failing because CASE
>> can
>> not be used like this, but how could I ever do a query like this.
>>
>> [CODE]
>> SELECT b.*
>
altendew wrote:
Im trying to create one query here. I know why its failing because CASE can
not be used like this, but how could I ever do a query like this.
[CODE]
SELECT b.*
FROM bonus b
JOIN
CASE b.type
WHEN 'custom' THEN 'bonusCustom g'
WHEN 'pts' THE
Im trying to create one query here. I know why its failing because CASE can
not be used like this, but how could I ever do a query like this.
[CODE]
SELECT b.*
FROM bonus b
JOIN
CASE b.type
WHEN 'custom' THEN 'bonusCustom g'
WHEN 'pts' THEN 'bonusPts g'
Sounds like you have triggers on the table, see the DEFINER clause within
this section of the manual:
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
Triggers within 5.0 require the user (within the DEFINER clause, or
executing the statement against the table when using CURRENT_USER
Hi
Jesse wrote:
I have an ASP.NET app where I'm doing an update, and the user name
that I'm using has the access to do an update. When I execute this
command, I get the error, "#42000Access denied; you need the SUPER
privilege for this operation". Following is my query:
UPDATE Families SET
I have an ASP.NET app where I'm doing an update, and the user name that I'm
using has the access to do an update. When I execute this command, I get the
error, "#42000Access denied; you need the SUPER privilege for this
operation". Following is my query:
UPDATE Families SET
LastName='a',Fath
Hi Mark,
Thank you very much for replying! I did open a bug for this last night
after I e-mailed:
http://bugs.mysql.com/?id=25460
As for reproducing, we're working on that at the moment. This happened
on a production system, so we worked first to stop the hemorrhaging.
Currently, we moved the h
I'll bite..
Sorry for this silly question but I've been always had trouble
pronouncing "MyISAM" and InnoDB.
How do you pronunce them?
I pronounce MyISAM as "give-me-foreign-keys" and InnoDB as
"curse-you-cryptic-foreign-key-errors"
(currently running far and fast)
--
MySQL General Mailing
Thanks. I might actually adapt our code, in my infinite free time.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Brent Baisley [mailto:[EMAIL PROTECTED]
> Sent: Monday, Janu
If this is in PHP, just use implode to create the string. The there is no need
to strip trailing commas and no loops.
$instring= implode('","', $a);
As for the query, where are you getting your "1000" values from? You can do joins on queries if your values are the result of a some
complex q
Hi,
I would use a (source,stamp) index, and not a (stamp,source) index to
solve the performance problem.
Jocelyn Fournier
www.mesdiscussions.net
> Brian, can you post the output of EXPLAIN for your query?
> I.e.,
> EXPLAIN ;
>
>
> At first glance, your query should be able to use the 'stamp
Brian, can you post the output of EXPLAIN for your query?
I.e.,
EXPLAIN ;
At first glance, your query should be able to use the 'stamp-source'
index since stamp is the first column indexed. However, I wonder if
wrapping the "NOW() - INTERVAL 14 DAY inside a "DATE()" would help.
MySQL may be ca
First, I think you may need to migrate off of OSX for your server if you are
under heavy load. I love OSX and have setup many
servers with it, but not for system with high contention. Many reviews show
that MySQL under OSX doesn't scale, most likely because
of the lack of fine grained locking in
Within the limits of an overall query, the IN clause can be arbitrarily
long. You'll use a loop in your program to construct a string such as
$instring .= "'$a[$i]',"
and then remove the unneeded trailing comma.
Our code here does that with very large lists that are the result of a
query. I don't
-Original Message-
From: Brian Dunning [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 07, 2007 1:12 PM
To: mysql
Subject: Help optimizing this query?
This is the query that's killing me in the slow query log, usually
taking around 20 seconds:
select count(ip) as counted,stamp from i
Thanks .
I have read these doucments,
but if i want store a .shp file,
How should I do? Convert it ?
Wating~~~
ViSolve DB Team-2 wrote:
>
> Hi,
>
> More info on spatial data,
> http://dev.m
Ah! ORDER BY after GROUP by - now it works:
SELECT o.orderid, u.username, o.date, sum( p.price )
FROM order o, users u, order_item oi, product p
WHERE o.userid = u.id
AND o.orderid = oi.orderid
AND oi.productid = p.productid
AND o.status = 'new'
GROUP BY o.orderid
ORDER BY o.date DESC , o.statu
Hello again. I am rather (actually very) rusty when it comes to composing
SQL these days. Can anyone spot the error here?
SELECT o.orderid, u.username, o.date, sum( p.price )
FROM order o, users u, order_item oi, product p
WHERE o.userid = u.id
AND o.orderid = oi.orderid
AND oi.productid = p.
Hello,
this doesn't work:
mysql> SELECT 'oer bv' REGEXP '[b|^b](!?[v$|v])';
++
| 'oer bv' REGEXP '[b|^b](!?[v$|v])' |
++
| 1 |
++
1 row in set (0.00 sec)
Hi,
More info on spatial data,
http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
http://dev.mysql.com/doc/refman/5.0/en/creating-spatial-columns.html
http://dev.mysql.com/doc/refman/5.0/en/populating-spatial-columns.html
Thanks
ViSolve DB Team
- Original Message -
From: "Cra
Hi,
[ERROR 1139 (42000): Got error 'repetition-operator operand invalid' from
regexp]
because,
In your query,
'!' is an Operator and ? is a wild character. Only wildcharacters should be
follow the Operators.
Try with.
SELECT 'boer bv' REGEXP '[b|^b](!?[v$|v])';
Thanks
ViSolve DB Team
---
Hi Jason,
Jason J. W. Williams wrote:
Hello,
We've been getting random crashes on our MySQL servers running MyISAM
tables for the last month, its gotten very bad in the last two weeks.
This has occurred on both 5.0.27, 5.1.11 and 5.1.15-nightly20070103.
It crashes the tables with high queries
Hi everyone,
I'm beginner in Gis,I want to establish a spatial database using MySQL.
But I don't kown hoe to.
Could someone give me the detail steps, or give me a databse that had
spatial data?
thanks.
--
View this message in context:
http://www.nabble.com/store-spatial-data-in-mysql-tf2938527.
Jan,
In English I pronounce them as...
My-eye-sam
In-oh-dee-bee
...respectively.
Regards,
Phil
2007/1/7, js <[EMAIL PROTECTED]>:
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing "MyISAM" and InnoDB.
How do you pronunce them?
Thanks in advance.
When
Hello,
i am try to make a regular expression work, but keep getting this error
message:
does anyone know how i can make it work?
The query is:
SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])';
So it has to match each starting 'b' and all the b's pf following words.
But now followed by a v(line
Hello,
i am try to make a regular expression work, but keep getting this error
message:
does anyone know how i can make it work?
The query is:
SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])';
So it has to match each starting 'b' and all the b's pf following words.
But now followed by a v(line
29 matches
Mail list logo