I am getting a misleading error message saying "duplicate key 127 at key 1" when
trying to add an item to a table. There is no duplicate (I downloaded then uploaded to
a new table and get the same error). The unique key is a smallint(4) with
auto-increment. Is there some limit in MySQL on a Lin
"MAN ..." wrote:
>
> HI THERE, I HAVE A PROBLEM WITH THE ETTIQUETES OF THE DATABASE, I MEAN HOW DO I CAN
>MAKE A SITE WHERE I CAN UPLOAD INFORMATION WITH A DATABASE, FOR EXAMPLE:
>
> IF I WANT A PAE WHERE SAYS "PUT YOUR NAME HERE" AND YOU HAVE TO PUT IT IN AN
>TEXTAREA HOW DO I MAKE THAT THAT
Anna wrote:
> No.
> As long as you give them different names. :-)
> $connectionLocal=mysql_connect(bleah, bleah, bleah);
> $connectionOther=mysql_connect(bleah, bleah, bleah);
>
> Then in any mysql_query you must, of course, specify
> which connection you are using.
>
> Anna
>
Thanx,
I've alread
Hello, I'm looking at the manual, and I cannot find the answer to this simple question.
What is the datatype in mysql for boolean? In Access it's yes/no.
What about mysql?
Thanks
Joel
Hello,
Until recently I have spent most of my time using the major databases such
as Oracle, DB2, Sybase etc. I am new to MySQL. At first I was excited
about such a low cost alternative such as MySQL, and I have found Mysql to
be a great database for very small databases, but for large databases
At 10:10 09/02/2001 +0800, Li Sze wrote:
Hi Li,
I will take a look in MyODBC code about the SQLBindParameter and
when I will have a reasonable answer I will send you the reply.
Regards,
Miguel
>Thanks for responding. I've changed the column back to size 1. However, if I
>follow the example from
OBDC's strength is that it is almost universal in accessing files, not
speed, and that may be the reason why using the jet engine will produce
quicker results. I don't know if it will work on your end, but I moved from
using MyOdbc to the following statement in accessing mysql database:
strCon
A recursive algorithm is the term used for an algorithm where a function
calls itself. Listing the entire directory structure of your hard drive
would employ such an algorithm. Any good book on programming should explain
recursive algorithms. You may find that helpful.
- Original Message
At 4:00 PM -0500 2/8/01, Paul E. Miller wrote:
>I encountered something really handy while playing
>around with mysql. The documented behavior for
>auto_increment is that it uses the next highest number no
>matter what.
>
>I noticed though, when I have a two element primary key,
>that the auto_in
Thanks for responding. I've changed the column back to size 1. However, if I
follow the example from the Microsoft Documentation, that is setting the
last parameter to &cbValue where cbValue = SQL_NTS, and BufferLength to 0, I
get a handling exception error when the last SQLParamData is called. Th
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> 1) Today I tried to reload my tables with backuing up and recovering
Peter> whole database by mysqldump - it seems like it does not work -
Peter> mysqld crashed during loading data back even after I'
Greetings!
I am one of the developers of a MUD, and we have recently decided to rewrite our
entire driver to C++/OOP and use MySQL to store our data, so it has become my
duty to begin to learn about all the facets of MySQL. I have been going through
FAQs, manuals, etc, and we are also using MySQ
Hi,
I'm a total newbie to MySQL. I am creating an application in
Java/JSP/Oracle. However, my client wants to move to MySQL because of the
low costs, and I have no idea about MySQL.
I just downloaded the API from MySQL.com
I now need to know the following things :
1. Is there a graphical util
Hello,
I am experiencing a problem with aborted connections to the db. In
essence, I have an web-based application writing large amounts of data
to a mysql database. The error seems to occur randomly. The only
reproducible part of the problem seems to be that the bigger the data
set the more like
Has anybody successfully built 3.23 on Mac OS X Public Beta? Does anybody
know if the version it supposedly builds under is a later beta? I still
can't seem to get it to work properly.
Thanks,
Geoff
-
Before posting, please ch
Hi,
I am using Mysql-3.23.22. Recently I encounter one of my database tables give me
"error 127", whenever I do a "select *" query and mysqldump. I did a perror command
and it does not give me any idea what is the meaning of this error number.
Can anybody help? Thanks in advance...
Daniel
> I am writing an application that will poll up to 500 devices every 5
> minutes. For this application I need to keep at least 6 months of data. If
> I were to use a single record for every update, I would have ~25 million
> records. Obviously this is not an ideal solution.
>
> I am intereste
On 08.02.2001 15:09:47 Christian Ribeaud wrote:
> would like that the table put automatically the today's date for every INPUT
as
> default value. What is wrong?
Uhm, why don't you use a timestamp column type then? Okay, it will also save
the time, but it's easy to extract only the date, if th
Hi,
One thing I have always wondered, how do you deal with table locking if you
have a number of people using mySQL with ODBC?
Does ODBC handle it? Does Access do it? Can mySQL do it with Berkeley?
I am esp talking if you are using mySQL from many different locations and
working on the same tab
Re your second query - without looking at the docs,
unix_timestamp(field1) - unix_timestamp(field2) would give you the
difference in seconds - I;m sure there's a cleaner way though!
On Thu, 8
Feb 2001, Quickling wrote:
> Hi,
>
> Question 1:
> ---
> We've got a server app that does a
Actually there is no reason to expect MySQL to perform better than
Access for a nominally sized database and everything running on one PC.
Access was designed and optimized for JET whereas ODBC is a
general-purpose API.
Also, the connection method impacts this significantly, as do the
complexity
Hola alguien habla español. que pueda ayudarme como se hace copia de
seguridad a tablas exageradamente grande.
He consultado el comando backup table tablas, to 'ruta' .
hay otra forma?.
Gracias.
Roger Retamoza
ICQ 102090754
Barranquilla Colombia
--
On Thu, 8 Feb 2001, Quickling wrote:
> Date: Thu, 08 Feb 2001 17:02:59 -0500
> From: Quickling <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: MySQL vs Access; you'd *think* the choice is obvious...
>
> Hi,
>
> Question 2:
> ---
> Is there any way in MySQL to compute, inline
Quickling wrote:
>
> Hi,
>
> Question 1:
> ---
> We've got a server app that does a lot of 'small' database reads and
> writes. We were originally using MS Access via DAO (Jet Engine) and we
> wanted to tighten up DB performance, so we've written a general ODBC
> database wrapper
Well, only use Access if it's a small project. I've used both MS SQL,
Oracle 7.3 and MySQL. My MS db is about 8 Gigs and I've only had to rebuild
damaged tables once in the last year...I just upgraded it to SQL server
2000, and it seems fine so far, as well. Oracle, I had bunches of problems
wi
Hi,
Question 1:
---
We've got a server app that does a lot of 'small' database reads and
writes. We were originally using MS Access via DAO (Jet Engine) and we
wanted to tighten up DB performance, so we've written a general ODBC
database wrapper object, but mainly just to connect
I have a data item (stored as a varchar) that looks like this:
Mel\'nikova
fieldname='Mel\'nikova' doesn't match it. Neither does
fieldname='Mel\\\'nikova'. fieldname='Mel%nikova' does produce a match,
and so does fieldname='Mel__nikova' (which leads me to believe that
mysql treats \' as
Or you could (if the two db servers are on the same lan) place a load
ballancer before them and the php connection wouldn't really care because the
two will look like one...;) Or you could write a connector script that checks
the 'health' of each server and then return the connect for that one.
c
Quentin Bennett wrote:
>
> Hi,
>
> For an indexed column, the index is used if the start of the string is used:
>
> LIKE 'a string of text%' may use an index
> LIKE '%any old string%' will not, since the start of the string is unknown.
>
> The index will only be used if the server decides th
See bugreport below.
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Friday, 09 February, 2001 10:38
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject:mysql-3.23.32-dec-osf5.1-alphaev6 dies on DECthread error in OSF1
V5.1
MySQL binary 3.23.32-dec
Hola Paul.
El campo incremento se usará en todas las versiones de MySql. es el primer
mai que recibo tambien puedes usar esto segun la ayuda.
*como crear un campo incremental
CREATE TABLE persons (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(60) NOT NULL,
PRIMARY KEY (id))
If that's the case u r running it but not really using it ... !!
> -Ursprüngliche Nachricht-
> Von: Joshua J. Kugler [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 8. Februar 2001 22:24
> An: Chan, Kwok-Hing; '[EMAIL PROTECTED]'
> Betreff: Re: Maximum Capacity and Stability
>
>
> I c
I can't speak for the maximum capacities (but I think they are in the manual
or FAQ) but as to stability, I've never had MySQL crash or corrupt a table,
and I've been running it for several months; almost a year, actualy.
j- k-
On Thursday 08 February 2001 01:19, Chan, Kwok-Hing wrote:
I encountered something really handy while playing
around with mysql. The documented behavior for
auto_increment is that it uses the next highest number no
matter what.
I noticed though, when I have a two element primary key,
that the auto_increment behavies in a majik uber-cool way.
I want to u
Actually I got "A connection could not be made using the data source parameters
entered. Save non-verified file DSN?
"(Mr) Pekka Gaiser" wrote:
> Hi,
> I got no solution, just a few ideas, probably you have checked them already.
> - Windows DSN name doesn't matter. Type in anything you want.
> -
How do I post a new binary distribution for inclusion in the page
http://www.mysql.com/downloads/mysql-3.23.html
?
I would like to contribute a standard binary distribution for DEC OSF
4.0D (Alpha) [mysql-3.23.32-dec-osf4.0d-alphaev56]. Compiling mysql
on this platform is a major pain, requi
If OPTIMIZE TABLE appears to be writting to a temporary file
while it works (.TMM).. Why must it lock readers out of the original
table file?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Trying to install the latest version mysql-3.23.32 on AIX 4.3. The install
script mysql_install_db fails with the following error:
Could not load program ./bin/my_print_defaults:
Dependent module /usr/local/lib/libz.a (shr.o) could not be loaded.
Member shr.o is not found in archive
libz.a exi
select column1,column2,column3, count(*) as numlines
from table
group by column1,column2,column3
having numlines > 1
That will find them,, you'll have to write some script or something
to go through the results and remove the duplicates, I'm not
sure if a query that will do both at once.
Linse
"Carsten H. Pedersen" wrote:
>
> > Does anyone know how to find duplicates in a table and deleting
> > them. I can't figure out how to structure the query.
> >
> > Linsen
>
> http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_6_0
>
> / Carsten
> --
> Carsten H. Pedersen
> keeper and maintainer of t
All of the examples from teh mysql++ docs show hte connection as:
Connection con("mysql_cpp_data");
whenever I run this statement, I get a seg fault. What is the problem?
My permissions are okay, I don't need any for mysql. Someone please
help, I'm stuck here and this is not good. I'm using Re
Depending upon the function of the table, you might consider
designing your table such that duplicates aren't possible (e.g.
putting a UNIQUE index on a column or set of columns).
Other than that, try dumping your table, removing the rows you
don't want, and reloading the table.
-Tilghman
--
"
I suppose you mean that you've been using telnet to access the
server and mysql to access the mysql server. From a security
standpoint, you should probably install sshd, deinstall telnet,
rsh, rexec, etc. and use ssh exclusively to login to your server.
Of course, this is only a tiny piece of an
do any one knows about a mailling list of oracle? wich is the eamil
address for subscribing to it? please mail me back ASAP, cheers
On Thu, 8 Feb 2001, clay bond wrote:
> Date: Thu, 8 Feb 2001 13:23:08 -0500 (EST)
> From: clay bond <[EMAIL PROTECTED]>
> To: unlisted-recipients: ;
> Cc: [EMAIL
I hope you have unique id in your table
Select distinct into temp table, then select each row from temp table and
delete from your_table where
field="dupl value" and id<>temp.id (in abstract syntax)
- Original Message -
From: Linsen Limsico <[EMAIL PROTECTED]>
To: mysql_list <[EMAIL PROTE
Willem Bison a écrit :
>
> When we increase the number of connections our 3.22.25 server 'hangs':
>
> mysql> show status;
> No connection. Trying to reconnect...
> ERROR 1129: Host 'xxx is blocked because of many connection er
> rors. Unblock with 'mysqladmin flush-hosts'
> ERROR: Can't connect
On Thu, 8 Feb 2001, Linsen Limsico wrote:
> Does anyone know how to find duplicates in a table and deleting them. I can't figure
>out how to structure the query.
>
> Linsen
>
Hello,
Being new to this I don't know the coding however I would look at making
another table and then use the UNIQUE com
> I tried the following code:
>
> CREATE TABLE news (... published date DEFAULT 'NOW()' NOT NULL,
> ..., showIt ENUM('TRUE') DEFAULT ERROR, ...);
>
> and I was surprised to get an '-00-00' as date after doing a
> SELECT. I would like that the table put automatically the today's
> date for
>- Original Message -
>From: "Linsen Limsico"
>Does anyone know how to find duplicates in a table and >deleting them. I
can't figure out how to structure the query.
>Linsen
Exact duplicates or where only one field is duplicated?
Anna
--
On Thu, 8 Feb 2001, Curtis, Lorenzo wrote:
> 2. Is there a detailed outline to use to compile Apache with PHP and mySQL
> effectively?
www.devshed.com/Server_Side/PHP/Soothingly_Seamless/print.html
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
--
Please look in the mysql manual before you ask questions (if you already
haven't)
http://www.mysql.com/doc/P/r/Privilege_system.html
:)
--Atle
On Thu, 8 Feb 2001, Jen Carroll wrote:
> I am getting the same error when I try to connect. Mine is a brand new
> install. Have you have any luck tro
Hello Konstantin,
this code is buggy, because 'new' is not a valid C operator.
And MYSQL is a struct not an object.
The 'new' operator allocates memory for objects (C++).
In C you?ve to use the malloc function.
Take a look at the libmysqltest example, which comes with your distribution.
Regard
> Does anyone know how to find duplicates in a table and deleting
> them. I can't figure out how to structure the query.
>
> Linsen
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_6_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlf
> "BR" == Brian Reichert <[EMAIL PROTECTED]> writes:
BR> When I try to do a mysqldump on the localhost, I get an out-of-memory
BR> error:
BR> # mysqldump -uroot -proot customer audit_trail_271
BR> mysqldump: Out of memory (Needed 8164 bytes)
BR> mysqldump: Got error: 2008: MySQL client
Does anyone know how to find duplicates in a table and deleting them. I can't figure
out how to structure the query.
Linsen
Check manual on ISNULL or another MYSQL functions that deal with NULL and
return 0 or 1.
- Original Message -
From: S A <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 3:34 AM
Subject: how to get SELECT to return 0 or 1 for WHERE match ?
>
> I want to SELEC
Danial Subhnai wrote:
>
> Hi,
>
> We require a developer with very good Mysql skills and experiance of
> getting big databases running fast.
>
> The database structure is built but we need someone to look it over and
> tune it up to run much faster than it does at the moment. DB is spread
>
Suse 7.0 when I ran rpm -Uhv MySql*3.23.32-1.i386.rpm against the sever, the
client and the
shared rpms.It ran without error and created the appropriate files on a 10 gig
/var/lib/mysql.
I moved the contents of mysql to /dbshare and created a symbolic link in /var/lib
called mysql which pointed
I am getting the same error when I try to connect. Mine is a brand new
install. Have you have any luck trouble shooting this problem?
Jen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
> I am writing an application that will poll up to 500 devices every 5
> minutes. For this application I need to keep at least 6 months
> of data. If
> I were to use a single record for every update, I would have ~25 million
> records. Obviously this is not an ideal solution.
Why not? Given
> Hi all.
>
> Apologies for not lurking long and if this question is answered
> somewhere I
> haven't yet found, but I'm on a timescale here...
>
> My company is looking to use MySQL on free *nix (FreeBSD or
> Linux) to store
> some text data and a *lot* of BLOB data.
>
> I am trying to check
Does anyone know how to find duplicates in a table and deleting them. I can't figure
out how to structure the query.
Linsen
Hi All,
I've built previous versions of mysql with gcc/g++ or other IBM
C++ compilers, but I'm having some problems with their VisualAge C++
V5.0.1 compiler.
Curently I have an error while compiling sql/sql_lex.cc. My command-line
(reduced to the minimum) is
xlC_r -DMYSQL_SERVER -DHAVE
Are you suggesting that I look at the mysql++ code as an example, or actually use the
mysql++ code instead of the "mysql.h" included libraries?
Chris
Sinisa Milivojevic wrote:
> Chris Hundley writes:
> > Can I implement some sort of exception handling when using the mySQL
> > client library?
Hi,
We require a developer with very good Mysql skills and experiance of
getting big databases running fast.
The database structure is built but we need someone to look it over and
tune it up to run much faster than it does at the moment. DB is spread
over 5tables, one with 3million record
Original Message -
From: "MB" <[EMAIL PROTECTED]>
> Hi all,
> I use replication on MySQL. One of my ideas is to generate HTML pages
> using PHP.
> Will I have any troubles using PHP and connecting simultaneously to both
> servers?
> Thanks in advance for any comments.
>
> Mariusz Brze
Rather a tall order (still reading docs, can't see anything about this), but
can two MySQL instances on two servers be connected to the same disks? For
failover purposes.
Any pointers to documentation on the subject greatly appreciated.
J.
--
Justin Rowles
Technical Consultant
Sellers Informa
On Wed, Feb 07, 2001 at 05:38:49PM -0600, Dan Nelson wrote:
> It's probably trying to read the whole table into memory. Try adding
> "--opt" to the mysqldump commandline.
OK, I've had _many_ responses that in effect say 'use -q' (--opt
is a superset). It works. Thanks.
Dumb question: why isn'
Adrian D'Costa wrote:
> Hi,
>
> I have two tables city and country
> +---+-+--+-+-++
> | Field | Type| Null | Key | Default | Extra |
> +---+-+--+-+-++
> | id
Linux is a *nix...
Your best bet would be replication which would allow you to have several
copies of the database one for writting and many for reading.
see REPLICATION in the online manual.
Alternatively if your databsae is read-only and you have some high-speed
network file system then you
Christian,
a DEFAULT value in a CREATE (or ALTER) statement must be a static value, try
using a TIMESTAMP field instead.
To use 'ERROR' in as an 'ENUM' DEFAULT it must be included in the definition,
i.e. ENUM('ERROR','TRUE')
Hope this helps...
John
On Thursday 08 February 2001 09:09, Christi
The slave is connected to the master and is working fine. However, when
I run a SHOW PROCESSLIST in the Master, the first process in this list:
| 16920 | system user | none | NULL | Connect | 826
| connecting to master | NULL
Shouldn't it be something different (since this is
Is it possible to run one MySQL server on more than one Linux box ?
and is this good, or should we put it on Unix machines ? We prefer Linux as
it is free :)
-
Before posting, please check:
http://www.mysql.com/manual.php
[EMAIL PROTECTED] wrote:
>
> >Description:
> After installing using an RPM the first time and then compiling the source
>the second time, it
> still does not allow me to give it a root password. It keeps telling me that I don't
>have access priv's.
> I've tried it logged in as root, mys
The size of Mysql tables is limitated by the max filñe size of the OS.
- Original Message -
From: "Justin Rowles" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 4:49 PM
Subject: Size limitations.
> Hi all.
>
> Apologies for not lurking long and if this que
>Description:
After installing using an RPM the first time and then compiling the source the
second time, it
still does not allow me to give it a root password. It keeps telling me that I don't
have access priv's.
I've tried it logged in as root, myself and mysql.
>How-To-Repeat:
At 17:05 08/02/2001 +0800, Li Sze wrote:
Hi!
If you only need room for 1 character you don't need a column with
size 2.
The last parameter of SQLBindParameter is a pointer to a buffer for the
parameter's length.
Then error HY090 means:
(DM) The argument ParameterValuePtr was a null pointer, th
I am a web/database developer and we have a new
Unix administrator who admits to having never
installed/configured PHP or mySQL. He was tasked
with setting up our development server with Apache,
PHP and mySQL. Since he made this attempt I have not
been able to connect to the server with DBTools
Problem: No space left on device
Solution: Pay more attention to partition sizes
I would have expected mysql to start failing queries on such an event.
-Original Message-
From: Lance Lovette [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 8:08 PM
To: MySQL
Subject: mysql ha
Hi all.
Apologies for not lurking long and if this question is answered somewhere I
haven't yet found, but I'm on a timescale here...
My company is looking to use MySQL on free *nix (FreeBSD or Linux) to store
some text data and a *lot* of BLOB data.
I am trying to check that MySQL will cope wi
Hi.
How do you ping Mysql fro a distant machine?
(i think my previous post was not clear enough, thanks Tim for pointing me here)
I have a java program that has to make sure that the MYSQL server it uses is still
alive. It has to diagnose from a 'eventual' mysql problem, or a networking related
Leonardo Dias wrote:
>
> "Mayville, Jeffrey" wrote:
> >
> > I keep seeing users asking about a problem they are having with replication
> > (I ran into the bug myself). I saw a message a week or so ago acknowledging
> > the bug and noting that it was self-inflicted (while cleaning up code) and
>
My company usually develops web applications using a Cold Fusion / NT /
MSSQL combination. But we're tendering for a new project which needs to
handle more concurrent users than we are confident Cold Fusion / NT can
manage. So we're looking to use PHP4/MySQL on a Linux server. The code -
it's for
"Mayville, Jeffrey" wrote:
>
> I keep seeing users asking about a problem they are having with replication
> (I ran into the bug myself). I saw a message a week or so ago acknowledging
> the bug and noting that it was self-inflicted (while cleaning up code) and
> has been corrected. The problem w
It's amazing. Configuration is fine (same as our test machines here). We
are trying to use it on production machines now. These are the errors I
get:
010208 12:35:29 Slave thread: error re-connecting to master:Binary log
is not open, last_errno=0, retry in 0 sec
I also have got this one:
01020
I keep seeing users asking about a problem they are having with replication
(I ran into the bug myself). I saw a message a week or so ago acknowledging
the bug and noting that it was self-inflicted (while cleaning up code) and
has been corrected. The problem will not exist in the next release (.33
Hi Everyone,
I am in a very very
desperate state 'coz my whole site is down and if I
cannot connect to the database through my servlet my
@ss is grass.
Everything seems to be working fine except when I
execute the servlet I get this frustrating error:
" Server configuration denies access to dat
this is very urgent:
The slave returns this on the error log;
010208 12:06:58 Slave thread: error connecting to master:Can't connect
to MySQL server on '0' (111)(107), retry in 200 sec
What's '0'? I've configured an IP to that.
--
Leonardo Dias
Catho Online
WebDeveloper
http://www.catho.co
Hi,
I tried the following code:
CREATE TABLE news (... published date DEFAULT 'NOW()' NOT NULL, ..., showIt
ENUM('TRUE') DEFAULT ERROR, ...);
and I was surprised to get an '-00-00' as date after doing a SELECT. I would like
that the table put automatically the today's date for every INPUT
> Jeremy Wilson:
> > I tested replication recently and found it extremely lacking. Even the
> > most minor of errors causes the daemon to stop replicating, effectively
> > rendering the ability useless to me, as I use mysql for authentication.
> What errors are you talking about? Errors like dupl
Hi,
After trying to install mysql succesfully on RH7 (yes, it finally
worked), I discovered that the daemon doesn´t start at boot. I tailed
the log and it says this:
010208 10:25:03 mysqld started
010208 10:25:04 /usr/sbin/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
010208 10:25:04
I am writing an application that will poll up to 500 devices every 5
minutes. For this application I need to keep at least 6 months of data. If
I were to use a single record for every update, I would have ~25 million
records. Obviously this is not an ideal solution.
I am interested in gettin
Ok, we've been having these troubles:
the slave is not connecting to the master. A simple
SHOW PROCESSLIST
shows a message with: trying to reconnect after a failed read
Sometimes the slave just won't connect. Does anyone knows what could be
wrong?
--
Leonardo Dias
Catho Online
WebDeveloper
ht
Hi.
Sometimes I need make software to administrate specifics databases on
MySQL for my clients running Windows.
I already did it before using an API, but I would like to use the
MyODBC to make things go faster.
I'm trying to use MyODBC with C++ Builder 3.0 Standard.
When I open the Dat
>I want to SELECT on one term & have the SELECT return as quickly as
>possible on the first TRUE instance.
>
>Ideally I'd like it to after the first matching case stop looking
>for other matches ( for speed ) and return 1. If there's no matches
>at all I want it to return 0.
>
>This works OK bu
>Dear Sir
>I am new to MySQL. I've created a table with three keys inside like this:
>
>CREATE TABLE reservation
>(
> reservation_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
> hotel_id INT UNSIGNED NOT NULL,
> customer_id INT UNSIGNED NOT NULL,
> PRIMARY KEY(reservation_id, hotel_id,
>Hi there,
>
>suppose I have table table1 with columns col1,col2,col3,col4
>I would like to set up a query that omits eg. col1 from the output even
>though col1 must satisfy some condition:
>
>SELECT col2,col3,col4 from table where col1=condition
>
>Any suggestions ?
>
>Thanks in advance
>
>A.Hann
"mike thomas" <[EMAIL PROTECTED]> writes:
> I'll have to think about this one. My application
> just consists
> of a huge table of domain names and users will be
> able to search for
> full strings and partial strings. So I'm not sure
> how I could create
> an intermediate results set from this t
Thanks for the info on tuning an IDE. I'll go
ahead and do that.
Regarding " Do you really need to do sub string
matching all the time?
Can you pre-build an intermediate results set that
can be optimally
queried?"
I'll have to think about this one. My application
just consists
of a huge table of
I see, I need a recursive algorithm
Can you get them in Woolworths?
- Original Message -
From: "Tommie Jones" <[EMAIL PROTECTED]>
To: "Phil Latio" <[EMAIL PROTECTED]>
Cc: <>
Sent: Thursday, February 08, 2001 12:18 PM
Subject: Re: Help with SQL statement please.
> If I am not mistaken
1 - 100 of 126 matches
Mail list logo
