Have you tried to run the query in MySQL's console?
- Carsten
-Oprindelig meddelelse-
Fra: Rob Galvin [mailto:[EMAIL PROTECTED]]
Sendt: 30. maj 2002 20:29
Til: [EMAIL PROTECTED]
Emne: ADO recordset is not returning rows in ASP page
I have an active server page using an ADO
Well you'll neew to do some coding in your application language. What are
you using to connect to MySQL? Perl? PHP? Java?
Tell me, and I'll give you an example where you only query the database once
(for optimum performance).
- Carsten
-Oprindelig meddelelse-
Fra: Sagi Bashari
call.
The trick is, that to make a tree you always need to use recursive
functions. The performance is gained by loading the complete list from
database at once (instead of calling a mysql SELECT statement for each
branch of the tree).
- Carsten
-Oprindelig meddelelse-
Fra: Carsten
Fra: Richard Clarke [mailto:[EMAIL PROTECTED]]
Sendt: 18. maj 2002 22:29
Emne: 4.0.1 Bugs
List,
I wondered if any movement has been made to determine the cause of the
following bugs that I have come across using Mysql 4.0.1.
1) selectunion causes a temporary table full type
You could use Kylix from Borland. It's a RAD tool - it's actually Delphi
ported to Linux.
- Carsten
-Oprindelig meddelelse-
Fra: Yvon Darang [mailto:[EMAIL PROTECTED]]
Sendt: 6. maj 2002 15:31
Til: [EMAIL PROTECTED]
Emne: Newbie Question
Hi everybody,
Let's say I do not want to
You can download MySQL++ from www.mysql.com
- Carsten
-Oprindelig meddelelse-
Fra: Hisseine Dj. [mailto:[EMAIL PROTECTED]]
Sendt: 6. maj 2002 17:24
Til: [EMAIL PROTECTED]
Emne: C++ API for Mysql
Hello,
Can someone tell me if there is an C++ API that works smooth with MYSQL on
Fra: Nick Arnett [mailto:[EMAIL PROTECTED]]
Sendt: 3. maj 2002 04:30
Emne: Strategies for maintaining tables calculated from other tables?
I'm finding that it's not quite as simple as I had imagined to maintain a
table whose values are calculated by analyzing other tables. The source
-Oprindelig meddelelse-
Fra: Mike Hall [mailto:[EMAIL PROTECTED]]
Sendt: 28. april 2002 12:28
Til: [EMAIL PROTECTED]
Emne: Fw: WHERE ignored
Corrupt index, hmm? I'll check that in a moment - thanks.
After looking at your fault-free script, my best bet would also be a
corrupted
-Oprindelig meddelelse-
Fra: Mike Hall [mailto:[EMAIL PROTECTED]]
Sendt: 27. april 2002 00:04
snip
No other scripts perform UPDATEs on that table, only INSERTs. But MySQL
returned the correct data at 8:55 and again at 9:05. It was only
when it ran
at 9am that it appeared to
Fra: Henning Olsen [mailto:[EMAIL PROTECTED]]
Sendt: 19. april 2002 14:39
Hey - can anyone help?
I have a MySql-db in which I can only have 127 records.
Using phpmyadmin to insert record number 128 (autoincrement) gets
this message:
INSERT INTO `kontakt` (`id`, `navn`, `adresse`,
Fra: savaidis [mailto:[EMAIL PROTECTED]]
Sendt: 17. april 2002 22:14
Emne: a query from php doen't work
I get a Query failed error on this:
What could hapent?
Try to alter this line:
$result=mysql_query($buffer);
to look like this:
$result=mysql_query($buffer) or
Fra: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sendt: 16. april 2002 09:52
MySQL AB wants to satisfy as many users as possible. That means
there may be
more than one language available for writing stored procedures.
For example, many mainstream databases currently support both Java and a
Fra: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
Sendt: 14. april 2002 19:22
In fact what it's odd is when I use EXPLAIN, I don't see anywhere DISTINCT
in the EXPLAIN result :
That's because the MySQL optimizer converts your distinct into a group by.
Read more here:
Fra: Simon Byrnand [mailto:[EMAIL PROTECTED]]
Sendt: 15. april 2002 04:00
I'm currently running MySQL 3.23.40 on Redhat 6.2 and its working nicely.
It was installed from binary RPM's.
I'm not trying to update to 3.23.49, but because the binary RPM's
available
require GLIBC 2.2 (Redhat
From: Russell E Glaue [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 2:20 AM
On the mysql-internals mail list we had a thread going about this. I was
suggesting something like embedding PERL into MySQL to produce something
like PERL/SQL (similar to PL/SQL in oracle).
snip
Would anyone on
To examplify this:
When you add your user, do it like you do now:
insert into a values (password('name'));
When the user logs in at a later time, do this:
select * from a where pw = password('name');
If no row is selected, no user with that password was found.
- Carsten
- Original
From: sreedhar [EMAIL PROTECTED]
Sent: Saturday, February 16, 2002 6:03 AM
How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'.
By sitting tight and waiting, just like the rest of us :-)
http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html
- Carsten
From: Colin Faber [EMAIL PROTECTED]
Sent: Thursday, January 31, 2002 7:07 AM
I think a better question would be why ;-)
To quote our beloved Basil Fawlty: Do you think this is what made the
British Empire great?
When asked why anyone would want to climb Mount Everest, George Lee Mallory
From: Paul DuBois [EMAIL PROTECTED]
To: Jude Insley [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Bug in UNIQUE?
The SQL below illustrates what I believe is a bug in MySQL up to and
including 3.23.47. Essentially I need a unique key where one or more of
the component fields of the unique
- Original Message -
From: Peter Dunham [EMAIL PROTECTED]
To: MYSQL [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 12:03 PM
Subject: MATCH vs LIKE
I am trying to speed up keyword searches using MATCH AGAINST instead of
like, but am getting unexpected results.
I had assumed that
- Original Message -
From: Jenny [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 5:14 AM
Finally i able to retrive image from MYSQL database via VB6.0.
However, i can only retrieve image where the size is greate than 17kb and
less then 32KB.
I have try to increate my
Maybe it's just me, but I find that my mysqld proccesses consume quite a lot
of memory. 7584 KB each to be exact.
I've installed MySQL using the RPM on mysql.com (and I don't use the MAX
version). I haven't made any config file, just installed it and let it run.
Can I do anything about it? It's
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
Sent: Saturday, January 12, 2002 11:23 PM
In the last episode (Jan 12), Carsten Gehling said:
Maybe it's just me, but I find that my mysqld proccesses consume
quite a lot of memory. 7584 KB each to be exact.
7 MB is nothing
Gehling [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 20, 2001 1:49 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
Hi!
3.23 (but 4.0 hasn't that bug either).
Will be 2.23.40 soon.
And have nice trip, btw.
On Jul 20, Carsten Gehling
I'm going to Spain today and cannot respond to any questions in the next
week. I was going to wait with this until I got home again, but what the
heck ;-)
Run the following script through your MySQL on an empty database with
mysql -uusername -ppassword dbname scriptname
and the last command
BTW: As I've stated earlier, the error goes away, if you either remove the
FULLTEXT index or let the affected fields accept NULL values.
- Carsten
- Original Message -
From: Carsten Gehling [EMAIL PROTECTED]
To: Sergei Golubchik [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July
Which dev. tree is that? 3.23 or 4.0?
- Carsten (who hasn't left yet ;-)
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
To: Carsten Gehling [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 20, 2001 1:22 PM
Subject: Re: Bug report: FULLTEXT index corrupts
Drop the index and recreate it
alter table you-table drop index your-index;
alter table you-table create index your-index(fieldlist);
- Carsten
- Original Message -
From: Rory O'Connor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 7:55 AM
Subject: re-indexing
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
To: Carsten Gehling [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 6:26 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
Hi!
On Jul 16, Carsten Gehling wrote
of the NULL
value in RDBMS' - I regard it as a necessary evil to be used sparsely. So it
would be great if I did not have to convert my text fields (text varchar)
into accepting NULL.
- Carsten
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
To: Carsten Gehling [EMAIL PROTECTED
Using MySQL version 3.23.39 on a Win2k server with SP2, I have some problems
with the FULLTEXT index. I have a table created like this:
CREATE TABLE `visitkort` (
`id` int(10) unsigned NOT NULL auto_increment,
`kategori_id` int(10) unsigned NOT NULL default '0',
`aktiv` tinyint(3) unsigned
You could use VIM (cross-platform) or UltraEdit (Win32), the latter is
capable of reading and writing *nix compatible files even though it's only a
Win32 program.
- Carsten
- Original Message -
From: Mike Cermak [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday,
3
- Fixing index 4
- Fixing index 5
Fix:
The error does not occur, if you drop the FULLTEXT index
Synopsis: FULLTEXT index corrupts the index with too many TEXT fields
Submitter-Id:
Originator: Carsten Gehling
Organization: Sarum
MySQL support: [none]
Severity: [serious]
Priority: [low | medium
at:
http://www.code-genie.com/
- Original Message -
From: Carsten Gehling [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 6:04 AM
Subject: Re: Slightly off-topic... Dump SQL editor thats
cross-compatWin/Linux
You could use VIM (cross-platform
From: "Florian G. Pflug" [EMAIL PROTECTED]
Sent: Tuesday, February 27, 2001 1:31 AM
I think XML support should not be just "sending the respone of an
SQL-Queries written in a weird way as an XML Document as another weird XML
Document to the client".
It should make the DB-Server into a hugh
From: "Jon Haworth" [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 5:40 PM
Oh no, not another one
Mike and James - you fell for the good ol' trick.
Bu hu for you - don't you just "love" it? :-)
Now whoever made the little bastard this time...?
Funny thing actually: My Outlook Express
From: "Geoff Coffey" [EMAIL PROTECTED]
Sent: Thursday, February 01, 2001 5:25 PM
I am in the process of migrating a site built with FileMaker Pro to MySQL
and PHP mostly because filemaker's web capabilities are too limiting. In
one
situation, we have a database of about 20,000 rows that
From: "Tom" [EMAIL PROTECTED]
Sent: Thursday, January 18, 2001 11:18 AM
I can't seem to get mysql server started on win2k. hell
I don't even know which file to run to start it up. I did
try all though and nothing seems to work.
http://www.mysql.com/doc/N/T/NT_start.html
Normally I'm not a
From: "Michel Tignyemb" [EMAIL PROTECTED]
Sent: Tuesday, January 16, 2001 4:33 PM
Here is the command :
mysqladmin -u root -p password 'mysql'
Remove the space between -p and password:
mysqladmin -u root -ppassword mysql
- Carsten
39 matches
Mail list logo