Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular database development tool:
Database Workbench Pro 3.2
Changes Highlights in 3.2
-
- Sybase SQL Anywhere support
- Firebird 2.1 support
- Microsoft SQL Server 2008
Upscene Productions expands product line by introducing
Sybase SQL Anywhere supports and introducing 2 free Lite
editions of the popular database development tool
Database Workbench
Version 3.2 introduces Sybase SQL Anywhere support and
lowers the price for the Oracle and Microsoft SQL Server
The next *MySQL University* session will take place this Thursday, 23rd
October. David Van Couvering will show how to use NetBeans with MySQL.
Note that this session will start at 9:00 Pacific Time (18:00 CET, 17:00
BST).
For this session, we'll use a new presentation system that we hope will
Hi,
Is something wrong with a sql query like this?
(SELECT commentname, count(comments.ID) as comid, 'comments' as section from
comments where commentname IN (SELECT DISTINCT commentname from comments
where id=35037 ORDER BY commentname)Group by commentname) UNION ALL (SELECT
Username, count(ID),
Please let me down of the list.
I resigns from my job.
Thanks
--
BSD is for people who love UNIX.
Ing. Vidal Garza Tirado
Depto. Sistemas
Aduanet S.A. de C.V.
Tel. (867)711-5850 ext. 4346, Fax (867)711-5855.
Ave. César López de Lara No. 3603 Int. B Col Jardín.
Nuevo Laredo, Tamaulipas, México.
1, Subqueries should be avoid when using mysql. Rewriting to be using joins
will probably solve your problem.
2. Explain is your friend.
On Mon, Oct 20, 2008 at 4:38 PM, Sangeetha [EMAIL PROTECTED] wrote:
Hi,
Is something wrong with a sql query like this?
(SELECT commentname,
Maybe you can use mysql -e instead.
On Mon, Oct 20, 2008 at 12:51 AM, walter harms [EMAIL PROTECTED] wrote:
hi ronaldo i tried and failed.
it seems that mysql has no option to specify a select statement.
did i mis something ?
re,
wh
walter harms schrieb:
hi ronaldo,
iadmit i was
Timestamp is the best bridge between java and mysql,I think.
On Sun, Oct 19, 2008 at 4:48 PM, Rama [EMAIL PROTECTED] wrote:
DATE TIME ZONE SENSITIVE
DATETIME NOT SENSITIVE TO TIME ZONE
TIMESTAMP TIMEZONE SENSITIVE
iam getting the above problem as date is timezone sensitive.i resolved
iam sorry iam facing same problem with the datetime iam confused and
working/investigating on it.
Problem is :
Java Program MYSQL
- --
-
Default timezone : GMT
Learnt!
On Wed, Oct 15, 2008 at 5:28 PM, philip [EMAIL PROTECTED] wrote:
Date: Tue, 14 Oct 2008 16:55:11 +0300
From: Olexandr Melnyk [EMAIL PROTECTED]
To: [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: Problem with GROUP BY
http://jan.kneschke.de/projects/mysql/groupwise-max
Thanks so much Rob, I will try and use joins and avoid Selects within
Selects ...I tried to comment out this select and it works... Gosh I wonder
why mysql does not support SEubqueries.. It just hangs in the copying to tmp
table status. Atleast I know whats wrong... Thanks very much
On Mon, Oct
select * from
(
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
) T
WHERE CC =
(
select max(cc) from
(
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
) T2
)
On Wed, Oct 15, 2008 at 5:08 PM, dave aptiva [EMAIL PROTECTED]wrote:
Hello
hi martin,Thanks,
But my problem is Why it is printing wrong date ( 2008-10-20 06:23:09 ) instead
of ( 2008-10-20 12:23:09 )
what is going wrong here?
On Tue, Oct 21, 2008 at 7:33 AM, Martin Gainty [EMAIL PROTECTED] wrote:
look at the MySQL doc to figure out whats going on
default MySQL
You could create an extra table in order to record the max number of
widget,the the ID should alway be 1.
On Thu, Oct 16, 2008 at 2:04 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
I would do a muli key PK with a after insert trigger to that would
change widget_number 1 to 1000. Just my HO...
I
Could you please give me an idea of how to manage the privileges inside
mysql?
Thank you very much.
On Wed, Oct 15, 2008 at 5:01 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Tue, Oct 14, 2008 at 1:49 PM, Grant Peel [EMAIL PROTECTED] wrote:
Hi all,
I run a shared Apache, Perl, PHP, Mysql,
Maybe it's a bug.^___^
On Thu, Oct 9, 2008 at 1:37 PM, Andrew Garner [EMAIL PROTECTED]wrote:
On Wed, Oct 8, 2008 at 3:10 AM, Zbigniew Szalbot [EMAIL PROTECTED]
wrote:
Hi there,
I hope someone can help. Due to they way my HD has been sliced I had
to move mysql database to
On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha [EMAIL PROTECTED] wrote:
Gosh I wonder
why mysql does not support SEubqueries.. It just hangs in the copying to tmp
table status. Atleast I know whats wrong... Thanks very much
It supports them, but won't optimize them well until 5.2. There's
some
On Mon, Oct 20, 2008 at 8:30 PM, Perrin Harkins [EMAIL PROTECTED] wrote:
On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha [EMAIL PROTECTED] wrote:
Gosh I wonder
why mysql does not support SEubqueries.. It just hangs in the copying to
tmp
table status. Atleast I know whats wrong... Thanks very
On Mon, Oct 20, 2008 at 9:31 PM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Mon, Oct 20, 2008 at 8:30 PM, Perrin Harkins [EMAIL PROTECTED] wrote:
On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha [EMAIL PROTECTED] wrote:
Gosh I wonder
why mysql does not support SEubqueries.. It just hangs in the
19 matches
Mail list logo