Hi Kevin,
I'm a system administrator for a small (200 people) branch of a large
university/medical school. I've worked with MySQL and use it as my database
of choice for web-based dynamic content. I would not consider myself an
experienced, professionally-trained, knowledgeable database
Martijn, thank you very much for your analysis. I hope others will continue to join in.
With regard to your point quoted below, are you referring to PostgreSQL, and would
that be a
stronger competitor to MS SQL Server 2000 than either the current version of MySQL or
MySQL 5?
Thanks, again, for
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will continue to join in.
So do I :-)
With regard to your point quoted below, are you referring to PostgreSQL,
and would that be a
stronger competitor to MS SQL Server 2000 than either the current version
of MySQL or
I have not work with it but postgres is supposed to work great in
/BSD/Linux/Unix/solaris environment
Which platform are you using?
:-)
Nestor A. Florez
Martijn Tonies [EMAIL PROTECTED] 11/7/2003 10:08:53 AM
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will
It sounds like a copy and paste from Microsoft, but that is just my
guess. An objective recommendation with show pluses and minuses of
both. It most definitely does not sound like this consultant is
qualified to suggest a database product. What about PostgresSQL,
Oracle, Sybase, DB2? They all
Nestor, thanks for your question.
The platform will actually be dictated by the SQL engine, not the
other way around, which is more typically the case. If we go with
MS SQL Server, we'll build a separate host, NT I would guess, to
host it. I'm only responsible for Unix and Linux boxes here, so
that do
very nicely without them. Why are you different?
John Griffin
-Original Message-
From: KEVIN ZEMBOWER [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:53 PM
To: [EMAIL PROTECTED]
Subject: Re: Need help comparing MySQL to MS SQL Server
Nestor, thanks for your question
kevin,
i tend to think the consultant really just read something that microsoft
sent him. it doesn't sound like he's qualified to suggest one database
or another.
We've been usinf mysql for a year now. We use InnoDB tables, which give
us primary key/foreign key constraints and transactions.
Hi, List,
I looked here:
http://www.mysql.com/doc/en/String_comparison_functions.html
But I am not seeing what I need.
I want to do a string comparison like this:
SELECT * FROM sometable WHERE surname LIKE '[A-C]%' ORDER BY surname;
This works in another RDBMS. It doesn't return a syntax
This should work for you:
SELECT * FROM sometable WHERE surname BETWEEN 'A' AND 'D' ORDER BY
surname
In my quick test the first parameter is inclusive while the second is
not, which is why it is D and not C.
On Thursday, October 30, 2003, at 02:22 PM, Scott Brown wrote:
I want to do a string
You can use RLIKE which is regular expressions then you should be able to execute
SELECT * FROM sometable WHERE surname RLIKE '^[A-C]' ORDER BY surname;
Kelley
Scott Brown wrote:
Hi, List,
I looked here:
http://www.mysql.com/doc/en/String_comparison_functions.html
But I am not seeing
Thanks for all of the responses!
Actually, Brent Baisley wins the syntax question of the day. The BETWEEN
syntax is what I needed.
REGEXP and RLIKE do not return any records, they return a count of the
number of rows matching the expression.
Thanks!
--Scott Brown
At 11:22 AM 10/30/2003, you
Thanks so much Brent, this is what I was looking for.
However, what do I do when I get to 'Z'?
I looked here, and now I am really confused:
http://www.mysql.com/doc/en/Comparison_Operators.html
It seems to say that BETWEEN returns a rowcount as well?
I am guessing that these all return
Oh, well, chalk it up to experience. RLIKE is what works the way I want. DOH!
Thanks,
--Scott Brown
At 12:34 PM 10/30/2003, you wrote:
Thanks so much Brent, this is what I was looking for.
However, what do I do when I get to 'Z'?
I looked here, and now I am really confused:
The BETWEEN operator works like and greater and less than search.
So, you can do the exact same query like this:
SELECT * FROM sometable WHERE surname='A' AND surname'D'
MySQL may actually optimize them the same way, but using BETWEEN is
more readable.
To include 'Z', just do a greater than
: Need help on WHERE ... LIKE Query
The BETWEEN operator works like and greater and less than search.
So, you can do the exact same query like this:
SELECT * FROM sometable WHERE surname='A' AND surname'D'
MySQL may actually optimize them the same way, but using BETWEEN is
more readable
]
: Cc: [EMAIL PROTECTED]
: Subject: Re: Need help constructing query ...
:
:
: - Original Message -
: From: Daniel Clark [EMAIL PROTECTED]
: To: [EMAIL PROTECTED]
: Cc: [EMAIL PROTECTED]
: Sent: Tuesday, October 21, 2003 2:33 PM
: Subject: Re: Need help constructing query
I have a single table that I need to pull info from can anyone help?
Table: Product
Fields: Itm_Code, Itm_Color, Itm_Size, Itm_Price, Itm_Desc, otherjunk
Primary Key(Itm_Code,Itm_Color,Itm_Size)
I am using ColdFusion MX as my programming language, CF does not permit
queries within queries.
Hi, I have a table full of logged urls and ip addresses. The following query
returns all the urls and the number of requests. How would I modify it to return
unique requests based on distinct ip addresses?
select url, count(*) as pageviews from table group by url order by pageviews
desc
--
Hi, I have a table full of logged urls and ip addresses. The following
query returns all the urls and the number of requests. How would I
modify it to return unique requests based on distinct ip addresses?
select url, count(*) as pageviews from table group by url order by
pageviews desc
- Original Message -
From: Daniel Clark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 2:33 PM
Subject: Re: Need help constructing query ...
: Hi, I have a table full of logged urls and ip addresses. The following
: query returns all
Then I think you want
SELECT url, COUNT(DISTINCT ip_address)
FROM tablename
GROUP BY url;
-Original Message-
From: John Kelly [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 3:45 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Need help constructing query
: -Original Message-
: From: John Kelly [mailto:[EMAIL PROTECTED]
: Sent: Tuesday, October 21, 2003 3:45 PM
: To: [EMAIL PROTECTED]
: Cc: [EMAIL PROTECTED]
: Subject: Re: Need help constructing query ...
:
:
: - Original Message -
: From: Daniel Clark [EMAIL PROTECTED
I have a table name product defined as follows:
Item_Code
Item_Size
Item_Color
Item_img
Description
Cost
Retail_Price
Category
and other non-essential items, such as qty based on code,size,color
The data is as follows:
j2400 S BLK j2400blk.jpgBlack Jacket12.00 24.00 Jacket
Patrick Shoaf [EMAIL PROTECTED] wrote:
I have a table name product defined as follows:
Item_Code
Item_Size
Item_Color
Item_img
Description
Cost
Retail_Price
Category
and other non-essential items, such as qty based on code,size,color
The data is as follows:
j2400 S BLK
I loaded MySQL 4.1, but now the text is gibberish in the Group_Concat field
SELECT Cat_Item_Img,Cat_Price,Product.Item_Code,GROUP_CONCAT(Item_Size
SEPARATOR ;) as sizes,Item_Img,
Description,Category,Retail_Price,Short_Desc,Product.Item_Color
FROM Cat_Items,Product
WHERE cat_code =BoltTech and
- Original Message -
I would use MySQL CC (command center, I think...)... I seem to remember
someone mentioning that mysql gui is discontinued...
CC is available from the mysql.org site, and is very easy to install on
windows xp (it's on my laptop...)
/originalmessage
I second that.
To whom it may concerned,
I am a web development support person working for North Carolina AT State
University. I am involved in a library project right now which requires a
MySQL free software installed on my computer so I can create a mysql database
for the project. By searching the internet
PROTECTED]
Sent: Monday, September 08, 2003 2:34 PM
To: [EMAIL PROTECTED]
Subject: Need help with the download of the Mysql GUI
To whom it may concerned,
I am a web development support person working for North
Carolina AT State
University. I am involved in a library project right now
Dan Greene wrote:
I would use MySQL CC (command center, I think...)... I seem to remember someone
mentioning that mysql gui is discontinued...
You remember right, the MySQL GUI IS discontinued. Why it is still
availiable for download, ask MySQL
Jakob
^--
To Unix or not to Unix. That is
: [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 6:18 AM
Subject: Re: Need help with oracledump (contributed program)
On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote:
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have
PROTECTED]
Subject: Re: Need help with oracledump (contributed program)
On Mon, Sep 01, 2003 at 11:09:02AM -0700, Martin Gainty wrote:
Doug
I copied this from an SAP integration with Orace site
http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/htm
l/5-odbc.htm
5.5.3 tsnames.ora
On Tue, Sep 02, 2003 at 12:25:35PM +0100, Jim Smith wrote:
A TNSNAMES file isn't going to help unless you have the Oracle
client software installed. If you had the software, you would
already have a tnsnames file.
Thanks all for your help. I've found a free java-based application
Hello,
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle dump command seems to be looking for a SID in a file called
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle dump command seems to be looking for a SID in a file called
On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote:
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle
.
*OracleDump is performed by (SID=ORCL)*
Keep us apprised to your progress...
Marty Gainty
- Original Message -
From: Doug Poland [EMAIL PROTECTED]
To: Jim Smith [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 6:18 AM
Subject: Re: Need help with oracledump (contributed
Hi all,
I need help changing host privileges in mySQL server. I am trying to
access mySQL server from a remote computer that doesn't have access
rights. The online doc sucks; I can't get anything useful out of it. A
step-by-step instruction on how to change it would be greatly
appreciated
Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html
Saqib Ali
-
http://www.xml-dev.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Absolutely! I have multiple indexes. I think it might be a problem with ODBC
Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html
Saqib Ali
-
http://www.xml-dev.com
-
Visit CARMEL MUSIC ENTERTAINMENT website
Two Questions:
Is the same query running directly on the linux server thru mysql is also very slow ?
Have you done a explain plan on the query ?
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
list?
Which parts of the process are slow? How does the query perform from the
mysql command line?
-Original Message-
From: Apollo (Carmel Entertainment) [mailto:[EMAIL PROTECTED]
Sent: 19 August 2003 17:29
To: [EMAIL PROTECTED]
Subject: Need help optimizing query, awfully slow
: Wednesday, August 20, 2003 2:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
When following query is pulled up, it takes about whole 1-2
minutes to come up. inquiries table has 17000 records,
contacts
Query takes 3.4 seconds to run on the server, but it takes 1-2minutes to run via
MyODBC 3.51.06 using passthrough (Access97 is the front end, but it has query
type that allows bypass of Access interpretation.
Two Questions:
Is the same query running directly on the linux server thru mysql is
To: Michael S. Fischer
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
Result of EXPLAIN is:
table|type|possible_keys|key|key_len|ref|rows|Extra
inquiries|ALL|contact_id| | | |8253|Using filesort
individual_contacts|eq_ref
]
Sent: Wednesday, August 20, 2003 3:14 PM
To: Michael S. Fischer
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
Result of EXPLAIN is:
table|type|possible_keys|key|key_len|ref|rows|Extra
inquiries|ALL|contact_id| | | |8253
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
When following query is pulled up, it takes about whole 1-2
minutes to come up. inquiries table has 17000 records,
contacts has about 7000, individual_contacts has about
1.2Ghz Pentium, with 1/2Gig of ram, 4.0.14MySQL, RedHat9.0
I have about 20K records that result from the following query. Front end for the
database is ACCESS97 and pulling up 20K records makes a huge performance hit.
For the form in question I am using PASSTHROUGH type query (the one that just
I am working on a Windows 2000 server.
The version 4.0.13 was installed at the end of June because we are looking
at using MySQL.
Me and the other guy are novice with MySQL.
I read the different emails about access and granting and password and
flushing privilege from other people who couldn't
thanks. I wanted a confirmation.
I did it and moving on installing v4.0.14
-Original Message-
From: Frank Tanner III [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 1:19 PM
To: [EMAIL PROTECTED]
Subject: Re: win200 - lost root privilege - cannot shutdown - need help
Right click
SELECT [field list] FROM archivetable,currenttable WHERE
archivetable.username=currenttable.username
notes: can use join,left,right,select inside select aka subselect check
the manual for detail
Regards,
--
Aftab Jahan Subedar
Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha
Hi,
I have a table:
mysql describe archivetable;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| sessionid | char(10) | | PRI |
Hi,
On Fri, Aug 01, 2003 at 11:55:36PM +0800, Jaime Teng wrote:
Now, I have two of these tables (archivetable,currenttable).
My problem is how do I perform a single query such that I get
results from these two tables:
mysql select * from archivetable,currenttable;
* Jaime Teng
[...]
Now, I have two of these tables (archivetable,currenttable).
My problem is how do I perform a single query such that I get
results from these two tables:
mysql select * from archivetable,currenttable;
+++-+-+
I know this is the mysql mailing list but I have tried the Fuse mailing list
and no one will help well what im wanting to know is how could I get more
avatars show in a room like I already have it where all users that are
logged in control this 1 avatar im trying to make it where every user has
At 15:15 -0500 7/18/03, Kyle Goetz wrote:
hey, i'm new to mySQL...this meaning that i have tried ~1 times to
install it and get it working over the past few weeks...and it always gives
me the same error (scroll further down to see it) despite following the
manual's windows installation exactly
hi dear mysql list members
i have setup a mysql database 4.013 with innodb enabled. when i set the transaction
isolation level to serializable. after executing a specific query is the insertion
into a table blocked for about 20 seconds. the table is defined as follows
CREATE TABLE
hi
i solved the problem by executing the commit after the select.
best regards
benny
hi there,
I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've
created directory /home/users/mysql and add group for mysql. Those are the
command that I've used previously:
shellgroupadd mtsqlid
shellmkdir /home/users
shelluseradd -d /home/users/mysql -s /bin/false -g mysqlid
Type the command
echo $PATH
You will see a set of semicolon delimited directory path names. Perhaps
something like
/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/X11R6/bin
The configure script is looking in each of these locations for an
acceptable C compiler. Either you do
Compiling MySQL from the source tarball is not for linux newbies.
Get the RPMs.
root wrote:
hi there,
I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've
created directory /home/users/mysql and add group for mysql. Those are the
command that I've used previously:
shellgroupadd
I disagree, even though I had my own share of problems in compiling 4.0.13.
The clue is in the error message
configure:error: no acceptable C compiler found in $PATH
It is very likely that if he typed
which cc or which gcc
the reply would come back
No cc (gcc) in ... (a list
At 17:42 -0500 7/6/03, Greg Donald wrote:
my coulmn (id) is an auto_increment coulmn and lets say that i have 100
entries, so the problem is that when i delete all entries on my table, the
column (id) starts from 101 ,shouldn't is starts from 1 again!
please i need help with this
Use truncate
At 4:20 -0500 7/7/03, Anthony Scism wrote:
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL |
|
| observing_site |
Hi Antony,
Eventually key is a reserved word ?? ;-)
nice one !!
Best regards
Nils Valentin
Tokyo/Japan
2003 7 7 18:20Anthony Scism :
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time
:
Thank you very much, I should have thought of that.
-Original Message-
From: Nils Valentin [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 4:34 AM
To: Anthony Scism; [EMAIL PROTECTED]
Subject: Re: need help with select statement
Hi Antony,
Eventually key is a reserved word
I would appreciate some help with a problem. I'm trying to create two
tables that have referential integrity.
If I try and create the following table it works fine:
CREATE TABLE book
(
sku INT
) TYPE=INNODB;
However, if I creating this table, I get an error:
CREATE TABLE book
(
sku INT,
You must create the key (sku), it is not created for you.
Tom Gazzini wrote:
I would appreciate some help with a problem. I'm trying to create two
tables that have referential integrity.
If I try and create the following table it works fine:
CREATE TABLE book
(
sku INT
) TYPE=INNODB;
However,
Please ignore my last email. I made a nauseatingly dumb error in the
book table (sku should be CHAR(14), not INT).
The only help I need is to get some sleep.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
my coulmn (id) is an auto_increment coulmn and lets say that i have 100 entries, so
the problem is that when i delete all entries on my table, the column (id) starts from
101 ,shouldn't is starts from 1 again!
please i need help with this
my coulmn (id) is an auto_increment coulmn and lets say that i have 100
entries, so the problem is that when i delete all entries on my table, the
column (id) starts from 101 ,shouldn't is starts from 1 again!
please i need help with this
Use truncate table, it will reset the auto_incement
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
- Original Message -
From: Greg Donald [EMAIL PROTECTED]
To: wael fareed [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, July 06, 2003 4:42 PM
Subject: Re: need help
my coulmn (id
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
alter table table_name auto_increment = 1;
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I did post a request for help earlier today, on how to select rows from
two tables based on missing information in a third. I have now come some
way on my own. I have two different queries that together does what I want.
But I don't know how to combine them to one. Would appreciate any
This is a reprise of a question I asked some months ago. Bruce Feist and Tore Bostrup
gave me some untested code to try. I've only now been able to try it, and it's not
quite working right. Here's a recap of the problem I'm trying to solve:
My Web host is running MySQL 3.23, which doesn't
- Original Message -
From: Sheryl Canter [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 22, 2003 2:46 PM
Subject: need help with subselect workaround
This is a reprise of a question I asked some months ago. Bruce Feist and
Tore Bostrup gave me some untested code to try. I've only
-Original Message-
From: Fred van Engen [mailto:[EMAIL PROTECTED]
Sorry, you'll need a backup. If your backup is not recent
enough and you
have a binary log (e.g. for replication), you can use that
log to restore
the database state.
If you have a backup and the update log
Hi,
On Fri, Jun 13, 2003 at 02:08:33PM -0700, jack ma wrote:
I had updated a field for all the entries in a table
by mistake, I need to undo that step. I dont have the
database back up to an stisfactory level. Is there a
way in MySQL I can step one action back? or undo one
command that I
Hi guys,
I had updated a field for all the entries in a table
by mistake, I need to undo that step. I dont have the
database back up to an stisfactory level. Is there a
way in MySQL I can step one action back? or undo one
command that I just did??
Thanks a lot guys!?
there. When I
upgraded to 4.0.12 I just moved the data folder from the old installation to
the new installation.
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 1:53 AM
To: [EMAIL PROTECTED]
Subject: Re: Need help with an update
The OS upgrade
I have no idea. sorry.
Sibananda Sahoo wrote:
Thanks for your reply. Could you please tell me is it
possible to achieve foreign key constraint in MySQL
3.23.56.
Rgds,
Sibananda
--- Jeff Mathis [EMAIL PROTECTED] wrote:
i'm not an expert by any means :)
but, you do need indexes
]
Subject: Re: need help
I have no idea. sorry.
Sibananda Sahoo wrote:
Thanks for your reply. Could you please tell me is it
possible to achieve foreign key constraint in MySQL
3.23.56.
Rgds,
Sibananda
--- Jeff Mathis [EMAIL PROTECTED] wrote:
i'm not an expert by any means :)
but, you
Here is the scenario.
I was running 3.23.39 that came with BSD/OS 4.3 ,
All the databases were running active.
I upgraded to BSD/OS 5.0 which has Mysql 3.23.49 and
suddenly NO databases are seen.
Everything is where is is supposed to be, but the mysqld
is not seeing the DBs that were running
. ;)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: System Administrator a.k.a. The Root of the Problem
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, 11 June, 2003 19:15
Subject: Need help with an update
Here is the scenario.
I was running
: Need Help About mysql.sock ERROR
You have several options, here is, I think, the easiest:
First you need to locate the sock file. The location depends on the
distribution (in my system is in /tmp). Use find / -name mysql.sock. On
some distributions the name can be slightly different, for example
i'm not an expert by any means :)
but, you do need indexes on both the primary key and the foreign key.
you've got one on foo_id, but you also need on on foo_value.
check the lists for more information. there's been plenty of discussion
lately ...
good luck
Sibananda Sahoo wrote:
Dear Sir
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I use MDK 8.2 and MySQL 4.0.13
i found this error
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Can anyone help me to solve this problem ?
a symbolic link in '/var/lib/mysql/' pointing mysql.sock
Ernesto
- Original Message -
From: Pratchaya Chatuphian [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 09, 2003 11:50 PM
Subject: Need Help About mysql.sock ERROR
ERROR 2002: Can't connect to local MySQL server through
Hi...
Thanks to the great help on this list (including Juan), I was able to get postfix
working with mysql. Now, of course, I need to be able to read the mail being
forwarded. :) Due to restrictions beyond my control, it needs to be a pop3 server - I
would prefer IMAP, but pop3 it is. And
Hi
I know that you may set max binlog size with the max_binlog_size variable.
However, is it possible to control the size of the relay-bin logs on the slave
servers as well ?
Will the relay-bin logs be deleted automaticly by mysqld or are there a
manuall procedure for doing this ?
I am running
On Fri, Mar 28, 2003 at 06:10:55PM +0100, Vidar wrote:
Hi
I know that you may set max binlog size with the max_binlog_size
variable. However, is it possible to control the size of the
relay-bin logs on the slave servers as well?
I don't believe it's documented (yet?) but I seem to remember
Hi,
I'm working for a client that has an auction application using MySQL.
We have a program to simulate the load when N users have an auction
page open. The auction page pings the server for updates every
few seconds, and that ping results in two UPDATEs and 64 SELECTs.
I have cut the
On Friday 07 March 2003 00:43, Chris Montgomery wrote:
I have been using MS Access for 5+ years and am new to MySQL. I
understand the theory behind setting relationships between tables, but
am trying to get up to speed in how to do it in MySQL.
My environment: Win2k and MySQL 3.23.54
Howdy Egor,
Friday, March 7, 2003, 7:36:00 AM, Egor Egorov wrote:
Both columns Node are indexed, so just add foreign key constraint. You can
find examples in the InnoDB manual:
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
I've looked at the examples, but one thing it doesn't
Disregard my previous msg. It looks like I have it figured out.
Friday, March 7, 2003, 5:31:38 PM, Chris Montgomery wrote:
I've looked at the examples, but one thing it doesn't mention is whether
both indexes need to be unique. In the primary table they are, but does
the index in the table
Howdy,
I have been using MS Access for 5+ years and am new to MySQL. I
understand the theory behind setting relationships between tables, but
am trying to get up to speed in how to do it in MySQL.
My environment: Win2k and MySQL 3.23.54
Here's what I want to do: I have two tables, categories
Hello mysql,
I have 2 tables :
Table1:
col1
col2
col3
DataSource
Table2:
col1
col2
col3
DataDestination
How to update Table2.DataDestination with value of Table1.DataSourse
where table1.col1=table2.col2 and table1.col2=table2.col2 and
table1.col3=table2.col3
--
This should do what you want:
UPDATE Table2, Table1 SET
Table2.DataDestination=Table1.DataSource WHERE
Table1.col1=Table2.col1 AND Table1.col2=Table2.col2
AND Table1.col3=Table2.col3;
--- PandaCoop-Krasimir_Slaveykov [EMAIL PROTECTED]
wrote: Hello mysql,
I have 2 tables :
Table1:
On Thursday 20 February 2003 09:28, saravanan saravanan wrote:
I am using mysql for my project.I am finding
problems of using FOREIGN KEY and STORED procedures in
version 4.0.please help me and send the details as
earlier as possible
Stored Procedures are not supported in MySQL yet.
501 - 600 of 912 matches
Mail list logo