I'm having difficulties with version 3.23.32 in production..
after giving up on my own compiled version, which I compiled in the same
way, on the same box, with the same flags as 3.22.32, I was getting
occasional core dump/restarts.. so I reverted to the mysql.com binary
from mysql.com
Now, a lar
Hi,
> "gopinath" == gopinath <[EMAIL PROTECTED]> writes:
gopinath> Hi, Is there any optimization tool for MySQL database , so
gopinath> that it can be fast?
gopinath> Please let us know as we are uploading our site using MySQL.
gopinath> Regards
gopinath> Gopinath Transitional//EN">c
Look up UNIQUE in TFM.
- Original Message -
From: "Chris Aitken" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 14:05
Subject: Making a table have no Duplicates
> Hi Everyone.
>
> Just a quick question I worked out once before on my lonseome and the
mysql
>
On Mon, 19 Feb 2001, Chris Aitken wrote:
> Hi Everyone.
>
> Just a quick question I worked out once before on my lonseome and the mysql
> manual, but it was longer ago than yesterday and it a blur how I did it.
>
> What I need to do is. I have a table, and in that table there are
> severa
- Original Message -
From: "j.urban" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 14:42
Subject: Re: dropping columns
> > But you could always look up the mysql documentation for your answer.
> > It should be identical if not, almost.
>
> Not even close.
I am using MySql 3.22.32 and PHP 4 on Windows 98 second
edition.
I have 904 records on my table, but when I use SELECT command
only 885 records listed.
When I am using PHPADMIN, record listed 855 only from total 904
records (904 total, 885 in query)
Can anybody help me to fix this problem?
Re
> But you could always look up the mysql documentation for your answer.
> It should be identical if not, almost.
Not even close. MSSQL 6.5 does not support dropping columns using ALTER
TABLE. There are many differences between MySQL and MSSQL and even though
it might work from time to time, re
Hi Everyone.
Just a quick question I worked out once before on my lonseome and the mysql
manual, but it was longer ago than yesterday and it a blur how I did it.
What I need to do is. I have a table, and in that table there are
several fields which need to be unique. What do I need to do t
Hello.
On Sun, Feb 18, 2001 at 07:43:25PM -0600, [EMAIL PROTECTED] wrote:
[...]
> When I execute the following query:
>
> select acts.resolution, title from acts, acts_text
> where acts.resolution=acts_text.resolution and
> words like "% china %" or words like "% japan %";
>
> I g
On Tue, Feb 20, 2001 at 09:33:40AM +0800, yindu wrote:
> thank you.
> i know mysql stored its tables in files,And i have looked through the mysql
>handbook.But i hadn't found information about the file systerm of mysql,i think a
>table
> is a file,then all tables in the same database should be
Could you provide us with the error messages you are getting?!?!
- Original Message -
From: "Michael Lépine" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 11:57
Subject: Executing multiple SQL commands.
> I'm trying to execute multiple create
No offense but if you didn't want to hear that type of "discussion" and you
knew sub-selects weren't supported, you would get a "more correct" response
if you started with "I know sub selects aren't supported but how can I
change this SQL statement to have the same effect in MySQL" or words to tha
>Description:
Updates > 4 MBytes cause the binary replication to stall.
>How-To-Repeat:
Try to replicate an UPDATE command with >4MB of data
>Fix:
log_event.h, line 45: delete MAX_EVENT_LEN
log_event.cc, line 88: replace MAX_EVENT_LEN with max_allowed_packet
>Submi
Hi,
Is there any optimization tool for MySQL database , so that it can be fast?
Please let us know as we are uploading our site using MySQL.
Regards
Gopinath
I have no problem compiling sample program
(I compiled it in this way:
gcc -lsqlplus -I/usr/include/mysql -L/usr/local/lib/ -o sample
sample.cc)
But when I execute the binary, I got this error message:
[root@sas /root]# ./sample
./sample: error while loading shared libraries: libsqlplus.so.1: ca
On 2001-02-18, Jon Roig did say,
> It's actually pretty simple.
>
> Here's an excellent tutorial on how to do it with PHP.
>
> http://www.oreillynet.com/pub/a/php/2000/09/15/php_mysql.html
>
> > From: Nikhilesh Haval <[EMAIL PROTECTED]>
> >
> > I want to store different file formats in a data
I'm trying to execute multiple create table commands and am getting SQL
errors. I'm using the MySqlManager.exe that comes with the Win32 version of
MySQL and the syntax is similar to the following:
/*==*/
/* Database name: physical data
Hello,
Personally, I am sick and tired of discussions like that.
On Sun, Feb 18, 2001 at 09:36:47AM -0800, Fredrick Bartlett wrote:
> I will kindly answer...
Thank you Fredrick! But your answer is not the answer Lieven wanted and me too, by the
way.
> Subselects are not supported in current re
As far as I'm aware, mysql doesn't support. What languages are you trying
to store English and simplified or traditional (Chinese that is) as well?
If it is just English & simplified then you have no problems, just use the
simplified character set in your applications (ie. web pages or whatever)
It's actually pretty simple.
Here's an excellent tutorial on how to do it with PHP.
http://www.oreillynet.com/pub/a/php/2000/09/15/php_mysql.html
Enjoy -- it's pretty cool what you can do with it.
-- jon
> From: Nikhilesh Haval <[EMAIL PROTECTED]>
> Organization: University of Sheffield
Title: ÍÎÓÒÁÓÊÈ, ÌÓËÜÒÈÌÅÄÈÀ-ÏÐÎÅÊÒÎÐÛ, ÂÈÄÅÎÊÀÌÅÐÛ, CISCO
Óâàæàåìûå ãîñïîäà,
Ïðåäëàãàåì ñî ñêëàäà â Ìîñêâå ïî íèçêèì öåíàì:
Íîóòáóêè Toshiba, Sony, Fujitsu-Siemens, Compaq, IBM, Mitac, Asus
Ìóëüòèìåäà-ïðîåêòîðû Panasonic, Sony, Nec, Sanyo, Proxima, Mitsubishi
Ïëàçìåííûå ï
Hi,
Before everyone shouts at you:
What platform, compiler and MySQL version
Quentin
-Original Message-
From: Fr3dY [mailto:[EMAIL PROTECTED]]
Sent: Monday, 19 February 2001 15:08
To: [EMAIL PROTECTED]
Subject: F_TO_EOF
Hi! I'm trying to compile MySQL but some files (like open.c) con
Download the binary distribution for Windows at
http://www.mysql.com/downloads/mysql-3.23.html and then read the mysql
manual, try installing it (it's not that difficult) and if you have any
questions/problems, ask the list.
- Original Message -
From: "Kerry" <[EMAIL PROTECTED]>
To: <[EMA
I want to create a text field who support Unicode. Is there any link, example to do it.
Sebastien
- Original Message -
From: "Jan Namedyński" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 10:02
Subject: Re: deleting old records VS. index on datetime field (question
about optimization)
> Rolf Hopkins wrote:
Blob field may do the trick but wouldn't it easier to store it on the drive?
- Original Message -
From: "I.SivaramaKrishnan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 17:05
Subject: storing files in database
> Hi all,
>
> Basically I have a requirement
To add, whatever program your are using, ie. php, perl, etc. may have a
function to add slashes for you.
- Original Message -
From: "Artem Koutchine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Robert Heron" <[EMAIL PROTECTED]>
Sent: Sunday, February 18, 2001 0:18
Subject: Re: special
Mind you, having spaces in your table names is not a good idea. Mainly due
to portability between systems. You'll save yourself a lot of agro if you
use underscore instead.
- Original Message -
From: "Yoav Bornstein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 18
Hi! I'm trying to compile MySQL but some files (like open.c) contain a parameter
(F_TO_EOF), not
present in my fcntl.h or any other header file.Could I substitute it for something
else? Thanks
-
Before posting, please check:
Rolf Hopkins wrote:
>
> That all depends.
>
> Do you need to keep the data for historical purposes?
I don't have to but I want ;-). it means that if speed difference would
be small I will.
Are your queries
> running particularly slowly? Have you read the manual about how you can
> optimize
What's your code? How are you trying to connect?
- Original Message -
From: "manikandan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 15:02
Subject: Hi help needed!
>
> Hi All!
>
> I am not able to connect to remote Mysql running on a Linux meachine
You are using MyODBC, right? I'll post you off list with example
connections from VB.
- Original Message -
From: "Ing. Max Alvarado B." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 18, 2001 2:37
Subject: Help.
> Hello, I've been trying to make and ODBC connection
Had the same problem. If you have a look at your database, through the
mysql prompt, you will see things like –. This is due to a language
problem with HTML. What language did you design your web page in? or is it
meant for multi-languages? But your's looks like plain English to me. In
any ca
I have a cgi-bin script which generates SQL expressions based on some user
input. I noticed yesterday that for certain input, the script would
return wildly incorrect results from the database. The problem was fixed
by adding parentheses around part of the Boolean expression in the WHERE
clause
On Sun, Feb 18, 2001 at 08:24:47PM -0500, J Colleary wrote:
> Does MYSQL support the CREATE PROCEDURES command, or have stored
> procedures? If so, how do I access them?
Nope.
This is documented in the manual.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
D
This is a MySQL list not an MSSQL list. But you could always look up the
mysql documentation for your answer. It should be identical if not, almost.
Even better, switch to mysql and people here would love to help you.
- Original Message -
From: "Wernher Korff" <[EMAIL PROTECTED]>
To: <[
You can look up DATE_SUB in the manual for starters and combine them with
other functions in the same section, to get what you want.
- Original Message -
From: "Laercio Brehmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 4:06
Subject: Difference of two d
Is there a Windows version for InnoBase yet?
Lee
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 8:03 AM
To: [EMAIL PROTECTED]
Subject: Innobase + transactions & row level locks will be released in a
few days in MySQL 3.23.3x
Hi, reader
Does MYSQL support the CREATE PROCEDURES command, or have stored procedures?
If so, how do I access them?
Thank you,
Jim Colleary
That all depends.
Do you need to keep the data for historical purposes? Are your queries
running particularly slowly? Have you read the manual about how you can
optimize? Another thing to consider is disk space but I don't think you be
anywhere near the limit yet but I could be wrong.
- O
>Description:
I have loaded the latest versions of MySQL client and MySQl server
using Linux RPMs from your web-site.
I downloaded the DBI and Msql-Mysql-modules files and followed the
instructions. DBI installed Ok but perl Makefile.PL failed for
Msql-Mysql-modules because it could not
Sascha Andres wrote:
>
> hi,
>
> on a suse 7.1 system my mysql fails on startup.
> it can't create a pid. how can i fix this ?
>
> sascha
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual
What are you using? MySQL or Microsoft SQL? If it's Microsoft SQL, you have
come to the wrong place otherwise try using MyODBC instead.
Why do you have to store information in a temporary column? Do you want to
keep the data in the column?
- Original Message -
From: "Wernher Korff" <[E
On Sun, Feb 18, 2001 at 12:11:09PM -0800, Jay Habegger wrote:
>
> MySql Experts:
>
> I have a mysql server running on host A with database X and a mysql server
> running on host B with database Y.
>
> In the context of a select I want to JOIN a table in database X on host A
> with a table in
Hi Jeremy!
>Very cool!
>I see the change log entries in the on-line manual already, but the
>source tarball isn't on SourceForge yet. :-(
>Anyone have one yet?
No, we are still busy working on the distribution, and no one has
it yet.
I just 15 minutes ago got the Solaris version running :).
hi,
on a suse 7.1 system my mysql fails on startup.
it can't create a pid. how can i fix this ?
sascha
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
> "Atle" == Atle Veka <[EMAIL PROTECTED]> writes:
Atle> You say you go to runlevel 5 at boot? In that case, you need
Atle> to put the S99mysql into the rc5.d/ directory..
Ok, thanks, I'll try that. But I thought the runlevel 5 stuff was
only executed after the runlevel 3 stuff, so t
> Hi!
>
> There is a timeout option for the client and net_read and write
> options for the server by which you can regulate these problems.
>
>
> Regards,
>
> Sinisa
Already I use the client timeout, it's not work when server is under high load
crawling to the standstill. I hope it would wait 1
You say you go to runlevel 5 at boot? In that case, you need to put the
S99mysql into the rc5.d/ directory..
Atle
On 18 Feb 2001, John Hunter wrote:
> Sorry to ask a FAQ, but I am having trouble getting the mysql daemon
> to start at boot in Redhat Linux 6.2 with mysql-3.23.33.
>
> I have r
Sorry to ask a FAQ, but I am having trouble getting the mysql daemon
to start at boot in Redhat Linux 6.2 with mysql-3.23.33.
I have read the manual and the limited amount that is now available on
Deja News.
Everything about the setup seems to work fine and have no trouble
starting mysql manuall
Hi all,
We are a travel agent and tour operator based in the Maldives and we have
over 90 tourist resort islands serving over 400,000
tourists annually.
We have plans to build an web based inventory for these resorts in
association with Maldives Tourism Promotion Board. The inventory
be used by
Hi,
I've a table which is read very often..
Simplified table structure:
create table comments (
id int unsigned not null auto_increment primary key,
datedate not null,
comment varchar(255) not null
Hello, Lieven!
I will kindly answer...
Subselects are not supported in current released versions of mySQL. Please "continue"
to ask questions, as that is what list groups are for.
Fredrick
Fred van Engen wrote:
> Hi,
>
> On Sun, Feb 18, 2001 at 05:23:02PM +0100, Lieven Op De Beéck wrote:
> >
MySql Experts:
I have a mysql server running on host A with database X and a mysql server
running on host B with database Y.
In the context of a select I want to JOIN a table in database X on host A
with a table in database Y on host B. Can this be done? Do I have to do
anything special with
On Sun, 18 Feb 2001, René Tegel took up a keyboard and dashed off...
> > Ok, I looked through the archive, unsuccessfully.
> >
> > Here's the "problem":
<...>
> You did use
>
> flush privileges;
>
> after inserting the new users? elsewise mysql won't recognize them until a
> restart.
Bingo!
Hi~ All.
I have a question about using index.
I have two following tables.
mysql> explain ex1 ;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| a | char(10) | YES | MUL |
You could use frames, then you wouldn't have to refresh ALL of the page
- Original Message -
From: Siim Einfeldt aka Itpunk <[EMAIL PROTECTED]>
To: Brian V Bonini <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTE
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: sri
To: [EMAIL PROTECTED]
Subject: Installation problem HPUX 10.20
>Description:
I am trying to install the binary fo
Hi,
On Sun, Feb 18, 2001 at 05:23:02PM +0100, Lieven Op De Beéck wrote:
> DELETE FROM product
> WHERE product.id in
>(SELECT p.id
> FROM product p, category c
> WHERE p.cat=c.id AND c.subcatfrom=2)
>
You forgot to read the manual.
Regards,
Fred.
--
Fred van Engen
Hi,
how can I print the results of my database querys?
MySQl is running local on my Linux System.
regards
Frank Steffen
e-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
I'm trying to connect to a SQL database I set up using SQL 3.23. If
possible I would like to see some JAVA code on how to connect to a
database with examples of Class.forName("?"), and anything that goes
between the try block. Also, what String goes between the quotation
marks. Is that the
Hi,
I want to delete products from subcategories which are part of a main
category.
for example:
maincat
|__subcat1
| |__prod1
| |__prod2
| |__prod3
|
|__subcat2
I'm trying to write a query which deletes prod1,2,3
I tried this but it doesn't seem to work. Can anyone help?
DELETE FROM prod
At 05:19 18-02-2001 +0100, Irmund Thum wrote:
>trivial Javascript task and the noscript tag can have a short
>explanation to turn on JavaScript
>for sorting the columns. So somebody with Javascript disabled visiting
>the site sees this information
>and can decide to turn Javascript on
Yes, that m
On Sun, Feb 18, 2001 at 03:06:08PM +0100, Jarmo Paavilainen wrote:
> Hi,
>
> ...
> > > Is there a way to create column names with spaces ?
> > >
> >
> > Yes you can use backquotes for this:
> >
> > create table `a b` ( `x y` int );
>
> Doesnt the normal (SQL9?) double quote do the trick? :
>
Hi,
...
> > Is there a way to create column names with spaces ?
> >
>
> Yes you can use backquotes for this:
>
> create table `a b` ( `x y` int );
Doesnt the normal (SQL9?) double quote do the trick? :
create table "a b" ( "x y" int );
// Jarmo
Julie Baroff writes:
> If connect to mysql server using C API function and mysql server is under very
> high load, client never timeout, it's just sit there waiting - how to stop
> this?
>
> I use the mysql_options() first to set timeout
>
>
> const char *timeout = "1";
>
> mysql_ini
On Sun, Feb 18, 2001 at 12:10:49PM +0800, Teddy A Jasin wrote:
> Hi,
> The problem is when I execute show processlist; the mysql
> replied syntax error. So i cant use the processlist.
> here's wat the mysql respond:
> SHOW PROCESSLIST;parse error near 'PROCESSLIST' at line 1
show processlist wor
On Sun, Feb 18, 2001 at 12:30:57PM +0200, Yoav Bornstein wrote:
> Is there a way to create column names with spaces ?
>
Yes you can use backquotes for this:
create table `a b` ( `x y` int );
I'm not sure this is documented though, so you may want to check
before using this.
show create table
Is there a way to create column names with spaces ?
Thanks :),
--
Yoav Bornstein.
Listen to Weird Al and George Carlin, watch South Park, use Linux and have
fun !
-
Before posting, please check:
http://www.mysql.com/manual
Well, could it be that this network is a wierd set-up. Ip-masq? so mabye it
is having troubles with hostnames or something. hmm... As far as the
physical network, yes I can rule it out. A sledge hammer might work (I've
been looking for a new server anyway )
-Mike
--
Hello,
I'm currently using BeOS 5.
So my question, is there any current releases of MySQL to support BeOS.
Any comments and notes are highly appreciated.
Thank you in advance for your help.
Regards,
Polad.
On Sun, Feb 18, 2001 at 05:09:17AM -0500, Mike Todd wrote:
> it is causing lots of problem. I cannot do anything really, queries create
> databases, drop databases - I get disconnected every time - and I have no
> idea why. It seems to be not docummented
The only time I've seen that error message
On Fri, Feb 16, 2001 at 10:56:57PM +0100, Benjamin Pflugmann wrote:
>
> > When you set up your database server so that it has enough RAM to
> > keep the whole database in main memory (buffer cache), random reads
> > don't need to wait for physical disk seeks and can be very fast.
> [...]
> > So m
it is causing lots of problem. I cannot do anything really, queries create
databases, drop databases - I get disconnected every time - and I have no
idea why. It seems to be not docummented
-Mike
-Original Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Sent: February 18, 20
On Fri, Feb 16, 2001 at 03:16:19PM +0800, chchen wrote:
> Hi all
>
> I find out that the performance of Heap table seems bad than MyIsam
> table. of course, MyIsam table usually on the H.D., so it will slow
> down because of I/O.
>
> but i do a test. I mount a memory disk on FreeBSD and update/
On Sun, Feb 18, 2001 at 04:35:29AM -0500, Mike Todd wrote:
?
>I am getting an error that I do not know how to resolve. I have looked
> though all the .docs, this is my last resort (it's 4:30AM). The system is
> running slackware with mysql 3.23.33. When I try and query, or just about do
>
On Fri, Feb 16, 2001 at 11:20:58AM +0100, Wernher Korff wrote:
> hello list;)
>
> i have a SQL command to DROP a COLUMN from a mySQL database, the
> problem is that the syntax i am using doesnt seem to be the right
> syntax for mySQL, my statement currently read:"ALTER TABLE
> WorkGroups DROP COL
On Fri, Feb 16, 2001 at 03:02:38PM +0200, Heikki Tuuri wrote:
>
> Monty will roll a new distribution of MySQL 3.23.3x this weekend.
> Innobase will be included there and it will provide transactions,
> rollback, recovery, row level locking, and Oracle-like consistent
> read.
>
> Monty will leave
Hello all,
I am getting an error that I do not know how to resolve. I have looked
though all the .docs, this is my last resort (it's 4:30AM). The system is
running slackware with mysql 3.23.33. When I try and query, or just about do
anything I get this error:
010218 4:02:54 Aborted con
On Fri, Feb 16, 2001 at 11:45:10AM -0700, Bifano, Joe wrote:
> Hi,
>
> I know we can connect to 2 separate Mysql database's using Perl and
> the DBI module but can we connect to 2 different machines? One will
> be what we are using on our server and one our clients wants to be
> able to have on t
>Description:
The following sequencee of statements should cause a deadlock.
transaction | operation | object
+---+---
1 | write | a
2 | write | b
2 | read | a
1 | read | b
It fails to do so with mysql-3.23.32 comp
On Fri, Feb 16, 2001 at 01:05:51PM -0500, Scott McCool wrote:
>
> My guess is that this is what was happening. I'm not sure of any
> way to confirm it though, how do I ensure that my select() is
> happening from a different database page then the insert?
Realistically, you can't. It's a guessin
On Sun, Feb 18, 2001 at 12:41:01AM -0500, Michael Fischer wrote:
>
> Hello,
>
> is there a browseable archive for this list?
>
> I would as soon look it over, if it exists, before
> posting what may be an FAQ.
Are you looking for something other than the archive which is
mentioned in the foote
You did use
flush privileges;
after inserting the new users? elsewise mysql won't recognize them until a
restart.
- Original Message -
From: "Michael Fischer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 2001-02-18 7:55 AM
Subject: Unable to designate host
>
> Ok, I looked throu
84 matches
Mail list logo
