Dear friends
Im having some problems with this queries on mysql 4.1.15
"SELECT * FROM scg00_scga2800_dbf WHERE taxdvig >= '20050302' OR (taxdvig =
(SELECT max(taxdvig) FROM scg00_scga2800_dbf WHERE taxdvig < '20050302') AND
(SELECT count(taxdvig) FROM scg00_scga2800_dbf WHERE taxdvig = '20050302'
Harish TM a écrit :
> hi...
> I need to store something like a couple of million rows is a MySql
> table. Is that ok or do I have to split them up. I intend to index each of
> the columns that I will need to access so as to speed up access. Insertion
> will be done only when there is very lit
tedd wrote:
Yes, I was wondering that myself considering the onslaught of "no-no's" one
gets by suggesting placing images into a dB. A PDf file is really not that much different
and probably better served via file system.
tedd
On the other hand, you get control of the images, as opposed to r
I would try dumping it using 'mysqldump -c' and inspecting the insert
statements ... seems awefully suspicious to me. I'm thinking you might have a
line feed character (or some other invisible) in there somewhere...
boof
--
brendan bouffler
Architect, HPC & New Technology
APJ ESS Competency La
On 5/31/06, Lukasz Budnik <[EMAIL PROTECTED]> wrote:
I'm losing my mind - no idea what's going on with this name.
Any hints most welcome ;)
Show your show create table?
--
-jp
Chuck Norris does not teabag the ladies. He potato-sacks them.
Hi Gilles,
I search in the manual with "ERROR 1064", and then get the page :
http://dev.mysql.com/doc/refman/4.1/en/error-messages-server.html
Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)
Message: %s near '%s' at line %d
I cannot figure out what is wrong from this info, whereas error code
106
Hi,
I have a table table_a and table_b:
table_a {
id
name
}
table_b {
table_a_id
b_value
}
Table A is a table with names, and table B is a table with values for a
specific name (optional, therefore a specific table).
I would like to select all records in A, done by:
SELECT name FROM table_a;
Hi Sheeri,
On Wed, May 31, 2006 18:11, sheeri kritzer wrote:
> Did you try the first query again? Is it possible that another
> "Szczech" was added in the time you did both queries? What happens
> when you the simple
>
> mysql> select id_c, name, from clients where name like 'Szczec%'; and
> mys
pfffttt... laziness!
On 5/31/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote:
On 5/31/06, Michael Price <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
>
>
>
>
Congratulations Michael! You just got yourself an indexed, searchable
record of ignorance (Gmane, MySQL.com, etc) and laziness, by shouting
at a lo
Hello again Paul,
1-Why the error code (1064) can't lead explicitly to the syntax problem ?
I'm sorry, I don't understand the question.
The mysql command returned the error code [ ERROR 1064 (42000) ]
I search in the manual with "ERROR 1064", and then get the page :
http://dev.mysql.com/do
Hi,
MySQL 5.0.22, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/ and mirror sites.
Note that not a
[EMAIL PROTECTED] wrote:
>I want to select a list, where it was registered in tbl
club_get_match with Id-
>Member in tbl detail_club_member, but it's not registered in tbl
wager.
Your schema has a problem: wagers.name_club is too short. If no
club_get_match.name_club value is longer than 20 c
Hi,
MySQL 4.1.20, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/ and mirror sites.
Note that not a
I'd start by looking at your schema.. Quite a lot of use of
varchars... I'd suggest using chars (takes more space but processes
faster).. Or even better, normalize the data so that you have a table
for symbols that is linked to this table via an integer based foreign
key.
Also it seems wierd fo
2006/5/31, Peter Brawley <[EMAIL PROTECTED]>:
Lew,
>If I have another polynomial, say the sum of terms 1,3,4, and 5, how
can I quickly search this
>database to see if it's already been stored?
SELECT DISTINCT polynomial_id
FROM polynomial p1
INNER JOIN polynomial p2 ON p1.term_id=1 AND p2.ter
Greetings,
I generate this report of all the holdings by symbol, summing up over
accounts. It is taking much too long. I was wondering if I can add
an index on something to make it more efficient. The first query
gets the most recent date, the next query sums it up by symbol.
Thank you
You need to check your syntax. You probably don't have FIELDS
TERMINATED BY and [OPTIONALLY] ENCLOSED BY and ESCAPED BY set
correctly.
True... those options are there for both LOAD DATA LOCAL INFILE and
mysqlimport
example:
mysqlimport -u -p --local --fields-terminated-by='|'
one thing here
Yes and no. The binary log is a long list of all changes to the
system, so if that's enabled you can get what was done. My binary log
(on 4.1.19) shows the query thread, but not the user/host that did the
change. So it might be difficult to implement an "undo".
Also, "delete from table1" does
Did you try the first query again? Is it possible that another
"Szczech" was added in the time you did both queries? What happens
when you the simple
mysql> select id_c, name, from clients where name like 'Szczec%';
and
mysql> select id_c, name, from clients where name like 'Szczech';
and most
You need to check your syntax. You probably don't have FIELDS
TERMINATED BY and [OPTIONALLY] ENCLOSED BY and ESCAPED BY set
correctly.
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
-Sheeri
On 5/31/06, Neeraj <[EMAIL PROTECTED]> wrote:
Hi harish
Thanks for reply
By executing this quer
At 17:38 +0200 5/31/06, Gilles MISSONNIER wrote:
Thank you Paul DuBois.
I have 2 questions for you :
1-Why the error code (1064) can't lead explicitly to the syntax problem ?
I'm sorry, I don't understand the question.
2-Could you tell me how I could go directly to the relevant page ?
Thank you Paul DuBois.
I have 2 questions for you :
1-Why the error code (1064) can't lead explicitly to the syntax problem ?
2-Could you tell me how I could go directly to the relevant page ?
[ Hard for you to feel like a lambda user in MySQL ]
my comment :
The "Search the MySQL manual"
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.13, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.13 is a bugfix release for the stable branch that is
suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0
or My
Lew,
>If I have another polynomial, say the sum of terms 1,3,4, and 5, how
can I quickly search this
>database to see if it's already been stored?
SELECT DISTINCT polynomial_id
FROM polynomial p1
INNER JOIN polynomial p2 ON p1.term_id=1 AND p2.term_id=3
INNER JOIN polynomial p3 ON p2.term_id=3
On 5/31/06, Michael Price <[EMAIL PROTECTED]> wrote:
Congratulations Michael! You just got yourself an indexed, searchable
record of ignorance (Gmane, MySQL.com, etc) and laziness, by shouting
at a lot of people to revert something you have started (or let
someone else start by using y
Chris Sansom wrote:
OK, so I suggested phpMyAdmin.
Dan Trainor said:
I highly suggest staying away from PHPMyAdmin.
and, even more helpfully, 'Anthony' wrote:
:-\
Fine - from this I gather phpMyAdmin is perhaps
On 31.05.2006 14:46 (+0100), Paul DuBois wrote:
> --ssl on the client side (mysql) isn't sufficient to enable an SSL
> connection, as stated in the manual. That's why Joerg indicated the
> use of the other options.
Why do I need to provide the client with a certificate? I don't have one
and I al
Chris Sansom wrote:
At 19:44 +1000 31/5/06, Logan, David (SST - Adelaide) wrote:
I would agree, I have found it useful as well. It does have a few
limitations (well the versions I've used)
BTW, what are the limits on OpenOffice's Base being used as a front end?
--
MySQL General Mailing List
F
Hi Michael,
Have you tried the link at the bottom of every email? If not then have you
looked here? http://lists.mysql.com/faq.php
Shouting at everybody who chooses to subscribe (which you have at some stage)
doesn't help
Regards
--
On 31.05.2006 12:47 (+0100), Joerg Bruehe wrote:
> I said I am no SSL expert, I just go by this quote from the manual:
Yes, I saw that. But it doesn't apply on Query Browser because there is
no such option available in the UI.
Btw, I cannot connect to MySQL5+SSL with Query Browser/Win but I can
c
Original Message Follows
From: "Neeraj" <[EMAIL PROTECTED]>
To: "'Harish TM'" <[EMAIL PROTECTED]>,"'sheeri kritzer'"
<[EMAIL PROTECTED]>
CC:
Subject: RE: Problem in using LOAD DATA LOCAL INFILE
Date: Wed, 31 May 2006 17:20:39 +0530
Hi harish
Thanks for reply
By executing this
Hi harish
Thanks for reply
By executing this query for this table I am not getting any error..
But I am getting wrong result.
I have tried many combinations for LOAD DATA LOCAL INFILE but I am getting
the results in two ways...
1. all the data getting loaded in first columns of first row.
Or
2. da
Hi,
I hope this is an appropriate place to ask this question, if you think it
is better suited for another list/forum, please let me know.
I have a table that looks like this:
mysql> select polynomial_id, term_id from polynomial;
+---+-+
| polynomial_id | term_id |
+-
Hi Yves, all!
Yves Goergen wrote:
On 31.05.2006 10:21 (+0100), Joerg Bruehe wrote:
According to your description below, where you got "Could not connect
...", you are given this warning if establishing the connection fails.
So the remaining case is a client trying to connect to a server which
At 19:44 +1000 31/5/06, Logan, David (SST - Adelaide) wrote:
I would agree, I have found it useful as well. It does have a few
limitations (well the versions I've used)
Actually, having just mildly sung its praises, there do seem to be
some bugs in the latest version I installed on my local ma
Hi Chris,
I would agree, I have found it useful as well. It does have a few
limitations (well the versions I've used) but once it is up and running,
it works fine. eg. It doesn't help with replication, amongst a few
others.
I use it internally within an intranet so there isn't much of a security
OK, so I suggested phpMyAdmin.
Dan Trainor said:
I highly suggest staying away from PHPMyAdmin.
and, even more helpfully, 'Anthony' wrote:
:-\
Fine - from this I gather phpMyAdmin is perhaps not a Good Thing.
Now, giv
Hi All,
I'm using 5.0.21 on Gentoo.
I've got very strange problem.
I have clients table with id_c and name columns.
I'm running simple selects:
mysql> select id_c, name, concat('#',name, '@'), length(name) from clients
where name like 'Szczec%';
+---+--+---+
On 31.05.2006 10:21 (+0100), Joerg Bruehe wrote:
> According to your description below, where you got "Could not connect
> ...", you are given this warning if establishing the connection fails.
> So the remaining case is a client trying to connect to a server which
> does not support SSL, or does
Hi Yves, all!
Yves Goergen wrote:
On 30.05.2006 16:28 (+0100), Joerg Bruehe wrote:
To find out whether your server(s) support(s) or not, you need to check
the corresponding variables. All this is described in the manual,
section "5.9.7. Using Secure Connections":
I still think that the clie
40 matches
Mail list logo
