What would I do if there are InnoDB tables ?
--
Dimitry
Wednesday, January 30, 2002, 9:31:09 PM, Paul DuBois wrote:
> At 11:10 -0800 1/30/02, JC wrote:
>>-BEGIN PGP SIGNED MESSAGE-
>>Hash: SHA1
>>
>>I'm kind of interested to find if there is a way to rename a database
>>with something
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Richard Clarke" <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 7:11 AM
Subject: Re: database/table performance
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass th
Hi,
i am developing a software on linux platform and Mysql Ver 11.13 Distrib
3.23.36, for redhat-linux-gnu (i386) as the backend and i would like to know
if MySQL( any version like previous one or the latest version), either of
versions supports STORED PROCEDURE, TRIGGERS and also VIEWS? if it su
hi,
I have run the script mysql_install_db --with-innodb. then I am getting
the
mysql>show variables like "have_innodb";
+---+---+
| Variable_name | Value |
+---+---+
| have_innodb | YES |
+---+---+
On Thu, Jan 31, 2002 at 02:19:28AM -, Greg Conway wrote:
> Wow! thanks for the responses!
>
> Here is what I think you are mostly asking for... I have run "mysqladmin
> variables" to get this.
Great. I've kept the problem section in the output.
> |
> | have_bdb| NO
I think a better question would be why ;-)
It's not that I don't love my PS2 I just don't see it as a very good
database machine you know ;-)
Mark Maunder wrote:
>
> Linux for PS2 is being released in Europe in May this year:
> http://www.scee.com/corporate/pressreleases.jhtml
>
> Who's going
hi,
I am referring "Innodb startup options" and "my.cnf file options" as in
the manual.
Till this I have installed the MyQSL-Max-3.23.47 and mysql-max daemon is
running. I can go to mysql command prompt.
mysql> show variables like "have_innodb";
+---+--+
| Variable_name | Value
From: "sreedhar" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Subject: Can I establish a ADO Connection to work with PHP and MySQL on
Linux
> Hi all,
>
> My Database on Linix. Can I establish a ADO Connection to work with PHP
and
> MySQL on Linux.
Uhm yes You could do that, but why?
Hi all,
My Database on Linix. Can I establish a ADO Connection to work with PHP and
MySQL on Linux.
regards,
sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Linux for PS2 is being released in Europe in May this year:
http://www.scee.com/corporate/pressreleases.jhtml
Who's going to be the first to get MySQL to compile on PS2. ;-)
~mark.
-
Before posting, please check:
http://www
On Thu, 31 Jan 2002, Charitha wrote:
>
> I want to know how to create a table with an autoincrement field in that
> along with a name field with the varchar datatype.
>
create table MySimpleTable (
id integer not null primary key auto_increment,
name varchar(32) not null
);
See:
http://www
Dear MySQL community,
I am new MySQL user. I want to migrate a M$ SQL Server
database to MySQL in a Linux box. Since table names in
MySQL@Linux is case sensitive, I am having troubles
connecting to the server via ODBC from a Windows box.
I search the documentation and find that I may be able
to
I appear to be having an error with the following update that I am
submitting to my database. I am using mysql's DATE_FORMAT function to pull
the date out and insert in a user friendly form. Upon submission of the
modified data, I use the below SQL to update the table information.
Everything is r
What I do with my mail server is to filter out all known "opt-in"
mailing list companies, not just their host name, but their net-block!
If the mail server doesn't have such options, try the router level,
firewalls or ACLs... Also adopted recently is the use of ORBZ, though
sometimes legitim
Check out:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
Gurhan
-Original Message-
From: Charitha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 10:51 PM
To: [EMAIL PROTECTED]
Subject: Help me to create a table with autoincrementing field
Hi all there,
I am a fresher
Hi all there,
I am a fresher to mysql.
I want to know how to create a table with an autoincrement field in that
along with a name field with the varchar datatype.
Thank you.
Regards,
Charitha.
-
Before posting, please chec
Try this:
select key_col, min(name), max(date_col)
from my_table
group by key_col ;
You could use max(name) instead of min(name) also, although
since the names can be misspelled, I don't see why it would matter
which name is displayed.
s.s.
On Wed, 30 Jan 2002 21:36:04
Below I have two queries. They both should do the same thing but the foreign
key syntax is a little different. The first query fails, though some queries
with foreign key clauses work sometimes, and the second one just works.
Am I right in thinking the syntax for both these queries mean the same
At 21:57 -0500 1/30/02, [EMAIL PROTECTED] wrote:
>I found out why my LOAD DATA INFILE did not work.
>
>The editor I was using translated the tabs I entered to spaces.
>That's why my load data infile didn't work!
>I used the following command to load the data successfully:
>
>load data infile "tes
I found out why my LOAD DATA INFILE did not work.
The editor I was using translated the tabs I entered to spaces. That's why my load
data infile didn't work!
I used the following command to load the data successfully:
load data infile "test.dat" replace into table persons fields terminated by '
On Wed, 30 Jan 2002, Dan Nelson wrote:
> In the last episode (Jan 30), Jeremy Zawodny said:
> > On Wed, Jan 30, 2002 at 08:11:53PM -0600, j.urban wrote:
> > > I've had good results with the following as well:
> > >
> > > :0
> > > * ^List-ID:
> > > mysql-list
> >
> > That will miss replies which
In the last episode (Jan 30), Jeremy Zawodny said:
> On Wed, Jan 30, 2002 at 08:11:53PM -0600, j.urban wrote:
> > I've had good results with the following as well:
> >
> > :0
> > * ^List-ID:
> > mysql-list
>
> That will miss replies which are sent to the list an CC'd to you.
> The list copy wi
On Wed, Jan 30, 2002 at 08:11:53PM -0600, j.urban wrote:
> On Wed, 30 Jan 2002, Jeremy Zawodny wrote:
>
> > > > do you have a procmail recipe which will catch ALL the messages to
> > > > this list and put them in one folder? Even CCs, reply's, whatever?
> > > >
> > > > I follow several lists, and
Wow! thanks for the responses!
Here is what I think you are mostly asking for... I have run "mysqladmin
variables" to get this.
Regards,
Greg.
+-+-
--
On Wed, 30 Jan 2002, Jeremy Zawodny wrote:
> > > do you have a procmail recipe which will catch ALL the messages to
> > > this list and put them in one folder? Even CCs, reply's, whatever?
> > >
> > > I follow several lists, and this is one of the only two that I
> > > can't come up with a worki
I'm getting an error trying to create a table but can't find any error codes
listed in the online mysql documentation.
Does anyone know a good source for this?
Also is the cause of my error recognisable to anyone? I just successfully
created the tables listed but this one bounced. All tables are
For folks that are having trouble with clean shutdown on OS X, try using
mysqladmin -u root -ppw flush-tables
before shutting down mysql.
I hadn't had a shutdown problem in a week then this evening I got the
dreaded pid file hang at shutdown and had to use kill -9.
The only thing I did differen
At 1:05 + 1/31/02, Julián Muñoz Domínguez wrote:
>I ask this here because it seems this topic is not covered in any faq (or
>I don't find it):
>
>
>Is it possible to have mysql listening in 2 unix sockets (diferent path)
>at the same time ?
>
>I use postfix, and the socket should be in a speci
On Wed, Jan 30, 2002 at 10:35:21AM -0500, Keith C. Ivey wrote:
> We're currently using MyISAM tables for everything. Are there
> circumstances in which the InnoDB table type would be better even if
> we're not going to use commit/rollback, or are transactions the only
> advantage of InnoDB?
Con
On Wed, Jan 30, 2002 at 10:05:39PM +, peaw peaw wrote:
> Oh I see.
>
> Since I really need this DESC badly, is it sensible to add a 3rd
> column that keeps its values in reverse order(say, SomeBigInt -
> value of col2) ? Then create an index on (col1,col3) and use it
> without the "DESC".
Yes
On Thu, Jan 31, 2002 at 01:05:33AM +, Julián Muñoz Domínguez wrote:
>
> I ask this here because it seems this topic is not covered in any
> faq (or I don't find it):
It's not frequently asked. ;-)
> Is it possible to have mysql listening in 2 unix sockets (diferent path)
> at the same time
> Since I really need this DESC badly, is it sensible to
> add a 3rd column that keeps its values in reverse
> order(say, SomeBigInt - value of col2) ? Then create
> an index on (col1,col3) and use it without the "DESC".
Yes. For a signed col2 you can try 0x7FFF - col2. Unsigned I think
you s
Hi folks,
Having MyODBC Woes, and just cant get it working with
unixODBC (odbc datasource manager). So far I have
tried building it using the
./configure --with-unix)DBC=/usr/local
--with-mysql-sources=/usr/loacal/mysql
I have aslo installed the rpms as well and can they do
not work. Have used b
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
I ask this here because it seems this topic is not covered in any faq (or
I don't find it):
Is it possible to have mysql listening in 2 unix sockets (diferent path)
at the same time ?
I use postfix, and the socket should be in a specific directory inside
/var/spool/postfix, but at the same tim
I'm forwarding this to the list since I can't offer any more advice
myself. -- Forwarded message --
Date: Wed, 30 Jan 2002 19:41:32 -0500
From: [EMAIL PROTECTED]
To: "William R. Mussatto" <[EMAIL PROTECTED]>
Subject: Re: Batch load of data problems
I guess I didn't make myself ve
Hello, everybody:
I have updated the filter on this list again to adjust for the new kind of
spam we've been getting. Two things I've changed are:
* fixed bug that did not ban attachments if Multipart was captilized - this
should stop the naver.com flood
* reduced the good words list to quer
On Thu, Jan 31, 2002 at 12:06:52AM -, Greg Conway wrote:
>
> I've just upgraded from a tarball MySQL (3.23.33) to an RPM (MySQL
> 3.23.47-1).
>
> Along the way, somewhere, MySQL seems to have lost it's ability
> operate as a transaction server!
>
> I know this as I use Zope to connect to My
Title: ³×À̹ö ¸ÞÀÏ
È«¼øÅ (javahong) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
Hi all,
I've just upgraded from a tarball MySQL (3.23.33) to an RPM (MySQL
3.23.47-1).
Along the way, somewhere, MySQL seems to have lost it's ability operate as a
transaction server!
I know this as I use Zope to connect to MySQL, and it's now giving me the
following error:
Error Type: NotSupp
Title: ³×À̹ö ¸ÞÀÏ
È«¼øÅ (javahong) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
On Thu, Jan 31, 2002 at 12:33:28AM +0100, Marco Fioretti wrote:
> > do you have a procmail recipe which will catch ALL the messages to
> > this list and put them in one folder? Even CCs, reply's, whatever?
> >
> > I follow several lists, and this is one of the only two that I
> > can't come up
On Wed, Jan 30, 2002 at 06:21:29PM -0500, Lee, Andrew wrote:
>
> I downloaded a precompiled version of MySQL 4 for Linux and I'd like
> to try it out. Anyone had success getting both running?
Yes.
> What did you have to edit in the startup and config scripts?
Used different port numbers and so
> Hello,
>
> do you have a procmail recipe which will catch ALL the messages to
> this list and put them in one folder? Even CCs, reply's, whatever?
>
> I follow several lists, and this is one of the only two that I
> can't come up with a working recipe for.
>
> TIA
> mweb
At 18:21 -0500 1/30/02, Lee, Andrew wrote:
>I downloaded a precompiled version of MySQL 4 for Linux and I'd like
>to try it out. Anyone had success getting both running? What did you
>have to edit in the startup and config scripts?
I used different settings for the following configure options:
I downloaded a precompiled version of MySQL 4 for Linux and I'd like
to try it out. Anyone had success getting both running? What did you
have to edit in the startup and config scripts?
TIA
-
Before posting, please check:
Title: ³×À̹ö ¸ÞÀÏ
È«¼øÅ (javahong) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
On Wed, Jan 30, 2002 at 03:06:36PM -0800, Joseph Drozdik wrote:
> Hi all,
>
> I've been looking at the performance of mysql using innodb tables
> and I've noticed that I can get a huge benifit by setting
> innodb_flush_log_at_trx_commit = 0. The documentation warns me that
> I can loose a couple
Hi all,
I've been looking at the performance of mysql using innodb tables and I've
noticed that I can get a huge benifit by setting
innodb_flush_log_at_trx_commit = 0. The documentation warns me that I can
loose a couple of seconds of transactions in system crash if I do this.
It seems like a gr
>That is possible too:
> - MySQL Training (http://www.mysql.com/training/)
> - MySQL Support (http://www.mysql.com/support/)
> - MySQL Consulting (http://www.mysql.com/consulting/)
>However, it will never be a substitute for manual tuning. Good database
>performance more than simply the result o
Hi,
I try to link ACCESS 97 to MySQL (3.23.43-max-nt), both on a Windows2000
Service Pack 2 Intel PC (Toshiba Satellite) with MyODBC.
It is working fine but for some tables ACCESS show their contents correct
in the beginning and after half a minute an ODBC ERROR occurs:
ODBC call failed
and
Hi Steve,
On Thu, 2002-01-31 at 06:35, Steve Rapaport wrote:
> I'd buy it!
That is possible too:
- MySQL Training (http://www.mysql.com/training/)
- MySQL Support (http://www.mysql.com/support/)
- MySQL Consulting (http://www.mysql.com/consulting/)
See, the manual and sample cnf files alread
On Thu, 31 Jan 2002, DL Neil wrote:
> Date: Thu, 31 Jan 2002 21:28:04 -
> From: DL Neil <[EMAIL PROTECTED]>
> To: "William R. Mussatto" <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: next insert id (slightly OT)
>
> William,
>
> > > What should be understood is that MySQL's impl
On Wed, 30 Jan 2002, Eurico de Sousa wrote:
> Date: Wed, 30 Jan 2002 16:56:24 -0500
> From: Eurico de Sousa <[EMAIL PROTECTED]>
> To: mysql post <[EMAIL PROTECTED]>
> Subject: Re: Batch load of data problems
>
> Hi. Resubmitting a post...
>
> Basically, my question is if you have defined an INT
Hi!
> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
Heikki> Hi!
Heikki> This is a bug in the MySQL layer of code. I am sending a carbon copy of this
Heikki> email to Monty.
>> I am using Mysql 4.0.1 alpha for Windows, my table are all on InnoDB, when
>> I connect
>> to
>> mysql se
Oh I see.
Since I really need this DESC badly, is it sensible to
add a 3rd column that keeps its values in reverse
order(say, SomeBigInt - value of col2) ? Then create
an index on (col1,col3) and use it without the "DESC".
The website does about 10 times more reading than
updating the table. Ther
Hi. Resubmitting a post...
Basically, my question is if you have defined an INT NOT NULL AUTO_INCREMENT id field
in a table,
and you want to load a data file into the table using the LOAD DATA INFILE command,
must you also
put the ids in the data file? Thanks.
Eurico
*
> >P.S. Is the Paul DuBois on this list the same Paul DuBois who wrote
> >"MySQL and Perl for the Web"?
> >
> >Just wondering.
>
>
> I believe so, yes.
=but he tends to hide/blend into the woodwork!?
=dn
-
Before posting, p
William,
> > What should be understood is that MySQL's implementation of AUTO_INCREMENT
>requires a particular/different
> > philosophical view: that first the 'primary row' is to be stored, then the
>AUTO_INCREMENT data captured, and
> > finally the dependent row is stored (in the second table
Title: ³×À̹ö ¸ÞÀÏ
È«¼øÅ (javahong) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
The manual is really a wonderful read - anyway:
char() 255 bytes
varchar() 255 bytes
text() 65535 bytes
-Original Message-
From: Emily Kelley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 1:34 PM
To: [EMAIL PROTECTED]
Subject: questio
Egor Egorov ([EMAIL PROTECTED]) writes:
> Ed,
>
> Monday, January 28, 2002, 11:26:44 PM, you wrote:
>
> EC> Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on
> EC> a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the
> EC> box, mysql will start,
At 02:34 PM 1/30/2002 -0600, Emily Kelley wrote:
>In the process of searching for a dynamic database solution for a work
>project I have just begun reading about MySQL. So far this looks like a
>very promising choice for us but I have one extremely basic question that I
>hope someone will kindly a
At 12:22 PM 1/30/2002 -0600, you wrote:
>I sent a reply back to JW about his problem on performance tuning and came up with I
>thought a really good idea. But there weren't any bites so I thought I start it on a
>new thread.
I'd like to point out that I'm pretty sure you sent the reply to me di
What is the best source of information about
performance tuning MySQL? I saw that Jeremy's proposed
book was to include a lot of coverage on this topic --
are there other sources? Is the online doc the best
place so far?
--- Mike Wexler <[EMAIL PROTECTED]> wrote:
> I don't think this will work.
I'd buy it!
-steve
-Original Message-
From: BD [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 7:23 PM
To: [EMAIL PROTECTED]
Subject: Really good idea on Performance Tuning???
I sent a reply back to JW about his problem on performance tuning and came
up with I thought a re
Use a 48-to 64 bit int. When you print or
calculate, divide by 10^12. It's called fixed-point arithmetic.
-steve
P.S.
Ignore the funny guy talking about the commas, he's never been
outside his country.
-Original Message-
From: Vasoczki Ferenc [mailto:[EMAIL PROTECTED]]
Sent: Wednesda
In the process of searching for a dynamic database solution for a work
project I have just begun reading about MySQL. So far this looks like a
very promising choice for us but I have one extremely basic question that I
hope someone will kindly answer for me.
Is there a character limit for text f
Hi,
I have two tables I wish to combine into a single table. Both tables use
the same format and include a unique key (ID) auto-increment field. Each
row also contains a date field. Whoever managed this database in the past
at some point set up a new server, and initially had new data sent to
Further, I'd advise NOT using field names like "date" and "key". Using
eserved words is never a good prcatice.
-Original Message-
From: Rick Emery
Sent: Wednesday, January 30, 2002 2:16 PM
To: 'P.Agenbag'; 'mysql'
Subject: RE: SQL help plz
Sorry, I meant:
mysql> select name,max(dateq
Sorry, I meant:
mysql> select name,max(dateq) from mytable group by keyq;
-Original Message-
From: Rick Emery
Sent: Wednesday, January 30, 2002 2:14 PM
To: 'P.Agenbag'; mysql
Subject: RE: SQL help plz
mysql> describe mytable;
+---+--+--+-+-+---+
| Field
mysql> describe mytable;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(11) | YES | | NULL| |
| keyq | int(11) | YES | | NULL| |
| name | cha
valentin,
Wednesday, January 30, 2002, 5:57:00 PM, you wrote:
v> Hello,
v> We are students in a french university and we have a trouble while
v> running mysql on our server.
v> After typing the command mysql, we have this message:
v> ERROR 2002: Can't connect to local MySQL server through socke
At 21:36 +0200 1/30/02, P.Agenbag wrote:
>Hi
>I need help with an sql string:
>
>have a table similar to this:
>
>idkeynamedate
>1 123name1 date1
>2 123name1 date2
>3 111name2 date1
>4 111name2
At 13:29 + 1/30/02, Will K. wrote:
>P.S. Is the Paul DuBois on this list the same Paul DuBois who wrote
>"MySQL and Perl for the Web"?
>
>Just wondering.
I believe so, yes.
-
Before posting, please check:
http://www.mys
Appreciate those of you referring me to GNU tar - it did untar mysql properly whereas
SUN's tar
couldn't.
Eurico
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I don't think this will work. The setting depend on a lot more variables then
you list. For example the mix of queries to updates. Although what you are
suggesting might make a first approximation.
Maybe a field where you could copy and paste the output of show status would
help to alleviate th
On Wed, Jan 30, 2002 at 06:21:20PM +, peaw peaw wrote:
> Hello.
> I'm new to this mailing list :+)
>
> I created a mutilple-column index, say
>
> "create index col1_col2 on table_name (col1,col2) "
>
> Both col1 and col2 are mediumint unsigned.
>
> "explain select * from table_name wher
This may already be implemented, but the MySQL Technical Reference for Version 3.23.41
states:
1.6.2 Things that must be done in the real near future:
- Implement RENAME DATABASE. To make this safe for all table handlers, it should work
as follows:
- Create the new database.
- For every tab
Hi.
I have a question regarding loading data from text files into tables using the LOAD
DATA statement.
I tried this under Win98 without success. Basically, I have a file called create.tbl
which has
CREATE TABLE statements. The last statements in this file are of the form:
LOAD DATA INFILE "fi
At 20:10 +0100 1/30/02, Vasoczki Ferenc wrote:
>I need to store data like 12,213142124
>where the decimal places can be 12.
>What column type should i use ?
>I tried float(4) but that is use only 2 decimal places, and i also tried
>decimal(12,12) but that is give me back 9. for 10,704704 ?
Hi
I need help with an sql string:
have a table similar to this:
idkeynamedate
1 123name1 date1
2 123name1 date2
3 111name2 date1
4 111name2 date2
5 123name1 date3
Now
At 11:10 -0800 1/30/02, JC wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>I'm kind of interested to find if there is a way to rename a database
>with something like the alter command.
>Looking in the index of the New Riders MySQL book I don't see
>anything other than renaming tables
>Lo
I know this was in the list just i really can't found in the archive.
I have about 20 tables, and every tables have a questionary in .doc format.
I want to archive theese docs.
How can i store theese doc files in table, and how can i get back in the
same format what i stored ?
Thx
/replys can be
On Wed, Jan 30, 2002 at 01:31:53PM +0900, Tatsuhiko Miyagawa wrote:
> Has anybody out there experienced with mysqld running on
> daemontools?
Yes.
> We're now testing this combination on our staging server without
> any problem, but if you can suggest any problem for it or
> anything, it would
On Tue, 29 Jan 2002, Sasha Pachev wrote:
> On Tuesday 29 January 2002 06:20 pm, Michael Widenius wrote:
> > I think we can avoid things like this by adding some extra 'not-
> > allowed-on-the-list' words, that a non-subscribe can't use, without
> > including an extra keyword in the email.
> >
>
I need to store data like 12,213142124
where the decimal places can be 12.
What column type should i use ?
I tried float(4) but that is use only 2 decimal places, and i also tried
decimal(12,12) but that is give me back 9. for 10,704704 ?
vaso
database,sql,query,table just to post :)
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm kind of interested to find if there is a way to rename a database
with something like the alter command.
Looking in the index of the New Riders MySQL book I don't see
anything other than renaming tables
Looking through the Manual for version 3
Dear sir,
I used mysql-4.0.1 running on Solaris-2.5.1 and
compile with Gcc-2.95.3. (package from www.sunfreeware.com)
I used command below.
CC=gcc CFLAGS="-O3" \
CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
./configure --prefix=/usr/local/mysql --with-low-memory --e
On Wed, 30 Jan 2002, Rick Emery wrote:
> The Linux version no longer has 2 GB limit. It is now whatever your disk
> capacity is.
The "no longer", however, is a function of later Linux kernels and
filesystems. Linux 2.2 kernels with the ext2 filesystem (probably still
the most common setup) have
Hi,
see the DBI perldoc
here is a quick example:
my $dbh = DBI->connect("DBI:mysql:mydb", $user, $password)
or die "Can't connect to $data_source: $DBI::errstr";
Charitha wrote:
>
> Hi all,
>
> Please guide me to get the connection with mysql through perl scripts and
> thro
Yes, using MS Query which comes with Office
ODBC must be installed and working with a DSN set to you MySQL database
then...
See if you have MSQuery installed... if you do the file name is MSQRY32.EXE
in your Office directory.
If MSQuery is not installed, find your Office 2k CD and run setup. Y
Yes, just i need to make it from code, and from a windows machine, so i cant
use shell() or something like that...
So i need to upgrade...
Vaso
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: 2002. január 30. 19:31
To: Vasoczki Ferenc; '[EMAIL PROTECTED]'
Subject: R
At 17:29 +0100 1/30/02, Vasoczki Ferenc wrote:
>Hi, i want to copy a table structure.
>I saw on the archive, there is a syntax like:
>create [newtable] select * from [sourcetable] where 1=2;
>
>This is not work on my MySQL server v.3.22
>Is it a 3.23 feature, or am i do something wrong ?
It's a 3
Hello.
I'm new to this mailing list :+)
I created a mutilple-column index, say
"create index col1_col2 on table_name (col1,col2) "
Both col1 and col2 are mediumint unsigned.
"explain select * from table_name where col1='value'
order by col1 DESC,col2 DESC "
shows that the query is still u
I sent a reply back to JW about his problem on performance tuning and came
up with I thought a really good idea. But there weren't any bites so I
thought I start it on a new thread.
There are a lot of threads about setting up MySQL for the best
performance. This might help to solve the proble
Egor Egorov ([EMAIL PROTECTED]) writes:
> Ed,
>
> Monday, January 28, 2002, 11:26:44 PM, you wrote:
>
> EC> Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on
> EC> a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the
> EC> box, mysql will start,
Hello Folks,
oncemore I post this question:
Is it possible to update data from Microsoft Word useing MyODBC?
Is there any other way to update data from MS Word?
Is here a VB Scripting Guru who can help me?
cheers,
Felix.
(keywords: database, table, sql) :-)
--
Solaris tar is broken (can't handle long file names). You need to use GNU
tar. See
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Solaris
Michael
On Wed, 30 Jan 2002, Eurico de Sousa wrote:
> Hi.
>
> I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 an
The Linux version no longer has 2 GB limit. It is now whatever your disk
capacity is.
-Original Message-
From: Steve Kramer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 11:34 AM
To: Christopher Thompson
Cc: MySQL
Subject: RE: Size Limitations
The manual doesn't specify
1 - 100 of 170 matches
Mail list logo
