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
branch of the tree).
- Carsten
> -Oprindelig meddelelse-
> Fra: Carsten Gehling [mailto:[EMAIL PROTECTED]]
> Sendt: 27. maj 2002 20:33
> Til: [EMAIL PROTECTED]
> Emne: SV: building tree view in mysql?
>
>
> Well you'll neew to do some coding in your application langua
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 [mail
> 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 ful
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
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
> 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 sourc
> -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
corru
> -Oprindelig meddelelse-
> Fra: Mike Hall [mailto:[EMAIL PROTECTED]]
> Sendt: 27. april 2002 00:04
> 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 ign
> 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 die($buffer."".my
> 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 an
> Fra: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
> Sendt: 16. april 2002 02:15
> I can disclose that there is actually some progress being made in stored
> procedures + triggers.
Ahh could you perhaps disclose a little more? :-) There's been a great
discussion on the choice of language, and I'm su
> 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 (Re
> 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:
http:/
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).
> Would anyone
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 Mess
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: "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 field
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 Mallor
From: "sreedhar" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Subject: Can I establish a ADO Connection to work with PHP and MySQL on
Linux
> Hi all,
>
> My Database on Linix. Can I establish a ADO Connection to work with PHP
and
> MySQL on Linux.
Uhm yes You could do that, but why?
- 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 ass
- 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
- 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
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
t;[EMAIL PROTECTED]>
To: "Carsten 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).
>
&
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
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 PROTEC
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 http://www.mysql.com/manual.php (t
f 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]>
s still there. So it is definitely a problem
within the FULLTEXT index.
- Carsten
- Original Message -
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
To: "Carsten Gehling" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 6:26 PM
Subject
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-inde
PROTECTED]>
> > Reply-To: "Steve Brazill" <[EMAIL PROTECTED]>
> > Date: Mon, 16 Jul 2001 10:48:08 -0700
> >
> > >Don't forget that "WinVI" exists.... and can be found (and
> > downloaded) at:
> >
> > http://www.winvi.de/en/
hk --safe-recover -force visitkort
- recovering (with sort) MyISAM-table 'visitkort.MYI'
Data records: 339
- Fixing index 1
Found block with too small length at 22812; Skipped
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
Fix:
The error does not occur, if you drop
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: Mon
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
From: "Peter Skipworth" <[EMAIL PROTECTED]>
Sent: Friday, March 23, 2001 11:43 PM
> Try copying your .MYD and .frm files to a directory and running 'restore
> table [tablename] from '/this/directory'
Thank you very much :-)
- Carsten
I have to MYISAM tables where I... ahem... have lost the corresponding .MYI
files. When I try to repair the tables, myisamchk reports this error:
myisamchk: error: 'questions.XXX' doesn't have a correct index definition.
You need to recreate it before you can do a repair
How do I recreate these
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
- Original Message -
From: "Henrik Lebtien Mohr" <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 3:57 PM
> If any of you have tried the following with ASP/ADO and MySQL, please
inform
> me of how you did it:
I've done a lot of this in my time, so I know most of the tricks.
> I use
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 Expre
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 no
From: "Marcos Minshew" <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 10:05 PM
> >From what I've read in the docs, this should work, yes?
>
> select mcorder.ord_id, project.address, mcuser.last_name
> from
> project inner join
> (mcuser inner join
>mcorder
> on mcus
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
--
From: "Issam W. Alameh" <[EMAIL PROTECTED]>
Sent: Monday, January 15, 2001 3:46 AM
> I am using an auto_increment field, every time I delete from the table,
the
> counter goes back, is there any way to keep the incrementation regardless
of
> the number reached after delete
This is the way auto_
From: "Neil Davis" <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 6:58 PM
> Guys,
>
> Amen. When I was 13 and got my first commodore 64, I decided to teach
myself
> BASIC. All I had was the manual. (the MySQL manual is the library of
> If it is documented somewhere, and can be produced
From: "Ralf R. Kotowski" <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 11:05 PM
>
No flames needed. This is a serious discussion. :-)
> So I guess the question would be were do we find people that could
> translate it to a manner so that mere mortals can understand it.
We already ha
48 matches
Mail list logo
