Dear Sirs and Ladies,
I tried to put some keys on a large table (more than 100.000.000 in 13G)
with the Statement:
ALTER TABLE mytable
ADD INDEX i1 (COL1(4)),
ADD INDEX i2 (COL2(4)),
ADD INDEX i3 (COL3(12)),
ADD INDEX i4 (COL4(12)),
ADD INDEX i5 (COL5(5)),
ADD INDEX i5 (COL6(11));
After about 7
Check the connection timeout parameter. Increase it if it's low and try..
>>> "W. Bauer" <[EMAIL PROTECTED]> 10/16/2003 6:20:44 PM >>>
Dear all
When I run a query on a table with about 22 Mio records and three columns of
type bigint, I get a Error 2013 Lost connection to MySQL server during
que
I think, if I understand this right, that the problem is the
int(1) which limits the index to only the first digit,
try to change that to int(11) or something like that, and see if that cures it.
Kelley
Ganbold wrote:
> Hi,
>
> I'm having some trouble running one query. I'm using FreeBSD 4.8 wi
Hi,
I'm having some trouble running one query. I'm using FreeBSD 4.8 with
linuxthread enabled mysql-4.0.14.
Server has 1GB ram and SCSI hard disk.
I need to get size of email message which is stored in MyISAM table.
The problematic query is:
select sum(size) from message where uid='2945';
---
Hi Dan,
Instead of skip-networking, use bind-address in my.cnf:
bind-address=192.168.0.1
I think you can just specify 1 IP like that. So... you either have 1)
listening on no IP (skip-networking), 2) listening on 1 IP
(bind-address), or 3) listening on all IPs (the default).
BTW, I think even w
* Kim G. Pedersen
> I looking for a way to convert a datestring to date value
> example
> UnknowFunction('23.03.68','dd.mm.yy') -> unixtimestamp
>
> In oracle we have
> to_date('23.03.68','dd.mm.yy')
>
> I have search the net for hours without luck.
Unix timestamps starts at 01/01-1970, your exa
I have MySQL running on a Linux box with two network interfaces - one is
a routable IP that connects to my DSL bridge and the other is a
non-routable IP (192.168.1.*) that connects to my internal LAN. I'd
like MySQL to be available on the internal interface but not to be
available on the interface
* Kim G. Pedersen
> I looking for a way to convert a datestring to date value
> example
> UnknowFunction('23.03.68','dd.mm.yy') -> unixtimestamp
>
> In oracle we have
> to_date('23.03.68','dd.mm.yy')
>
> I have search the net for hours without luck.
Unix timestamps starts at 01/01-1970, your exa
Thanks all, it helped me a lot
Manisha
- Original Message -
From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; "Manisha Sathe"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 10:56 PM
Subject: Re: PASSWORD() function problem
* Michael Winston
> At 2:06 PM -0500 10/16/2003, Dan Nelson wrote:
> >In the last episode (Oct 16), Michael Winston said:
> >> Is there any way to do "natural sorting" in MySQL? That is:
> >> Chapter 1
> >> Chapter 2
> >> Chapter 10
> >>
> >> instead of
> >>
> >> Chapter 1
> >> Chapter 10
>
* Andreas Ahlenstorf
> I'm having a tricky problem: I've got a database table (PicklistData
> with three fields, which I have to use for a join to get the data,
> which is associated with them. They are called EAN, ISRC and
> LabelProductCode. Until now, there's nothing difficult. But a thing,
> w
Hello
I looking for a way to convert a datestring to date value
example
UnknowFunction('23.03.68','dd.mm.yy') -> unixtimestamp
In oracle we have
to_date('23.03.68','dd.mm.yy')
I have search the net for hours without luck.
Regards
Kim G. Pedersen
macaos/elprint Development
+45 35373808
--
On Thursday, October 16, 2003, at 01:36 PM, Jeremy Zawodny wrote:
On Wed, Oct 15, 2003 at 06:35:03PM -0400, Gabriel Ricard wrote:
On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
I'd be interested to know if you can get a test running that uses
either a key_buffer or an innodb
Are there any gurus out there that can help with optimizing queries /
mysql database, little freelance work? Maybe if I can get the
processing time down, this won't be as much of an issue.
Travis
David Brodbeck wrote:
-Original Message-
From: Travis Reeder [mailto:[EMAIL PROTECTED]
Hello,
I'm having a tricky problem: I've got a database table (PicklistData
with three fields, which I have to use for a join to get the data,
which is associated with them. They are called EAN, ISRC and
LabelProductCode. Until now, there's nothing difficult. But a thing,
which makes the problem i
At 2:06 PM -0500 10/16/2003, Dan Nelson wrote:
In the last episode (Oct 16), Michael Winston said:
Is there any way to do "natural sorting" in MySQL? That is:
Chapter 1
Chapter 2
Chapter 10
instead of
Chapter 1
Chapter 10
Chapter 2
If not, are there any plans for this feature in future r
It's running on Redhat 9.
Travis
Jeremy Zawodny wrote:
On Thu, Oct 16, 2003 at 02:45:26PM -0600, Travis Reeder wrote:
Is there a way to give mysql a lower priority? I have an app that is
constantly using the database and it is pinning the processor constantly
which makes it hard for other ap
There was a question last week about the behavior of this
function, which is inconsistently (and inaccurately) documented
in the manual.
A little black box testing shows the following:
1) mysql_insert_id successfully retrieves the last
auto_inserted id used by a connection.
2) multiple processe
On Thu, Oct 16, 2003 at 02:45:26PM -0600, Travis Reeder wrote:
> Is there a way to give mysql a lower priority? I have an app that is
> constantly using the database and it is pinning the processor constantly
> which makes it hard for other applications to run.
What OS are you using?
--
Jeremy
> -Original Message-
> From: Travis Reeder [mailto:[EMAIL PROTECTED]
> Is there a way to give mysql a lower priority?
If you're on a UNIXish operating system, you could try running it with the
'nice' command. 'nice' lets you set the priority of the process you launch
with it.
Note that
Is there a way to give mysql a lower priority? I have an app that is
constantly using the database and it is pinning the processor constantly
which makes it hard for other applications to run.
Travis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Hello all,
The referencial integrity control don´t apply to a simple table, do it? So,
I saw it´s good to do it use InnoDB table type. What´s your opinion about
it? Is it the only and the best way to apply refericial integrity?
My DB is growing, and growing, and I´m very concerned about my host
l
If you have 4.0.2 or later you can use the CAST() function, if you have
earlier you should be able to emulate it with the BINARY keyword for the
ORDER BY clause, examples below:
[EMAIL PROTECTED]:tmp > CREATE table sort (
-> num int
-> );
Query OK, 0 rows affected (0.00 sec)
[EMAIL PRO
You are confusing the string function with the sql function.
Mike Tuller wrote:
Unless I am mistaken on REPLACE's use, I don't think that will work. The
example I have in the O'Reilly MySql book that I have shows this.
REPLACE(string, old, new)
Returns a string that has all occurances of the subs
The mysql docs, in the security section, warns of special
characters encoded in dynamic urls. IE., %27 (`'`). Is
there a hazard with the string '%27' being in the database?
Or is this just another case of protecting against the
insertion of the `'` character? In other words, if I
am already escapin
actually it will act like insert in eather case. if its there,
delete it first, if not just insert.
http://www.mysql.com/doc/en/REPLACE.html
as far as using shell to do the insert/update, you could look at
command line php, that way you get the logic and you don't have to
learn a new language
Sorry, I meant to say "I've tried the subquery", not
the substring, on 4.1, and that's probably what we'll
use in the future.
select date, value, type from A a1 where value =
(select max(a2.value) from A a2 where a1.type =
a2.type);
Ana
--- Ana Holzbach <[EMAIL PROTECTED]> wrote:
>
> Hi Ro
In the last episode (Oct 16), Michael Winston said:
> Is there any way to do "natural sorting" in MySQL? That is:
> Chapter 1
> Chapter 2
> Chapter 10
>
> instead of
>
> Chapter 1
> Chapter 10
> Chapter 2
>
> If not, are there any plans for this feature in future releases?
> Would be pretty he
Unless I am mistaken on REPLACE's use, I don't think that will work. The
example I have in the O'Reilly MySql book that I have shows this.
REPLACE(string, old, new)
Returns a string that has all occurances of the substring old replaced with
new(e.g., REPLACE('black jack', 'ack', 'oke') returns "bl
On Thu, Oct 16, 2003 at 12:49:41PM -0400, [EMAIL PROTECTED] wrote:
> In a message dated 10/16/03 9:27:04 AM Eastern Daylight Time,
> [EMAIL PROTECTED] writes:
>
> > This is down to the OS. As MySQL is multy threaded its all down to SMP
> > support.
> >
>
> with all due respect, I don't think
If memory serves, adjustments to the OS need to be made to take advantage of
the 64-bit memory addressing. I know some changes have been made to OS X to
run on a 64-bit chip, but I'm not certain they've made enough modifications
to take advantage of the memory addressing.
I'd be interested to see
On Thursday, October 16, 2003, at 02:19 PM, Jeff McKeon wrote:
$revenues = mysql_fetch_rows($data);
To dump the data into the array. Is this correct?
There is no single function in the mysql extension to retrieve all
records at once. You can do this with the dbx extension, which wraps
MySQL (&
Is there any way to do "natural sorting" in MySQL? That is:
Chapter 1
Chapter 2
Chapter 10
instead of
Chapter 1
Chapter 10
Chapter 2
?
If not, are there any plans for this feature in future releases?
Would be pretty helpful...
Michael
--
MySQL General Mailing List
For list archives: http://li
It sound like you want to use REPLACE instead of the SELECT and
INSERT/UPDATE combo. Replace will insert if the record doesn't exist
and update if it does.
On Thursday, October 16, 2003, at 01:27 PM, Mike Tuller wrote:
I have a shell script that I have data entered into a database, and
instead
> > $revenues = mysql_fetch_rows($data);
> >
> > To dump the data into the array. Is this correct?
>
> There is no single function in the mysql extension to retrieve all
> records at once. You can do this with the dbx extension, which wraps
> MySQL (& other DBMS) functions. with the MySQL exten
On Thursday, October 16, 2003, at 02:04 PM, Jeff McKeon wrote:
Do this query:
SELECT YEAR(TheDate) AS Year,MONTH(TheDate) AS
Month,CustomerName,CustomerID,SUM(Revenue*Quantity) AS
Revenue FROM rev GROUP BY Year, Month ORDER BY Year,Month,CustomerID
In practice this would change to something like
> Do this query:
>
> SELECT YEAR(TheDate) AS Year,MONTH(TheDate) AS
> Month,CustomerName,CustomerID,SUM(Revenue*Quantity) AS
> Revenue FROM rev GROUP BY Year, Month ORDER BY Year,Month,CustomerID
>
In practice this would change to something like...
$data=mysql_query("SELECT YEAR(TheDate) AS Yea
Or you could just do one simply query as I explained previously,
retrieve the data in PHP, and group it by date rather than spending the
same time in PHP generating a massive, inefficient query (and if you
have a large number of customers, you won't generate a query larger
than the maximum MySQ
On Thu, 2003-10-16 at 17:42, Jeff McKeon wrote:
> Is there a way to generate a "line number" for a query return within the
> returned rows??
>
> For instance, if I return 5 rows from a query, is there a command or
> function I can put in a query to add a column that contains the row
> number retur
On Wed, Oct 15, 2003 at 06:35:03PM -0400, Gabriel Ricard wrote:
>
> On Wednesday, October 15, 2003, at 03:10 PM, Jeremy Zawodny wrote:
>
> > I'd be interested to know if you can get a test running that uses
> > either a key_buffer or an innodb_buffer_pool in the 3.5GB range.
>
> Interestingly e
Has anybody implemented datawarehouse applications with MySQL?
What tools are you using? (OLAP Server, Report tools, etc.)
I'm currently evaluating Microstrategy, it works pretty well, but does
not support MySQL.
Any ideas?
Regards.
--
MySQL General Mailing List
For list archives: http://lis
I have a shell script that I have data entered into a database, and instead
of just entering in the data blindly, I want it to check to see if the item
it is entering exists already, and if it does, update the information rather
than inserting it. So I want to run a select statement, and if results
Hi Jeff
OK, aliasing table is creating a copy of one table but calling it something
different, so you compare a table to itself e.g.:
FROM revenue a, revenue b, revenue c COULD ALSO BE FROM revenue AS a,
revenue AS b, revenue AS c
I am referencing revenue three times but have aliased it as a, b,
As I understand it mysql is a single process multi-threaded application. I have
heard of some thread schedulers that allow for a certain granularity of
determining where to run a particular thread / process. I think this is the
purpose behind Sun's processor groups.
Is there such a thing for Lin
Hi Roger,
Thanks for the pointer.
CONCAT would be a nightmare to maintain, especially
with data where the values can have all sorts of
ranges, and where we could just as well be looking for
the value corresponding to the latest (or earliest)
date instead. It would just create too many cases
> If you have a way to generate the query code dynamically
> (e.g. using a loop in C, PHP etc.), you can build a query
> using aliased tables :
>
> SELECT YEAR(a.date) AS year, MONTH(a.date) AS month,
> SUM(a.revenue) AS cust1_rev,
> SUM(b.revenue) AS cust2_rev, SUM(c.revenue) AS cust3_rev
> F
In a message dated 10/16/03 9:27:04 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> This is down to the OS. As MySQL is multy threaded its all down to SMP
> support.
>
with all due respect, I don't think that is 100% true. Although certainly
the underlying OS kernel must support multi
Hi
If you have a way to generate the query code dynamically (e.g. using a loop
in C, PHP etc.), you can build a query using aliased tables :
SELECT YEAR(a.date) AS year, MONTH(a.date) AS month, SUM(a.revenue) AS
cust1_rev,
SUM(b.revenue) AS cust2_rev, SUM(c.revenue) AS cust3_rev
FROM revenue a, r
Sorry, hit ctrl-s by accident and sent the email before I was done...
Yeah, I already got that far but it's just short of what I need as an
end result.
Is there a way to generate a "line number" for a query return within the
returned rows??
For instance, if I return 5 rows from a query, is there
Yeah, I already got that far but it's just short of what I need as an
end result.
Is there a way to generate a "line number" for a query return within the
returned rows??
For instance, if I return 5 rows from a query, is there a command or
function I can put in a query to add a column that contai
* Ana Holzbach
> Thanks for your reply. Here's the next step: I've
> added a date column to my table as follows:
>
> ++---+--++
> | id | value | type | date |
> ++---+--++
> | 1 | 6 | a| 2002-09-08 |
> | 2 | 2 | b| 2003-10-
I think you should use something like LIMIT 50, 15
Check the manual for the correct syntax.
(http://www.mysql.com/doc/en/SELECT.html explains it better than me)
Thanks
Emery
- Original Message -
From: "Cummings, Shawn (GNAPs)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, O
Just do
Select ... limit 50, 15;
(if i'm wrong, see MySQL manual, Section LIMIT Syntax)
;)
Alexis
-Original Message-
From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]
Sent: quinta-feira, 16 de Outubro de 2003 16:49
To: [EMAIL PROTECTED]
Subject: LIMITS
when I do a query is th
On Thu, 16 Oct 2003 11:49:29 -0400
"Cummings, Shawn (GNAPs)" <[EMAIL PROTECTED]> wrote:
> when I do a query is there a way to IGNORE the first X number of returned
> records???
>
> For instance I want to see 15 records after the first 50.
yes, use LIMIT clause:
SELECT * FROM tablename LIMIT 50
At 10:10 AM 10/15/2003, you wrote:
In the last episode (Oct 15), mos said:
> At 07:47 AM 10/15/2003, you wrote:
> >mos <[EMAIL PROTECTED]> wrote:
> >> I want to speed up a large query and I noticed if I do an:
> >>
> >> Explain select * from LargeTable order by IndexCol1
> >>
> >> it always has Ext
when I do a query is there a way to IGNORE the first X number of returned
records???
For instance I want to see 15 records after the first 50.
Shawn Cummings
Engineering Project Manager
Global NAPs
10 Merrymount Rd
Quincy, MA 02169
Desk 617-507-5150
VoIP 617-507-3550
[EMAIL PROTECTED]
--
I think the closest you can get is something like this:
SELECT YEAR(TheDate) AS Year,MONTH(TheDate) AS
Month,CustomerName,CustomerID,SUM(Revenue*Quantity) AS Revenue
FROM rev
GROUP BY Year, Month
ORDER BY Year,Month,CustomerID
A table with this data:
++--++--
Thanks y'all. It seems that the temporary table is the way I want to go for
my particular situation.
Susan
-Original Message-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:05 AM
To: Nitin; Susan Ator; [EMAIL PROTECTED]
Subject: Re: Temporar
>We copy data from one table to another using:
>insert into TBL1 select * from TBL 2;
>The current database hangs and the process never finish when copying >huge
>tables (around 25million rows). Looking at the processlist it states that
>the process stays in \"closing table\" or \"wait on cond
Roger,
Thanks for your reply. Here's the next step: I've
added a date column to my table as follows:
++---+--++
| id | value | type | date |
++---+--++
| 1 | 6 | a| 2002-09-08 |
| 2 | 2 | b| 2003-10-01 |
| 3 | 5 | b
Hi,
We copy data from one table to another using:
insert into TBL1 select * from TBL 2;
The current database hangs and the process never finish when copying huge
tables (around 25million rows). Looking at the processlist it states that
the process stays in "closing table" or "wait on cond" st
Also, sometimes one needs to copy the content of a table in itself but
earlier versions of MySQL don't support something like
INSERT INTO some_table SELECT * FROM some_table /* the select table and
insert tables are not different */
So, you may create a temporary table, fill it with the info you
Hi,
If I remember, ENCODE() is reversible using DECODE() or something similar.
I might be wrong, just check the manual!!!
Thanks
Emery
- Original Message -
From: "Nitin" <[EMAIL PROTECTED]>
To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 16:
basically used to make queries easier running from within scripts. it could
be a good workaround for views, as you can create a temporary table to be
used as a view, but it gets destroyed as the connection to your database
closes. You can also use it as a good workaround for union, for older mysql
"Manisha Sathe" <[EMAIL PROTECTED]> wrote:
> thanks all, it works (i just increase it to 20)
Please, don't use PASSWORD() function in your own application, use MD5() or SHA1()
instead.
> but one more thing, now if i want to get this password (e.g for option
> forget password), can we retrieve, i
PASSWORD() is a one-way function (I was confirming just).
Though, it has worked for you, please consider the advice of Paul in his
previous Email when he recommended you read about PASSWORD() at the URL:
http://www.mysql.com/doc/en/Miscellaneous_functions.html
Thanks
Emery
- Original Message
> Do you talk about MySQL users or about users of the typo3?
Typo3 users. I setup typo to send error messages, and I get this:
There has been numerous attempts (4) to login at the Typo3
site "typo3 server" (www.wals.lib.wi.us).
This is a dump of the failures:
16-10-03 08:55: Login-attempt from
I have a table that contains customer revenue information.
REVENUE TABLE:
Date, customer name, CustomerID, revenue, quantity
I need to create a query that will produce the following result
Year, Month, Customer1_rev, customer2_REV, customer3_rev, etc...
2002, 01, 0, $30.00, $15.00
2
I would like to know the circumstances in which a temporary table would be
used. What is the rationale behind temporary tables? I have searched the
manual and the 'net but only find out information about creating or
manipulating them.
Thanks,
Susan
--
MySQL General Mailing List
For list archive
Can you please provide me with the direct link to those PDFs?
I have worked with Stored Procedures on MS SQL but have not yet played with
them on MySQL. I first want to read about them even before I download the
supporting version.
Thanks
Emery
- Original Message -
From: "Bob Brands" <[EM
all encryption functions are one way only
Nitin
- Original Message -
From: "Manisha Sathe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 6:46 PM
Subject: Re: PASSWORD() function problem
> thanks all, it works (i just increase it to 20)
> but one more thin
Maybe installing MyODBC 3.51.06 will solve the problem.
I am not sure.
Thanks
Emery
- Original Message -
From: "miguel solorzano" <[EMAIL PROTECTED]>
To: ".eric" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 05:16
Subject: Re: not found driver 3.51 not found
Hi!
Mark Matthews, the author of Connector/J commented on the speed improvements
of JDBC since the eWeek benchmark.
Best regards,
Heikki
- Alkuperäinen viesti -
Lähettäjä: "Mark Matthews"
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Lähetetty: Thursday, October 16, 2003 4:18 PM
Ai
On Thu, 16 Oct 2003, Serge Cohen wrote:
> [...]
> Now I'd like to use the libmysqld, so that I can have a an embedded
> server, still this same application should be able to connect to a DB
> server (over internet).
> From what I've read and tried, the libmysqld library does not provide
> the fun
This is down to the OS. As MySQL is multy threaded its all down to SMP
support.
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 16 October 2003 12:25
To: [EMAIL PROTECTED]
Subject: Parallel Processing
I've been reading the online docs and asking around
thanks all, it works (i just increase it to 20)
but one more thing, now if i want to get this password (e.g for option
forget password), can we retrieve, i believe we can not- just want to
confirm
manisha
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Manisha Sathe" <[E
"Vaidas ?ilionis" <[EMAIL PROTECTED]> wrote:
> i have installed mysql on my deksop computer.
> now i see one table can use
>
> #1016 - Can't open file: 'pages_lt1.MYI'. (errno: 144)
$ perror 144
Error code 144: Unknown error 144
144 = Table is crashed and last repair failed
Check why last repai
Dear all
When I run a query on a table with about 22 Mio records and three columns of
type bigint, I get a Error 2013 Lost connection to MySQL server during
query. If I use limit x it works fine as long x<70.
Is there anything I can do to circumvent this error?
Thanks, W. Bauer
--
NEU FÜR ALL
What linux distro are you using? I'm going to assume either Redhat or
Mandrake, however there are other `RPM' using distros.
Redhat:
ftp://ftp.redhat.com/pub/redhat/linux/9/en/os/i386/RedHat/RPMS/mysql-client*
Mandrake:
ftp://ftp.tux.org/distributions/mandrake/9.1/i586/Mandrake/RPMS/MySQL-cli
Couldn't you also group by grouper2 and date2 ?
Something like:
...
GROUP BY grouper1, grouper2, date2
Just a hint I didn't test it.
On Thu, 2003-10-16 at 01:01, Travis Reeder wrote:
> I am trying to do an aggregate query, but having some problems and here
> they are simplified:
>
> Table
I've been reading the online docs and asking around about MySQL's ability to
perform parallel processing. It does not appear to support such
functionality. Maybe this is intentional, or I missed something in the manual.
I have a 4 way Intel server that I'd like to be able to contain certain
u
i have installed mysql on my deksop computer.
now i see one table can use
#1016 - Can't open file: 'pages_lt1.MYI'. (errno: 144)
How can i repair it? or it's lost?
phpmyadmin swoes: "in use"
somebody locked it? strange... this only i using...
--
MySQL General Mailing List
For list archives
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again;
A few days ago I've posted the following question (during a WE)...
unfortunately I had no answer, so I'm just giving it a second chance.
As this is the second (and last) round for this question, please don't
restrict yourself,
I'd be VER
[EMAIL PROTECTED] wrote:
>
>> Did you get any error messages?
>
> Oh, sorry, forgot that part. No, it refreshes the screen as though the
> name or password were incorrect. I've tried creating new users into the
> table, but still does the same thing.
Do you talk about MySQL users or about users
Dear Mr. Singh,
You need to install Mysql-shared-compat
available at
http://www.mysql.com/downloads/mysql-4.0.html
for more information take a look at
http://www.mysql.com/doc/en/Linux-RPM.html
Enjoy
Nitin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: T
Okay,
Now I understand what you want. (For people who try to unsub me from this
list: Sorry I only try to help, if you are not intressted in it pleasee
dont read)
If you start using MySQL 4.1 (Only ALPHA) then you can use subqueries like
this:
select *
from table1
where id not in
( select re
Hello All!
I really need a hand here. I'm volunteering at this NGO (non-profit org)
in New Delhi. I and another developer built a .NET/MySQL app for managing
the communications department. The app worked sweet on our machines, but
when we moved it to the server and ran a UNION query (one of man
Hi group,
I just read the first news item on the MySQL website and thought some of you might
need to read about it as it is very interesting for those who use MySQL for hi end
transactions.
This gave me more powers in choosing MySQL as my favorite DBMS.
Just go to http://www.mysql.com or
http:
Mysql-shared-compat
available at
http://www.mysql.com/downloads/mysql-4.0.html
for more information take a look at
http://www.mysql.com/doc/en/Linux-RPM.html
Enjoy
Nitin
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Randy Chrismon" <[EMAIL PROTECTED]>
Cc: <[EMAI
it could better be like
SELECT * FROM list WHERE name in ('$this1', '$this2', '$that1')
Nitin
- Original Message -
From: "Colleen Dick" <[EMAIL PROTECTED]>
To: "Mike At Spy" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 10:14 AM
Subject: Re: OR in MySQL st
Chris,
- Original Message -
From: "Chris Nolan" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 15, 2003 2:43 PM
Subject: That eWeek benchmark...
> Hi all,
>
> Looking back over the eWeek benchmark that's linked to from www.innodb.com
> (where MySQL is a
Mike,
MySQL AB charges U.S. $1650 per day:
http://www.mysql.com/consulting/migration.html
"
The cost of MySQL Migration Assistance starts at 3.300 euros + taxes
(Europe) or 3.300 dollars + taxes (US), with the following terms
minimum duration two days
daily rate based at 7,5 working hours a day
> About Access I can only say that it's very useful tool for a lot of
> people and there is a lot of places where it makes perfect sense to
> use Access. I don't claim it's a perfect reporting tool for all kind
> of reports, but depending on the requirements it may be the right tool
> for a specif
Hi,
I'm working with version 5.0 as well, like you I find it hard to find
documentation on MySQL-5.0 and not much support for MySQL-5.0 on the mysql
list, probably because not many people work with 5.0. I'm studding MySQL5.0
to see how far I can come to create a tool to convert a Oracle Databas
94 matches
Mail list logo