Ken writes:
Query question:
Can anyone think of a way to accomplish this in a single query?:
I have a table with elements that each have a date.
For a given record, I want to get, in one query, the record just earlier than this
record's date, and the record just later than this
Hi all
I was just getting thru the documentation of MySQL at the mysql.com
site and there it is specified that
The recommended way to install MySQL on Linux is by using an RPM file
Can anyone tell me in what way it is different installing mysql from the
rpm's and from the source code ??
Hi all,
How can I retrieve mysql admin password if I forget it??
Rgds,
unplug
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
On Thu, Sep 06, 2001 at 04:35:57PM -0700, Aaron Brick wrote:
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
On Thu, Sep 06, 2001 at 12:36:12PM -0700, Duc Chau wrote:
I just wanted to know how stable is mysql databse replication is?
What we have in mind is a tiered system.
$master (california)-(internet ssh tunnel)
\$slave (texas)
10 other slave
On Wed, Sep 05, 2001 at 01:33:03PM -0700, A. Clausen wrote:
I've been running a master/slave MySQL database system for about
four months now and I've got nearly 360mb of binary logs. I want to
archive anything over about a month old, but I've heard that there
is a procedure that you have to
On Wed, Sep 05, 2001 at 03:43:00PM -0500, Jeff Adams wrote:
Greetings,
This morning we sucessfully inserted a new record on our master
MySQL machine. 4 1/2 hours later, the change showed up on the
slaves. I was under the impression that MySQl replication would
occur in a more timely
On Thu, Sep 06, 2001 at 06:08:00PM +0800, Chun-Hung Chen wrote:
When configuring mysql, some errors happened.The report of config.log
and error messages are listed below.The environment I use is Sun Solaris
8(SunOS 5.8) with gcc 2.95.3.
[snip]
configure:2376: checking return type of sprintf
I'm looking for a simple CRM (adresses / contacts / orders)
system using MySQL as a back-end. If anyone on this list
has developed (or have knowledge of) a system with the
following requirements, please drop me a message.
- MySQL *must* be the backend (for integration w/ other
company data)
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
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 the
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
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).
Do
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
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 to
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
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 I
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 needs
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, September 07,
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 numbers
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
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 really
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
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 ?
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
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 what
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 printouts what
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
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 |
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
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 --
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
get 3.23.41
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
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)
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 machines.
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?
Thank you,
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,
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
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
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 Team
[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 binary or
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
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 Applications
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 query
-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
%% 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
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
Deryck Henson ([EMAIL PROTECTED]) writes:
I need to make about 15 tables that use the same template as the first one.
Please help.
gripe
Please post more information. Platform, software, etc. This is like saying, I want to
get from point A to point B. Please help.
/gripe
OK, I've got that
Hi
First of all try to use datetime column for datetime 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 sp.
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 7AM
We
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 was only
[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's
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
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 total
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
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 LIKE '%$serchstring%'. (apparently then it dosen't
help).
Now I was wondering if it would get faster by using
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
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 to
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 like to make
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 the
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/0817244mode=threadthreshold=
At a first glance, I think Oracle
- 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 them don'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 ?
Why would
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 faster
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 else that
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
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
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 or
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 limitations
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 the
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 -
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.
Think of
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.
But ODBC as a
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
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
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
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 build
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 them
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-use code
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
1 - 100 of 162 matches
Mail list logo