Hi,
Hm, using ulimit on my own Ultra Sparc w/ Solaris 8, I can raise ulimit
to max. 1024. Probably not quite enough. More study will be required :-/
Martijn
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: donderdag 23 juni 2005 16:27
> To: mysql@lists.mysq
if that was the case it would easy to be a millionaire..
spam or scam... it's all the same..
bruce wrote:
hi...
i'm out here in california, the bay area, and was wondering if anyone on the
list is interested in either being partners, forming a sweat equity startup?
or if anyone has an idea/con
Im trying to get dynamically insert the current date into a LOAD FILE
statement for some ETL automation, but Im having difficulty passing the
string into the LOAD statement:
This will not work.
SELECT @Today:=CURDATE();
LOAD DATA LOCAL INFILE '/s3/data/[EMAIL PROTECTED]' INTO TABLE Data;
Anyone
hi...
i'm out here in california, the bay area, and was wondering if anyone on the
list is interested in either being partners, forming a sweat equity startup?
or if anyone has an idea/concept, and you're looking for people to be part
of your team...
i've read way too many articles about the 3 ki
I am having trouble with this small bit of sql I am using for a
homepage.
I need to select information on the next two events from two
separate tables; tblevents (which holds event related info), and
tbleventdate (which holds info related to each date, including times and
informatio
I am having trouble with this small bit of sql I am using for a
homepage.
I need to select information on the next two events from two
separate tables; tblevents (which holds event related info), and
tbleventdate (which holds info related to each date, including times and
informatio
Kevin Burton wrote:
Any idea whats going on and how I could fix this?
This seems like a bug in the SQL parser. The LIMIT is only ignored in this one
situation.
If I just add a:
UNION
(SELECT * FROM FOO LIMIT 0)
To the query will work correctly.
This might be an acceptable workaround
Jeremy,
Thanks. I used Perl's cron module to execute my script. So I assume
only the cron mdoule is active all the time, but not my perl script.
Your approach looks interesting to me. I will think about it.
ted zeng
On Jun 27, 2005, at 1:14 PM, Jeremy Cole wrote:
Hi Ted,
When a new record
Why do you think you're using a UNION in your query? The keyword UNION
doesn't appear anywhere in your query. You don't even have a second query
being UNIONed to the first. All you've got is a pair of parentheses
surrounding your original query, which seems to perform okay.
For what it's worth, I
Kevin Burton wrote:
( SELECT * FROM FOO WHERE FOO.LAST_UPDATED
< 1119898418779 AND FOO.FEED_ID = 1 ORDER BY FOO.LAST_UPDATED DESC LIMIT
10 ) ORDER BY LAST_UPDATED DESC LIMIT 10
OK. I *totally* just figured it out!
WOW.
so.. the LIMIT in the first SELECT is *totally* ignored and the entire
Here's a big problem I'm having.
If I have a query like:
SELECT * FROM FOO WHERE FOO.LAST_UPDATED < 1119898418779 AND
FOO.FEED_ID = 1 ORDER BY FOO.LAST_UPDATED DESC LIMIT 10
it only takes about 10ms or so to execute.
but... if I rewrite it to wrap it in a union like so:
( SELECT * FROM FOO WH
Hi Ted,
When a new record is added to a specific table, I want to
react to it right away, running a perl script to do something.
Right now, I use a cronjob that checks the table every minuet.
It is slow(it could waits up to a whole min.) and not efficient.
To my understanding, I would need to
When a new record is added to a specific table, I want to
react to it right away, running a perl script to do something.
Right now, I use a cronjob that checks the table every minuet.
It is slow(it could waits up to a whole min.) and not efficient.
To my understanding, I would need to put a trig
On Jun 27, 2005, at 1:32 PM, Ted Zeng wrote:
I don't know if it is possible under Mac OS. But I assume it is,
consider it is basically a UNIX.
I just want to trigger a shell script, say, a perl script.
Could a shell script be called from a C program?
It looks like I will need to go through a lot
Thanks! Worked perfectly. And also thanks to the other people who
responded. Being unfamiliar with how MySQL seems to handle time your
responses really helped!
-Chris
On Jun 27, 2005, at 1:16 PM, [EMAIL PROTECTED] wrote:
That would have worked if TIME values weren't converted to numbers
Eko Budiharto <[EMAIL PROTECTED]> wrote on 06/27/2005 12:28:27 PM:
> >Are you actually saying that you have a database with more than 1.8e+19
> >records in it? I don't think you do. I think you are combining several
> >pieces of information into something that looks like a number and it's
> >e
Thanks. This info. is very useful to me.
I don't know if it is possible under Mac OS. But I assume it is,
consider it is basically a UNIX.
I just want to trigger a shell script, say, a perl script.
Could a shell script be called from a C program?
It looks like I will need to go through a lot of
[EMAIL PROTECTED] wrote:
Christopher Molnar <[EMAIL PROTECTED]> wrote on 06/27/2005
12:55:08 PM:
What I would like to use is:
select ctype, count(tsid), sum(amount), sum(amount_collected), sum
(camount), sum(commision), sum(subtime(time_out,dispatch_time)) as
time from time_sheet where t
Christopher Molnar <[EMAIL PROTECTED]> wrote on 06/27/2005
12:55:08 PM:
> I have a table that has the following structure:
> mysql> describe time_sheet;
> +--+---+--+-+
> ++
> | Field| Type | Null | Key | Defaul
I am currently projecting a project where we can use MySQL to control
documents similiar to ISBN for IntraNet. We plan to export into XML as well.
It will require a good labelling, strategy and planning. Do anyone know
where I can find good resource to get started?
Thanks,
Scott
--
Power to
I have a table that has the following structure:
mysql> describe time_sheet;
+--+---+--+-+
++
| Field| Type | Null | Key | Default|
Extra |
+--+---+--+-+---
[EMAIL PROTECTED] wrote on 27/06/2005 16:33:44:
> Are you actually saying that you have a database with more than 1.8e+19
> records in it? I don't think you do.
If you were to add records at the rate of a million a second, which is, I
think, beyond the capabilities of any foreseeable future h
Gleb Paharenko wrote:
> Hello.
>
> Your situation looks very rare. I didn't found complains in bug
> database and archives. If you are able to reproduce this situation the
> bug report would be helpful.
Yeah, well - first I'd need to reproduce the 50mill records :-)
This will take maybe a month
If you really need more than 20 digits of accuracy and can move to 5.0.3
+
you can use the Decimal data type without losing precision.
This is out of Chapter 23. Precision Math
The maximum value of 64 for M means that calculations on DECIMAL values
are accurate up to 64 digits. This limit of 64
Eko Budiharto <[EMAIL PROTECTED]> wrote on 06/26/2005 11:02:30 AM:
> Hi,
> is there anyway that I can have more than 20 digits for integer
> (bigInt)? If not, what I can use for database index?
BIGINT UNSIGNED can range from 0 to 18446744073709551615
(http://dev.mysql.com/doc/mysql/en/numeric-ty
At 08:11 AM 6/27/2005, you wrote:
Hello,
How can I prevent duplicate entries when I fill the data base with
"load data"? I tried ignore, but that has no effect. Probably I'm
something very elementary, but I'm still learning...
Regards,
Hans.
Hans,
Ignore/Replace will only
Changes average about 10 a month, in my experience: new ZIP codes and
split ZIP codes, plus quite a few that go away. So you are working
with a database that's probably around 2% wrong. I've never seen a
*free* source of current accurate data: the USPS charges a lot for
this, so generally t
Brian Dunning <[EMAIL PROTECTED]> writes:
> Dude, that's more than 5 years old.
Yup, but it's worked fine for every application I've used it for. ZIP
codes don't tend to get moved around very often, and when they do it's
not very far...
ScottG.
[...]
>> As I said below, you can download a
Selon Hassan Schroeder <[EMAIL PROTECTED]>:
> Mathias wrote:
>
> > This is the right structure including "The" in the middle :
> > mysql> SELECT * FROM names ORDER BY case when substring(name,1,3)='The'
> >then REPLACE(name,'The ','')
> >else name end;
>
> ? all of which produces
Hi, I would like to know if the support for fulltext index on ucs2-columns will
be added and if so when.
BR /Kenneth Lindh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mathias wrote:
This is the right structure including "The" in the middle :
mysql> SELECT * FROM names ORDER BY case when substring(name,1,3)='The'
>then REPLACE(name,'The ','')
else name end;
? all of which produces exactly the same result as:
SELECT * FROM names ORDER BY T
"Harish Gabbita" <[EMAIL PROTECTED]> wrote on 06/27/2005 10:17:48 AM:
> Hi Everybody,
> I am using MySql 4.0.21 standard version. I have a profile table with
the
> structure in similar manner:
> mysql> select A0,A1,A14,A15,A19,Split from PROFILE where A1=100;
> +---+-+-+-+-+
Hi Everybody,
I am using MySql 4.0.21 standard version. I have a profile table with the
structure in similar manner:
mysql> select A0,A1,A14,A15,A19,Split from PROFILE where A1=100;
+---+-+-+-+-+--+
| A0| A1 | A14 | A15 | A19 | Split|
+---+-+-+-+-+
thanks gary:
of course this is the perfect solution, and it will be a very good open
source project, but: how is it posible that the mysql team has not
implemented this proxy solution all ready?
i am not a lazy guy, of course if a need to implement this i will do,
but i prefer a mysql's solu
Right,
i have all my attention on the " The Yeti" order, and didn't see the rest.
This is the right structure including "The" in the middle :
mysql> SELECT * FROM names ORDER BY case when substring(name,1,3)='The' then
REPLACE(name,'The ','')
-> else name end;
++
| name
Mathias wrote:
you didn't give an alternative, but i've forgotten just a '^' :
mysql> SELECT * FROM names ORDER BY REPLACE(name,'^The ','');
No, sorry -- that doesn't work at all; REPLACE takes a string,
not a regex. Look at your example below: 'The ' should be
after ''; '' shou
Hi,
Am a newbie to mysql.
I am trying to deploy mysql database server on a windows machine and
update this
database from a remote linux machine(client) periodically.
The connection to mysql server in windows is failing when i run the
client program at mysql_real_connect (). Am using
mys
Hi,
you didn't give an alternative, but i've forgotten just a '^' :
mysql> SELECT * FROM names ORDER BY REPLACE(name,'The ','');
++
| name |
++
| |
| The |
| The |
| |
| |
| |
Hello,
How can I prevent duplicate entries when I fill the data base with
"load data"? I tried ignore, but that has no effect. Probably I'm
something very elementary, but I'm still learning...
Regards,
Hans.
jdh dot beekhuizen at duinheks dot xs4all dot nl
--- GoldED+/LNX 1.1.5/04041
Hallo Jigal,
Op 22 Jun 05 schreef Jigal van Hemert aan <[EMAIL PROTECTED]:
JvH> What about reading the data into the table and storing the
JvH> 'amount' in varchar for now. Then you can run an update query in
JvH> UPDATE `table` SET `amount`= REPLACE( `v_amount`, ',' , '.'),
JvH> `v_amount`
Hallo Anoop,
Op 22 Jun 05 schreef Anoop kumar V aan Jigal van Hemert <[EMAIL PROTECTED]>,:
AkV> Alternatively, you can parse the text files using application logic
AkV> (java, c++, etc) and then after extracting (and cleaning) your data
AkV> insert them into mysql.
I had been thinking about t
Hello.
Send an example of your file and your table's definition
(use SHOW CREATE TABLE for this purpose). Please, next time
send your replies to the list.
>
>Hope you're doing great today. Back to my question last week, I've
>been encountering this problem of loading my file using the
Hello.
Your situation looks very rare. I didn't found complains in bug
database and archives. If you are able to reproduce this situation the
bug report would be helpful.
Per Jessen <[EMAIL PROTECTED]> wrote:
> I ran into a table full situation a couple of days ago, but didn't spot it
Hello.
You have several problems and they're should be resolved step by step.
First fix the problems with permissions. Usually they're solved by
changing the owner of mysql database to mysql user. Check what's wrong
with /var/log/mysqld.log. It might be necessery to create it manually.
Why a
Hello.
A lot of statistics you could get from 'SHOW INNODB STATUS'.
For example 'FILE I/O', 'INSERT BUFFER AND ADAPTIVE HASH INDEX',
'BUFFER POOL AND MEMORY' could be helpful. See:
http://dev.mysql.com/doc/mysql/en/innodb-monitor.html
Manoj <[EMAIL PROTECTED]> wrote:
> Greetin
Hello.
Check your results with official binaries. Set max_connections
variable to big enough value. Combinations of different versions of compilers
and glibc sometimes could give unpredictable results.
"huang leo" <[EMAIL PROTECTED]> wrote:
> Hi, everyone:
>I had done a test on Lin
Hi
> this,among other answers, can be done :
>
> mysql> select * from names;
> +--+
> | name |
> +--+
> | |
> | The |
> | |
> | The |
> | |
> +--+
> 5 rows in set (0.02 sec)
>
> mysql> select * from names order by replace(name,'The
thanks for the reply.
but this solution its imposible because my applications are done
allready, or perhaps the applications are not mine.
i need a transparent balancer, and i dont anderstand how is possible
thet it does not exists.
grettings
d2clon
Gary Richardson wrote:
You're probably
I ran into a table full situation a couple of days ago, but didn't spot it till
last night.
I read the advice about altering the pointer-size:
http://dev.mysql.com/doc/mysql/en/full-table.html
but I neglected to read Jason Collisons comment about backing up my data first.
I lost about
50mill
Mathias wrote:
You have the choice between this :
http://dev.mysql.com/doc/mysql/en/application-password-use.html
and this :
The optimal solution when migrating to MySQL 4.1+ from a previous version is to
upgrade to PHP 5 (if you're not using it already) and rewrite any code
accessing MySQL usin
Hi,
Im using : mysqlclient10-3.23.58-6
,mysql-server-4.1.11-2,mysql-4.1.11-2 On fedora 3.
when i run the following command its gives Error:
[EMAIL PROTECTED] etc]$ /etc/init.d/mysqld start
touch: cannot touch `/var/log/mysqld.log': Permission denied
chmod: changing permissions of `/var/log/mysqld.
mm wrote:
Dear friends,
This is my first cpp module working with mySQL.
It looks like the error is located in
MYSQL *m=mysql_real_connect(myDB, host, user, passwd, ...
There is a way to find out step by step which parameters is wrong?
I am working with Fedora core 3
and MySQL 3.23.58
Thanks,
MT
52 matches
Mail list logo
