Hello Michael,
Thursday, February 08, 2001, 1:58:24 AM, you wrote:
Peter>> I've done mysqladmin "flush logs" and then copied the .frm and .db
Peter>> files into other database directory - and the bug was unable to be
Peter>> repaired.
MW> I assume you mean 'unable to be repeated' ?
Yes of co
Hello:
I had some problem when I install MySQL.
Could you kindly give me a good F&Q about mysql install?
Thank you.
--Nich
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 F&Q 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 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 mysql;
--
In other words, if struct MYSQL allocated manually,
Hi,
I am a begginner in linux and mysql and yesterday after trying to create a
table in database test i receive this error:
- error writing file ./test/ames.frm (errcode:28).
After searching for the cause of this error i think i have discovered it:
- my disk partition /dev/hda7 (150MB) in which
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 configurati
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 configurati
Hi,
Sorry for my stupid question,
I have probleme when i use C API : LinK Problem.
MY COMMAND :
bash>gcc -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 :
I hope somebody may of come across this sort of problem before dealing with
counting total records in subcategories.
I have two tables sslinks which contains links (URL) information and
sslinkcats which contains category information.
The category table "sslinkcats" has a field called "lcat_id" (
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'
Hi All,
Does anyone know if a field called WHEN could cause trouble with queries?
Many Thanks
Andy Woolley
www.databasewatch.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
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 I
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
Mark Cogan writes:
> Is there a more detailed description of the MyISAM file format than in the
> MySQL manual?
>
>
>
> ---
> Mark Cogan[EMAIL PROTECTED] +1-520-881-8101
> ArtToday www.arttoday
Chris Hundley writes:
> Can I implement some sort of exception handling when using the mySQL
> client library? I'm running an application and when I issue a query with
> an error in it, I catch the error and print output, but the software
> throws a general exception. Should this code be in a
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
> #include
> #include
>
> void main()
> {
> string dbname = "test2";
> stri
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 Message---
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 t
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 th
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);
If I am not mistaken I think you are trying to do a nested select.
This is not possible in Mysql. I've had similar problems.
You will have to use some sort of recursive algorithm in your perl code
(if you are using perl)
to accomplish this.
Phil Latio wrote:
>
> I hope somebody may of come acro
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
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
"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
>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
>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 bu
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
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
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
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
> 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,
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
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 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
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
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
"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
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
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
>
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
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
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
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, th
>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:
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
[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
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
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
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
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
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'
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
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
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
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 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
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.
>
> 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
> 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
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
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
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
>
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
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
> 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
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
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
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
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
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
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
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
--
"
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
"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
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
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
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, requi
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 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
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:
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
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))
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
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
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
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
1 - 100 of 126 matches
Mail list logo
