Deryck,
the latest information on InnoDB you can always find at
http://www.innodb.com
Regards,
Heikki
Innobase Oy
>Here is two thing for you.
>
>First, GREAT source for search of pass problem on any thing really.
>
>http://marc.theaimsgroup.com/
>
>Then, information on the InnoDB. Not hard to
Hello,
Windows support 2000 threads by default (with the help of thread library).
Then what a mean of max_connection = 100 because MySQL One each connection
on differente thread.
Is i able to increase the max_connection limit.
Manish Mehta
E-mail: [EMAIL PROTECTED]
--
You are welcome, and if that doesn't work for you.
I am sure you will find the answer here:
http://marc.theaimsgroup.com/?l=mysql&w=2&r=1&s=curses+termcap&q=b
Daniel
>
> i gonna check that...
> thanx for your super speed answer...
>
> i'm surprised
>
> - Original Message -
> From: D
i gonna check that...
thanx for your super speed answer...
i'm surprised
- Original Message -
From: Daniel Ouellet <[EMAIL PROTECTED]>
To: [AFQ]T1T4N <[EMAIL PROTECTED]>
Cc: MySQL <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 1:57 AM
Subject: RE: Problems with compilation
> > I ha
> I have Debian the last release, and i want to compilate mysql and it had
> some errors
> here is a little text.
> checking for tgetent in -lncurses... no
> checking for tgetent in -lcurses... no
> checking for tgetent in -ltermcap... no
> checking for termcap functions library... configure: erro
I have Debian the last release, and i want to compilate mysql and it had
some errors
here is a little text.
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
checking for tgetent in -ltermcap... no
checking for termcap functions library... configure: error: No
curses/t
I love this one! (:>
That put a smile on a long night!
Thanks!
Daniel
> The original query is as follows:
>
> SELECT * FROM websites WHERE category LIKE '%"&search&"%' OR keywords LIKE
> '%"&search&"%' OR description LIKE '%"&search&"%'
>
> The "&search&" instances are from an ASP page. 'sea
Here is two thing for you.
First, GREAT source for search of pass problem on any thing really.
http://marc.theaimsgroup.com/
Then, information on the InnoDB. Not hard to find really.
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#I
nnoDB
Have a good reading.
Danie
The original query is as follows:
SELECT * FROM websites WHERE category LIKE '%"&search&"%' OR keywords LIKE
'%"&search&"%' OR description LIKE '%"&search&"%'
The "&search&" instances are from an ASP page. 'search' is a variable that
is asigned the value of the query string 'search'
dim search
I asked this on comp.lang.perl.modules but I thought someone here might
have an idea as well: I have some code that does this:
use DBI;
my $dbh = DBI->connect('dbi:mysql:database=mysql;host=localhost',
$username, $password);
$dbh->func('createdb', $newdb, 'admin'
Hello
What a difference between
mysqladmin Vs WinMySQLAdmin
Because i thing both were works as same. but those thing i set
through --set-variable command not reflect on WinMySQLAdmin. Why?
Manish Mehta
E-mail: [EMAIL PROTECTED]
---
OK, I will soon have a huge database, home to about 500,000,000+ records and
believe that MySQL needs to be faster. I have heard good things about
InnoDB but Ihave no idea what it is. Can someone please tell me (or give a
url telling) what it is, the benifits, how I can set it up on an already
e
hello,
Is MySQL Support Encryption ?
Manish Mehta
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reque
Hi,
> /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
>
> now the file is present. i dont understand what to do about it.
> I searched over the net for ever thing, but didnt understand how to get rid
> of this problem.
perror 13: permission denied. Your mysqld server
Hello Everyone,
We are using MySQL as backend.
What is Maximum size of MySQL Database?
Manish Mehta
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
Hi,
[EMAIL PROTECTED] writes:
> To whom ever can help:
>
> I have a database dumped from PostgreSQL to a text file , is there any
> method used to convert this to MySQL?
Yes, please use mysqlimport. See mysqlimport --help for information,
more detailed information can be found from the MyS
Jani Tolonen writes:
> Chris Davis writes:
> > I am having trouble porting MySQLGUI to Mac OS X. Any plans to make a
> > package?
> >
> > -chris
>
> Hi Chirs,
>
> Yes, in the near future. We just about to get Mac OS X for
> ourselves.
Sorry, I read your question too quickly. My
Chris Davis writes:
> I am having trouble porting MySQLGUI to Mac OS X. Any plans to make a
> package?
>
> -chris
Hi Chirs,
Yes, in the near future. We just about to get Mac OS X for
ourselves.
Regards,
- Jani
For technical support contracts, visit https://order.mysql.com/
__ ___
Hi,
Jindo Soul writes:
> Hello,
>
> I've never understood the difference between TinyInt(1) and TinyInt(4). For
> CHAR data
> type, I know the number enclosed in the bracket means the length of the CHAR
> type.
> But how does TinyInt(1) differ from TinyInt(4)? I tried to experiment with
admin writes:
> I am working on a project for a client that got roped into MsSQL7 by her
> last hosting company. I am looking for a good way to convert a MsSQL7
> Database to MySQL. Anyone know of a piece of software that will convert the
> Database files or atleast suck from one database to t
Ingvar Li-Si-Tsin writes:
> But today I got a letter from my hosting administrator
> saying (in a rude way - but it
> is another matter) that I am kind of disturbing the whole
> server"s work
> because of the amount of tables in my database.And he also
> threatened to switch off
> my si
Hey everyone! As most of you know the official (as in, not using a BASH
shell) release of MySQL 4.0 will be out very soon. So, let's throw a party!
Not like something at someone's house (although I wish we could). Just a
get - together online in a chat room with games, music (mp3s), and more!
yogi writes:
> Hi, is there a comprehensive list of mySQL error codes and the related
> messages somewhere?
> Thanx, Cheerio, yogi
>
> - travel light!
> e-mail: [EMAIL PROTECTED]
Hi,
Try perror #err_code. 'perror' (print error) comes with MySQL
distribution. perror works also for system
Ashley M. Kirchner writes:
> Gerald Clark wrote:
>
> > Perhaps mysql does not own the directory that contains the databases.
> >
> > > I just compiled from scratch, and successfully installed v3.23.42 on an
> > > RH7.1 system. EVerything went fine, no errors anywhere, it started up
Hi Jani,
Thanks for your answer.
That is true that you guys are making some available. I sure don't deny that
at all and it is very generous of you guys to spend the time doing it as
well!
One reason is that I wanted Apache with PHP and Static MySQL built in. So, I
have to compile it anyway. So
[EMAIL PROTECTED] writes:
> I have a table in a mysql database that contains data from two
> different languages using two different character sets. I need to be
> able to query in either language. Queries that I run against the data
> in English seem to run fine. However, queries against
David Aldridge writes:
> I downloaded the latest version of MySQL and installed it on my Sparc
> Ultra5. I used the pkgadd -d to install it. It said the install was
> successful. When I run mysql_install_db, I get the following error message:
>
> # ./mysql_install_db
> Creating db table
>
Vien Huynhle writes:
> I am getting this error in my log files from mysql
>
> (Got timeout reading communication packets)
>
> I'm starting safemysql with the variables
>
> -O key_buffer=16M -O sort_buffer=1M -O back_log=200 &
Hi Vien,
Please increase the 'net_write_timeout' and 'ne
Hi Todd,
> Setting basedir=/var/lib/mysql produces the error message:
> /usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/var/' (Errcode: 2)
> with datadir not set to anything
errcode 2 = no such file or directory
> Setting datadir=/var/lib/mysql produces the error message:
Alex Menendez writes:
> Hello, All
Hi Alex,
> I built a spammer cgi some time ago that sends opt-in email to a list
> of recipients stored in a member account db. It has ran fine in the
> past. However, recently it is generating 2013 errors (Lost connection to
> Mysql server during query)
Daniel Ouellet writes:
> Hi,
Hi Daniel,
> I am looking into using optimization of the GCC 2.95.3 for I686 as
>
> -O3 -mpentiumpro
>
> to compile an optimize version of MySQL.
>
> But as I look around, I see that some user warned about using this as they
> said there is bug in GCC for
Hi David,
DAVID DECESARE writes:
> I have run into an intermittent problem since one of our MySQL databases
> grew over 5 GB. Basically, about once to twice a day the CPU will hit 100%
> utilization (and stay there) and MySQL will stop accepting queries (I
> couldn't even do a normal shutdown
To whom ever can help:
I have a database dumped from PostgreSQL to a text file , is there any
method used to convert this to MySQL?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
Hello,
A solution to my problem:
"For an athlete's first entry in the database I need a column
value of 1. The second performance entry of the same athlete
would have a value of 2. And so on."
has been posted by Paul Dubois:
ALTER TABLE tbl_name
ADD seqnum INT UNSIGNED NOT NULL AUT
I downloaded the latest version of MySQL and installed it on my Sparc
Ultra5. I used the pkgadd -d to install it. It said the install was
successful. When I run mysql_install_db, I get the following error message:
# ./mysql_install_db
Creating db table
Creating host table
Creating user table
Crea
In the MySQL documentation, it states that the binary log will be replacing
the update log, and it should be used in its place as it can do anything
the update log can. I'm not sure this is the case. The update log shows
where the individual connections connect from and what user connected. I d
Hello!
I really hope that You will carefully consider this
situation:
Being a customer of a hosting service - it"s addres is
http://www.valuehost.ru
-for only 4 monthes and also being a newcomer in the
internet,
I decided to create a MySQL-database-supported site about
the city I live in(St.Pe
Gerald Clark wrote:
> Perhaps mysql does not own the directory that contains the databases.
>
> > I just compiled from scratch, and successfully installed v3.23.42 on an
> > RH7.1 system. EVerything went fine, no errors anywhere, it started up
> > fine and I was able to set passwords fine.
At 2:05 PM -0400 10/4/01, Schmidt, Allen J. wrote:
>I had read that somewhere before so the number was not a surprise when I saw
>it. More it is a surprise why I cannot just simply add the field back in. I
You can. Or you could simply change its type to UNSIGNED and double the
range of available
At 4:08 PM -0400 10/4/01, Jason Frisvold wrote:
>Is there a way to have DBI return the value of the auto-incremented field
>upon insert? Or do I have to insert and then do a select afterwards?
$dbh->do ("your insert statement");
$auto_inc = $dbh->{mysql_insertid};
--
Paul DuBois, [EMAIL PROTEC
On 04-Oct-2001 Jason Frisvold wrote:
> Is there a way to have DBI return the value of the auto-incremented field
> upon insert? Or do I have to insert and then do a select afterwards?
>
$sth->insertid;
--
Don Read [EMAIL PROTECTED]
-- It's always darkes
I have participated on several groups before and this was the first time i
received a comment like this. I didnt wanna bother replying to it as i know
people r different and i am glad we have this delete button that i rely on
in such cases :)
Yes i was here for an advice and thank you Mr. Ravi fo
Is there a way to have DBI return the value of the auto-incremented field
upon insert? Or do I have to insert and then do a select afterwards?
Thanks,
---
Jason H. Frisvold
Senior ATM Engineer
Engineering Dept.
Penteledata
CCNA Certified - CSCO10151622
[EMAIL PROTECTED]
Hello, all...
Being new to the list, I'm admittedly doing a risky thing jumping into the
middle of a thread like this, but here goes...
Issues of tone and attitude aside, I know (from looking at examples, not
mucking with it myself- yet) that both mssql and mysql can be accessed
simultaneously u
Hello,
i am trying to install mysql on IRIX.
I am having problem running the mysql_install_db
script.
I went through the documentation about "Problems
running mysql_install_db"
It is asking to examine the generated log file
"IRIS.log". (/var/esp/ssdb/data/IRIS.log)
The message from the log f
Ravi Raman writes:
> Hi.
>
> I got the impression "Harpreet" was looking for some advice/experiences from
> someone who had ported a database in this way. He most likely was not
> looking for a snide, essentially one-word reply.
Well, I could've said that I've done similar things for 2 differe
Craig Newlander wrote:
> Hello,
> How can I execute query and have it's output (just data, no structure)
> saved to a CSV file?
> Thanks,
>From the command line? AFAIK mysql will only output tab separated results
so you have to do something like:
echo "SELECT 'a', 'b', 1" |mysql db |perl -n
[EMAIL PROTECTED] wrote:
> No everyone is probably just busy working on the new release and getting it
> installed. Give it a day and you'll see plenty of E-mail.
>
> And Welcome aboard!!
>
> M;)
>
> > Welcome Howard! This is my first day to the list. Seems rather
> > slow...wonder if its always
Well once again I have answered my own question.
You need to install an php update which is at
http://pkg.nl.cobalt.com/
-Original Message-
From: Jason Radley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 10:51 AM
To: Mysql@Lists. Mysql. Com
Subject: cobalt php-mysql
I am
No everyone is probably just busy working on the new release and getting it
installed. Give it a day and you'll see plenty of E-mail.
And Welcome aboard!!
M;)
> Welcome Howard! This is my first day to the list. Seems rather
> slow...wonder if its always like this.
>
> Allen
>
> -Original Me
Hi!
At my website I have advertised new features and fixes
which will be in 3.23.43. But Monty put .43 out so
unexpectedly quickly because of a bug in INSERT DELAYED,
that for InnoDB .43 is essentially the same as .42.
New InnoDB fixes and features will be in .44. I have
already written all exce
Rafal,
>Hi!
>Is it possible to change default table type from MyISAM to InnoDB, for example
>by putting
>set-variable = table_type=InnoDB
>line into my.cnf file?
Starting from 3.23.43 you can put
default-table-type=innodb
to my.cnf. Before .43 it was
default-table-type=innobase
>Thanks
>R
Welcome Howard! This is my first day to the list. Seems rather slow...wonder
if its always like this.
Allen
-Original Message-
From: howard gramer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 2:02 PM
To: [EMAIL PROTECTED]
Subject: test
testing to see if i am sub'd to the
I had read that somewhere before so the number was not a surprise when I saw
it. More it is a surprise why I cannot just simply add the field back in. I
have been using mysqlfront on windows to do this and it has not been a
problem in the past.
I will try importing into a new table first.
Thanks
testing to see if i am sub'd to the list. Haven't seen any traffic.
sql blah blah
howard gramer Home of Lady Liberty, AFT World Trade Center
Environment..: Telecommunications at the circuit level.
Email: [EMAIL PROTECTED]Flower: 124096153
MSN Messenger: howard [EMAIL
Hi!
MySQL 3.23.43 is now released.
This release was mainly done because of a hard bug in INSERT DELAYED
(Accidently introduced in 3.23.42) that could lock up mysqld during
'FLUSH TABLES' or in 'SHUTDOWN'.
If you are not using INSERT DELAYED then there is no big reason to
upgrade.
Changes in r
> Error: 1062 - Duplicate entry '2147483647' for key 1
That number is the largest number which can be stored in a signed 32-bit
(INT) field.
As I rather doubt that your table contains > 2 billion rows, I am betting
that your auto-numbers are starting at 1. My advice would be to create a
new table
> Error: 1062 - Duplicate entry '2147483647' for key 1
That number is the largest number which can be stored in a signed 32-bit
(INT) field.
As I rather doubt that your table contains > 2 billion rows, I am betting
that your auto-numbers are starting at 1. My advice would be to create a
new table
I am sure this has been discussed but have not found specifically what I
need.
I have a MyISAM table with an auto_increment primary key field. It sorta
went nuts and started inserting strange new values.
I decided to follow the stated procedures for resetting an auto_increment
field by deleting a
At 09:57 04/10/2001 +0800, Osman Omar wrote:
Hi!
>Hi,
>
>I have a table like this
>
>model color
>-
>135 blue
>135 red
>135 green
>235 black
>235 green
>
>
>How do I get how many row in each distinct model
>eg
>
>model 135 have 3 color
>model
Hi!
select count(*), model from tbl group by model;
On 04-Oct-2001 Osman Omar wrote:
> Hi,
>
> I have a table like this
>
> model color
> -
> 135 blue
> 135 red
> 135 green
> 235 black
> 235 green
>
>
> How do I get how many row in each
I am messing around with a cobalt server and installing mysql
to be the database for php. I have installed mysql but php
doesn't look like it was configured with mysql. I tried to do
a quick connection and got this message.
***
Error
MySQL said:
MySQL Connection Failed: Can't
Carl Troein:> Yes, but only if you don't include 8 kilobytes worth of
Carl Troein:> redundant irrelevance when you post.
Wow, pretty harsh there Carl -- there are some really good decaffeinated
brands available now. Although you are correct in pointing out that
continuing to carry the entire thr
Hi,
I have a table like this
model color
-
135 blue
135 red
135 green
235 black
235 green
How do I get how many row in each distinct model
eg
model 135 have 3 color
model 235 have 2 color
thanks.
--
Hello,
How can I execute query and have it's output (just data, no structure)
saved to a CSV file?
Thanks,
Craig
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Harpreet writes:
> Can we create a php page that will use mssql_connect to connect to ms sql
> server get the data and then use mysql_connect and connect to mysql server
> and populate the table.
>
> Is this possible.
Yes, but only if you don't include 8 kilobytes worth of
redundant irrelevanc
Can we create a php page that will use mssql_connect to connect to ms sql
server get the data and then use mysql_connect and connect to mysql server
and populate the table.
Is this possible.
Regards,
Harpreet Kaur
Software Developer
Crispin Corporations Inc.
-Original Message-
From: W
At 18:39 04/10/2001 +0300, Jari Aalto+mail.linux wrote:
Hi!
Only to clarify about the configuration files on Windows.
MySQL should use either the c:\my.cnf or \winnt\my.ini
file. In your case the best option is g:/winnt/my.ini.
Regards,
Miguel
>* Sun 2001-09-02 Dmitry Mityugov <[EMAIL PROTECTED
Slight error here if you want the auto icrement field to work properly
On Wed, 3 Oct 2001, Chris Johnson wrote:
> Date: Wed, 3 Oct 2001 20:07:49 -0500
> From: Chris Johnson <[EMAIL PROTECTED]>
> To: Russell Miller <[EMAIL PROTECTED]>, sjs <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED]
> Subject: R
* Sun 2001-09-02 Dmitry Mityugov <[EMAIL PROTECTED]> mail.default
| [+]
| > I'm using
>>
>> Ver 3.23.41-max-debug for Win95/Win98 on i32
>>
>> And command
>>
>> mysqld-nt --install
>>
>> Displays error dialog box
>>
>> "Failed to install service"
>>
>> In Event viewer the messages simp
[EMAIL PROTECTED] writes:
> Hi everybody !
>
> I have Red Hat 6.2 and kernel 2.2.14.
> I installed mysql server 3.23.42 from rpms.
>
> Shall i recompile my kernel to the newest version ??
> I heard, that kernel 2.2.14 have serious problem on hevy loaded system =
> using mysql 3.23.42 .
You sho
I always use
INSERT INTO table SET field1='value', field2='value', etc...
If I don't specify fields like an auto-incrementing number, it is filled in
automatically.
- Jonathan
-Original Message-
From: sjs [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 5:51 PM
To: [EMAIL
I checked and repaired my MYI files. Then did a check on the MYD files. I
keep getting a message: "table not having a correct index definition. You
need to recreate it before you can do a repair" This is running on NT2000
Server. Any ideas?
I ended up using PHP 4.0.4, latest MySQL and Apache from source to get PHP
to work on RH 7.0. I tried 4.0.2 - 4.0.6 and only the 4.0.4 worked.
The cool thing about source,not sure if RPM's do this, is that I can change
my config.status file and rerun using the ./config.status.
I can send my 123 st
"Ralf R. Kotowski" wrote:
>
> I did install all RPM's exept the benchmark. What is the name of the
> header files?
>
> On 3 Oct 2001, at 14:20, Carl Troein wrote:
>
> >
> > Ralf R. Kotowski writes:
> >
> > > I got Red Hat 6.2 and the Mysql 3.23.36-1 RPM packages installed,
> > > when I try to c
Excuse me for putting confirm reading flag ON.
On 04-Oct-2001 [EMAIL PROTECTED] wrote:
> Hi there!
> I have a varchar(255) row in a table, that contains some URL f.e.
--
Ruben Muradyan
System Administrator/Security Manager
PanARMENIAN Network
+-
Hi there!
I have a varchar(255) row in a table, that contains some URL f.e.
http://www.somehost.net/eng/headlines/cache/699.htm
I need to cut the first (http://www.somehost.net) part from this URL.
After looking at regexp realization in MySQL I've written
SELECT r_js REGEXP "^[http://./]"; as
Unless you ran it as
mysql_install_db --user=mysql
mysql does not own the databases.
do
chown -R mysql /usr/local/mysql
chown -R /var/lib/mysql
( Or whereever your database directory is )
jesse junsay wrote:
> Hi..
>
> I have a problem running my MySQL server. After
> running shell>mysql_instal
Hi,
I have MySQL currently running under Solaris7, and wish to set-up a
slave, also running Solaris7. At some point, though, the slave will be
upgraded to Solaris8. Will the MySQL binaries still work OK, or will I
need to install the Solaris8 binaries? Also, would it be possible to
have th
Is it possible to grant privileges to tables or databases if you have
installed mySQL as a stand alone server and if it is how do you do it.
--
For a few bucks, you can save hundreds! Right now, CollegeClub.com members
can
MySQL uses only one index for a select, so it can't use an index
when there is an OR in the where clause.
Ask Bjoern Hansen wrote:
> Hi,
>
> I have a table with about 1.5M rows.
>
> 9 of the colums are varchar(9)'s.
>
> when I just select on one of them it goes fine, like:
>
>
>> explain se
I define my textareas like this (perl cgi scritps):
$portdesc
Note the WRAP="SOFT" flag
I then simply insert the users information into the mysql table and when it
is called up in the HTML form, it retains its carriage returns.
You do need to ensure that quotes are handled correctly.
>Current
I have run into an intermittent problem since one of our MySQL databases
grew over 5 GB. Basically, about once to twice a day the CPU will hit 100%
utilization (and stay there) and MySQL will stop accepting queries (I
couldn't even do a normal shutdown of MySQL). The problem happened more
frequent
Benjamin Pflugmann writes:
>Hi. Does the error log of the master contain any error?
Nothing at all in the master logs.
>Does the new log position make sense?
Yes, the position is ok, and the slave gets the updates. Its just that
strange error messages about dropped connections and 0-byte pack
You need the mm.mysql driver, which can be downloaded from
http://sourceforge.net/projects/mmmysql/
Alec Cawley
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
sha writes:
> hello sir
What an odd way to address a crowd. :-o
> i have a problem that is when i installed mysql
in my system it's driver was not loaded in my system.
from where can i get this and how can i use it i m to
use it for jdbc and my operating system is windows 2
000 prof.
If w
hello sir,
i have a problem that is when i installed mysql in my system it's driver was not
loaded in my system. from where can i get this and how can i use it i m to use it for
jdbc and my operating system is windows 2000 prof.
thank u.
--
sha
Join 18 million Eudora users by signing
On Wed, Oct 03, 2001 at 05:39:09PM +, Mike Lucente wrote:
> I'm also unable to create files >2GB with mysqldump, even after a
> recompile with gcc 2.96, RH 7.1 w/2.4.2 kernel, glibc 2.2.2.
AFIAK, it is limitation of ext2 file sistem.
You can't create any file lager then 2GB on ext2.
[skip]
jesse junsay writes:
> Then this error occurs.
>
> "starting mysqld daemon with databases from XX
> mysql daemon ended"
>
> The manual didn't say anything on how to solve this
> problem. So I hope this will help.
That's not an error message. Error messages can be
found in the error lo
Haai,
I'm experiencing the following problem:
I have a dual 1 Ghz machine running RH 7.1 running mysql server version
3.23.39.
Everything is just based on default configurations as provided by the rpms.
This machine has 1 client (a java program running on another machine)
that does some serio
On Thursday 04 October 2001 06:48, Neil Silvester wrote:
> Currently I am using a standard field for information
> input to the MySQL database. When I display the allready information in the
> text fields to allow the user to manipulte the information, the formatting
> includes any carrige return
Hi..
I have a problem running my MySQL server. After
running shell>mysql_install_db when everything runs
fine then I tried to start the server with this
command shell>safe_mysqld &
Then this error occurs.
"starting mysqld daemon with databases from XX
mysql daemon ended"
The manual did
Hi!
Is it possible to change default table type from MyISAM to InnoDB, for example
by putting
set-variable = table_type=InnoDB
line into my.cnf file?
Thanks
Rafał
-
Before posting, please check:
http://www.mysql.com/manual.
Colin Faber writes:
> I fail to see why ENUM() isn't used in this case, This is exacly what
> its for.
Well, if you have an enum('0','1'), the numerical values stored
in the database will be 1 and 2, and so you would have to put
your values in quotes when you insert, or you'll end up with
'' an
Hi everybody !
I have Red Hat 6.2 and kernel 2.2.14.
I installed mysql server 3.23.42 from rpms.
Shall i recompile my kernel to the newest version ??
I heard, that kernel 2.2.14 have serious problem on hevy loaded system =
using mysql 3.23.42 .
Please, answer this questions.
regards
I. Piasec
WORK AT HOME USING YOUR COMPUTER!!!
_
Dear Friend,
You can earn $46,000 or more in next the 90 days sending e-mail.
Seem impossible? Read on for details (no, there is no "catch")...
___
Does MySQL Support Procedure.If yes, Whats a real syntax?
Manish Mehta
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
I have a Coldfusion website administration function sitting on a MySQL
database. I am using a SQL query (see below) to 'show tables'. I am then
using the results to dynamically build database modification pages (enabling
administrator to modify the database structure as well as modify content).
It
Hi,
I have a table with about 1.5M rows.
9 of the colums are varchar(9)'s.
when I just select on one of them it goes fine, like:
> explain select * from t1 where f2 = 'COM051000';
+---+--+---++-+---+--++
| table | type | possible_keys | k
Hi.
On Thu, Oct 04, 2001 at 09:01:05AM +, [EMAIL PROTECTED] wrote:
[...]
> > Actually, it's in the manual (but just recently ;), but it tells
> > otherwise: http://www.mysql.com/doc/C/o/Column_types.html
>
> Ah. One question about using CHAR(1) as BOOL, though:
> Will the value be stored as
1 - 100 of 107 matches
Mail list logo
