hi guyz
2 problems
1.
i ve a page that picks up random records from mysql database and displays
them
now i want to limit the display to 5 or 6 records per page
that is if it could pickup ALL the records in the db and disolay only 5 or 6
on each page
my project supervisor wants somethin
Hello,
I've experienced what seems to be the same problem on
Redhat 7.2. I eventually realized that in addition to
the regular 4.0.2 server RPM, I had to also install
the MySql-Max 4.0.2 server RPM. After that,
everything worked fine.
I was under the impression that there would only be
one ser
Hi,
The below mentioned sql makes an error when created
with two foreign key constraints under MySQL/Innodb
table type. Any help to solve this problem?
create table UserMenuRestrictions
(
CompanyCodechar(10) not null,
UserId char(10) not nul
In using MySQLGui v 1.75, I get the following message when I try to
connect to the database:
Can't connect to local MySQL server through socket "(111)
What can I do in addition to following the configuration for .my.sql
in MySQL.help? I can access the database through the text based mysql
Does anyone know if these instructions actually work?
(they didn't for me)
http://cerebus.sandiego.edu/~jerry/UnixTips/mysql.html
I'd like to fix them up so I and others never have to seek this out again,
tall order?
Who can help me?
after I followed these the server didn't start.
I had to use
I know this is an off topic question, but wondered if anyone might have a
moment to help. I wouldn't ask if I could do a sub-select...
I am using mysql v3.23.51 and have a table I need to display the information
of users who are working in both category 3 and category 5.
Table def looks kind of
Hi!
I recently took a test drive for MySQL 4.0.2. Installation was a breeze
as always.
However, when I tried to start MySQL server using the same old my.cnf
which 4.0.1
had no problems with, 4.0.2 complained about the following and refused
to start.
020713 07:24:55 mysqld started
Unknown suffi
[EMAIL PROTECTED] writes:
> En réponse à Jan Kudrman <[EMAIL PROTECTED]>:
> I've found it on the online documentation of MySQL.org with comments of user.
> Since I've replaced the RP of RH 7.3 by RPM of MySQL.org, I don't have any
> problem
No known RH-specific bugs with the MySQL rpms shipped
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
So this works as expected,
mysql> create table test_1 (id int,value char);
Query OK, 0 rows affected (0.00 sec)
mysql> create table test_2 (id int,val char);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test_1 values (1,a),(2,b),(3,c);
ERROR 1054: Unknown column 'a' in 'field list'
m
In the last episode (Jul 12), Larry Irwin said:
> I'd like to set up my CREATE's to have CHECK and REGEXP but can't
> seem to get 4.0.2 to accept my attempts...
>
> CREATE TABLE IF NOT EXISTS aptype (
> aptype_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
> appt_type VARCHAR(3) NOT NU
filter: sql,query
I did some tests recently on a two column primary key, one of which was
an autoincrement column. It worked nicely, maintaining a separate
increment for every unique value in the second column. I was ecstatic,
as this was exactly what I need for some tables I'm designing.
Howeve
Ok.. Bug #2.. (yes, I'm getting a bit cranky!)..
The "copy_if_not_empty()" routine is whacking my username (and it would my
password if it was also set). In my case, the routine gets the following
args :
copy_if_not_empty (to=0x7f7f41b0 "rflower", max_length=64, from=0x7f7f0980
"", length=-3
Hello,
We have compiled in InnoDB support for MySQL 3.23.51. We would LOVE to take
advantage of the transactions and foreign key assignments that it provides.
We are having an issue, with the following SQL, however:
All of the alter table statements are ending with this error:
ERROR 1005: Can't
I'd like to set up my CREATE's to have CHECK and REGEXP but can't seem to
get 4.0.2 to accept my attempts...
CREATE TABLE IF NOT EXISTS aptype (
aptype_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
appt_type VARCHAR(3) NOT NULL,
branch VARCHAR(2),
print_ticket VARCH
I'd like to set up my CREATE's to have CHECK and REGEXP but can't seem to
get 4.0.2 to accept my attempts...
CREATE TABLE IF NOT EXISTS aptype (
aptype_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
appt_type VARCHAR(3) NOT NULL,
branch VARCHAR(2),
print_ticket VARCH
I've found a nasty in SQLError.. I'm guessing it is a causualty of
cut-n-paste.. Notice that the CLEAR_STMT_ERROR macro is being used to clear
the error of "hstmt" when it's null.. Not only is the macro name wrong, but
the argument as well.. In my case, hstmt was null, and it was dereferencing
At 01:48 PM 7/12/2002, Jeremy Zawodny wrote:
>On Fri, Jul 12, 2002 at 01:43:02PM -0700, Jon Drukman wrote:
> > now instead of getting the error every 30 seconds, i get it every
> > hour. is there a way to make it go away forever?
>
>Make the number really big?
>
>I wonder if you can set it to 0 t
Satish,
you can look from http://www.mysql.com/doc/N/e/News.html if you can find
such a bug fix from 3.23 or 4.0 during the past 6 months.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download M
On Fri, Jul 12, 2002 at 01:43:02PM -0700, Jon Drukman wrote:
> i am having the "Error reading packet from server: (server_errno=1159)"
> replication problem.
>
> in searching the archives for others experience replication problems, i
> came across the suggestion of adding these lines to my.cnf
Concerning mysql-max-4.0.2-alpha-pc-linux-gnu-i686.tar.gz on SuSE 7.3
If you cd /usr/local and unpack the tarball then create a symlink to mysql,
cd into mysql and run ./bin/mysqld.safe the daemon can't locate
mysql-max-4.0.2-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys.
If you rem
i am having the "Error reading packet from server: (server_errno=1159)"
replication problem.
in searching the archives for others experience replication problems, i
came across the suggestion of adding these lines to my.cnf
set-variable = slave_net_timeout=3600
set-variable = net_read_timeout
In the last episode (Jul 12), Robert Boyd Skipper said:
> I've written a Perl application that works fine with MySQL as installed
> in my Windose system, but causes MySQL to restart when I run it on my
> FreeBSD version. I've narrowed it down to one script where the
> problem seems to recur,
Would I get better performance if mysql were being run from a SCSI hard
drive?
Lawrence
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Hello:
I've written a Perl application that works fine with MySQL as installed
in my Windose system, but causes MySQL to restart when I run it on my
FreeBSD version. I've narrowed it down to one script where the
problem seems to recur, but that script is pretty long. I will send it,
if that
In the last episode (Jul 12), Carlos Rovetto said:
> Hi. I want know why the time of response is slowly when i make a
> Join between two tables using sql query in MySQL.
>
> I don't have more experience in MySQL
Make sure you have indexes on the columns you use to join the tables.
--
It depends on the size of the tables that you are joining together. Can you
index any of the columns that you are joining? If you post the query that
you are trying to execute I might be able to help you more.
DK
-Original Message-
From: Carlos Rovetto [mailto:[EMAIL PROTECTED]]
Sent:
Hi. I want know why the time of response is slowly when i make a Join
between two tables using sql query in MySQL.
I don't have more experience in MySQL
Carlos
_
MSN. Más Útil cada Día. http://www.msn.es/intmap/
-
Does your my.cnf file contain any comments that begin after a configuration
option? I had similar problems setting up 4.0.2, but stripping such
comments fixed it. E.G.:
set-variable = innodb_mirrored_log_groups=1 # Some comment here...
MySQL 4.0.2 complains about the set-variable statement
Hi!
Below is my my.cnf. I tested the
mysql-4.0.2-alpha-pc-linux-gnu-i686.tar.gz
distro and it worked. What distro did you use?
Regards,
Heikki
# The MySQL server
[mysqld]
#bdb-no-sync
server-id=1
language=/home/heikki/mysql-4.0/sql/share/english
default-table-type=innodb
#log-bin
port=3307
soc
I'm trying to install MySQL on my Playstation 2 (mipsel-pc-linux-gnu,
apparently). For entertainment purposes, you understand. :)
It configures, compiles, and installs fine, but when I get to running
mysql_install_db, it gets a bit upset. Lots of error 1033.
Am I going to be able to get there
Yes, exactly.
chown -R mysql /usr/local/mysql
chown -R mysql /var/lib/mysql
Of course you need to substitute the actual paths for the distribution
and data directories.
David Kramer wrote:
>Ok thats what I was guessing, so I need to create a new user for the DB
>seperate from the root. Do I
Ok thats what I was guessing, so I need to create a new user for the DB
seperate from the root. Do I " chown " the binaries and database files to
my new user? Or Do the binaries always stay to root?
Thanks much!
DK
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent:
Hi,
I'm a new user of mysql, I was upgrade from mysql 4.01 to 4.02 in
mandrake 8.2.
The following options in current running my.cnf suddently not work:
innodb_data_file_path = ibdata1:100M
innodb_data_home_dir= /data/mysql/
innodb_log_group_home_dir = /data/mysql/
The mysql user should own the databases and files, not root.
David Kramer wrote:
>I am able to access all of the database instances that I have created when
>starting Mysql with safe_mysql(as root user). As soon as I start mysql any
>other way, I keep getting the Access Denied Error. Can root
Hi,
I'm sorry to trouble you, I was upgrade from mysql 4.01 to 4.02 in
mandrake 8.2.
The following options in current running my.cnf suddently not work:
innodb_data_file_path = ibdata1:100M
innodb_data_home_dir= /data/mysql/
innodb_log_group_home_dir = /data/mysql
Sorry about the rant.. I've been spending the last two days trying to
install gcc, MySQL, MyODBC and UnixODBC on several AIX and HP boxes with
varying degrees of success and lots of aggravation (much of it due to
braindead configure scripts that ALWAYS want to leave gcc arguments around
when N
Hi
I Have a question relating to setting up users for our customers on a shared
server environment. I can not find this answer in the documentation so I am
trying here.
Is it standard practice to give the user of the database (site owner) one
set of permissions which I figure should be:
select
I don't have your exact setup installed so cannot verify this, but how about
rewriting your statement a little? I just tried this in mysql and it works
fine, so it may from php. Let me know :-)
Change the query to:
SELECT *, Rand() as MyOrder
FROM products
WHERE sale_price IS NOT NULL
ORDER BY M
Hi Heikki,
I am addressing this mail specifically to you, because I am still trying to
create a small reproducable test case. The brief description is that on
Windows MySQL 4.01 a left join query of two tables gives different results
at different times even when executed on a mysql command line.
I am able to access all of the database instances that I have created when
starting Mysql with safe_mysql(as root user). As soon as I start mysql any
other way, I keep getting the Access Denied Error. Can root only access DBs
under safe_mysql? Im completely lost here
Thanks,
DK
David Kra
Hello list,
I would like to propose two changes for mysqldump:
1) With --extended-insert, separate the data for the individual rows
with a newline (and possibly two spaces for alignment); this adds
only a byte (or three) per row, is more readable, and most
importantly (for me), it allows for dif
Mark Matthews wrote:
> Steve Hay wrote:
> | I've tried the same myself on MyISAM tables as well now, and I also
> | found that there is no problem - it only seems to happen using BDB
> tables.
> |
> | However, I need to use BDB tables rather than MyISAM to get transaction
> | support, which is r
Just a note: I tried MySQL 4.0.2 and it works fine. Seems to be only
3.23.51 built by MySQL itself that has the issue. Releases before, and
now a release after (albeit a 4.0.x version) work fine.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
>
> I have MySQL 3.23.47 running on our sever.
I've read that it is possible to use 64 indexes in MyISAM tables in MySQL.
I haven't been able to find any documentation on how to actually do this
though.
any references to appropriate documentation would be greatly appreciated.
regards
Sean Peters
[EMAIL PROTECTED]
-
On 11 Jul 2002, at 16:06, Dan Lamb wrote:
> I'd like it to order like this:
>
> aristo 156
> aristo 222
> aristo 1001
>
> How can I do this in MySQL? Is there a way to take the numbers into
> account when using order by?
There are various ways to break up your strings and convert part to a
n
Hi,
For estabilish the relationship you have to type the same same
sql command what you fire from other RDBMS like oracle.Only the
command prompt is mysql> in plance of sql>.
For more detail go to www.mysql.com and read documentations.
Thanks,
Anjani
-Original Message-
From: Otoniel Ca
Hussein,
Thursday, July 11, 2002, 12:45:38 PM, you wrote:
HM> when i change my configfile my.cnf, i have to restart my server. is
HM> there another way without restarting mysqld ?
If you change [mysqld] section, nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=
louie,
Friday, July 12, 2002, 12:06:07 PM, you wrote:
lm> http://www.mysql.com/doc/C/r/Crash_recovery.html
lm> Is this very reliable? Coz im planning to remove the --skip-locking options.
On some OS, like Linux, Windows, Solaris skip-locking is ON by
default.
Why do you want remove --skip-lock
When I try this:
SELECT article, dealer, price
FROM shop s1
WHERE price=(SELECT MAX(s2.price)
FROM shop s2
WHERE s1.article = s2.article) LIMIT 0, 100
I got this error message:
You have an error in your SQL syntax near 'SELECT MAX(s2.price)
FROM
This is funny, but my email regarding replication slave disconnect error
in 3.23.51 was bounced back as Spam and asked me to add sql,query in
message.
Whereas, Spam like this goes unnoticed.
Nilesh
-Original Message-
From: Njamba [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 5
[snip]
I'm having trouble with ordering. I've got data in a varchar field that
currently gets ordered like this when I use 'order by myfield asc':
aristo 1001
aristo 156
aristo 222
I'd like it to order like this:
aristo 156
aristo 222
aristo 1001
How can I do this in MySQL? Is there a way to
Hi,
I am new to MySQL and was needing to know about MySQL and
relationship between tables. Can it be done and if so how?
Any docs or show me how would be greatly appreciated.
Thanks in advance!
-
Before posting, p
Keith,
Thanks for your comments.
KCI> It looks like the min and max are rounded to integers. Try
KCI> "SELECT 2 BETWEEN 2.1 AND 5" or "SELECT 3 BETWEEN 2 AND 2.8".
KCI> Also, the exponential numbers are converted to integers, not
KCI> truncated at the "e". It's just that your 1e30 is too big fo
Victoria Reznichenko wrote:
>Steve,
>Wednesday, July 10, 2002, 11:12:48 AM, you wrote:
>
>SH> The bug can be reproduced as follows:
>
>SH> Create the following simple database containing just one BDB table:
>
>SH> CREATE DATABASE test;
>
>SH> CREATE TABLE foo (
>SH>id INT NOT NULL
Hi,
I am making a faq maintenance system using mysql and php.
To insert a entry in to a faq table i am using the following query:
-
INSERT INTO faq_table_netvd (id,question,
answer,netvcr,netdetector,add_date,mod_date,keyword,category,display,attach_
id)
VALUES ('0','$frm[question]',
'$fr
Subject: Re: Replication problems
From: "Jared Richardson" <[EMAIL PROTECTED]>
===
Did you change the slave number in the second slave's config file? I forget
the exact syntax, but if memory serves, there is a number in the my.ini (or
my.cnf) that must be unique. If you just copied, you may hav
Hello!
You will get problems when you set the 2nd slaves server-id the same as
other one. server-ids MUST be unique...once made that mistake too...
Greetings
Ralf
Gerald Clark wrote:
> Did you copy the master.info file over too?
>
>
> Santiago Alba wrote:
>
>> Hi All,
>>
>> I had a system re
I believe it is SELECT DATABASE();
Chris
sql,query
-Original Message-
From: Jenny Christy [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 6:41 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: How to know the current database
Hello all,
Is there any function(APIs) provided b
On 12 Jul 2002, at 14:25, [EMAIL PROTECTED] wrote:
> When the integer comparison is performed, the min & max are parsed as
> integers and anything after the first non-digit is ignored, and that
> works okay-ish for the decimal point for obvious reasons, but of
> course the exponential syntax does
Did you copy the master.info file over too?
Santiago Alba wrote:
>Hi All,
>
>I had a system replication on Linux consisting of MASTER and only one SLAVE.
>I stopped replication, I did a backup on my slave and it recreated in
>another machine so now I have two SLAVES connected to database MASTER
The server must be able to read the file, and since the server normally
runs as the user 'mysql',
it will not be able to read files sitting in root's home directory.
Put the file in /tmp, and make it readable by others.
Sofiane FAESSEL wrote:
> hello everybody
> I have a problem using mysql and
I verified his problem with 3.23.38 here using myisam files.
The key here is that the unique index is across TWO integer
fields, one of which is auto_increment.
Victoria Reznichenko wrote:
>Richard,
>Thursday, July 11, 2002, 7:26:00 PM, you wrote:
>
>RF> But the default table type is already MyI
What would you expect?
You ask for the whole file, and then ask
that it be sorted by two fields.
How do you expect this to happen without a temp file?
Tiago Antao wrote:
> Hi!
>
> I have a very simple query
> SELECT a, b FROM t ORDER BY a, b
> I also have an index on t(a)
> I have run ANALYZE
>
>>mysql> select 798 between 75.2 and 999.1;
>>++
>>| 1 |
>>++
>>
>>mysql> select 798 between 75.2 and 1e30;
>>+---+
>>| 0 |<<< Really?
>>+---
Since -p="" is not valid syntax, it should not work.
There is no equal sign after the -p, and no space between the p and the
password which needs no quotes.
If you have no password leave out the -p option.
Derek Fountain wrote:
>Hi,
>
>I have a server running 3.23.41 on Redhat 7.1. The probl
Sofiane,
Friday, July 12, 2002, 2:07:00 PM, you wrote:
SF> hello everybody
SF> I have a problem using mysql and the load data infile command. i have all my
SF> data in a text file tabulated and using load data as it is documented i
SF> receive this message
SF> "ERROR 13: Can't get stat of '/roo
Asma,
Friday, July 12, 2002, 2:15:42 PM, you wrote:
AA> does it means when a column has an index, the records inside will no longer
AA> duplicate?
Nope. It will be true if you create _unique_ index or primary key. If
you create 'simple' index column can contain duplicated records.
http://w
Hi All,
I had a system replication on Linux consisting of MASTER and only one SLAVE.
I stopped replication, I did a backup on my slave and it recreated in
another machine so now I have two SLAVES connected to database MASTER.
But I found problems. I show you the output on my database MASTER and
[EMAIL PROTECTED] wrote on 12.07.2002 12:58:00:
>
>MySQL,
>
>I'd have expected all three of the following to give the same result,
>but even if there's a type-conversion problem from INT, then I
>certainly wouldn't expect it to be different for 798.1 and 1e30 for
>example...
>
>mysql> select 798
Hi,
For first i wish to apologize for using the list with some questions which
don't have to much in common with the subject of this list.But i hope you
understand me.
Me and the organization for which i work, are interested for buying some
servers.On this servers machine we wish to install like
Matt,
- Original Message -
From: "Matt Parlane" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, July 12, 2002 8:08 AM
Subject: Next 4.0 version
> Hi all...
>
> Firstly, would I be correct in saying that there have been a whole heap of
> bugs fixed in the next versio
Hello all,
Yeah i have worked with this replication to the core
but i faced some minor problem with that
as i have to do it in two way
hence i dropped that idea and hunting for some other way to do that
so i put those words like remote entry
any way thanks a lot for your response
-
Actually
Micheal,
- Original Message -
From: "micheal" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, July 12, 2002 1:35 AM
Subject: Serious doubt about InnoDB isolation level
> Hi MySQL experts there,
> Here is the copy of the mail I sent to the author.
> ...
> 1. Accord
At 21:30 11/7/2002 -0300, [EMAIL PROTECTED] wrote:
Hi,
>I am trying to update my version and I am not getting. My current version is
>3.23.49-nt. I am using MySql in Windows 2000.
>
>When I try to install it happens the mistake -103:
>
>An error occurred during the moves date process: -103
>Compo
does it means when a column has an index, the records inside will no longer
duplicate?
if so, i can't put an index to that column because that record need to be
duplicate
At 05:50 AM 7/12/02 -0500, Mark Matthews wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Asma Aripin wrote:
>|
>
hello everybody
I have a problem using mysql and the load data infile command. i have all my
data in a text file tabulated and using load data as it is documented i
receive this message
"ERROR 13: Can't get stat of '/root/essai.txt' (Errcode: 13)"
here is the command i use
mysql> load data infil
amolsonaikar,
Friday, July 12, 2002, 9:46:45 AM, you wrote:
a> I am an oracle dba and will be shifting to mysql. I have the documentation(html)
downloaded with me and mysql on my PC (on linux) however I need to find out where
exactly I ll get the info related
a> to mysql database administration
William,
Friday, July 12, 2002, 12:45:02 AM, you wrote:
WM> I am new to MySQL and I was trying to find out how to setup a record
WM> with a datatype as a image jpg etc...
Take a look at BLOB column type:
http://www.mysql.com/doc/B/L/BLOB.html
--
For technical support contract
Robert,
Friday, July 12, 2002, 3:56:50 AM, you wrote:
RA> Im running windows 98, Apache 2.03, MySQL 3.23.51 and Php 4.0
RA> I can user all mysql's functions using php to interact with the MySQL sever
RA> but am having problems using the MySQL GUI. I can connect to the database
RA> however when
Kent,
Thursday, July 11, 2002, 9:22:52 PM, you wrote:
KH> I would use this query:
KH> SELECT DISTINCT SUBSTRING(email,LOCATE('@', email) ) FROM AddressList ;
So?
Syntax of your SQL statement is correct.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This ema
I am trying to update my version and I am not getting. My current version is
t> 3.23.49-nt. I am using MySql in Windows 2000.
t> When I try to install it happens the mistake -103:
t> An error occurred during the moves date process: -103
t> Component: servers
t> File group:
t> File:
Did you rem
Richard,
Thursday, July 11, 2002, 7:26:00 PM, you wrote:
RF> But the default table type is already MyISAM
If you didn't set up another default table type.
Please, show us the output of
SHOW TABLE STATUS LIKE "your_table_name";
Can you create a repeatable testcase?
And some more info..
Wha
Charitha,
Friday, July 12, 2002, 7:49:03 AM, you wrote:
C> Can i make mysql to put enteries in two different machines
C> If there is an entry made in mysql in local machine, is there any options
C> so that the same entry is made in the remote machine mysql db
C> If there is any option pls. let me
Steve,
Wednesday, July 10, 2002, 11:12:48 AM, you wrote:
SH> Continuing my troubles with AUTO_INCREMENT (which nobody has yet
SH> responded to), I've now ruled the Perl DBI out of the equation and
SH> reproduced the same problem using the "mysql.exe" command-line tool.
SH> Hopefully somebody w
MySQL,
I'd have expected all three of the following to give the same result,
but even if there's a type-conversion problem from INT, then I
certainly wouldn't expect it to be different for 798.1 and 1e30 for
example...
mysql> select 798 between 75.2 and 999.1;
++
| 7
The feature is called replication, there are options to restrict
replication down to table level. So I guess looking tinto the doc might
help.
Charitha wrote:
>Hello all,
>
>Can i make mysql to put enteries in two different machines
>If there is an entry made in mysql in local machine, is ther
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Asma Aripin wrote:
|
|
|
| --
| I want to select 1 record from 200,000 rows of records. I use this SQL
| statement:
|
| SELECT password FROM TableUser WHERE username='jack00'
|
| It takes me about 20 seconds just to view the password.
|
| Is t
How about:
SELECT
e1.event_id,
e1.time,
count(distinct e2.time)
FROM
events e1
LEFT JOIN events e2 USING (event_id)
GROUP BY
e1.event_id,
e1.time,
e2.event_id
HAVING
count(e2.time_id) > 1
;
I don't know if this one does it too (might work in strange MySQL SQL
Tim Ward
Brett Ward Limited - www.brettward.co.uk
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 12 July 2002 11:17
> To: Tim Ward
> Subject: Re: RE: SELECT performance
>
>
> Your message cannot be posted because it appears to be either spam or
> s
Hi!
I have a very simple query
SELECT a, b FROM t ORDER BY a, b
I also have an index on t(a)
I have run ANALYZE
Also the number of repetitions of values of a in t is very low.
My view is that the execution should require little temporary space and
little time, something like:
for each different
I wonder who to send this mail to.
So I decided to send it to the list may be someone responsible for such will
see it.
There is someone spreading spam through the MySql List.
I received this attached e-mail today
If you check correctly it was originally addressed to the list.
And that is how I en
http://www.mysql.com/doc/C/r/Crash_recovery.html
Is this very reliable? Coz im planning to remove the --skip-locking options.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
http://www.mysql.com/doc/C/r/Crash_recovery.html
Is this very reliable? Coz im planning to remove the --skip-locking options.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
> Hi everybody,
> my humble excuse to all I bothered with that ... mysql type mediumblob is
working
> perfectly, but there's another column in the tabel of type varchar
> containing mostly the same values. So that's it
> Stefan
>
> > P. S: I do the select first because I need the ID anyway.
> >
>
En réponse à Jan Kudrman <[EMAIL PROTECTED]>:
I've found it on the online documentation of MySQL.org with comments of user.
Since I've replaced the RP of RH 7.3 by RPM of MySQL.org, I don't have any
problem
Regards
Julien Sobrier
> I have receive an answer that there is a bug in MySQL rpm packa
I have receive an answer that there is a bug in MySQL rpm packages in Red
Hat 7.3 distribution.
I have tried to find any information about it but I didn't find anything
about it. There is no errata on Red Hat web site, and also other sources
hasn't any information about the bug in Red Hat 7.3 MyS
Hi,
I have a server running 3.23.41 on Redhat 7.1. The problem is that I can't
access a database as a local user, but I can as a remote user. That is, on
the local machine I get this:
>/usr/bin/mysqladmin -u tpdb -p="" create fred
/usr/bin/mysqladmin: connect to server at 'localhost' failed
er
99 matches
Mail list logo
