On Thu, Nov 09, 2006 at 09:26:52AM -0800, Bill MacAllister wrote:
> What happened to the Innodb web pages? What comes up for be is a
> search page with a bunch of related links on it. I wanted to pull
> down a copy of ibbackup documentation and it isn't there anymore.
Strange indeed, I get the s
On 2006-11-09 Daevid Vincent wrote:
> I am using this query to pull three random comments from a table:
>
> "SELECT *, DATE_FORMAT(created_on, '%b %D') as date_format FROM comments
> ORDER BY RAND() LIMIT 3";
>
> The problem is that sometimes, I get two of the same comment. How can I
> refine t
I am using this query to pull three random comments from a table:
"SELECT *, DATE_FORMAT(created_on, '%b %D') as date_format FROM comments
ORDER BY RAND() LIMIT 3";
The problem is that sometimes, I get two of the same comment. How can I
refine this query to give me 3 unique/distinct ones?
--
M
--On Thursday, November 09, 2006 08:37:01 PM +0200 Onur
<[EMAIL PROTECTED]> wrote:
Bill MacAllister wrote:
What happened to the Innodb web pages? What comes up for be is a
search page with a bunch of related links on it. I wanted to pull
down a copy of ibbackup documentation and it isn't
Hi,
Do you know if a UDF can return a boolean value?
Thanks,
Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is the byte size of an index for datetime type column?
How can I compute disk space required if I want to add an index on a
DATETIME column?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL AB asked Hoyer... the lead developer to remove the "MySQL" part
from the name of the application... and he used that as an excuse to
stop the project.
His option !
Now you can try MySQL AB's tools...
http://dev.mysql.com/downloads/gui-tools/5.0.html
Or you can go to the original developer
> Can anyone tell me what's wrong: http://www.mysqlfront.de/
>
> It's my favorite toll now it's gone
Plenty of others - let me advertise Database Workbench - www.upscene.com
:-)
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upsce
Can anyone tell me what's wrong: http://www.mysqlfront.de/
It's my favorite toll now it's gone
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Anybody know? I tried every version after 5.0.19 and none allow me to do
concurrent inserts/load data into a myisam table, even with the new
force concurrent variable
we are stuck on 5.0.19 for now, any ideas?
matt_lists wrote:
We have been using older versions of mysql without any problem (5
VenuGopal Papasani wrote:
hi all,
I have got a problem with mysql and i want to uninstall it and then
re-install it but the problem is how to recover my data.My mysqldump
command
is not working.Can i have any other procedure to recover my data like
copying the folder of my database from the da
Bill MacAllister wrote:
What happened to the Innodb web pages? What comes up for be is a
search page with a bunch of related links on it. I wanted to pull
down a copy of ibbackup documentation and it isn't there anymore.
Bill
+---
| Bill MacAl
Em Thu, 09 Nov 2006 09:26:52 -0800, Bill MacAllister escreveu:
> What happened to the Innodb web pages? What comes up for be is a search
> page with a bunch of related links on it. I wanted to pull down a copy of
> ibbackup documentation and it isn't there anymore.
Perhaps they are at O
What happened to the Innodb web pages? What comes up for be is a search
page with a bunch of related links on it. I wanted to pull down a copy of
ibbackup documentation and it isn't there anymore.
Bill
+---
| Bill MacAllister, Senior Programmer
, for each version of the
MySQL Manual (4.1, 5.0, and 5.1) there are two RPM files. For the 5.0
Manual, for example, there are:
http://downloads.mysql.com/docs/mysql-refman-5.0-en-html-chapter-1-20061109.noarch.rpm
http://downloads.mysql.com/docs/mysql-refman-5.0-en-pdf-1-20061109.noarch.rpm
You ca
Jens Kleikamp schrieb:
hi to all,
I have a simple question/szenario.
Here are my tables:
1. image (id, name)
2. tag (id, name)
3. images_tags (image_id, tag_id)
At the moment I have the following working query, it selects all images
which have *at least one of the tag ids* (25,30) assigned.
On 2006-11-09 VenuGopal Papasani wrote:
> hi all,
> I have got a problem with mysql and i want to uninstall it and then
> re-install it but the problem is how to recover my data.
This seldom solves problems. What problem do you have, maybe we can help
without having you uninstall your server :)
hi all,
I have got a problem with mysql and i want to uninstall it and then
re-install it but the problem is how to recover my data.My mysqldump command
is not working.Can i have any other procedure to recover my data like
copying the folder of my database from the data folder and then making a
b
Giorgio,
InnoDB only implements MATCH SIMPLE. MySQL/InnoDB ignores the MATCH
clause that you specify in the foreign key constraint definition.
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
"
A referential constraint is satisfied if one of the following con-
dition
Tim,
we hired Osku in August 2005 to work on the fulltext project. Osku has
done also lots of other work during the past 15 months. His fulltext
project is progressing slowly but steadily. I cannot give any promises
when/if Osku's work will be ready.
A factor that also affects this is that M
hi to all,
I have a simple question/szenario.
Here are my tables:
1. image (id, name)
2. tag (id, name)
3. images_tags (image_id, tag_id)
At the moment I have the following working query, it selects all images
which have *at least one of the tag ids* (25,30) assigned.
SELECT DISTINCT image.
On 11/9/06, ViSolve DB Team <[EMAIL PROTECTED]> wrote:
Hi Experts,
We are in the process of converting Oracle administration commands into MySQL
for some purposes. We dont know how to convert the following Oracle commands to
MySQL. How to do that..?
1. ALTER USER spec TEMPORARY TABLESPACE tem
These commands are Oracle specific or contains Oracle specific
extensions. Nothing wrong with that, but in some cases there just is no
corresponding command in MySQL, as the concepts are different.
ViSolve DB Team wrote:
Hi Experts,
We are in the process of converting Oracle administration co
Hi Experts,
We are in the process of converting Oracle administration commands into MySQL
for some purposes. We dont know how to convert the following Oracle commands to
MySQL. How to do that..?
1. ALTER USER spec TEMPORARY TABLESPACE temp_ts;
2. DROP USER jbossjms1 CASCADE;
3. DROP TABLESPAC
24 matches
Mail list logo
