- Original Message -
From: <[EMAIL PROTECTED]>
To: George Pitcher <[EMAIL PROTECTED]>
Sent: Saturday, August 25, 2001 1:41 PM
Subject: Re: install problems AGAIN
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filte
> CREATE TABLE MSJOURNL (ACCT INT(3),
> DESC CHAR(29),
> DTE DATE)
>
> This query fails when MySQL encouters DESC. Changing DESC to DESCRIP
causes
> the query to work. I'm wondering if filtering for the reserved word
DESCRIBE
> causes DESC not to be legal for use in field names?
desc itself is a
On Sun, Aug 26, 2001 at 01:58:23PM -0700, Bill Angus wrote:
> CREATE TABLE MSJOURNL (ACCT INT(3),
> DESC CHAR(29),
> DTE DATE)
>
> This query fails when MySQL encouters DESC. Changing DESC to DESCRIP
> causes the query to work. I'm wondering if filtering for the
> reserved word DESCRIBE causes DE
Hi !!
)-Original Message-
)From: Bill Angus [mailto:[EMAIL PROTECTED]]
)Sent: Sunday, August 26, 2001 1:58 PM
)To: [EMAIL PROTECTED]
)Subject: Query fails
)
)
)CREATE TABLE MSJOURNL (ACCT INT(3),
)DESC CHAR(29),
)DTE DATE)
)
)This query fails when MySQL encouters DESC. Changing DESC to DE
CREATE TABLE MSJOURNL (ACCT INT(3),
DESC CHAR(29),
DTE DATE)
This query fails when MySQL encouters DESC. Changing DESC to DESCRIP causes
the query to work. I'm wondering if filtering for the reserved word DESCRIBE
causes DESC not to be legal for use in field names?
On Sun, Aug 26, 2001 at 10:40:20PM -0500, Mark Johnson wrote:
>
> Is it possible to set a differenent password per database for the
> same user? It doen't appear to be possible
Not that I know of. The user is tied to a single password.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Tech
Is it possible to set a differenent password per database for the same user?
It doen't appear to be possible
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I'm in the process of building a tree-structured message base, or rather
porting software I wrote back in mid-80s to the web. This isn't the
ubiquitous "threaded" BBS software. It's tree-structured. This means that
every message on the message base is related through a single ancestor, Msg #
http://www.mysql.com/downloads/contrib.html#SEC607 The Access one works
pretty good.
Cheers
M;)
If you ever fall off the Sears Tower, just go real limp, because maybe
you'll look like a dummy and people will try to catch you because, hey, free
dummy.
- author
-Original Message-
From: J
Hi
Can you help me locate the information on your website about converting
Access 2000 to MySQL.
I host with Webfusion, who use MySQL, but my site has been created using
Access and I need to "convert it" before uploading. I understand the
conversion is quite easy and that all the information is
Hey Jeremy, Michael,
I wanted to thank you both for your replies, they definatly have given me
some more insight into the situation, and also gave me some extra motivation to
keep my commitment to mysql. Like most other people, i hope this 'mess' can be
resolved in the near future.
Jeremy, to
Hi
I need to set the max_allowed_packet to 16M. below is my
01mysql-server.sh file. I use DBI and I know that I have to start this
before the DBI program and I did but if I use ./mysqld --help it shows
that my max_allowed_packet is still 1M. Any help would be really great
since I've been working
On Sun, Aug 26, 2001 at 04:45:07PM +0200, Chris Chabot wrote:
> Hi Jeremy, thanks for a good reply. In awnser to some of your questions :
>
> Jeremy Zawodny wrote:
>
> > > Now, a few years after first using MySql, a major dispute seems to
> > > plague the 'image' of MySql, and posibly also t
Hi!
Jeremy Zawodny did already answer this email, but I have a couple of
additions to his answer.
> "Chris" == Chris Chabot <[EMAIL PROTECTED]> writes:
Chris> Dear Everyone,
Chris> I have been looking at this mysql.com/org dispute for a while now,
Chris> and i must say i am getting mor
"Darius Blaszijk" <[EMAIL PROTECTED]> writes:
> I'm just beginning with MySQL, and I have the following question. Is there
> something like events in MySQL. What I want to do is write some message
> automtically into a table every time a record in some table is changed.
You're looking for trigge
On Sun, Aug 26, 2001 at 11:52:15PM +0200, Boaz Yahav wrote:
> Does mysql have something like NO LOCK?
>
> SELECT * FROM mytable WHERE myfield='xyz' NO LOCK
By default, no. But if you use InnoDB tables in MySQL, you'll get
non-locking SELECTS, which is probably what you're looking for. See
the
Hello,
I'm just beginning with MySQL, and I have the following question. Is there
something like events in MySQL. What I want to do is write some message
automtically into a table every time a record in some table is changed.
Many thanks, Darius Blaszijk
---
Does mysql have something like NO LOCK?
SELECT * FROM mytable WHERE myfield='xyz' NO LOCK
berber
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list a
On Sat, Aug 25, 2001 at 09:24:25PM -0500, Paul DuBois wrote:
> At 10:07 AM -0700 8/24/01, Katherine Porter wrote:
> >For single values I usually use this DBI function and query:
> >
> > my $val =3D $dbh->selectrow_array("SELECT value FROM tab1 WHERE test=3D=
> >2");
> >
> >However, what if I wan
I'm always seeing stuff like:
MySQL 3.23.41-max: up 9 days, processed 115,312,654 queries (140/sec.
avg)
On the bottom of emails. My question is HOW do you add this to emails?
Thanks lots
David Ayliffe ([EMAIL PROTECTED])
Running Windows 2000 Advanced Server (SP2)
Also running Suse Linux 7.1
>> the table becomes corrupted. Is this some limitation of inno DB or should I
>> separate the UPDATE process in two separate UPDATE statements?
>It's a known and confirmed bug that will be fixed in 3.23.42. There
>was an announcement just posted about this a few minutes ago.
Hi Jeremy,
thanks
On Sun, Aug 26, 2001 at 09:10:31PM +0200, Ralph Graulich wrote:
> Hi,
>
> recently I converted a table containing a large amount of text
> fields from myISAM to inno-DB and encountered a problem I can't help
> with. The table structure consists of:
>
> textref_id INT(12) UNSIGNED
>
Hi,
recently I converted a table containing a large amount of text fields from
myISAM to inno-DB and encountered a problem I can't help with. The table
structure consists of:
textref_id INT(12) UNSIGNED
textref_cat_id INT(12) UNSIGNED
textgroup_key CHAR(5) NOT NU
Hi!
A serious bug has been found in the big BLOB and TEXT
support of InnoDB. If you update the primary key of a
row whose length is > 8000 bytes, then the table
becomes corrupt. Also the tablespace may become
corrupt. Note that also a REPLACE can internally be
handled as an update.
A fixed versi
On Fri, Aug 24, 2001 at 09:59:38AM -0400, Tac/Smokescreen wrote:
>
> I have a large (>40 million rows) table that currently consists of a
> few integers and a varchar. I need to add a memo (text > 255 chars)
> field to about 2% of the rows. Originally I was going to create
> another table with a
Ryan,
if you can run the recovery inside gdb
with mysqld compiled with the gcc option -g
and print the stack trace with bt, it may help
me to see where the problem is and fix it.
If you have updated the primary key of a > 8000-byte
row then the table is certainly corrupt and cannot be
saved. But
On Sun, Aug 26, 2001 at 11:29:31AM +, Greg Cope wrote:
> Jeremy Zawodny wrote:>
> > On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote:
> > >
> > > The other solution is rsync. I dont know much about this guy
> > > yet, but I have some concerns with using it to copy over large
> > >
What compiler you use? I have similar problem with some software packages,
when I try compile it with RedHat gcc-2.96. Try another version, gcc 3.01 or
gcc 2.95
On Sun 26 Aug 2001 18:39, sailer-sh wrote:
> I use kernel 2.4.9 ,I compiled mysql-3.23.41(./configure --with-low-memory;
> make ), whe
I use kernel 2.4.9 ,I compiled mysql-3.23.41(./configure --with-low-memory; make ),
when "make", it said :
ranlib .libs/libmysqlclient.a
creating libmysqlclient.la
(cd .libs && rm -f libmysqlclient.la && ln -s ../libmysqlclient.la libmysqlclient.la)
make[2]: Leaving directory `/usr/src/mysql-3.2
Sigh, that wasnt realy the point of the email, but ok, i knew it could
happen when i wrote it.
The images -are- stored in the database in the product i'm activly
marketing, its a content management system, which can be administered via a
web interface. All text / html / images are stored in the D
While I have not specifically done a linux vs NT shootout, I have worked
with many similar programs on both platforms. My closest experience was
with the commercial database Sybase (ASE 12.0)
With the same data, and the same database schema on the exact same
hardware, we found that linux (RH 6.
Hi guy's,
does anybody has experience with running mysql on a linux system or on an
winnt-server-system?
If I have the same hardware for both operating systems ( e.g PIII with 256
MB Ram and a 36 GB SCSI-HF)
which one gives me or the mysql users the best performance?
At the moment I used a winn
Description:
I want to install MySQL on my PC. But I'm using Windows ME as
operation system. So I downloaded the "Windows 95/98/NT/2000
(Intel)"-version.
Was this correct?
After installation I tried to start the server using following
MS DOS-commando "C:\my
Jeremy Zawodny wrote:>
> On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote:
> >
> > The other solution is rsync. I dont know much about this guy yet,
> > but I have some concerns with using it to copy over large remote
> > files. For example, if I have a 1.2 gig table that has been hea
> > I would also strongly suggest not storing your images in the
> database but
> > rather a link to the image.
>
> even that - why?
> if you're using an ultrafast webserver like Tux in combination with
> Apache/php-perl
> the Tux webserver serves the images incredibly fast (see specweb tests)
Jeremy Zawodny writes:
> On Sat, Aug 25, 2001 at 08:32:00AM -0500, Steve Suehring wrote:
> > Hello-
> >
> > I poked around on the site but didn't find any definite answer.
> > Roughly when is version 4.0 of MySQL expected out? I saw the
> > information on the todo in regards to version 4.0 and t
Venu writes:
> Hi !!!
>
> Can anyone has the answer for him ? How we can have a secure data transfer
> over the web using MySQL and its APIs ? He is desperately needed some idea
> in order to take further steps with MySQL ?
>
> Regards
> Venu
>
Something like this :
ssh1 -C [EMAIL PROTECTED]
Dear List,
I did a data warehouse comparison of a number of databases a while back - for
full details of data structures and queries see :
http://homepages.slingshot.co.nz/~markir
Altho I spent more time on Mysql than any of the others, I was not able to
optimize some aspects as much as I wo
38 matches
Mail list logo
