I have trouble writing a character into the database (the column is declared as
char(2) not null) because I figured that if it appends a null at the end of the
character data I want to insert (i.e.'A\0'), it would still fit. I bound the
parameters first before assigning the data and executing
I had some problem when I install MySQL.
Could you kindly give me a good FQ about mysql install?
Thank you.
www.devshed.com has some interesting info on using/installing MySQL.
Also on PHP and other stuff.
Greetz,
B.
Hi Everyone,
Sorry for the subject but I am in a very very
desperate state 'coz the 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 @$#$@$# error:
" Server
Hi,
Sorry for my stupid question,
I have probleme when i use C API : LinK Problem.
MY COMMAND :
bashgcc -o fic.ex NA_PEC_Sin.c
-L/usr/local/REP-MYSQL/mysql-3.23.32-pc-linux-gnu-i686/lib
-lmysqlclient
(the 3 lignes represent 1 ligne for my command )
ERROR MESSAGE :
Can anyone tell me the maximum capacity (number of tables, records) of MySQL
database,
and the stability comparison with other databases like MS Access, Oracle, MS
SQL, etc.?
Since it is important for decision of database in my project.
Thank you very much!
"mike thomas" [EMAIL PROTECTED] writes:
Greg,
Well, I'm doing like "%stuff%" selects on a single column table
with 20 million records, so any speed gain would be great. Would
I be correct in saying that a select of this type will always do
a table scan?
Pretty much.
I think I'll go
Hi,
I think I'll go with SCSI and increase the RAM so I can use a
heap table.
A cheap first step might be to go with a couple of decent 7200 rpm,
ATA100 (or whatever the hell they're calling themsevles this week)
disks and RAID0 them.
Striping Good.
Also, make sure your IDE is
As of 3.23.xx, WHEN is a reserved word.
regards,
P
On Thu, 8 Feb 2001, Andy Woolley
wrote:
Hi All,
Does anyone know if a field called WHEN could cause trouble with queries?
Many Thanks
Andy Woolley
www.databasewatch.com
Dear sir ,
I was browsing the whole site to down load the windows NT version of mysql but i could
not get any proper guidence or the proper downloading page..
could u please guid me in downloading mysql..
Thanking you.
Pradeep Rangdal
Cybage Software Ltd
Pune
Hello mysql,
1) Today I tried to reload my tables with backuing up and recovering
whole database by mysqldump - it seems like it does not work -
mysqld crashed during loading data back even after I've removed all
bad tables and bdb logs to have a clean system.
This looks like the same
Mike Baranski writes:
This gives me a seg fault, I know I have the correct user/pw, but I can't get the
thing to run past "First", any ideas why the connect is not working properly?
#include iostream.h
#include sqlplus.hh
#include string
void main()
{
string dbname =
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-win.zip
This is the link to the Win32 binary of the latest version.
To find the downloads page on the website, visit www.mysql.com and click on
the "Downloads" link in the menu on the left of the screen.
HTH
Jon
-Original
Dave Hodgkinson wrote:
"mike thomas" [EMAIL PROTECTED] writes:
Greg,
Well, I'm doing like "%stuff%" selects on a single column table
with 20 million records, so any speed gain would be greatWould
I be correct in saying that a select of this type will always do
a table scan?
Murat KARABEK writes:
hi all,
i'm testing mysql 3.23.32 on windows and i need to use Turkish character
set in sorting or using string functions such as upper etc. do you know
where i can find latin5 files for windows?
thnx.
HI!
All our last 3.23 releases, including the above
Konstantin Osipov writes:
Hi All!
Is this code buggy?
--
MYSQL* mysql = new MYSQL;
mysql_init(mysql);
mysql_real_connect(mysql, "localhost");
/* some work*/
mysql_close(mysql);
mysql_real_connect(mysql, "otherhost");
/* some work*/
mysql_close(mysql);
delete
This is really a JavaScript problem if you don't want to use the submit
button.
Use PHP to load the values of both tables into a JavaScript array. Then
write JS code that will change the contents of the City control based on
what is selected in the country control. Not terribly difficult.
Cal
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 I
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
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,
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 but
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
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
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 duplicate
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
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
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:
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
has been
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
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,
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,
Adrian D'Costa wrote:
Hi,
I have two tables city and country
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| id|
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't
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
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
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? I'm
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
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 the
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)
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
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
over
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 SELECT on
Does anyone know how to find duplicates in a table and deleting them. I can't figure
out how to structure the query.
Linsen
"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 run out of
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/mysqlfaq
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.
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
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
- 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
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
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 command
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 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
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
--
"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 the bitbybit.dk
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)
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,
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.
- I
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
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
If that's the case u r running it but not really using it ... !!
-Ursprngliche 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 can't
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
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 that it
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
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
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 object,
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 SQL, the
Hola alguien habla espaol. 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
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
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
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
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
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
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
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
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.
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
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 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
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
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
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 already tried
"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 NAME
82 matches
Mail list logo