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 s
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
mak
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, count(commen
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,
> > i
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
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/
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 20
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 a
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 My
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...
>
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,
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
so
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... T
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
hi all...
i have a strange problem with a simple script that is doing select into
outfile...
the thing just does that. it does a select into an outfile. if i print
the query that's passed to mysql_result in the script and then copy it
and paste it z`into the mysql client it works fine but i
20 matches
Mail list logo
