That seems to work fine, but now the problem is that am no longer able
to log in to the Admin utility using root and the server name of db1. I
can get in using a alternate account I created before I made the change
just fine.
Jeff Smelser wrote:
On Tuesday 30 November 2004 01:36 pm, Steve Gros
Hi,
I need to get all the details of an employee whose salary is the lowest.
I can do like this in Oracle
select * from emp where id = (select min(id) from emp).
Can we have any alternative in MySQL for the above query, as sub queries
are not supported in MySQL 4.0.21
Regards,
Naras
hello,
i m working on mysql version 4.0.18 .the documentation given for this
version will show subquries syntax which whill not work practically.
i urgently want help in this regard. can anybody mail me how can we write
the subquries in mysql version 4.0.18 ?
Eg. select * from table as t1 where
Thanks a lot for the quick response :)
We are not using MyISAM tables. All our tables are
InnoDB tables. The rational behind this decision is
that the database is expected to get hundreds of
insert queries per second, so we want the row level
locking
of InnoDB to speed this up. (I should ha
Below DDL for t_quiz_trivia
CREATE TABLE `t_quiz_trivia` (
`quiz_id` int(11) NOT NULL auto_increment,
`quiz_name` text NOT NULL,
`quiz_keycode` varchar(255) NOT NULL default '',
`quiz_pil_jwb` varchar(255) NOT NULL default '',
`quiz_confirmation_msg` varchar(255) NOT NULL default '',
`quiz_er
I am trying to execute this query and it is failing with Table is full error
(I know I can make temp tables big).
update t1, t2
set t1.XXX=1
where t1.YYY=t2. and t2. like '%X%';
My t1 has 10,00,000+ records and t2 has about 70,000 recorsds. I would like
to know how can I optimize this quer
Do you have an index on the client_id in the t_quiz table? Can you post
the ddl for t_quiz?
Ady Wicaksono wrote:
mysql> alter table t_quiz_trivia add foreign key (client_id)
references t_client (client_id) on delete set default;
ERROR 1005: Can't create table './smsserver/#sql-215d_11eff.frm'
(
Some of the vulnerabilities have been addressed in recent releases. I
would check the bug list and change log to see if your versions have
been patched. If you want to disallow all tcp/ip connections you can use
the |--skip-networking parameter. Only Unix sockets or Windows named
pipes connecti
on 11/30/04 8:53 PM, Victor Pendleton at [EMAIL PROTECTED] wrote:
> If you plan on connecting only from the localhost host or via an ssh
> tunnel you block port 3306 at the firewall or router. What exactly are
> you looking to accomplish?
Well, some friend of a friend decided to scan me and found
If you plan on connecting only from the localhost host or via an ssh
tunnel you block port 3306 at the firewall or router. What exactly are
you looking to accomplish?
Scott Haneda wrote:
I can do a telnet host.com 3386 and get a answer back from mysql. Is the
only way to turn off remote access
I can do a telnet host.com 3386 and get a answer back from mysql. Is the
only way to turn off remote access like this with a router and limit the
ports, or is there some setting in mysql that will not allow outside
connections other than from a IP range I tell it to?
--
--
mysql> alter table t_quiz_trivia add foreign key (client_id) references
t_client (client_id) on delete set default;
ERROR 1005: Can't create table './smsserver/#sql-215d_11eff.frm' (errno:
150)
May i know what makes error ?
Here is the reference table
CREATE TABLE `t_client` (
`client_id` int(1
I think he gave you the right answer.
you can also use joins instead of where, but it is the same idea, not sure
which one of the two will be faster though:
select groupid, groupname, owner.name as f_owner, creator.name as f_creator
from groups
left join users as owner on owner.uid = groups.grou
How so? Is there something you didn't understand? Peter's solution is the
right idea. You need to join the groups table to the users table once to
get the creatorname and again to get the ownername. Maybe it will be
clearer if we rewrite the query to make the join conditions explicit:
SEL
Hi, anyone has suggestions what changes to make to allow this query to run
faster?
SELECT domain FROM tbl_1
WHERE
id > 0 and id < 2
domain = "12.221.190.111"
AND score IS NOT Null
AND data LIKE "%param=search"
GROUP BY domain, data
--
every one of those WHERE clauses makes the query v
No offense but your response has created more confusion about this..
Here is a more simple diagram for what I'd like to get from an SQL query:
Table users:
uid username
1 john
2 jim
3 mary
Table groups:
id name creator owner
1 test 11
2 abc 1
I am trying to make a proper subqueryjust not sure bout the syntax
I use this this basic query to connect all of my tables:
# here is the basic query that connects all the tables..this works :)
$sql = 'SELECT playlist.name as playlist_name, artist.name as artist,'
. ' artist.'.$language.' as
Kris zoob-at-doomstar.com |Lists| wrote:
I am trying to join to tables:
users:
uid name
1 john
2 jim
3 mary
groups:
groupid groupname groupowner groupcreator
1 test1 1 1
2test2 1 2
3
Hi Lynn,
(B
(BIf you look in the archives you will find some strong recommendations
(Bagianst RH and for Suse (performance reasons). (Look for "AMD 64 bit" or
(B"perfomance")
(B
(BI am personally using Debian (sid) which you may not want to do for your
(Bproduction ;-). Suse 9.2 unfortunatel
I am trying to join to tables:
users:
uid name
1 john
2 jim
3 mary
groups:
groupid groupname groupowner groupcreator
1 test1 1 1
2test2 1 2
3 test32
At this point, what you say you are doing should work, but doesn't. We
cannot guess what's wrong. Please enter your command,
UPDATE listings SET map = CONCAT(ML, '.png') WHERE ML <> '';
get your error message, and then copy/paste the whole thing into your next
message. That way, someone sho
No, it won't. That will return every member_id that has either
specialty_id=6, or specialty_id=33, or both. Mike only wants both.
There are 2 solutions. One is the self-join proposed by Johan, although you
usually wouldn't put one of the requirements into the join condition. That
is, I woul
Graham Cossey wrote:
Am I missing something?
Will this not do the trick:
SELECT DISTINCT member_id
FROM table
WHERE specialty_id IN(6,33);
That would return any member_id with specialty_id=6 and any member_id
with specialty_id=33, i.e. member_ids with specialty_id 6 OR 33. I think
he wanted membe
Am I missing something?
Will this not do the trick:
SELECT DISTINCT member_id
FROM table
WHERE specialty_id IN(6,33);
Graham
> -Original Message-
> From: Johan Höök [mailto:[EMAIL PROTECTED]
> Sent: 30 November 2004 19:56
> To: Mike Zornek
> Cc: [EMAIL PROTECTED]
> Subject: Re: Select m
On Tue, 2004-11-30 at 11:50 -0600, Jeff Smelser wrote:
> On Monday 29 November 2004 11:35 pm, Greg Macek wrote:
> > I was thinking about this as well, but was hoping to minimize the amount
> > of work I would have to do. However, if this makes the most sense for
> > upgrading, perhaps this is what
On Tuesday 30 November 2004 01:36 pm, Steve Grosz wrote:
> I had installed MySql on Win2003, and when I check the 'server
> information' page, it shows a IP of 127.0.0.1. The IP of the server has
> a 192.x.x.x address.
Change the line below in my.cnf to what you need.. Its binding to 127 ip.
# k
Ajay Kalambur wrote:
Hi
We have been having problems with a MySql database that runs on Linux.It
just occurred suddenly and was working fine before
Details:
MySql Version:# mysql Ver 14.7 Distrib 4.1.6-gamma
The filesystems which are accessed by MySql just hang.We cannot access any
of the tables.
Are you data files on a local filesystem? When this issue occurs can you
access any regular files on the drive?
Ajay Kalambur wrote:
Hi
We have been having problems with a MySql database that runs on Linux.It
just occurred suddenly and was working fine before
Details:
MySql Version:# mysql Ver 1
Ajay,
Could you send the error messages (.err file in the mysql dir)
and your my.cnf file?
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
We have been having problems with a MySql database that runs on Linux.It
just occurred suddenly and was working fine before
Details:
MySql Version:# mysql Ver 14.7 Distrib 4.1.6-gamma
The filesystems which are accessed by MySql just hang.We cannot access any
of the tables.All clients just hang.
Hi Mike,
you should be able to do:
SELECT DISTINCT t.member_id
FROM table t
INNER JOIN table t2 ON t2.member_id = t.member_id AND t2.speciality_id = 2
WHERE t.speciality_id = 6
/Johan
Mike Zornek wrote:
I'm very much a noob when it comes to MySQL .. Historically I've only used
it for storage. I nee
I had installed MySql on Win2003, and when I check the 'server
information' page, it shows a IP of 127.0.0.1. The IP of the server has
a 192.x.x.x address.
I'm asuming that this might have a problem why I can't telnet to it to
make sure the DB is working??
How can I change this, or do I need
I'm very much a noob when it comes to MySQL .. Historically I've only used
it for storage. I need help.
I have a table:
++---+--+-+-+---
-+
| Field | Type | Null | Key | Default | Extra
|
+--
I just received a box with the following specs:
Dual AMD64
8G ram
Two 3ware 2.4 terabyte RAID 5 arrays.
My company has been using Redhat for most of its production machines.
1. Does anyone have any success/horror stories running MySQL 4.0.x
on RHES 3/ AMD64?
2. Does anyone have alternate recommenda
That did not do it. I'm still getting the same error message (?)
Tom
On Nov 30, 2004, at 2:09 PM, gerald_clark wrote:
Thomas McDonough wrote:
I'm trying to set all the values of column 'map' to the value of
column ML and '.png'. My intuition and an extensive reading of the
manual and mail arch
Thomas McDonough wrote:
I'm trying to set all the values of column 'map' to the value of
column ML and '.png'. My intuition and an extensive reading of the
manual and mail archives tell me to do it like this:
mysql> update listings set map= concat (ML, '.png') where ML<>'';
mysql> update list
Thomas McDonough wrote:
I'm trying to set all the values of column 'map' to the value of column
ML and '.png'. My intuition and an extensive reading of the manual and
mail archives tell me to do it like this:
mysql> update listings set map= concat (ML, '.png') where ML<>'';
but all I get is thi
Gleb Paharenko wrote:
Hello.
There is a variable sort_buffer, which you can set with -O sort_buffer=xxxM or
in my.cnf.
myisamchk -o -p -f --sort_key_blocks=512M - -key_cache_block_size=512M
it's no longer -O sort_buffer=xxxM
it's now --sort_key_blocks
and I set it to 512M and it still s
I'm trying to set all the values of column 'map' to the value of column
ML and '.png'. My intuition and an extensive reading of the manual and
mail archives tell me to do it like this:
mysql> update listings set map= concat (ML, '.png') where ML<>'';
but all I get is this:
ERROR 1064 (42000): Y
Well, I think you've just succeeded in demolishing my wonderful example; it
turns out that we don't need to use a stored procedure to find a median
after all ;-)
You're right that the algorithm I described in my original reply is a bit
simplified and assumes an odd number of rows; it doesn't handl
On Monday 29 November 2004 11:35 pm, Greg Macek wrote:
> I was thinking about this as well, but was hoping to minimize the amount
> of work I would have to do. However, if this makes the most sense for
> upgrading, perhaps this is what I'll do.
Actually, I think you will be minimizing going the 4.
Dinçer Akay wrote:
Hi,
My Table
No | Type | ID
[snip]
Select random "No" (i know rand())
Select two row (i know limit 0,2)
Select Type v,h or h,v but dont want v,v or h,h
How about selecting one random row where "Type" is v and one where
"Type" is h and then UNIONing the two record se
Sasha,
> Ronan:
>
> InnoDB complains it cannot allocate memory. With your configuration you
are
> likely to run out of memory:
>
> You are telling InnoDB to allocate at least 256 MB + 20 MB for the buffer
pool.
> On top of that, you are telling MyISAM to use 384 MB for the key buffer.
So this
> is
Hi,
My Table
No | Type | ID
1v 3233
2h 5123
3v 1345
4v 5457
5h 8756
6h 8757
7v 8067
Select random "No" (i know rand())
Select two row (i know limit 0,2)
Select Type v,h or h,v but dont wa
Ah! Many thanks. That appears to be our problem here:
mysql> show variables like 'colla%';
+--+---+
| Variable_name| Value |
+--+---+
| collation_connection | latin1_swedish_ci |
| collation_database | u
Hello,
I think your tables have a collation different from the connection collation.
Open mysql client:
mysql> show variables like 'colla%';
+--+---+
| Variable_name| Value |
+--+---+
| collation_connection
Hello.
There is a variable sort_buffer, which you can set with -O sort_buffer=xxxM or
in my.cnf.
matt_lists <[EMAIL PROTECTED]> wrote:
> Are these critical errors? It keeps on going, saying it's fixing records
>
> I tried doing a check table on the main server, it's been running a wee
Hello.
Think about merge storage.
http://dev.mysql.com/doc/mysql/en/MERGE_storage_engine.html
Alok Gore <[EMAIL PROTECTED]> wrote:
> Hi All,
> I tried digging for this information in the archives but could not
> find anything.
> I am in to developing an app. that uses very high a
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Debugging_server.html
"Scott Tanner" <[EMAIL PROTECTED]> wrote:
> I've been having this issue as well, happening more frequently to our
> production web /ejb servers. I've increased the logging to warning level,
> but my logs don't conta
If you are hitting file size limits, you probably want to look into
using the InnoDB table type. That will allow you to work around file
size limits and have a database of just about any size you need. You
won't end up having a 30GB file, but multiple smaller files which will
be transparent to
Ever since we upgraded to 4.1.7, we've been seeing a lot of errors
similiar to this one:
ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT)
and (latin1_swedish_ci,COERCIBLE) for operation 'locate'
The query which generated this particular error is this:
SELECT COUNT(*) FR
[EMAIL PROTECTED] wrote:
news <[EMAIL PROTECTED]> wrote on 11/30/2004 07:58:18 AM:
Michael J. Pawlowsky wrote:
Because you will be downloading 500,000 rows... And I don't really
think that was the point. Who cares what the example is. Personally I
was quite impressed with great explanation.
I se
"I just wish that MySQL was a year or two further along than it is so
that 5.x would be fairly mature and we could actually start coding
stored procedures, views, etc"
Oh indeed, neither can I! Not just procedures and views either, but also
triggers and sequences! And a job scheduling system w
Hello,
I happen to be in a position to utilize a 6GB FC solid state disk (RAM
based with battery and disk backup) on our new storage area network.
I haven't ever used an SSD for MySQL before, but I am aware of the
potential performance benefits. My question is, does anyone have any
suggestions
- Original Message -
From: "Mark Leith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 30, 2004 10:47 AM
Subject: RE: Stored Procedure?
> I think a much better example of store procedures is one showing actual
> procedural processing. Whilst they also allow a lot le
- Original Message -
From: "Wolfram Kraus" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 30, 2004 10:04 AM
Subject: Re: Stored Procedure?
> Heyho!
>
> [EMAIL PROTECTED] wrote:
> > news <[EMAIL PROTECTED]> wrote on 11/30/2004 07:58:18 AM:
> >> Michael J. Pawlowsky w
I think a much better example of store procedures is one showing actual
procedural processing. Whilst they also allow a lot less communication
over the network, and a lot less SQL knowledge for the "user"(!) - a
stored procedure is also a way of doing all the work that you currently
get the "client
Hi All,
I tried digging for this information in the archives but could not
find anything.
I am in to developing an app. that uses very high amount of data
(Close to 80 GB per machine). It has 3-4 logical tables. But I have to
partition them in to multiple tables because the mysql table size
Well i´m having another problem with ibdata1. It´s too big. I looked
at mysql documentation and as it looks for i don´t have a way to
reduce ibdata1´s size except following those passes from below:
-Dump the content of databases
-Stop the server
-delete a ibdata file and iblogfiles
-start the serv
Heyho!
[EMAIL PROTECTED] wrote:
news <[EMAIL PROTECTED]> wrote on 11/30/2004 07:58:18 AM:
Michael J. Pawlowsky wrote:
Because you will be downloading 500,000 rows... And I don't
really think that was the point. Who cares what the example is.
Personally I was quite impressed with great explanatio
news <[EMAIL PROTECTED]> wrote on 11/30/2004 07:58:18 AM:
> Michael J. Pawlowsky wrote:
> > Because you will be downloading 500,000 rows... And I don't really
> > think that was the point. Who cares what the example is. Personally I
> > was quite impressed with great explanation.
> I second tha
Are these critical errors? It keeps on going, saying it's fixing records
I tried doing a check table on the main server, it's been running a week
and who knows how long that'll take
myisamchk -o -p -f --sort_key_blocks=512M - -key_cache_block_size=512M
--read_buffer_size=8M 321st_stat
- paralle
Michael J. Pawlowsky wrote:
Because you will be downloading 500,000 rows... And I don't really
think that was the point. Who cares what the example is. Personally I
was quite impressed with great explanation.
I second that it was a great explanation! Please don't get me wrong!
And furthermore I
Because you will be downloading 500,000 rows... And I don't really
think that was the point. Who cares what the example is. Personally I
was quite impressed with great explanation.
I would have simply said a chunk of code that runs on the server that
the client can call. And this guy took the
Hi,
your question suggests that you have installed MySQL already. Just
install the upgrade in the same way. Start reading at chapter 2.2.
If you got MySQL pre-installed with your operating system, you will need
an upgrade from your distributor anyway. The paths built in the official
MySQL binarie
Hi,
Am Mo, den 22.11.2004 schrieb Danesh Daroui um 16:29:
...
> /*> mysql -h 127.0.0.1 -u root -p
> Error 1045 (28000): Access denied for user
> 'root'@'localhost.localdomain'. (using password YES)
> */
this might be a problem in your DNS. It resolves 127.0.0.1 to
'localhost.localdomain' instea
[...]
Suppose you have a table with a million records, test scores from a widely
taken exam for example. You need to find the median mark - NOT the
average! - so your algorithm needs to read all million records, sort them
into ascending or descending sequence by the test score, then read exactly
ha
Hi all!
I would like to know if it's possible to compile a custom 4.0.22 server
including some functionality from 4.1.x source tree. The functionality I
would like to include it's neither critical nor substantial. Basically, what
I would like to include is the COMPRESS / UNCOMPRESS functions (
69 matches
Mail list logo
