sql, query
Hi Folks
ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
Syoyu_db( Code, Kana) ON DELETE CASCADE ;
works fine.
But how to drop the constraint or modify the constraint ?
Simply changing ADD to DROP or MODIFY throws errors
regards
--
Dear Sir,
When Iam trying to connect remote mysql database Using
JSP on LINUX Os it is giving an error...
Remote system is Windows NT.
java.sql.SQLException: Communication link failure: Bad
handshake
I loaded
1).MySQL-3.23.40-1.i386.rpm
2).MySQL-client-3.23.40-1.i386.rpm
3).mm.mysql.jdbc-12b.t
Maybe I'm way out here, but this happens to me (or similar) quite often.
My solution; SELECT DISTINCT
And a single row will be returned for each.
Niclas
On Tuesday 08 October 2002 21:48, Michael Knauf/Niles wrote:
> Here's a query for ya:
>
> SELECT products.product_name, products.fg_numbe
021009 12:56:49 mysqld started
/usr/sbin/mysqld: ready for connections
021009 12:56:49 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'FIRST' at position 4
021009 12:56:49 Error reading packet from server: Binary log is not open
(read_errno 0,server_errno=2000)
Hello all,
I am using mySQL and PHP, how can I use PHP to display the length of time
used by a query?
Shaun
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Dear all,
I am not sure why mysql thinks char(192) = char(194) = char(193) =
char(195)?
mysql> select char(192)=char(193);
+-+
| char(192)=char(193) |
+-+
| 1 |
+-+
1 row in set (0.00 sec)
mysql> select char(192)=char(
Pushpinder,
Looks like a file permission problem. Which user do
you have that runs the MySQL daemon (server)? Does
this user have the ability to write to the directory
you've specified as the data directory for MySQL?
Kelly
--- Pushpinder Garcha <[EMAIL PROTECTED]>
wrote:
> Hi
> I have set up
Toby,
If I understand correctly you want to perform two distinct actions:
1. Convert Microsoft Office Word .doc files into .pdf
2. Store those pdf's in MySQL.
You should look into (via google.com) some doc to pdf converters. An example
is this com object: http://www.convertzone.com/doc2pdfcom/help
I know it's not very important in normal day to day operations, but does
anyone know what each thread does within mysqld with Innobase installed?
It'd be nice to know what Innobase is doing when a process is pinned at 100%
of the cpu..if it's doing cleanup from a huge update, etc.
1655 ttyp1
keep looking for the books and help, but there's
another resource for you while you're learning, and
it's free.
if you have a windows machine that you can use as a
front end to your mysql server (or any other
database), go to http://corereader.com/ .
after you connect to your database, core
toby,
to store image in mysql database, i usually use blob/mediumblob/longblob
data type.
what do u mean for images in text?
Ivan Paul
Web Developer
Mediate - Media Communications
http://www.bhaktimedia.com
- Original Message -
From: toby gibbson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTE
toby,
to store image in mysql database, i usually use blob/mediumblob/longblob
data type.
what do u mean for images in text?
Ivan Paul
Web Developer
Mediate - Media Communications
http://www.bhaktimedia.com
- Original Message -
From: toby gibbson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED
At 11:17 -0500 10/06/2002, I whispered:
> > -Original Message-
>> From: Robert H.R. Restad [mailto:[EMAIL PROTECTED]]
>> Sent: Sunday, October 06, 2002 9:04 AM
>> To: James Riordon; [EMAIL PROTECTED]
>> Subject: RES: Re: Server comparison running Mysql
>>
>> Another thing... I notic
> -Original Message-
> From: Nestor [mailto:[EMAIL PROTECTED]]
> Sent: 08 October 2002 16:01
> To: [EMAIL PROTECTED]
> Subject: Reposting: Connecting a web server to a db server
>
>
> Any ideas?
>
Have you reloaded the mysql server?
Try this at the shell...
mysqladmin -u root -p reload
On Sat, Oct 05, 2002 at 03:47:18PM +0300, Heikki Tuuri wrote:
> Shane,
>
> > 021004 12:57:00 Slave: error 'Incorrect key file for table:
> 'listing_text'. Try to repair it' on query 'UPDATE sell.listing_text SET
> description='blah' WHERE listing_id=221112', error_code=1034
> >
> > So, I issued
>Description:
See "How-To-Repeat"
>How-To-Repeat:
I uploaded a copy of the tables to support.mysql.com/pub/mysql/secret.
Each of the tables below contains many rows (from 50-100k per table).
We were unable to duplicate with a smaller result set,
CREATE TABLE listing (
id int(10) unsigned NOT
On Tuesday 08 October 2002 22:29, Arul wrote:
> Hi All
>
> I had created a DataSource in Tomcat Admin Console.
> But i am not getting a connection
>
> ds.getConnection()
>
> results in error.
> The error is java.sql.SQLException : cannot load JDBC Driver class null
>
> But while creating the datas
I have had problems with PHP and MySQL and have made some changes. First
off, in http://bugs.php.net/bug.php?id=19529 MySQL is complaining about
things not being cleaned up. This is because any query that returns
results (which one's don't -- any?) must get them.
In case of an unbuffered query, w
Hi
Are out there tools to extract stats of different query types per
table/database basis? Like if I want to know which one is the most
accessed table and stuff like that. Having log-bin enabled.
Thanks
Mihai RUSU
Disclaimer: Any views or opinions presented within
At 15:53 +0100 10/06/2002, Andrew Braithwaite was thought to have said :
>Hi James,
>
>What kind of disks are in the old system and the new system (scsi or ide,
>any raid, what rpm do they have etc..?) I ask this because high cpu levels
>can be a symptom of a diskbound server...
>
>Try running
At 10:42 -0500 10/07/2002, gerald_clark was thought to have said :
>You don't give operating system versions for the two machines.
Right you are:
Server A
Redhat 7.1
PHP 4.2.1
MySQL-Max 3.23.49a
2.4 (2.4.9-12)
Server B
Redhat 7.2
PHP 4.2.2
MySQL-Max 3.23.52 (Just upgraded again)
2.4 (2.4.9-3
At 11:12 -0300 10/06/2002, I whispered:
>Maybe P4 1,7 mhz performs marginally better than a P3/1000Mhz, but ...
>
>My webserver have a P3/450Mhz with 384 MB Ram and a 10 Gb IDE drive :P I
>cant seem to get above 1.0 load average on the machine on normal use (I have
>average 10-30 people online si
I think if you decide to store in the blob,
whatever it is, a pdf or jpeg or bmp, it is going to be in binary format.
While you need to display it back, just convert them back to whatever format
you like.
Else there is always the choice of just storing the path in your database.
By the way, which
Hi!
./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc)
Server version: Apache/1.3.26 (Darwin)
PHP Version 4.0.4pl1
PHP mysql support
Client API version 3.23.22-beta **
** is this a problem with mySQL 3.23.61 running?
When running this query through Apache/PHP on MacOSX 1
Hi,
I want to put the master behind a dynamic IP and use one of those dynDNS services.
If the master is unavailable will the slave always resolve the domain name when
trying to reconnect or only once at startup?
Regards,
Kai
PS: SQL, QUERY (<- that's for the filter, sorry)
---
I tried this and got a different result:
[root@daevid root]# telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
?Host 'daevid' is not allowed to connect to this MySQL serverConnection
closed by foreign host.
[root@daevid root]# telnet localhost
howdy.
we use the binary log as a crash recovery tool.
therefore, once we have backed up the db (we use the excellent mysql_backup for this)
we can happily discard yesterday's binlog.
the only correct way i've found to get rid of old binlogs in to issue RESET MASTER,
and i figure i should do t
What happens when the user reaches their quota limitation from MySQL
doing an insert? IIRC, the filesystem won't allow the write and could
potentially cause problems with the database.
You may choose to put them on another un-quota-ed filesystem and write a
quick perl script to check the size of
Sorry or posting this again, but I have try everything
I could think and I am getting no where.
I have a webserver(10.1.1.3) running Linux RH7.3 with
PHP4.2.3 and a DBserver(10.1.1.2) running W2K and MySQL 3.23.52
The user mbn has select and insert permissions:
grant select, insert on database
I think i have a damaged table in one of my databases.
I can do a SELECT count(*) from table
on every table in the db with no problem, except for 1
of them, the query just sits for a while.
So i assume this table is damaged. does anyone have any suggestions as to
what i can do about this?
tests
Not really getting errors but getting warnings when inserting records
and having duplicate values since the primary key is the one that is
auto incremented...
Keith C. Ivey wrote:
> On 8 Oct 2002, at 12:23, Bill Hess wrote:
>
>
>>What is the maximum value of an AUTO_INCREMENT field? I am cur
William Martell wrote:
>I do not know how to do this?? Can anyone point me in the right
>direction???
>
>
Look up the LIMIT option in MySQL.
if (! $StartAt) {
$StartAt = 0;
}
... SELECT LIMIT $StartAt, $PerPage;
$StartAt += $PerPage;
... then either session_register your startat var
Did you try unsigned int?
Bill Hess wrote:
> Hello all...
>
> What is the maximum value of an AUTO_INCREMENT field? I am currently
> running into a maximum value of 296,995,724 on Solaris 8 using MySQL
> 3.23.42 - the field has been defined as an INT(11), which should be
> able to handle a v
mysqldump
Todd Williamsen wrote:
>i would like to know how to write batch script for dumping schema and
>data into a sql file. This script should dump the whole database and
>data
>
>
>-
>Before posting, please check:
> http:
Jungshu,
- Original Message -
From: ""Heo, Jungsu"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, October 07, 2002 5:49 AM
Subject: InnoDB Performance Question.
> Hello everyone.
>
> I'm working on migrating Oracle to MySQL 4.0.3
>
> MySQL works on Redhat 7.3 and
On 8 Oct 2002, at 12:23, Bill Hess wrote:
> What is the maximum value of an AUTO_INCREMENT field? I am currently
> running into a maximum value of 296,995,724 on Solaris 8 using MySQL
> 3.23.42 - the field has been defined as an INT(11), which should be able
> to handle a value bigger than wh
Hello,
I am trying to find a way to store the body of a binary NNTP message into
MySQL. However, due to the way lines are encoded, MySQL will not accept the
SQL statement. Does anyone have any ideas on how I should approch this?
Thanks,
Dan Cumpian
-
I have am having problems getting the MySQL server to start running, please help me,
here are my problems, I have also displayed my error logs below, at least I hope they
are the error logs;
I have been trying to install the
mysql-3.23.52-pc-linux-gnu-i686.tar.gz
Everything seems to be goi
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> On Tue, Oct 08, 2002 at 12:13:28PM -0400, Kevan
> Louou wrote:
> >
> > what is the index max size for mysql 4.0?
>
> What's the largest file your operating system will
> let you create?
>
Is your answer related to the index size meaning that
it
Todd,
> i would like to know how to write batch script for dumping schema and
> data into a sql file. This script should dump the whole database and
> data
Write this in a batch file:
mysqldump [options] dbname >somename.sql
where is the name of the db. See the manual for mysqldump optio
The only time you will gain a speed advantage is if you have no variable
>>length fields in your record (varchar, text, etc.). You may notice that
>>all your CHAR fields are changed to VARCHAR as soon as a variable length
>>field type is added. CHAR is less efficient from a space storage point
If you want to stay with 3.23 then download the max version. Install
the max version. Look at one of the .cnf files in the main mysql
directory. Uncomment the lines having to do with innodb. Change the
innodb_data_home_dir variable to be the path you want d:\mysql for
instance. When you are d
On Tue, Oct 08, 2002 at 12:13:28PM -0400, Kevan Louou wrote:
>
> what is the index max size for mysql 4.0?
What's the largest file your operating system will let you create?
> is it possible to do replication with a master on linux and a slave
> on windows?
Yes.
> if yes, how can I make the sl
> Dear Sir, Madam,
>
> I was trying to make a comparison on you website between the mysql
> server, acces 2000, microsoft sql server and interbase. Crash-me
> however does not return any information, it does not work. Is it
> possible that you can provide me with this information? I hope to hea
> i would like to know how to write batch script for dumping schema and
> data into a sql file. This script should dump the whole database and
> data
Here is what I use which is pretty straightforward unless I am missing
something.
d:\mysql\bin\mysqldump -u root --password=password --opt -A >
d
Is it then correct that VARCHAR(255) and TINYTEXT are strictly
equivalent?
If no, where is the difference?
Thanks,
Christophe
NOTE: I understand now the "sql,query" stuff. Strange idea.
--
Christophe Barbé <[EMAIL PROTECTED]>
GnuPG FingerPrint: E0F6 FADF 2A5C F072 6AF8 F67A 8F45 2F1E D72C B
Apologies to the list. Apparently the question I asked regarding binary
data dumps is an issue involving a MySQL startup parameter: log-bin.
Apparently this is the redo-log facility of MySQL for all successful
updates. This can be turned on or off. Question answered.
Thanks,
Rob
Robert Fox
S
That was it! Thank you all for your help.
Steve.
-Original Message-
From: Iikka Meriläinen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 2:21 PM
To: Steve Bradwell
Cc: [EMAIL PROTECTED]; Oluwagbamila Oyekanmi; Bruce Lewis
Subject: RE: startup on win2000 as service not workin
Hi,
First run 'mysqld-nt --remove'
then
'mysqld-max-nt --install'
This removes the old installation of the service and then inserts a new
InnoDB-enabled registration.
Iikka
On Tue, 8 Oct 2002, Steve Bradwell wrote:
> Hi,
>
> I checked the path, it is correct. I also tried from
> c:\mysql\bin\
Hi,
I checked the path, it is correct. I also tried from
c:\mysql\bin\mysqld-max-nt --install
and got the following,
The service already exists!
The current server installed: C:/mysql/bin/mysqld-nt.exe
So what I can tell is I am not running mysqld-max-nt like I thought I was,
but my.ini has all
Hi
I have set up the MySQL database to run locally on my Mac. I have set
the privilege for the root user. However, when I log in as the root user
I am still unable to create a new database
mysql> CREATE DATABASE master;
ERROR 1006: Can't create database 'master'. (errno: 13)
Please tell why
I had the same thing happen to me. Go in to services and right-click on
the mysql service. Go to properties and verify that the service is
assigned to the right executable. Mine was not so I had to start MySQL
manually every time I restarted.
(MySQL, query)
>>> Steve Bradwell <[EMAIL PROTECTE
what is the index max size for mysql 4.0?
is it possible to do replication with a master on
linux and a slave on windows? if yes, how can I make
the slave work on linux if the master crashes?
thanks in advance
__
Post your fr
Thanks for your response.
I tried to connect to the server via telnet as you suggested with the
following result.
telnet my.machine.ip 3306
Trying my.machine.ip...
Connected to my.machine.ip.
Escape character is '^]'.
Connection closed by foreign host.
Is this the behaivior
I had the same problem happen to me. Go in to services and right-click
on the mysql service and check the properties. Check that the service
is assigned to the right executable. Mine was not so I had to start it
manually every time I restarted.
>>> Steve Bradwell <[EMAIL PROTECTED]> 10/08/02
On Tue, 8 Oct 2002, Jesse Sheidlower wrote:
> I'm sure this is a common requirement, but the only thing I could
> find in the docs or in a book or two was an unanswered version of
> the same question at http://www.mysql.com/doc/en/CREATE_DATABASE.html .
>
> I'm setting up MySQL on a small ISP and
I've been using MySQL now for around a month. I also administer the system
where our MySQL implementation is installed. Each night, we perform a full
file system backup around 11:50PM. I just noticed that our MySQL root data
directory is filling up with binary data files named so:
`hostname`-b
I am currently try to set up mysql on my computer and I'm running into a
few bugs. I'm using the book "PHP fast & easy web development". I've
run into a problem when I type the command mysqld --standalone into the
prompt. I get the following error:
Can't initialize InnoDB as 'innodb_data_file_p
> Hello everyone,
> Can someone please tell me how I can do the following:
> >From the query below, I want to get the details of the header of the message
> and display them on a page, one per line.
> If I just query the Header field, it displays them in one long line.
> What can I do to display t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
we've started doing some work of porting MySQL 4.0 to the QNX operating
system. The patches are already part of the source tree and MySQL currently
compiles and runs, but we have not done any thorough testing yet. One of
the known bugs is that my
I think I'm sure, wont I get better performance from one query than two?
Michael
"Michael T.
Thanks Heikki,
My testcase is not valid. After I get the connection, I didn't set auto commit to
false on the connection object, so I was unable to see the committed data. I saw the
REPEATABLE READ behavior now, but it's unfortunate to know READ COMMITTED is not
supported yet...
--Jianliang
Hello,
I'm fairly new to mySQL and the list, so this might have been discussed in the past,
but i couldn't find anything that helped.
I'm trying to search for a part of an email adress, either name or domainname or
either part of it. If I use match... against, it only lets me search for the par
I have downloades the last version of your software, but when I try to
connecto to the mysql server remotly, the server crash, and safe_mysqld
restar it. Your software reports "lost connection to MySQL dureing query"
And the safe_mysqld reports dureing the crash:
bash-2.05# /usr/local/mysql/bin/s
>Description:
Compilation fails with subject configuration due to missing typecasts
in sql/mini_client.cc and sql/mysqld.cc
>How-To-Repeat:
./configure --prefix=/usr/local/mysql --with-innodb
make
>Fix:
apply supplied patch which simply provides neccessary
I have Mysql set up on the same machine as the apache server. There is a
database name inventory_db with a table product_info which have the two row
id and name. I know there are three records in the table. However when ever
I place this script below into a webpage I get just a blank page. What c
Jianliang,
I tested that with two mysql clients, and it appeared to work ok. Check with
SHOW CREATE TABLE tablename
what is the type of your table. Is it MyISAM?
Also put the line
log
to the [mysqld] section of your my.cnf and restart mysqld. Then you will see
all received queries in the fil
I have a database with a table called targetTsObj, and I want to perform
many queries from it, such as this one:
select run,rerun,camcol,field,id,ra,decl,r from targetTsObj where ra
between 255.84730673785904 and 256.31969326214096 and decl between
58.7494108 and 58.9577892
On
On Mon, 2002-10-07 at 22:02, Jeremy Tinley wrote:
> The problem isn't so much with the failover. It's with data integrity.
> Binlogs control replication. You can place a failover master in between
> the master and slaves. In the event of a master failure, you eliminate
> the loss of writes by d
Hello Philipp,
Monday, October 7, 2002, 7:02:18 PM, you wrote:
PS> Can't create a new thread (errno 11). If you are not out of available
PS> memory, you
PS> can consult the manual for a possible OS-dependent bug
errno 11 may also mean that ulimits are exhausted.
PS> debian 3.0
PS> kernel 2.4.
Hello All.
I hope you are all having a great day. ;)
I am trying to query MySQL using PHP and I would like the results to display
on multiple pages.
I would like to display only 20 results per page and allow the user access
to the other pages by clicking next or an index of numbers 1 2 3 4 5 6
Thanks for all your help. Then it's more confusing to me. I opened two MySql windows
and set autocommit=0 and then update one column and then issue the command COMMIT in
one window, in the other MySql window, I queried the column and saw the change
immediately.
I also did the same thing with o
It seems that you have two entries in the products table for the same
fg_number, one with the values:
'SPKR,CM8HD', 'FG00914', '8",HIGH DEFINITION,CEILING MNT LOUDSPEAKER'
And a second one with the same fg_number but in this case with a
lowercase F.
'', 'fg00914', ''
Is this rigth?
Please, if y
Hello all...
What is the maximum value of an AUTO_INCREMENT field? I am currently
running into a maximum value of 296,995,724 on Solaris 8 using MySQL
3.23.42 - the field has been defined as an INT(11), which should be able
to handle a value bigger than what I am seeing - The DuBois MySQL boo
thnx rich
but u see the problem iz my clients want their text IN pdf format to be
displayed with all these colors on the page in other words they want
their sites layout to be maintained on the pages showing this pdf text
as they are pretty concerned bout security
so what do i do now
Thanks, your comments are very helpful, especially the info that if I
have already a not-fixed field in a table the performance cost of adding
a VARCHAR (instead of a CHAR) is 0.
NOTE for the Mailing-list Admins: There is a 1 hour (at least) between
the post and the availability of the mail in th
what is the index max size for mysql 4.0?
is it possible to do replication with a master on
linux and a slave on windows? if yes, how can I make
the slave work on linux if the master crashes?
thanks in advance
__
Post your fre
Check your ini file to make sure the path reflects the proper location of
the database.
Bruce
- Original Message -
From: "Steve Bradwell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 08, 2002 8:14 AM
Subject: startup on win2000 as service not working.
> Hi everyon
i would like to know how to write batch script for dumping schema and
data into a sql file. This script should dump the whole database and
data
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Michael Knauf/Niles wrote:
>What I _really_ want is the combination of your two querys, that is,
>product_name, product_description, from the product table + all the specs
>related to the product from the specs table , based on the fg00914 number.
>
Are you sure? :-)
As I pointed out, if the fir
VARCHAR basically sets a maximum length for the field and only stores
the data that is entered into it, thus saving on space. The CHAR type
has a fixed length, so if you set CHAR(100), 100 character worth of
space will be used regardless of what the contents are.
The only time you will gain a s
You need to Install MySQL as a service.
Use the following steps on the DOS command prompt:
1. cd \your-path-to-mysql\bin
2. >mysqld-max-nt --install
You could then start the service from Services in Control panel or use "NET
START mysql" on the command line.
Regards
'Gbamila
- Original
What I _really_ want is the combination of your two querys, that is,
product_name, product_description, from the product table + all the specs
related to the product from the specs table , based on the fg00914 number.
I should get 7 rows in this example
I'm using this query in a php web page th
Please cc me as I'm not on this list. Thanks.
root[csh]@amber1[15]# mysql --version
mysql Ver 11.18 Distrib 3.23.52, for sun-solaris2.9 (sparc)
root[csh]@amber1[16]# /usr/local/mysql/libexec/mysqld --version
/usr/local/mysql/libexec/mysqld Ver 3.23.52 for sun-solaris2.9 on sparc
Scripts are w
Christophe Barbe wrote:
>I am looking about experienced pros and cons on the use of VARCHAR. My
>understanding is that, except if you know that each time the text will
>have the same length, VARCHAR is better. This seems a bit too perfect to
>be true.
>
You do not have to use all the chars ... if
Christophe Barbe wrote:
>Le mar 08/10/2002 à 11:35, Michael T. Babcock a écrit :
>
>
>>Before I forget: SQL, QUERY ... going write a filter for these some day ...
>>
>>
>
>I don't get what you mean by "SQL, QUERY ...".
>I know how to write a SQL QUERY.
>
>
I was making sure I'd get past t
Le mar 08/10/2002 à 11:35, Michael T. Babcock a écrit :
> Before I forget: SQL, QUERY ... going write a filter for these some day ...
I don't get what you mean by "SQL, QUERY ...".
I know how to write a SQL QUERY.
I am looking about experienced pros and cons on the use of VARCHAR. My
understandi
Dear Sir, Madam,
I was trying to make a comparison on you website between the mysql server,
acces 2000, microsoft sql server and interbase. Crash-me however does not
return any information, it does not work. Is it possible that you can provide
me with this information? I hope to hear from you.
Michael Knauf/Niles wrote:
>I get 7 rows of data I don't want, then the 7 rows of data I do want... and
>after scratching my head for awhile, I've come to the conclusion that I do
>not understand the query structure. (the query came from multiple
>suggestions in response to my last posting on thi
hi,
2 ways to do this:
a) don't store the file actually in the db but store the path to it.
b)use the function LOAD_FILE(filename) to get the contents of a file as
a string value and store as a blob.
decide which to use depending on how many pics you have
cheers
Rich
toby gibbson wrote:
>
Before I forget: SQL, QUERY ... going write a filter for these some day ...
christophe barbe wrote:
>What are the disadvantages of using VARCHAR instead of CHAR.
>Is it going to be considerably slower?
>
>
It really depends on your table, but if you find it slower, break down
into multiple t
I'm sure this is a common requirement, but the only thing I could
find in the docs or in a book or two was an unanswered version of
the same question at http://www.mysql.com/doc/en/CREATE_DATABASE.html .
I'm setting up MySQL on a small ISP and would like to be able to
restrict the size of indiv
Ross,
Monday, October 07, 2002, 8:14:09 PM, you wrote:
RR> We am having a problem with the encode() and decode() functions. When
RR> the second argument to the functions is a quoted string, the functions
RR> return values as expected. When the second argument to the functions is
RR> another fun
Last time I saw this error, it was due to an authentication issue. Try
adding the user you have for the JSP pages or the user who is used for
Apache to your domain controller or to the administrative user list
under the NT users dialog. If you add this to the domain controller
make sure Password
Jon,
> So how do I optimize memory usage? Where to start ?
If your server is compiled with debug=full, the command
mysqladmin proc stat
shows you total server memory use. Look in the manual at
How MySQL uses Memory
SHOW VARIABLES (for all vars that control server memory use)
Pe
Hi!
I corrently working with a project to build a web based calendar with alarm
(reminder for each event).
table 'calendarEvents'
start datetime NOT NULL default '-00-00 00:00:00'
remindTime tinytext NOT NULL
The column 'remindTime' specify the time before an event the alarm will go
off.
F
robert_goetz,
Monday, October 07, 2002, 4:51:02 PM, you wrote:
raWSdd> i am a trainee at westlb-systems in duesseldorf, germany and it's my task
raWSdd> to evaluate different dbms' like Postgre SQL, MySQL, MS Access ´97 ;), SAP
raWSdd> DB and Oracle
raWSdd> well i searched the web and various doc
01) at the setup, how do i do to install the software at
drive c: and the database files at drive d:?
02) How do i install INNODb at Windows 2000 server with MySql
3.23?
Thanks
Jacob - Brazil
---
UOL Eleições 2002 - Todos os lances da disputa política
http://eleicoes.uol.com.br/
---
Hi All
I had created a DataSource in Tomcat Admin Console.
But i am not getting a connection
ds.getConnection()
results in error.
The error is java.sql.SQLException : cannot load JDBC Driver class null
But while creating the datasource i had given the driverclassname as
org.gjt.mm.mysql.Driver
On Tue, 8 Oct 2002, Steve Bradwell wrote:
> Hi everyone,
>
> I have recently moved my mysql server from a win98 machine to a win2000
> machine. After running the self extracting setup for mysql, I copied my
> existing my.ini file over from the win 98 box, made neccesary changes to
> start mysqld-
1 - 100 of 135 matches
Mail list logo
