Hello,
We are using mySQL on over 6 servers here, we have been doing so for over 2 years, and
we are constaly facing problems with corrupted tables, especially on two of our
busiest servers.
Tables seem to corrupt out of the blue and we have to shut them down ( the servers )
occassionaly to f
On Thu, Sep 06, 2001 at 12:40:16PM -0700, xris wrote:
> I was just browsing through the searchable online MySQL manual,
> trying to find a list of the aggregate functions (as I don't trust
> the list in the O'Reilly book, considering the number of typos and
> missing information in other sections
On Fri, Sep 07, 2001 at 10:29:31AM +0300, Mark Papadakis wrote:
> Hello,
>
> We are using mySQL on over 6 servers here, we have been doing so for
> over 2 years, and we are constaly facing problems with corrupted
> tables, especially on two of our busiest servers. Tables seem to
> corrupt out of
I'm trying to do select count (*) from table. but it doesn't work
ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes'
at line 1
Same happens with max (column) and min (column).
Do I have to install anything else or is something wrong. I'm using
redhat 7.0 wi
On Fri, Sep 07, 2001 at 09:28:28AM +0200, Antonio Ortega Sancho wrote:
>I'm trying to do select count (*) from table. but it doesn't work
>
> ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes'
> at line 1
>
> Same happens with max (column) and min (column).
>
Antonio Ortega Sancho writes:
>I'm trying to do select count (*) from table. but it doesn't work
Try count(*) instead.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it t
On Fri, Sep 07, 2001 at 09:28:28AM +0200, Antonio Ortega Sancho wrote:
>I'm trying to do select count (*) from table. but it doesn't work
>
> ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes'
> at line 1
>
> Same happens with max (column) and min (column).
No
On Thu, Sep 06, 2001 at 10:44:28AM -0700, Duc Chau wrote:
>
> Hi, can someone tell me how the index number on the bin logs are
> incremented?
They are incremented by adding one to the extension.
001 -> 002 -> 003 -> 004
and so on.
> When i update my master machine the changes are still going
I have a couple questions regarding MySQLGUI:
1. Where is the documentation located? Help only
offers 'about', and I am unable to find any docs on
the mysql.com website.
2. How does one execute multiple commands at the same
time? I know in Microsoft SQL Enterprise manager, you
seperate the lin
I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00
(hppa2.0w),
Apache/1.3.20.
The load are rather high, and "Queries per second avg: 94.859"
This is an local B2B installation som we are really not getting any traffic
between 4PM and 7AM
We have peeks where there is more than
On Fri, Sep 07, 2001 at 10:11:30AM +0200, Terje Kristensen wrote:
>
> We have peeks where there is more than 1000 Queries per second.
> Does anyone have any experience with a higher number of queries pr
> second than this ?
About a year ago, I used mysql-super-smack and was able to hit 8,000
per
Hi,
I have a big problem, the Running_Threads are very often too high
(max_connections is 100) and of course mysql crash with "too much
connections" ! All php3 requests begin with mysql_connect and finish by
mysql_close, our ASP said max_conection is enough high and problem is
elsewhere. We verify
Hi,
a snippet from a session on a linux box running standard mysql client (2.23.33):
mysql> update members_p set newscode='1' where ID='640103502408';
Query OK, 0 rows affected (0.00 sec)
mysql> update members_p set newscode='1' where ID='640103502408';
Query OK, 1 row affected (0.01 sec)
All
> About a year ago, I used mysql-super-smack and was able to hit 8,000
> per second on our [then new] server. The highest I've recorded on an
> actual production application was around 5,000. But I don't watch the
> numbers closely very often...
Just out of curiosity, on what hardware? My nee
It would appear that you are putting spaces between Count and the bracket
which as far as I can tell will not work hence try count(*) etc...
Chris Thorpe
- Original Message -
From: "Antonio Ortega Sancho" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, Septembe
hi all,
i have a question. i would like to know if mysql has a sql'x' standard. my
problem is that i would like to use UNION or MINUS or... but it seems not to
work, another problem is that i would like to make some nested query.
by
thanks in advance.
Giovanni
On Fri, Sep 07, 2001 at 09:54:35AM +0100, [EMAIL PROTECTED] wrote:
>
>
> > About a year ago, I used mysql-super-smack and was able to hit
> > 8,000 per second on our [then new] server. The highest I've
> > recorded on an actual production application was around 5,000.
> > But I don't watch the
Chadrick Mahaffey wrote:
>what does all this mean? I tried to type this in my command console
changin
>/ to \ and I don't understand what is happening. I get all kinds of
errors.
It looks to me that you're trying to use the Unix install notes - don't!
Refer to section
2.1.2 in the excellent man
Hello Terje,
Friday, September 07, 2001, 12:11:30 PM, you wrote:
TK> I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00
TK> (hppa2.0w),
TK> Apache/1.3.20.
TK> The load are rather high, and "Queries per second avg: 94.859"
TK> This is an local B2B installation som we are re
Hi guys,
I'm just a student, working on a project. We have to migrate a oracle
database to MySQL. In order to do that we must search for diferences between
the two and for other information that can help us. (of course we're not
allowed to just download software and convert)
Now, I've allreaddy s
Hello,
I saw your message on the list, could you
tell me which scripting language you are
using (php, perl, java ?)
and if you have the time could you show me
your my.cnf and the result of a "show variable"
request ? I am experiencing problem with 100% CPU
load and can't figure what it is ?
Th
Hi,
i'm using MySQL 3.23.37 on a Linux system with an average of about
20 queries/second.
First of all i have a little question how i can optimize a query.
The query is like that:
select * from tbl where key_field1 & constant1 and key_field2 &
constant2
Examine that query with explain select.
Hi,
> > > About a year ago, I used mysql-super-smack and was able to hit
> > > 8,000 per second on our [then new] server. The highest I've
> > > recorded on an actual production application was around 5,000.
> > > But I don't watch the numbers closely very often...
> >
> > Just out of curiosity,
On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote:
>
> I'm quite surprised that this level of performance is available from
> such standard (well, not standard as in 'common', but y'know what I
> mean...) hardware. The last I heard, 1K+ queries/sec was only being
> done on extremely
Any ideas?
/Mattias
>Hi!
>
>I've just installed (a couple of days ago) mysql.
>I will use mysql for using with hlstats. That is
>a stats-program for HalfLife Counter Strike. (game)
>
>But I got errors... I guess it's a problem with mysql
>or me not knowing how to do it.
>
>Here is some printou
>Description:
There is in manual_Problems.html:
That means that if you search with col_name LIKE 'a%', you will get all
column values that start with A or a. If you want to make this search
case-sensitive, use something like INDEX(col_name, "A")=0 to check a
pre
>Description:
There is duplication in the syntax of INSERT. Last version is special case of the
second.
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES (expression,...),(...),...
or INSERT [LOW_PRIORITY | D
hi all !
i am new to mysql and trying to install it onto my win NT 4.0
workstation.
but the winzip is not able to install it !
is anybody else facing the same prob?
does anybody know the cure?
sumit
-
Before posti
Hi,
Try to extract the files before running setup.exe. If this does not work you
zip archive may be corrupt.
Regards,
Antonie
-- S C I B I T --
Antonie Neethling ([EMAIL PROTECTED])
http://www.scibit.com/mysql - MySQL related products
-- S C I B I T --
> -Or
Jeshua Lacock writes:
>
> Hello all,
>
> I have searched the archives and found various suggestions and tired
> them (and variations of them) and I cannot get "mysqld" running on Mac
> OS 10.0.4 (Darwin 1.3.7).
>
> I had previously built and run 3.23.39 on the same machine, but I cannot
> ge
Hello,
I am running version 3.23.41 on windows '98. When I run winipcfg I show
that my hostname is siren.goldengate.net and
my ip address is 10.0.0.1. When I type c:\mysql\bin mysql I get an error
message:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I tried several versions
Hi all,
I'm trying to build the MySQL super-smack benchmarking tools. I'm getting
the following errors on make:
make all-recursive
make[1]: Entering directory `/root/rpms/super-smack-1.0'
Making all in src
make[2]: Entering directory `/root/rpms/super-smack-1.0/src'
c++ -DHAVE_CONFIG_H -I. -I.
Edward Beheler writes:
> I have a couple questions regarding MySQLGUI:
>
> 1. Where is the documentation located? Help only
> offers 'about', and I am unable to find any docs on
> the mysql.com website.
>
> 2. How does one execute multiple commands at the same
> time? I know in Microsoft SQL E
Campbell writes:
> Hi,
>
> a snippet from a session on a linux box running standard mysql client (2.23.33):
>
> mysql> update members_p set newscode='1' where ID='640103502408';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> update members_p set newscode='1' where ID='640103502408';
> Query
Hi,
I'm making an application on C++Builder5,
which will be comunicated with MYSQL server , What do you
MYSQL API recomend : MYSQL++ or MYODBC, I know that the
MySQL C++ API is the official API, but can I connect to
other SQL server whit this API?
Thank you,
Vilmara
*** PDV
Giovanni Borri writes:
> hi all,
>
> i have a question. i would like to know if mysql has a sql'x' standard. my
> problem is that i would like to use UNION or MINUS or... but it seems not to
> work, another problem is that i would like to make some nested query.
>
> by
> thanks in advance.
Aaron Brick writes:
> good day -
>
> i have found cases in which the daemon blocks waiting on a select() and
> just plain refuses to process certain queries. since i am reading in a 60
> meg file, meaning about 3.5 million queries, this consistently happens
> somewhere in the middle. i am using 3
I need to make about 15 tables that use the same template as the first one.
Please help.
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
Basil Hussain writes:
> Hi,
>
> I'm quite surprised that this level of performance is available from such
> standard (well, not standard as in 'common', but y'know what I mean...)
> hardware. The last I heard, 1K+ queries/sec was only being done on extremely
> high-end Sun enterprise-level machin
Ai2s, Proyecto writes:
> Hi,
>
> I'm making an application on C++Builder5,
> which will be comunicated with MYSQL server , What do you
> MYSQL API recomend : MYSQL++ or MYODBC, I know that the
> MySQL C++ API is the official API, but can I connect to
> other SQL server whit this API?
>
> Th
Hi,
on freshmeat.net you can find some libraries which provide same
comfort as mysql++, so try check...
S pozdravem
Michal Dvoracek [EMAIL PROTECTED]
Capitol Internet Publisher, Korunovacni 6, 170 00 Prague 7, Czech Republic
tel.: ++420 602 210 900, ++420 2 3337 1117, fa
Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> If you wish to make your application transparent, you should use ODBC.
ODBC, or MyODBC?
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server
Hello
we would like to use MYSQLGUI
is it allowed ?
Id not not have any user and password to enter for download
Best regards
Franck Lepretre
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
Ed Carp writes:
> Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
>
>
> ODBC, or MyODBC?
> --
> Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
>
> Squished Mosquito, Inc.
> Internet Applications Development
> Escapade Server-Side Scripting Language Development
[EMAIL PROTECTED] writes:
> Hello
>
> we would like to use MYSQLGUI
>
> is it allowed ?
> Id not not have any user and password to enter for download
>
> Best regards
>
> Franck Lepretre
>
It is completely free to use as much as you wish on as many computers
as you wish.
Just download
Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> Ed Carp writes:
> > Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> >
> >
> > ODBC, or MyODBC?
>
> ODBC as an API.
>
> Then you install ODBC driver for RDBMS of your choice and configure
> ODBC likewise.
>
> But ODBC as a programming mode
hi !
thanx for your reply. now i could install mysql on my NT.
nut now when i give the command mysql-nt --install it says unable
to install.
moreover as it is in the installaton doci tried to look for the
my-example.cnf file but i cud get only a link of this name in whole of
my
Ed Carp writes:
>
> So, is MyODBC just for MySQL, or can one use it for talking to other databases via
>ODBC also? Sorry, I'm just confused today, I guess ;)
> --
> Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
>
> Squished Mosquito, Inc.
> Internet Applicati
Hello!
Is it possible to get the total number of records when doing a select with
LIMIT?
For example, if I do:
SELECT * FROM tbl LIMIT 0,10
I would like to get the total number of records in tbl along with the 10
first ones..
I need this to display "showing 0 - 10 of 354", and my quer
-Original Message-
From: Jean Paterson [mailto:[EMAIL PROTECTED]]
Sent: 07 September 2001 14:34
To: '[EMAIL PROTECTED]'
Subject: Problems retrieving tables
Can anyone help- I am new to MySQL.
I am using Ultradev. I have installed MyODBC on my PC and set it up
connect to my ISPs MySQL
%% Chadrick Mahaffey <[EMAIL PROTECTED]> writes:
cm> How do I start the server and create a database in plain English. I'm not
cm> familiar with:
cm> SECTION 4.16 - Documentation
shell> ./scripts/mysql_install_db
shell> cd mysql_installation_directory
shell> ./bin/safe_mysqld --u
Hi,
I my name is ryan and I own a small site which has a mysql database and servlet
support.
I have a simple query to all you mysql gurus...
my table is very simple, i created a table with the following
create table datee(int today);
now,what statement do I use to put the sysdate into the colu
Deryck Henson ([EMAIL PROTECTED]) writes:
> I need to make about 15 tables that use the same template as the first one.
> Please help.
Please post more information. Platform, software, etc. This is like saying, "I want to
get from point A to point B. Please help."
OK, I've got that out of my
Hi
First of all try to use datetime column for date&time storage porpouses.
create table datee(datetime today);
And then:
insert into datee(today) values(now());
After all of this, please RTFM :)). It's all written there.
Regards
Daniel Łaś
e-direct Polska s
Terje Kristensen wrote:
>
> I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00
> (hppa2.0w),
> Apache/1.3.20.
>
> The load are rather high, and "Queries per second avg: 94.859"
> This is an local B2B installation som we are really not getting any traffic
> between 4PM and
Jeremy Zawodny wrote:
>
> On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote:
> >
> > I'm quite surprised that this level of performance is available from
> > such standard (well, not standard as in 'common', but y'know what I
> > mean...) hardware. The last I heard, 1K+ queries/sec
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes:
> now,what statement do I use to put the sysdate into the column today?
> this is NOT working
> insert into datee values(select DAYOFMONTH(sysdate()));
Of course not. "insert into datee values (Now())" will, though. Just feed it
to mysql ... ;)
Here
Hi List,
I'm a little bit confused.
I do the following:
Create a table with 1 int and two floats.
mysql> create table testfloat(z int, ll float, ul float);
Query OK, 0 rows affected (0.00 sec)
inserting one row into the table
mysql> insert into testfloat values(1,-0.1,0.1);
Query
On Thu, Sep 06, at 11:05pm, Chris Bolt ([EMAIL PROTECTED]) wrote:
> SELECT * FROM yourtable WHERE id = LAST_INSERT_ID();
But that will only work if it was the same thread that inserted the last record in
the table. If this is running from say .. a script that just wants the last
inserted record
Why not just:
SELECT MAX(id) AS max_id FROM yourtable;
Then run another select to get the record?
Or, if you want the last record:
SELECT * FROM yourtable ORDER BY id DESC LIMIT 1;
maybe.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original M
Mark Papadakis wrote:
> We are using mySQL on over 6 servers here, we have been doing so for over 2 years,
>and we are constaly facing problems with corrupted tables, especially on two of our
>busiest servers.
> Tables seem to corrupt out of the blue and we have to shut them down ( the servers
On Friday 07 September 2001 15:37, Torgil Zechel wrote:
> Is it possible to get the total number of records when doing a select with
> LIMIT?
No. As least, not in MySQL, unless I am missing something.
> For example, if I do:
>
> SELECT * FROM tbl LIMIT 0,10
>
> I would like to get the to
I wanted to put in my 2 cents. Access is not an RDBMS.. It is a single
user - small user, and frequent fix type system. I have never worked on a
real database system that does not have a command line interface. It seems
fearsome at first, but it's actually easy. SQL Server do doubt ha
Hello,
Actually I am programming an web directory (like yahoo). But my sql queries
need
ernormous cpu resources. So it is quiet slow. I can't use indexing because
my serach works with <>. (apparently then it dosen't
help).
Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
t
I think this is a little OT here, so after reading please
indicate me where to talk about this subject.
I'm a skilled programmer in C, C++ and others progr. lang.
I have also a solid background in SQL and some RDMS
(DB2, Oracle, SQLServer, and of course, Mysql).
I'm going to attend a long perio
Stefan Pinkert wrote:
> Examine that query with explain select... show that the indexes are not
> used. The keyfields are unsigned tiny int where every bit has a different
> meaning. Any clue how i can rewrite this query in a way where the indexes
> are
> used?
If MySQL thinks it will be faster
On Friday 07 September 2001 06:11 am, you wrote:
> Giovanni Borri writes:
> > hi all,
> >
> > i have a question. i would like to know if mysql has a sql'x' standard.
> > my problem is that i would like to use UNION or MINUS or... but it seems
> > not to work, another problem is that i would li
Lorang Jacques ([EMAIL PROTECTED]) writes:
> Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> tables. As it
> is quiet some work, I first want to ask you guys if this is really going to
> make my queries faster (much faster ?)
Yup. I've got the entire set of laws for th
Claudio Cicali wrote:
> I'm going to attend a long period of holidays (finally) so,
> I thought: why don't try to implement stored procedures
> in mysql ?
>
Someone did it with perl.
http://software.tangent.org/article.pl?sid=01/08/23/0817244&mode=thread&threshold=
> At a first glance, I think
- Original Message -
From: "Colm Brazel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 4:33 PM
Subject: Re: command line open source ARRRGG!!
> > Open source software is written by technical people. They do it because
> > they enjoy it. Most of t
Claudio Cicali ([EMAIL PROTECTED]) writes:
> At a first glance, I think Oracle PL/SQL is the best (afaik)
> programming language for sp, but, in the case we implement
> that language, should we go against some Oracle copytight
> infringment ?
Why would you want to do such a thing? Isn't SQL good
What´s the diference between The row storage format (Fixed, Dynamic, or
Compressed) .
I'am experiencing problems with update statements which goes against a table
with the row_format property set to Fixed.
Thanks.
Pablo Fraga (MIS).
e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED]
icq: 113466029
At 10.44 07/09/2001 -0500, Ed Carp wrote:
>Claudio Cicali ([EMAIL PROTECTED]) writes:
>
> > At a first glance, I think Oracle PL/SQL is the best (afaik)
> > programming language for sp, but, in the case we implement
> > that language, should we go against some Oracle copytight
> > infringment ?
>
On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote:
> Lorang Jacques ([EMAIL PROTECTED]) writes:
>
> > Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> > tables. As it is quiet some work, I first want to ask you guys if this
> > is really going to make my queries f
Jeremy Zawodny wrote:
< snip >
>
> Are subsequent inserts just as slow to replicate?
>
> Can you show us the output of SHOW SLAVE STATUS and maybe the my.cnf
> files of the master and a slow slave?
>
> Jeremy
>
Thanks for the response. Below is the info you requested. If there's
anything
Hi All,
where do I specify the remote hosts that are allowed to access port 3306? I
have made entries in the user table of the mysql db, but still cannot conect
from a remote machine. Thanks,
Ric.
_
Get your FREE download of MSN
My $.02,
Stick with the ANSI standard. (ANSI99?) Do not try to implement either
PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any
other procedural or OO language in stored procedures. Speaking form
experience, all this does is blur the lines of that the database should
If you read thru more about the reasons for recommendation for
installing thru RPM, you'll understand. Since the folks who built RPMs
have definitely spent lot of time building the RPMs which is optimized
for performance. I do trust them and commend their efforts.
The source definitely gives you
This is a standard 1st quarter computer science topic.
You can't reliably test floating point numbers for equality.
0.1 has no exact floating point binary representation.
Perhaps you should use the DECIMAL type which is stored
internally as a string.
Guddack Thorsten ICM MP SCM SCCM PI wrote:
>
What´s the diference between The row storage format (Fixed, Dynamic, or
Compressed) .
I'am experiencing problems with update statements which goes against a table
with the row_format property set to Fixed.
Thanks.
Pablo Fraga (MIS).
e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED]
icq: 113466029
> - it's cool
Not a valid business reason.
> - where I work, we have a HUGE database-driven web-application. A lot of
>our business logic is implemented via stored procedures, that
>act as black boxes for the web-designers.
>Think of enterprise java beans.
>They are not "nonsense
Ed,
Stored procedures allow you to pre-compile and re-use code easily. They also
make transactions easier. (At least from one point of view) It's not like
the XML argument. SPs are also part of the ANSI spec so to be compliant,
MySQL will have to have them. XML is not part of the ANSI-SQL spec.
> Do the current limitations of 500 characters per index and limited (?)
> number of columns per index pose problems? I want to use fulltext
> on a database with 7 varchar(255) columns and several smaller varchar
> columns but can't build a fulltext index. Is there documentation on
> the limitat
Cal Evans ([EMAIL PROTECTED]) writes:
> Stick with the ANSI standard. (ANSI99?) Do not try to implement either
> PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any
> other procedural or OO language in stored procedures. Speaking form
> experience, all this does is blur
Pablo Fraga ([EMAIL PROTECTED]) writes:
> What´s the diference between The row storage format (Fixed, Dynamic, or
> Compressed) .
RTFM!
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
http://www.mysql.com/doc/D/y/Dynamic_format.html
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - htt
At 11.03 07/09/2001 -0500, Ed Carp wrote:
> > - it's cool
>
>Not a valid business reason.
>
> > - where I work, we have a HUGE database-driven web-application. A lot of
> >our business logic is implemented via stored procedures, that
> >act as black boxes for the web-designers.
> >Thin
Ed Carp wrote:
>
> Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
>
> > Ed Carp writes:
> > > Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> > >
> > >
> > > ODBC, or MyODBC?
> >
> > ODBC as an API.
> >
> > Then you install ODBC driver for RDBMS of your choice and configure
> > ODBC likewise.
>
Not quite. We're not looking for a left join or natural left join.
I'm not sure MySQL or any database can even do this, it may have to be
done (rather unattractively) on the API side.
The data in the two tables aren't tied by ID, and shouldn't mix w/ each
other at all.
To do this, all we've bee
No, they do not differ from the rest. The only thing is that they need
longer
time to process (between 1 and 4 seconds, normally the SAME query is
processed
in a few miliseconds). The only correlation i found is that all queries
in that
log query the merge table.
How does mysql handle locks on m
Let me clarify.
I'm in great favor of stored procedures in MySQL. It is my HO that all
interaction with the database should take place within stored procedures.
But the ANSI standard is sufficient for most interaction with the database.
My call to arms was to resist the urge that Oracle could no
Torgil Zechel writes:
> I would like to get the total number of records in tbl along with the 10
> first ones..
As far as I recall this is one of the things that will be added in
version 4. The question is just when that version will be stable
enough to be fully trusted (it might already be for
On Fri, Sep 07, 2001 at 11:10:46AM -0500, Ed Carp wrote:
> > Do the current limitations of 500 characters per index and limited (?)
> > number of columns per index pose problems? I want to use fulltext
> > on a database with 7 varchar(255) columns and several smaller varchar
> > columns but can't
ricardo bravo writes:
> Hi All,
>
> where do I specify the remote hosts that are allowed to access port 3306? I
> have made entries in the user table of the mysql db, but still cannot conect
> from a remote machine. Thanks,
Do the entries match the host you're connecting from? Did you add th
On Fri, 7 Sep 2001, Cal Evans wrote:
> Date: Fri, 7 Sep 2001 11:05:27 -0500
> From: Cal Evans <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED], Ed Carp <[EMAIL PROTECTED]>
> Subject: Re: Let's approach stored procedures
>
> Ed,
>
> Stored procedures allow you to pre-compile and re
Cal Evans wrote:
> Stored procedures allow you to pre-compile and re-use code easily. They also
> make transactions easier. (At least from one point of view) It's not like
> the XML argument. SPs are also part of the ANSI spec so to be compliant,
> MySQL will have to have them. XML is not part of
SQL. Stored procedures are loosely analogous to shell scripts. No
additional language constructs, outside of what is defined in the ANSI-SQL
standard are necessary for them.
IMHO, C would be a bad thing.
My $.02 worth, (which is worth less, each time I post)
Cal
*
* Cal Evans
* Senior Internet D
> Since the current version of MySQL is open source you could write stored
> procedures in the same language used in (until recently) DB2, i.e., C. I
Why reinvent the wheel? MySQL already has user-defined function capability
in C.
> Related question, what language or psuedo language would be us
Hi,
> > On the other hand though, it gives me some comfort that the hardware
> > being used in my operation will meet any future needs. We have
> > similar spec servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI
> > RAID5). Maybe I should try out mysql-super-smack and see what kind
> > of numbers
Hello,
How can I limit the query to those rows where "SUM(value) as Tot > 0". If I
put it in an where clause it get an error. So how to do that
SELECT id,url,title,description,top,keyword,SUM(value) as Tot FROM links
LEFT JOIN keywords on links.id=keywords.LinkId Group by id order by tot desc
Lora
Hi, I am a newbie to MySql and I am planning to use MySql and PHP to develop
a shopping cart and other components of a full blown ecommerce site. Is this
a good choice for this kind of work or do you guys think some thing like SQL
Server and ASP is a better choice.
Experienced users, please ad
1 - 100 of 160 matches
Mail list logo
