bound?
select prime.* from prime join prime as p2 on prime.pv+2=p2.pv where prime.oid
100;
--
Simcha Younger sim...@syounger.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
' asc LIMIT 10;
When you use quotes you are no longer referring to the column, instead the
order orders by the string 'name'.
This is a meaningless sort, and your results wil not be ordered at all.
Thanks
Brent
--
Simcha Younger sim...@syounger.com
--
MySQL General Mailing List
For list
. INCORRECT!
Again correct, you tried to match `name` against boolean TRUE (the evaluation
of you expression).
Best regards,
Johan
--
Simcha Younger sim...@syounger.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
backticks, not quotes.
`group`, not 'group'.
--
Simcha Younger sim...@syounger.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
'
for the part of the statement that I've marked as *bold* and how I can over
come this problem ?
You have to add the users table to the subquery.
Your subquery only has the fixtures_results table in the 'from' clause, and the
subquery is not aware of the tables you use in the outer query.
--
Simcha
Halliday
http://www.pintumbler.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=sim...@syounger.com
--
Simcha Younger sim...@syounger.com
--
MySQL General Mailing List
For list archives: http
the problem?
You probably have apparmor installed, and it prevents mysql from writing to any
directory other than the mysql data directories, regardless of which user it is
running under.
--
Simcha Younger sim...@syounger.com
--
MySQL General Mailing List
For list archives: http
.
--
Simcha Younger sim...@syounger.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Wed, 06 Oct 2010 17:48:55 -0400
kalin m ka...@el.net wrote:
Simcha Younger wrote:
executing this query didn't update the record.
why?
The two values you have here are equal:
sample data : 12862162510269684
query: where unix_time 12862162510269684
12862162510269684
and therefore the 'less than' query did not match that row.
--
Simcha Younger sim...@syounger.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
the same.
select distinct id from `table` where concat(`b`, `c`, `d`) in (select
concat(`b`,`c`,`d` from `table` where id = '0001') AND id != '0001';
(untested)
--
Simcha Younger sim...@syounger.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
11 matches
Mail list logo