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
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
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 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
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
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,
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...
>
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
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
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
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/
iam sorry iam facing same problem with the datetime iam confused and
working/investigating on it.
Problem is :
Java Program MYSQL
- --
-
Default timezone : GMT
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
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
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
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.
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), '
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
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
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
20 matches
Mail list logo
