Any plans to upgrade the MyODBC driver to support .NET?
I downloaded a copy of MySQL and tested it with a .NET app and received an
error that this version of ODBC wasn't supported. Just wondering if this is
on the development horizon.
i have Mac OS X Server and i think MySQL is preinstalled, but it's not
running so i tried to start it and got the typical socket error 2002.
then i tried this:
[mbase:~] ted% safe_mysqld
touch: /usr/var/mbase.err: No such file or directory
chown: mysql: invalid user name
Starting mysqld daemon wit
i have Mac OS X Server and i think MySQL is preinstalled, but it's not
running so i tried to start it and got the typical socket error 2002.
then i tried this:
[mbase:~] ted% safe_mysqld
touch: /usr/var/mbase.err: No such file or directory
chown: mysql: invalid user name
Starting mysqld daemon wit
I just ran across mtop on freshmeat. Looks kind of nice to me.
--
Bruce
One day at a time... One second if that's what it takes
"Gorantla, Aruna" wrote:
>
> Hi All,
> Does anybody know if there are any monitoring tools for MySQL database?
>
> Thanks,
> Aruna.
>
> -
Rants: 2 Spam: 1
Looks like you're ahead on this one.
On Fri, 25 Jan 2002 15:29:04 +0100, Marjolein Katsma wrote:
>And this nitwit ...
Life is tough. Life is tougher when you're stupid. - John Wayne
(database, sql, bat whiskers)
--
If you have a field 'weight', you could
SELECT *, RAND()*weight AS r FROM table_name ORDER BY r
(Or you can complicate the expression more :-)
laszlo
Ed Lazor wrote:
Ed Lazor wrote:
> I found this:
> SELECT * FROM table_name ORDER BY RAND()
>
> Is there a way to weight the random selection so
This is an Official WebStream Press Release
Release date: January 25, 2002
For more information contact:
Crawford Grimsley, Vice President of WebCasting Services
[EMAIL PROTECTED] 954-730-7127 Ext. 217
WebStream Announces move into the WebCasting arena
FOR IMMEDIATE RELEASE
WebStream In
I found this:
SELECT * FROM table_name ORDER BY RAND()
Is there a way to weight the random selection so that certain records are
more likely to come up?
It's for a banner exchange program. The idea is to somehow give precedence
to help promote certain sites.
Thanks! =)
-Ed
Paul DuBois wrote:
> I think that MM.MySQL used to be packaged as a tar file, but not is
> distributed
> as a JAR. Use the newer one, you'll be better off. And do as the filename
> indicates: un-jar it. You'll end up with a directory that contains the
> actual driver file plus a bunch of othe
On Fri, Jan 25, 2002 at 04:02:23PM -0800, Bruce Sandell wrote:
>
> So does this mean that you should or should not bother using indexes
> on a heap table?
You should use an index on a heap table column just like you would for
any other table. It's just that the index isn't a B-Tree like with
MyI
So does this mean that you should or should not bother using indexes on a
heap table?
Thank you very much for you help on this matter.
Bruce
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 3:48 PM
To: Bruce Sandell
Cc: [EMAIL PROTECTED]
On Fri, Jan 25, 2002 at 03:44:07PM -0800, Bruce Sandell wrote:
>
> Is the index for a hash table stored on disk or in memory?
You mean for HEAP tables, which used hashed indexes?
> I have a hash table that I am constantly adding data to, which means
> the index is constantly being updated. If I
Sorry, thats a heap table, not a hash table.
-Original Message-
From: Bruce Sandell [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 3:44 PM
To: [EMAIL PROTECTED]
Subject: Indexing hash tables
Is the index for a hash table stored on disk or in memory? I have a hash
table that
Is the index for a hash table stored on disk or in memory? I have a hash
table that I am constantly adding data to, which means the index is
constantly being updated. If I keep the size of the key buffer sufficiently
large, will the new index values be there upon creation, or not until they
are
On Fri, Jan 25, 2002 at 04:26:51PM -0500, Don Smith wrote:
>
> is it possible for mysql to use a different service for
> authentication such as ldap or a passwd file?
Not without modifying the source code, nope.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408
Does anyone know about any projects or future plans to do this,
one of the reasons we actually chose sequel server is that it can
authenticate from our windows nt user list.
If mysql could have authenticated off of an ldap server this would have
been a big win
many thanks
don smith
Jeremy Zaw
On Fri, Jan 25, 2002 at 03:40:37PM +0200, Sinisa Milivojevic wrote:
> Gorantla, Aruna writes:
> >
> > Hi All,
> > Does anybody know if there are any monitoring tools for MySQL database?
> >
> > Thanks,
> > Aruna.
> >
>
> Hi!
>
> There is a wide choice.
>
> You can use either admin modul
Hi Jon,
> I have a query that is returning 15 records per page. For each record, I
> may do up to 2 subselects - this is done by issuing seperate queries inside
> the 15 record recordset (depending on the level of detail chosen by the
> user). The problem is that things slow down quite a bit wh
Gorantla, Aruna writes:
>
> Hi All,
> Does anybody know if there are any monitoring tools for MySQL database?
>
> Thanks,
> Aruna.
>
Hi!
There is a wide choice.
You can use either admin modules of mysqlgui or mysql module in
MOODSS.
Depends on what exactly you need, and on your taste .
At 16:11 -0600 1/25/02, Paul DuBois wrote:
>At 16:59 -0500 1/25/02, Rahadul Kabir wrote:
>>I'm a bit confused here. can some please tell me what is the difference
>>between this two files
>>
>>-- mm.mysql.jdbc-1.2c.tar.gz ( Includes mysql_comp.jar and
>>mysql_uncomp.jar)
>>-- mm.mysql-2.0.10-you
Hi All,
Does anybody know if there are any monitoring tools for MySQL database?
Thanks,
Aruna.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the lis
At 16:59 -0500 1/25/02, Rahadul Kabir wrote:
>I'm a bit confused here. can some please tell me what is the difference
>between this two files
>
>-- mm.mysql.jdbc-1.2c.tar.gz ( Includes mysql_comp.jar and
>mysql_uncomp.jar)
>-- mm.mysql-2.0.10-you-must-unjar-me.jar
>
>For JDBC driver to run with
I'm a bit confused here. can some please tell me what is the difference
between this two files
-- mm.mysql.jdbc-1.2c.tar.gz ( Includes mysql_comp.jar and
mysql_uncomp.jar)
-- mm.mysql-2.0.10-you-must-unjar-me.jar
For JDBC driver to run with mysql which one do I need? I thought you
only need .
At 14:26 -0700 1/25/02, Matthew Walker wrote:
>Say I have a similar enum field that shows up in many tables. Right now,
>if I want to change it, I have to change it everywhere. What I'd like is
>a way to have a 1 column table that contains a list of the possible
>values for the enum field, and hav
is it possible for mysql to use a different service for authentication
such as ldap or a passwd file?
many thanks
don smith
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
Say I have a similar enum field that shows up in many tables. Right now,
if I want to change it, I have to change it everywhere. What I'd like is
a way to have a 1 column table that contains a list of the possible
values for the enum field, and have the enum automatically build itself
based on tha
Hi all,
I have a query that is returning 15 records per page. For each record, I
may do up to 2 subselects - this is done by issuing seperate queries inside
the 15 record recordset (depending on the level of detail chosen by the
user). The problem is that things slow down quite a bit when doing
Alright then!
> database,sql,query,table
Which field type do I use for a simply checkbox Y,N?
Thanks
Any objection to this ?
cbcolumn enum ('Y', 'N') NOT NULL DEFAULT 'Y'
May not be the most space efficient, but its clear, self-documented and
unambiguous.
It does what it says on the tin.
Da
At 14:04 -0700 1/25/02, Matthew Walker wrote:
>This brings to mind a question I've had for a while. Is there any way to
>automatically build and update an enum based on another very simple (1
>column) table?
What does that mean, exactly?
>
>Matthew Walker
>Ecommerce Project Manager
>Mountain Top
This brings to mind a question I've had for a while. Is there any way to
automatically build and update an enum based on another very simple (1
column) table?
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: James E. Hicks III [mailto:[EMAIL PROTECTED
I've been using enum ("Y","N").
James
-Original Message-
From: Vernon A Webb [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 10: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 simp
Hi,
I am running MySQL-3.22.32 and MySQL-3.23.47 on Solaris 8. In reading
through your documentation for 3.23.47, I noticed that in section "4.1.4
Running Multiple MySQL Servers on the Same Machine" it is written:
"If you want to run multiple servers, the easiest way is to compile the
servers wi
On Wed, 2001-12-05 at 16:33, Arjen G. Lentz wrote:
>
> - Original Message -
> From: "Florin Andrei" <[EMAIL PROTECTED]>
>
> > SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM
> > event, iphdr, tcphdr WHERE event.cid = iphdr.cid AND event.cid =
> > tcphdr.cid AND tcphdr
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> 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?
>
>
> --
> Martin M
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
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
Hello
At 13:08 -0600 1/25/02, Paul DuBois wrote:
>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
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/
> 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 hea
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
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
> > Contribut
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
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 PROT
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.
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,
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 my
=?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
[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, there is one case w
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
-
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 ta
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
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 WHE
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).
> Howeve
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
>
>-
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
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 - W
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)
http://lists.mysql.
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
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, whi
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
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
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
documenta
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 s
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
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
---
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'
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
DL
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. Lo
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> sel
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"
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 M
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
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
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
>
> ++--
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
|
++
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), bu
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 sta
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?
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 fi
Hi SF,
> I have problem with join and order clause. I have 2 table join with
> amount condition and sort by order clause. The result of this join
> generate unwanted row to me.
>
> example
> table1
> No. Amount Count
> 1 1000 2
> 2 2000 3
> 3 500 1
> table2
> No. Name Amount
> 1 A 1000
>
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 wher
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. 4
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?
Tha
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.
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 ||| htt
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
op
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 deci
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/ (th
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. Hope
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.
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 InnoDB
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
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
> >
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 --
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 allo
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 conce
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 mysql+
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
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');
DB_DIR=director
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:
>T&F Informatio
1 - 100 of 140 matches
Mail list logo
