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
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 their
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
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 for a
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 COLUMN
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 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/inser
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 my
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
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.
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 G)
-Mike
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:
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
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_init(mysql);
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
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? :
create table "a
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 might
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
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
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 PROTECTED];
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 |
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! Thank you.
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
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 Beck wrote:
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
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
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
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 read
"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 that I
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
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 :).
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
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"
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)
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
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.
-
Does MYSQL support the CREATE PROCEDURES command, or have stored procedures?
If so, how do I access them?
Thank you,
Jim Colleary
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,
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
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:
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
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
Had the same problem. If you have a look at your database, through the
mysql prompt, you will see things like #8211;. 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
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
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 .I
am
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?
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:
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,
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
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 where
- Original Message -
From: "Jan Namedyski" [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:
I want to create a text field who support Unicode. Is there any link, example to do it.
Sebastien
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: [EMAIL
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)
Title: ÍÎÓÒÁÓÊÈ, ÌÓËÜÒÈÌÅÄÈÀ-ÏÐÎÅÊÒÎÐÛ, ÂÈÄÅÎÊÀÌÅÐÛ, CISCO
Óâàæàåìûå ãîñïîäà,
Ïðåäëàãàåì ñî ñêëàäà â Ìîñêâå ïî íèçêèì öåíàì:
Íîóòáóêè Toshiba, Sony, Fujitsu-Siemens, Compaq, IBM, Mitac, Asus
Ìóëüòèìåäà-ïðîåêòîðû Panasonic, Sony, Nec, Sanyo, Proxima, Mitsubishi
Ïëàçìåííûå
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
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)
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
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
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
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
Could you provide us with the error messages you are getting?!?!
- Original Message -
From: "Michael Lpine" [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 table
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
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 get
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
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,
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?
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
several
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
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 !DOCTYPE HTML PUBLIC "-//W3C//DTD
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
71 matches
Mail list logo