On Thu, Jan 24, 2002 at 02:07:14PM -0600, Jay Paulson wrote:
I'm trying to increase the maxium number of connections to my MySQL
database but I am not sure how to do this. I've gone to the manual
and it doesn't say too much (maybe i'm looking in the wrong spot?).
The machine I'm running is
Hi,
With all the recent talk about replication, just wondering if there are
any others out there who have experience replicating BDB tables?
My experience so far has been that the slave instance of MySQL has been
crashing once in a while, when applying perfectly legitimate
On Tue, Jan 15, 2002 at 08:36:16PM +0200, Heikki Tuuri wrote:
This brings up an interesting point. If you've lost your .frm
files, are you totally screwed, or does InnoDB contain enough
information to restore those .frm files? It's not a big deal if
With some work, yes.
On Wed, Jan 23, 2002 at 06:15:38PM -0500, Alex Shi wrote:
How to check disk space been used for all of the tables of a
specific mysql account?
Depends what you mean.
MySQL accounts don't necessarily map to tables or databases, so how
can you properly account for shared data?
Jeremy
--
hello anyone know why ooverhead happen?
some of my table are overheading where a run delete and updates queries.
---
Everton B Yoshitani
[[EMAIL PROTECTED]]
UF Communications, Inc.
-
Before posting, please check:
hi,
Yes, I was really thinking about the InnoDB Tables,
Thank you very much for such a systematic and accurate reply,
Thanks and regards,
Chetan
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 1:10 PM
To: Chetan Lavti
Cc: [EMAIL
On Thu, Jan 24, 2002 at 01:48:58PM +0100, Paul van den Berg wrote:
Hello list,
the regular mysql-client returns some useful information after
batch-inserts like:
Query OK, 11393 rows affected (0.47 sec)
Records: 11393 Duplicates: 0 Warnings: 0
I can fetch the number of effected rows
I'm trying to enable binary logging on my MySQL server (3.23.28-gamma-log), per the
recommendations in the manual about properly backing up the database.
In my /etc/my.cnf I have:
[mysqld]
log-bin=updates
I had also tried just:
[mysqld]
log-bin
But no update log file is being created in my
On Fri, Jan 25, 2002 at 04:15:18PM +0800, Geoffrey Soh wrote:
Hi,
My experience so far has been that the slave instance of MySQL
has been crashing once in a while, when applying perfectly
legitimate DELETE queries on the replicated BDB tables.
That's a bad sign.
MySQL then
On Fri, Jan 25, 2002 at 05:23:23PM +0900, Everton B Yoshitani wrote:
hello anyone know why ooverhead happen? some of my table are
overheading where a run delete and updates queries.
I'm not sure what you mean. Can you provide an example?
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical
On Wed, Jan 23, 2002 at 11:25:31PM -0500, Jason Yates wrote:
Heres an example scenario, say I have two tables
table1
-id
| name
|
| table2
|_ id
address
zip
I inner join table1 and table2 on id. I want to delete all the
records in
my usr_dat(user data) table overhead!
this table are updated constant every time that a user request a web page on
my site the php script update the lastseen field in this table so when i
access the phpMyAdmin interface to manage the database the phpMyAdmin show
some overhead bytes in this table
On Fri, Jan 25, 2002 at 03:30:11AM -0500, Ken wrote:
I'm trying to enable binary logging on my MySQL server (3.23.28-gamma-log), per the
recommendations in the manual about properly backing up the database.
In my /etc/my.cnf I have:
[mysqld]
log-bin=updates
I had also tried just:
Jeremy Zawodny wrote:
On Thu, Jan 24, 2002 at 12:19:12PM +0200, Oleg Prokopyev wrote:
Ken Menzel wrote:
Hi Oleg,
There is some sort of thread problem with freebsd but it usuually is
not that bad. How did you compile MySQL? I would recommend using the
ports version of Mysql
my usr_dat(user data) table overhead!
this table are updated constant every time that a user request a web page on
my site the php script update the lastseen field in this table so when i
access the phpMyAdmin interface to manage the database the phpMyAdmin show
some overhead bytes in this table
Rahadul,
Thursday, January 24, 2002, 8:45:31 PM, you wrote:
RK hi,
RK I recently installed MySQL3.23.47 and now I need the JDBC drivers for
RK it. Does anyone know where can I find a Free JDBC driver that would work
RK with MySQL 3.23.47-1?
RK thanks so much
You can find JDBC drivers, look at:
Do I need to have a clean install on my machine. Right now, I've installed
the mysql server on one machine(Windows 2000) and the developer is trying
to access it using the VB application from his machine(client)which is a
windows 98 pc using the mysql driver.
Thanks alot
Rutledge,
Friday, January 25, 2002, 12:19:58 AM, you wrote:
Reoen A quick question. When creating a table that will hold values generated
Reoen by the password() function, what kind of column should this be stored
Reoen in...I am assuming VARCHAR(?). Could someone kindly tell me the length?
Hello Jeremy,
Friday, January 25, 2002, 11:00:43 AM, you wrote:
Why query type
select count(*) from table_name where key_field between 'min' and
'max' so slow?
example:
mysql select count(*) from Textes where ID between 7937 and 45061;
+--+
| count(*) |
+--+
|
I have problems with uptime on my Internet service with approx 1 million
page-views per month(most of which involves several mysql queries),
apparently because of something with MySQL.
Involved products are:
mysqld Ver 3.22.32 for pc-linux-gnu on i686
apache-perl 1.3.9-13.1- (Apache with
Hi,
If I look under task manager- Processes, mysqld-max-nt.e uses up 99%. For
simple queries, it seems to be fast, but for long and complex query, it
just hangs.
An example of aa query we're trying to run:
SELECT ADV.AMB_No AS ColCode, CD.Company_Name AS ColDesc, ADV.Account_Item_ID AS
Hey folks -
Here is hoping someone can help once I get it down I promise I'll post all
my work on this list so some other newbie can benefit.
I'm simply trying to run a very very straightforward JDBC test with mySQL
I keep getting the Server configuration denies access to data source
error.
Same pb with version 3.23.47
Description:
Following is the test reproduced in several databases (tables of around 7
millions records). Mysql compiled with GBK charset.
A select used with a like 'alpha%' condition fails to report exact matches.
Even if the select is completed by an OR field =
Hi!
Below is the column type mapping function from ha_innobase.cc.
But the internal column type inside InnoDB is not too important for the
user, because you can only see it in the output of innodb_table_monitor.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support
Hello,
I have been successfully using the MYSQL database for the past
3+ months - however I have just encountered a bug with MYSQL that
prevents my query from working.
Basically I have a field in a table that describes an item, and I have
written a program that allows a user
LdS I'm experiencing the same problem.
LdS But I sort of found a way around it (though I'm sure this is not really the
right way).
LdS When I remove the *password* for *root* and login again as root, I'm able to
create new users using GRANT then flush priviliges.
LdS Does this mean I have to
Guy-Maurice Lepoutre writes:
Hello,
I am using Visual C++ 6.0 and I have some linking
problems while trying to run the example program
MFC_ex.cpp included in the downloading files in the
mysql.com website.
Here are the errors I get:
MFC_ex.exe - 18 error(s), 0 warning(s)
Thanks
Hery,
Friday, January 25, 2002, 4:35:18 AM, you wrote:
HY I need to know, how to configure MySQL can be support unicode like Chinese
HY (simplified and Traditional), Croation,Chezh or whatever.
There is no unicode support in MySQL. It will be probably supported in version 4.0.3.
HY Hery
Christopher,
Friday, January 25, 2002, 1:05:02 AM, you wrote:
[max length of a string]
CT you may want to do this programatically in a small C++
CT (or C, or whatever) program. It _may_ be faster. It may not, there'll be
CT a lot of network traffic. SQL servers tend to be rather bad at
Michael,
Friday, January 25, 2002, 4:17:53 AM, you wrote:
MO Are there any other good mailing lists out the about databases?.. If so, can
MO you post the site where i can sign up for them?
See other MySQL lists at:
http://lists.mysql.com/
MO Mike
--
For technical support contracts, goto
Jacob,
Thursday, January 24, 2002, 7:49:54 PM, you wrote:
JFL I found files whith names like localhost-bin.001, localhost-bin.002 in
JFL /tmp/
JFL What are they ?
These are log files. You can see more information about log files maintenance at:
Hi all,
following query
SELECT LAST_INSERT_ID() as auto_num FROM xrenders;
fills our whole slow query log (500 kB a day).
AUTO_INCREMENT field is int(11) type, primary key;
table is of type MyISAM.
We do the same operation on another similar table of the same
db which is much larger without
On Fri, Jan 25, 2002 at 02:22:12PM +0100, Marek Kustka wrote:
following query
SELECT LAST_INSERT_ID() as auto_num FROM xrenders;
fills our whole slow query log (500 kB a day).
Just do 'select last_insert_id() as auto_num'.
The id isn't kept per table anyway, it is kept per session.
TF Information Exchange (TF)
Physical Address : Room 210, Building 2, Chegongzhuang Street No. 6,
Xicheng District, Beijing, China
Post Code: 100044
Tel: +86-10-6800-3112
Fax: +86-10-6800-1452
Web site: http://www.tangfeng.org
E-mail: [EMAIL PROTECTED]
Fred van Engen wrote:
On Fri, Jan 25, 2002 at 02:22:12PM +0100, Marek Kustka wrote:
following query
SELECT LAST_INSERT_ID() as auto_num FROM xrenders;
fills our whole slow query log (500 kB a day).
Just do 'select last_insert_id() as auto_num'.
The id isn't kept per table anyway, it
Hi I am new to MySQL
I have installed MySQL on windows 200 swerver and installed MyODBC.
I created a db and added a user with the grant command and added
select,insert,delete,update privileges for the user.
mysql show grants for www;
And this nitwit also just spammed the SpamCop newsgroup! Must be out on a suicide
mission...
Once again: PLEASE make this list subscription-only! We really DON'T need spam here!
At 15:53 2002-01-24, you wrote:
These are the items that iam interested in selling..
Could you help me with some
Good grief! Yet another SPAM on the same day. When will it filter through the
apparently thick head that the so-called filtering DOES NOT WORK?
Stop this sillyness already, please. SUBSCRIPTION only for this list is the only
sensible solution!
At 22:41 2002-01-25, you wrote:
TF Information
freebsd2# cd /usr/ports/databases/mysql323-server
freebsd2# make pre-fetch
You may use the following build options:
WITH_CHARSET=charsetdefine the primary built-in charset
(latin1);
WITH_XCHARSET=list define other built-in charsets (may be
'all');
Hello,
I am trying to decide which OS to use for a dedicated mysql server for my
website. I need filesize 2GB support. I really wanted to use Solaris, but
there are no drivers for my RAID adapter (long story). I was considering
NetBSD, but I don't know it well. I was then back to thinking
Hi,
I did all that but I still have the linking problems:
it seems that it doesn't find the MysqlConnection
implementation.
NOTES:
--
1) The main workspace and project for the mysql++ API
are located in the root
directory
2) This project, when built, will yield the static
library
Hank,
1. RH 7.1 supports files 2GB if you choose the Enterprise/SMP flavour
(you'll be asked to choose which install you want to pursue when you put
the install CD in) No kernel re-compile needed.
2. MySQL will support large files. Also, if you use Innodb tables, many
of the large file
Does null take up the same amount of storage as an empty string? If
one has a table and stores an empty string in place of NULL for
elements that were left blank on a Web form, does that increase
storage requirements? Or does having the column already defined mean
that storage was already
Bogdan,
You solved your own problem - that's good (and the timestamps below hint that you have
other abilities)
Did you realise that you could specify a LINES TERMINATED BY '\r\n' clause and stick
with LOAD DATA?
Oh the joys of working with *nix and Windows...
=dn
- Original Message
At 02:31 AM 1/25/2002 , you wrote:
On Thu, Jan 24, 2002 at 05:27:18PM -0600, BD wrote:
I will be putting variable length text into a field (up to 255
characters but typically around 60 characters) and wonder what makes
for faster retrieval? Or does it matter? A field defined as
Michael,
Let's round it up to 3 million rows (I'm lazy at math too!)
Let's say you currently allow 15 bytes per name.
Let's say the longest name on file is 12 characters.
The exercise would save 3 bytes/row multiplied by 3M rows, ie 9MB
(yes, let's ignore binary-decimal differences too)
If you
I belive the type of table you use here will be the only thing
that will speed things up. If you use MyISAM tables and have
100's of users calling things from the DB and 100's of users
INSERTING things into the same table, then it will be very slow
due to MyISAM's table level locking. Using
On Fri, Jan 25, 2002 at 10:18:08AM -0500, John Kemp wrote:
: Hank,
:
: 3. Do not use the RH mysql version. Get it from the Mysql website, and
: use 3.23.47-max (which includes Innodb support) or higher.
What's wrong with the RH mysql version? I've been using it for 5
months without a problem.
Hi all,
We are moving our site and wanted to find out if anyone has done this and
what is the best solution. We have a 2 web server farm now with 1 being
Mysql that we are hsoting at an ISP.
Want to know the best way to move the live database to our new server farm
with 2 database servers.
Alright then!
database,sql,query,table
Which field type do I use for a simply checkbox Y,N?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
If your column is of type VARCHAR, you want save much space (at least not as
much as DL Neil said). The specifications of tha varchar column type is that
it uses as much bytes as the data in it. Of course this will make your
indexes smaller (if this column is indexed).
A few days before I
Wow, I feel like I wasted time just asking! :-) But my goal was not to
save disk space it was to optimize the queries on the table as this is a
test project for mySQL/OS X versus Unify/SCO or Unify/Linux or mySQL/Linux.
I am kind of partial to the mySQL/OS X combo, so I wanted it to work as
At 10:58 AM -0500 1/25/02, Vernon A Webb wrote:
database,sql,query,table
Which field type do I use for a simply checkbox Y,N?
How about CHAR(1)?
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA |||
On Thursday 24 January 2002 11:14 pm, Tobias Erichsen wrote:
? I?ve read an old message of yours on deja concerning the possiblity
? that the client can automatically select a master or slave in a
? replication-environment. ?Is this only available for linux, or does
? the libmysql.dll also
VarChar Usually
-Original Message-
From: Vernon A Webb [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 9:58 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL Checkbox table field
Alright then!
database,sql,query,table
Which field type do I use for a simply checkbox Y,N?
Is there the equivalent of a sequence in mysql? Does anyone have an example
of emulating sequences?
Thanks
Rich
Rich Bolen
Senior Software Developer
GretagMacbeth Advanced Technologies Center
79 T. W. Alexander Drive - Bldg.
Hello,
I have a simple query, and a problem countless people must have had, I just
cannot work it out at the moment, I am new to MySQL; I hope you can help.
My current statement looking at the manual.
SELECT * FROM contacts WHERE age=MAX(age);
I started with:
mysql select * from contacts
Hi!
HeikkiiH == Heikki Tuuri [EMAIL PROTECTED] writes:
HeikkiiH Ken,
HeikkiiH the 'connection lost' error suggests some bug in the client or
HeikkiiH communication. Since you are running 4.0.1-alpha, it could be something with
HeikkiiH the query cache. I think Sanja has already fixed some
Hi!
Heikki == Heikki Tuuri [EMAIL PROTECTED] writes:
Heikki Sanja,
Heikki maybe adding some debug code to the client or the server would help? After
Heikki all, the symptom is easy to notice: the client claims the connection to the
Heikki server is broken. Why does it claim that?
This could
Richard Morton a écrit :
Hello,
I have a simple query, and a problem countless people must have had, I just
cannot work it out at the moment, I am new to MySQL; I hope you can help.
My current statement looking at the manual.
SELECT * FROM contacts WHERE age=MAX(age);
I started
In the last episode (Jan 25), Michael Collins said:
At 10:58 AM -0500 1/25/02, Vernon A Webb wrote:
database,sql,query,table
Which field type do I use for a simply checkbox Y,N?
How about CHAR(1)?
The BIT type seems to be the best fit. It's currently a synonym for
CHAR(1), but there's
Hi,
I'm trying to update the values of Contact_ID and
Volunteer_ID in a table called Contributors. The layout for
Contributors is
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra
|
Do the update without quotes for 1 and 13..
Vaidhy
On Fri, Jan 25, 2002 at 11:48:31AM -0500, David S. Jackson wrote:
Hi,
I'm trying to update the values of Contact_ID and
Volunteer_ID in a table called Contributors. The layout for
Contributors is
Michael: see also my PS comment
Dobromir: Michael and I were joking between us, hence the silly comments appearing.
I apologise if this did not communicate.
IMHO the pragmatics of the exercise made it a waste of time/effort - even when I
over-stated the savings at
every opportunity!
On a Friday
I'm having a weird problem with my mysql data dump and wondering if anybody
else has had a similar problem.
I run my mysql dump program, no problem there, download the file, and view
it with a text editor (an oldie: pfe - programmers file editor). Then one
dark day pfe was about half way through
At 10:49 AM -0600 1/25/02, Dan Nelson wrote:
Which field type do I use for a simply checkbox Y,N?
The BIT type seems to be the best fit. It's currently a synonym for
CHAR(1), but there's a TODO item:
* Optimise `BIT' type to take 1 bit (now `BIT' takes 1 char).
Are you thinking MS SQL
Hi Buddy,
Anybody knows the solution of my problem ?
I've written a program with Kylix 1 and MySQL 3.23 . I
am using DBGRID, DBNavigator, DataSource,
ClientDataSet, DataSetProvider, SQLDataSet,
SQLConnection objects for my program. It queries a
table an put it into DBGRID table. I am using CHAR
Hello Richard,
I have a simple query, and a problem countless people must have had, I just
cannot work it out at the moment, I am new to MySQL; I hope you can help.
My current statement looking at the manual.
SELECT * FROM contacts WHERE age=MAX(age);
I started with:
mysql select *
Richard,
Friday, January 25, 2002, 6:21:29 PM, you wrote:
RB REALFROM: Richard Bolen [EMAIL PROTECTED]
RB HOUR: 2002012518
RB Is there the equivalent of a sequence in mysql? Does anyone have an example
RB of emulating sequences?
There is an 'auto_increment' attribute for the column. Look
Yeah, I think in the end what I will do is change a lot of the columns
back to char from varchar. I was thinking this would save space making
for a smaller faster DB, but the inherent overhead in a varchar field is
not worth the space savings, which DL made crystal clear.
Thanks,
Michael
In the last episode (Jan 25), Michael Collins said:
At 10:49 AM -0600 1/25/02, Dan Nelson wrote:
Which field type do I use for a simply checkbox Y,N?
The BIT type seems to be the best fit. It's currently a synonym for
CHAR(1), but there's a TODO item:
* Optimise `BIT' type to take
mm.mysql-2.0.10-you-must-unjar-me.jar
this is the JDBC driver for Mysql3.23.47. Can someone tell me what is
the command to unjar this file as well as how to install this on
linux.
mysql is on /var/lib/mysql (by default) and JDK on /home/tomcat.
thanks so much
--rahad
Rahadul Kabir wrote:
mm.mysql-2.0.10-you-must-unjar-me.jar
this is the JDBC driver for Mysql3.23.47. Can someone tell me what is
the command to unjar this file as well as how to install this on
linux.
mysql is on /var/lib/mysql (by default) and JDK on /home/tomcat.
thanks so much
If this is on a Unix flavor, you can use 'cmp' to compare the data and
index files (off-line, of course). Once you know they are identical,
you can simply plot the difference between the slave's update log position
and the master's update log position. As long as it's always 0, the
two are in
At 11:32 AM -0600 1/25/02, Dan Nelson wrote:
Why would the MySQL TODO mention an MS SQL feature? :)
Because the MySQL team wants to add a feature that is found in another DBMS?
OK, so it's actually a synonym for tinyint(1).
I could not find a reference to the synonym in the MySQL
In the last episode (Jan 25), Michael Collins said:
At 11:32 AM -0600 1/25/02, Dan Nelson wrote:
Why would the MySQL TODO mention an MS SQL feature? :)
Because the MySQL team wants to add a feature that is found in
another DBMS?
According to the Mysql manual, the bit type was added in
On Fri, Jan 25, 2002 at 12:33:59PM -0500 Gurhan Ozen [EMAIL PROTECTED] wrote:
Hi David,
First of all, whever you have a primary key on your table, do all updates
according to the primary key..
So whatever the primary key for the person you wanna do update, do
something like:
update
On 25 Jan 2002 07:05:32 +0800, [EMAIL PROTECTED] (Steven Roussey)
wrote:
Does anyone have a best practices for efficiently storing md5 hash
values in MySQL?
--snip--
Md5 hash-- 16 bytes.
char(32) binary -- 32 bytes.
BIGINT -- 8 bytes
--snip--
Or you can use base64, which
On Fri, 25 Jan 2002, Rahadul Kabir wrote:
Date: Fri, 25 Jan 2002 12:40:35 -0500
From: Rahadul Kabir [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: How to install JDBC driver!
mm.mysql-2.0.10-you-must-unjar-me.jar
this is the JDBC driver for Mysql3.23.47. Can someone tell me what is
can some one please tell me how to unjar a package, like a package which
comes with .jar extension (executable file).
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Guy-Maurice Lepoutre writes:
Hello,
I am using Visual C++ 6.0 and I have some linking
problems while trying to run the example program
MFC_ex.cpp included in the downloading files in the
mysql.com website.
Here are the errors I get:
Configuration: MFC_ex - Win32
Hello all,
I have a question which just may very well be ridiculous. In one table,
we have a column of type timestamp. In normal cases, we want any changes
to this row to update this timestamp (hence the nature of this datatype).
However, there is one case where we do NOT want the timestamp
It's like tar. I do jar xvf file.jar
man jar even works! :-)
Michael
Rahadul Kabir wrote:
can some one please tell me how to unjar a package, like a package which
comes with .jar extension (executable file).
thanks
-
At 13:45 -0500 1/25/02, [EMAIL PROTECTED] wrote:
Hello all,
I have a question which just may very well be ridiculous. In one table,
we have a column of type timestamp. In normal cases, we want any changes
to this row to update this timestamp (hence the nature of this datatype).
However,
At 17:13 + 1/26/02, DL Neil wrote:
Hello Richard,
I have a simple query, and a problem countless people must have had, I just
cannot work it out at the moment, I am new to MySQL; I hope you can help.
My current statement looking at the manual.
SELECT * FROM contacts WHERE
Jeremy Zawodny writes:
Are there platforms other than Windows (OS/2, perhaps?) on which MySQL
is able to use named pipes?
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL
Jeremy Zawodny writes:
On Wed, Jan 23, 2002 at 11:25:31PM -0500, Jason Yates wrote:
Heres an example scenario, say I have two tables
table1
- id
| name
|
| table2
|_ id
address
zip
I inner join table1 and table2 on id. I want to
At 13:32 -0500 1/25/02, Rahadul Kabir wrote:
can some one please tell me how to unjar a package, like a package which
comes with .jar extension (executable file).
thanks
Just as tar tars and untars, jar jars and unjars. :-)
jar xf jarfile.jar
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
Hi,
when I'm trying to lock multiple tables and some of the are Compressed,
mysql warn's me only about the first-one being Compressed. It either
reports the first Compressed table only from the list, or it checks
only the first-one in the list of
Hi Monty!
I am combining two messages into one:
Heikki server is broken. Why does it claim that?
This could happen if some client code set the 'thd-killed' flag.
The main problem here is why we should get this in mysqldump, but
not
in 'mysql'.
Ken, did you get any output from mysqldump
David S. Jackson wrote:
On Fri, Jan 25, 2002 at 12:33:59PM -0500 Gurhan Ozen [EMAIL PROTECTED] wrote:
Hi David,
First of all, whever you have a primary key on your table, do all updates
according to the primary key..
So whatever the primary key for the person you wanna do update, do
At 12:02 PM -0600 1/25/02, Dan Nelson wrote:
According to the Mysql manual, the bit type was added in 3.21.12.
`BIT' `BOOL' `CHAR'
These three are synonyms for `CHAR(1)'.
I see that now in the online docs, I am using the pdf, guess it is
not as up to date. Sorry if I spoke out of turn.
select Item.Item_Description, Item.Retail_Value, Item.Bid_Description,
Contributors.Name from Item, Contributors where Contributors.Contributor_ID
1;
-Original Message-
From: David S. Jackson [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 12:14 PM
To: Gurhan Ozen; [EMAIL
I have a table with two fields that reference the same field in
another table. Is this allowed (I'm not sure if it is). mysql
3.23.46 allows this, but apparently, mysql 3.23.47 does not. Create
it with just one key and it's fine. Reference different tables
and it's fine.
mysql-3.23.47 InnoDB
Hi David,
First of all, whever you have a primary key on your table, do all updates
according to the primary key..
So whatever the primary key for the person you wanna do update, do
something like:
update Contributors set Contact_ID = 1, Volunteer_ID = 13 where
A couple hundred netapps? Man, you must have a big operation. What
sort of business is it?
I'm also interested on a technical level. I'm flogging a business
plan right now that will involve installation of a lot of remote
microservers, and a central facility that will maintain replication
WITH_LINUXTHREADS=yes Use the linuxthreads pthread library.
This is _NOT_ recommended for
production
servers. Expect problems when enabled.
How fresh or stale is this information? Are there in fact problems
under heavy
Is it possible to authorize mysql from an alternative source, ie ldap,
passwd file, etc...
many thanks
don smith
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
The fastest way I found would be:
SELECT MAX(age) FROM contacts
good luck
bb
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 26, 2002 12:14 PM
To: Richard Morton; [EMAIL PROTECTED]
Subject: Re: Selecting the row with largest number in a column
On Fri, 25 Jan 2002, Sinisa Milivojevic wrote:
Hi,
sorry, I didn't get it. As far as I know there's no way yet how to
uncompress table my using SQL command. I have to uncompress using
`myisamchk --unpack *.MYI`, right?
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
Hi,
when I'm trying to
1 - 100 of 133 matches
Mail list logo
