Hi David,
I think you can try pipes(hope u r using linux/unix).
this is a method we used to export/sqlload for oracle.
craete a pipe file, say abc.txt(mkfile -p abc.txt).
start the the dumpfile reading in bg(should be run first).
start the dump-file generation of C++.
with this setup we could save
At 07:40 PM 9/25/2004, you wrote:
I've looked all over the mysql.org website, for data element/column types,
and find no reference to storing data as a link to an html document or
blob. I am thinking this can be done but need help with syntax.
So, is there there a way to store the following in
I was attempting to install mysql ver. 4.0.21 when I encountered a
premature ending to the install as shown here:
[EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql
Installing all prepared tables
040925 21:50:34 Warning: Asked for 196608 thread stack, but got 126976
040925 21:50:34 .
I've looked all over the mysql.org website, for data element/column
types, and find no reference to storing data as a link to an html
document or blob. I am thinking this can be done but need help with
syntax.
So, is there there a way to store the following in a data record?
http://mydomai
I think Sol meant to copy the rest of the group on his suggestion as well...
Rhino
- Original Message -
From: "sol beach" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Saturday, September 25, 2004 4:01 PM
Subject: Re: MIN(foo) as bar WHERE bar>50
> Something like this might
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 25 September 2004 14:31, Rhino wrote:
> - Original Message -
> From: "Michael Satterwhite" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, September 25, 2004 12:29 PM
> Subject: Retrieving field characteristics
>
> >
- Original Message -
From: "Michael Satterwhite" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 25, 2004 12:29 PM
Subject: Retrieving field characteristics
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> In order to make my field definitions more dynamic, I'
Hai Lakshmi,
Backup I am yet to learn.
transactional tables-limited knowledge- transaction safe tables are
the ines in which you will be able to rollback the changes u made to
the db since last commit or rollback.
to check is innodb is running(rather enabled), in linux u may use the command
mysql
- Original Message -
From: "Andy Bakun" <[EMAIL PROTECTED]>
To: "Laszlo Thoth" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, September 25, 2004 1:30 PM
Subject: Re: MIN(foo) as bar WHERE bar>50
> On Fri, 2004-09-24 at 21:31, Laszlo Thoth wrote:
> > Here's the kids:
> >
> >
I would suggest exposing yourself to other developers and them to you as
well. They are often found on irc server irc.freenode.net. The more you
expose yourself to them and them to you, the better you know and better
prepared you get for exam. They also provide resourceful information as
they ex
> Hi, I took the MySQL core and professional certification exams and failed
both, so now I want to go again, but does anyone have any tips or techniques
for studying that they've found useful?
>
Wow, what a drag.
Did you read the study guide? How long have you been a MySQL user?
I am preparing to
On Sat, 2004-09-25 at 00:35, Søren Ragsdale wrote:
> Whoah. HAVING. I have never heard of that keyword before, possibly
> because it is not listed in the MySQL manual TOC. Thank you very much!
Its not in the TOC but its part of the SELECT statement docs:
http://dev.mysql.com/doc/mysql/en
MySQL supports sub-queries in the 4.1 versions.
Cheers
Andrew.
- Original Message -
From: "Andy Bakun" <[EMAIL PROTECTED]>
To: "Laszlo Thoth" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, September 25, 2004 6:30 PM
Subject: Re: MIN(foo) as bar WHERE bar>50
On Fri, 2004-09-2
On Fri, 2004-09-24 at 21:31, Laszlo Thoth wrote:
> Here's the kids:
>
> mysql> SELECT p.name as parent,c.name as
> child,(TO_DAYS(NOW())-TO_DAYS(c.dob))/365 as age FROM people as p LEFT JOIN
> people as c ON p.name=c.parent WHERE c.name IS NOT NULL ORDER BY p.dob;
You seem to be missing a parent
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
In order to make my field definitions more dynamic, I'd like to retrieve the
field length definition from the database. E.g. If a field is described as
varchar(5), I'd like to retrieve the "5" at runtime so as to limit the length
of data a user can pre
- Original Message -
From: "Laszlo Thoth" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 25, 2004 3:43 AM
Subject: Re: MIN(foo) as bar WHERE bar>50
> > What version of MySQL are you running? Version 4.1.x and 5.0.x offer
many
> > more potential solutions than the
> What version of MySQL are you running? Version 4.1.x and 5.0.x offer many
> more potential solutions than the earlier versions, which don't support
> subqueries.
Sorry, should have specified. I am using 4.0.20, but I am under no obligation
to stick with this version. (I'm developing an applica
Is there any way to load huge amounts of data with
LOAD DATA INFILE and make the load process have a low
priority so the server stay responsive during the
process?
I know about CONCURRENT and LOW_PRIORITY options for
load data but that's not what I'm looking for since I
load into a new database ev
i use suse 9.0 and mysql 4.0 , i drop a db is very important for me ,
hoe to i can recover it ?do you have any tool for this function .
this is vital for me . please help me .
--
E.Norouzi
Site Administrative Of P.S.P.ÂCo, Ltd.
Tel:+98-21-2865439/41
Fax:+98-21-2865120
International Fax:+1-603-761
19 matches
Mail list logo
