At 09:02 16.07.01 -0700, John Hawkins wrote:
>I'm having a bit of trouble doing a LEFT JOIN. Any input would be greatly
>appreciated.
>
>table 1 (sites, has approx 30 records) has a list of sites with the
>following fields:
>ID, sitename, url
>
>table 2 has (ratings, has approx 2020 records) has
Sir,
I'm using Linux Mandrake 8.0. This is the first time
I'm using Linux OS. My question
is: how to install MySQL GUI to Linux.
Please help me.
Thank you very much.
My email : [EMAIL PROTECTED]
Do You Yahoo!?
Get your free @yahoo.co
I have got an example with a simple and very often used select here also...
| 28 | DELAYED | localhost| dbSmurfa | Delayed_insert | 1|
Waiting on cond | GuestBook
| 479 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1|
Locked | SELECT Users.ID, Users
Dear Paul,
I have a high respect and esteem for you, your book and your valuable
and effective answers to questions made by dozens of MySQL users. I am
really sorry if I have offended you with my previous e-mail. I think, we
are very busy at work, and it is better to leave for the lawyers the
sol
The manual
http://www.mysql.com/doc/R/E/REPAIR_TABLE.html
mentions the QUICK and EXTENDED options for REPAIR TABLE. But it does
not say which is the default. Anyone know?
Thanks,
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (
Hi All:
I finally got mysql compiled and installed. The daemon started but when I try to use
the client or any of the admin scripts I get a core dump. I ran the sql tests and it
installed the test db and it managed to run the test ... I am running under soalris
2.5.1.
Any help would be great
Hi there
I'm having trouble in a multi-threaded client with segfaults in
mysql_free_result(). After trawling the archives, I've found other people
reporting the same problem, but the fix in each case has been to make sure
that the pointer returned from mysql_store_result() is non-null. This is no
At 9:05 AM +0545 7/17/01, Deependra B. Tandukar wrote:
>Greetings!
>
>I have two talbes in MySQL, Table1 and Table2.
>
>Table1
>iditem
>1 apple
>2 banana
>3 orange
>
>Table2
>iditem
>1 shoes
>2 suit
>3 mango
>
>If I want to add a row/column from Table1 to Table2, is
Hi,
there is somethng strange in installing mysql using my own made
charset. Configuration and compilation is going ok. But after that
I can't use mysql not as root not as aother user... When I do
safe_mysqld --skip-grant & all is Ok (logical) I can change
privileges make drop datab
I've been experiencing a simmilar problem only with MyISAM tables.
This is under 3.23.35 and 3.23.36 on Sparc/Solaris 2.7.
For me the problem occurs when doing an ALTER TABLE or a simmilar
operation (eg OPTIMIZE) on relatively large tables (>4 millon rows)
with one or two indeces.
The table in
Date |Tue, 17 Jul 2001 10:27:59 +0800
>From |"tpchan" <[EMAIL PROTECTED]>
Hello!
T> Hi,
T> Recently, I had downloaded a copy of Standard binary RPMs for
T> MySQL-Max-3.23.39-1.i386.rpm and I try to installed it on Linux Red Hat 6.2.
T> The command for installation as below:
T> rpm -ivh MySQL-M
Greetings!
I have two talbes in MySQL, Table1 and Table2.
Table1
iditem
1 apple
2 banana
3 orange
Table2
iditem
1 shoes
2 suit
3 mango
If I want to add a row/column from Table1 to Table2, is it possible? May be
something like:
insert into Table1 (item) values ((
> I have problem to run configure on my unix box.
>
> My OS is solaris 5.8.
> gcc version is 2.95.2
>
> I use gzip and gtar to extract the package with version mysql-3.23.39
>
> See the below. I don't know what's the problem.
http://home.earthlink.net/~jaymzh666/solaris.html
Phil
--
Insanity P
Hi,
Recently, I had downloaded a copy of Standard binary RPMs for
MySQL-Max-3.23.39-1.i386.rpm and I try to installed it on Linux Red Hat 6.2.
The command for installation as below:
rpm -ivh MySQL-Max-3.23.39-1.i386.rpm.
Here is the error I get after the installation.
Giving mysqld a couple of
The problem is just as it states, "Access denied" ... You can also find the
information that the username is 'root' and a password was supplied.. so the
first thing to check out would be the password the script is using to
connect with. Once that is corrected it should work fine.
Hope that helps.
but before you issue this command and possibly trash your database, use
select * from a_table where status='flag_value';
to look at the records which will be deleted. you may find some surprises.
At 08:19 AM 7/16/01 -0400, you wrote:
>Why not:
>
>delete from a_table where status='flag_
Hi!
I am now finally back from Australia after a 36 hour, which involved 4
hours waiting for a airplane to be repaired, 3 plane changes and one
missed airplane. Finally back in Finland, we got the message that our
baggage had been lost on the way :(
Australia was great, but it's real nice to b
Try connecting to 'localhost' instead unless your web server is different
from your mysql server in which case, you'll need to give root permission to
connect from 209.198.250.5. If not, try posting some code to the list.
It'll make it easier for us to solve your problem.
- Original Message
Ok so
SELECT * FROM Events, Djs, EventDjs WHERE Events.eventID = EventDjs.eventID
AND Djs.DJID = EventDjs.DJID;
should give you a list with the event and the dj etc, if you only want one
event then add something like AND Events.Events.eventID = 'x' or whatever.
cheers,
noel
On Tuesday, July
Hi Guys,
What im looking at doing is working out the best way to safely shut down
mysql so I can do a full backup of the system, then restart it back. (im
running on a FreeBSD box)
I know I can kill the PID and other drastic measures but I dont want to do
anything that might corrupt the data.
> mysql> select vend_city+', '+vend_state+' '+vend_zip
> -> from Vendors
> -> order by vend_name
> -> ;
...
> 4 rows in set (0.01 sec)
>
> How do I do this in MySQL?
SELECT CONCAT(vend_city, ', ', vend_state, ' ', vend_zip) FROM Vendors ORDER
BY vend_name;
--
At 8:19 AM +0800 7/17/01, Erymuzuan Mustapa wrote:
> I have an Excel worksheet saved as text file(tab delimited),
>Load data works fine on my Win2k(MySQL 3.23.38) for bulk loading but on
>MacOS X , MySQL 3.23.39 the same same file doesn't seem to work right, all I
>got was malformed data. Usin
At 5:54 PM -0700 7/16/01, Bob Rea wrote:
>Still reading SQL in 10 Minutes, and here is the next problem, string
>concatenation in SELECT queries. The book has this query and this
>result. The other data is there in the table.
>
>mysql> select vend_city+', '+vend_state+' '+vend_zip
> -> from Ve
Hi,
I'm appologise in advance if I've sent this to an inappropriate
mailing list. I'm trying to find pre-compiled binaries for mySQL (any
stable version) for Digital unix 4.0d. I'm no whiz on Unix and so would
prefer not to have the headache of trying to compile from scratch. Are
these bin
When am trying to connect to mysql am getting this error
"Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in /var/www/html/accounts/include/useradmin.php on line
144 Unable to select database"
What is the problem, Please do assist thanks
Rega
When am trying to connect to mysql am getting this error
"Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in /var/www/html/accounts/include/useradmin.php on line
144 Unable to select database"
What is the problem, Please do assist thanks
Rega
Good tutorial
http://www.mysql.com/articles/ddws/index.html
enjoy
Ken
- Original Message -
From: "Bob Rea" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 5:54 PM
Subject: Next Newbie Question
> Still reading SQL in 10 Minutes, and here is the next problem, stri
Question:
given data in a table such as
id, value, date
0, value1, 1999-01-25
1, value2, 1999-01-02
2, value2, 1999-01-04
3, value1, 1999-01-22
4, value2, 2000-01-01
how can i select the latest 'id' for a given same set of 'value' based on
'date'? ie: i would like to be able to get records id
> > I was wondering, is it possible to have different log files for
> > different databases somehow?
>
>RedBack? You're just down the street... Sort of.
Ya, but for how long (for either of us). ahem.
>difficult to do (add the necessary code to MySQL), provided that the
>logging code is as
Still reading SQL in 10 Minutes, and here is the next problem, string
concatenation in SELECT queries. The book has this query and this
result. The other data is there in the table.
mysql> select vend_city+', '+vend_state+' '+vend_zip
-> from Vendors
-> order by vend_name
-> ;
+
I have an Excel worksheet saved as text file(tab delimited),
Load data works fine on my Win2k(MySQL 3.23.38) for bulk loading but on
MacOS X , MySQL 3.23.39 the same same file doesn't seem to work right, all I
got was malformed data. Using either LOAD DATA or mysqlimport.
If there's a bette
Hello,
I am working with MySQL (Ver 9.38 Distrib 3.22.32, for -freebsd4.1.1
(i386)) on FreeBSD 4.2-STABLE running (I believe) on a dual 233 Intel
box. We have been having some problems as of recently where system
swap becomes flooded and the system is brought to a halt. We believe
we have isola
hi!
> "Pete" == Pete Kuczynski <[EMAIL PROTECTED]> writes:
Pete> Hi,
Pete> I updated my tables to BDB, but it still shows MYISAM.
Pete> Do I need to remove mysql and reinstall it compiled for BDB like the
Pete> manual suggests? I'm using nusphere's mysql on NT4 server, so I'm not
Pete> shur
Not a problem, glad I could assist you. Yeah I've ended up running into
major problems with the packages my self on older versions of solaris
running on newer hardware. Hopefully the maintainer will upgrade his/her
hardware at some point. Anyone want to donate? ;-)
"[EMAIL PROTECTED]" wrote:
>
Hi Colin:
I once again want to thank you for the info. I had indeed installed a
'package' gcc compiler from sunfreeware. I followed your advice and I
downloaded gcc 2.95.3 source and compiled it on the machine that I was
trying to install mysql and sure enough I got it compiled. This would surely
[This is an email copy of a Usenet post to "mailing.database.mysql"]
Martin,
Here is how you can do what you want using a temporary table. Note that
using this method, if you have two guys who play the same position, and
they have an equal number of points, it'll select both records.
mysql> CR
Hello All,
I have need to modify users table in mysql database. I wish to expand the user column
from 16 chars to 128 chars. Will this cause problems with MySQL server engine and
will it recognize and use my changes? What is maximum size allowed and also can I
safely expand width of databas
Hi,
I just experienced a strange bug in MySQL 3.23.39 I couldn't explain (and couldn't
reproduce, it's why I post it on this list ;))
I misconfigured my my.cnf, so MySQL didn't found the host.frm.
The strange behaviour is just after the normal shutdown of mysql :
010717 00:01:19 mysqld starte
On Monday 16 July 2001 15:03, Kalpesh Modha wrote:
> Hello.
>
> I am trying to get mysql working on RedHat 7.1 and it works fine however,
> when I try to make a local connection from either Java or PHP. I get a
> connection refused message. Whats missing ?
>
> Thanks for your help in advance.
Yo
[This is an email copy of a Usenet post to "mailing.database.mysql"]
Just insert a row with the initial value you want minus one, and then
delete it. That will make the table do what you want.
mysql> INSERT INTO Orders VALUES (-1, "", NOW(), -1, 125478);
Query OK, 1 row affected (0.03 sec)
Well, let me give the complete details
Let's say I have one table called events
with fields eventID and eventName
Then one table called djs
with fields djID and djName
And finally a table linking them all called eventdjs
with fields called eventID and djID
this table links one event with all th
Well, let me give the complete details
Let's say I have one table called events
with fields eventID and eventName
Then one table called djs
with fields djID and djName
And finally a table linking them all called eventdjs
with fields called eventID and djID
this table links one event with all th
At 5:39 PM -0400 7/16/01, Simon Lee wrote:
>Hi:
>
>I have a process that will be receiving a bulk of data, say, every 5
>minutes.
>
>In the program, I can:
>
>1. Use the "Insert into" command to put the data into the table one at a
>time,
>(Drawback: it would be very slow for each query to put
WOW THIS REALLY WORKS!!!
Dear Friend & Future Millionaire:
AS SEEN ON NATIONAL TV:
Making over half a million dollars every 4-5 months from your home for
an investment of only $25 U.S. Dollars expense one time.
THANKS TO THE COMPUTER AGE AND THE INTERNET!!
==
Hi:
I have a process that will be receiving a bulk of data, say, every 5
minutes.
In the program, I can:
1. Use the "Insert into" command to put the data into the table one at a
time,
(Drawback: it would be very slow for each query to put in the data). Or
2. Save the whole data into a file,
First off, what BSD? There are a few of them... and what version?
Sometimes --with-low-memory doesnt seem to work... What I have done in the
past to get it to compile is edit the Makefile in that directory, find the
line that compiled sql_yacc.cc, and add the compiler flag -O0 ... Sure that
turns
Hi!
Is it possible to use IF in the FROM part of a SELECT statement?
I've got three tables:
Profiles:
ID: int
CityID: int
Cities1:
ID: int
Name: VarChar 255
Cities2:
ID: int
Name: VarChar 255
Now I'd like to use Cities2 if the CityID in the table Profiles is
bigger than 7.
W
>Description:
I try to run mysql in conjunction with Apple WebObjects5 (the
EnterpriseObjects Framework).
This framework generates certain SQL Statements which fail (see How-To-Repeat).
>How-To-Repeat:
Ok first the "positive test":
create table test ( nam
Hi,
I understand mysql supported InnoDB and BDB table types for the purposes
of transaction logging, which I need to use.
Which is recommended by you folks for NT4 boxes.
Pete
___
Pete Kuczynski
Sr. Field Engineer
DHL Airways Inc.
Infrastructure Technology &
Oh no you don't. Now be quiet! All of you! We don't want another of those
(*shudders*) holy wars.
And Fred Dinkler: Don't you never ever ask that again :-) Go find your own
truth without disturbing the peace (or is it only a ceasefire?)
=|8-)
- Carsten
- Original Message -
From: "Mike
Open Invitation to NuSphere and Progress
The people at MySQL AB would like to invite you, NuSphere Corporation
and Progress Software Corporation, to talks on neutral soil for the
purpose of resolving our disputes. We propose to meet on Wednesday 18
July 2001 and continue for as long as we need,
I hate to differ with you here, John... but please check the following URL
and notice the price tag on it --
http://www.redhat.com/products/software/linux/7-1_standard.html
RedHat is betting on, correctly so, that users in general will not spend
the time and effort to download over 100 meg of d
Basic instructions to enable mysql in MacOSX Server 10.0.4:
http://patricklarkin.com/macosxserver/
--
Patrick
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
MySQL uses the LEFT JOIN, RIGHT JOIN Syntax ...
RTFM: http://www.mysql.com/doc/J/O/JOIN.html
> -Ursprüngliche Nachricht-
> Von: Bruce Stewart [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 16. Juli 2001 11:54
> An: Mysql-Help (E-mail)
> Betreff: Outer join syntax..
>
>
> Hi all,
>
> MyS
-- Original Message --
From: "Steve Brazill" <[EMAIL PROTECTED]>
Reply-To: "Steve Brazill" <[EMAIL PROTECTED]>
Date: Mon, 16 Jul 2001 11:32:24 -0700
>EMACS !! ick, yuck, blah !!!
I'm always amazed how it's infiltrated the 'database' group (type) of
people
-- Original Message --
From: "Steve Brazill" <[EMAIL PROTECTED]>
Reply-To: "Steve Brazill" <[EMAIL PROTECTED]>
Date: Mon, 16 Jul 2001 11:32:24 -0700
>EMACS !! ick, yuck, blah !!!
I'm always amazed how it's infiltrated the 'database' group (type) of
people
I have problem with table lockings scince i upgraded the MySQL version, and i have
tried with
both RedHat 7.1 rpm version 2.23.36 and compile myself with 2.23.39. The result is the
same.
As can be seen in the "screenshot" below there is one process running, and a lot
sleeping. In
this example
Hi!
On Jul 16, Carsten Gehling wrote:
> Description:
> A specific table (see "How-To-Repeat) with a FULLTEXT index causes errors in
> the MYI file when inserting new rows.
>
> 1) Create the following table:
> CREATE TABLE `visitkort` (
[skip]
> ) TYPE=MyISAM;
>
> 2) Insert a row with the follow
> From: Pete Kuczynski [mailto:[EMAIL PROTECTED]]
>
> Can anyone tell me for shure if my version of mysql supports
> transactions. Version: 3.23.37
>
> The bitbybit web site states that is does not, but someone told me that
> it does, help!
>
> > MySQL doesn't support transactions. If you don't k
Thanks for the clarification. Is it a MySQL bug then that the CREATE query
converts all the VARCHAR fields into CHAR fields so the query 'CREATE
TEMPORARY TABLE User2 SELECT * FROM User' creates a temporary table much
larger than the User table?
-Original Message-
From: Michael Widenius [
Date |Mon, 16 Jul 2001 16:38:14 +0530
>From |"Ganesh Krishnan" <[EMAIL PROTECTED]>
Hello!
GK> Hi,
GK> I am developing a Java application which uses MySQL database on Linux
GK> platform. Mark Mattews' MySQL driver is being used.
GK> I am able to connect to the database from the application if I
Date |Mon, 16 Jul 2001 12:32:01 +0300
>From |Jurgis <[EMAIL PROTECTED]>
Hello!
J> Hi,
J> is it possible to use differenet character sets on one mysqld, couse i need to sort
data in tables using my character set but not only i want to do this stuff in for
example latin1 character set...
You nee
I'm surprised that there hasn't been any reply to this posting. I've
continued to put up with the error 2003 but after several hours I get error
2013 - "Lost connection to MySQL server during query". May I note that the
code works 100% when using local UNIX socket. It's only when using TCP/IIP
tha
TextPad ( http://www.textpad.com ) also handles Unix/Win (for table/db
dumps, etc) without a problem and is my own personal choice. Includes syntax
highlighting if you want that
kind of thing.
Emacs on Windows is also good, but it can be a bear to configure and get
running the way you might want
EMACS !! ick, yuck, blah !!!
I'm always amazed how it's infiltrated the 'database' group (type) of
people
Vi is 'bester' (you wanna talk about learning curves ?)
- Original Message -
From: "Mike Baranski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Mon
Date |Sun, 15 Jul 2001 21:14:43 +0200
>From |Alexandre BAUMEISTER <[EMAIL PROTECTED]>
Hello!
>>> Do someone see improvements compiling Mysql with Gcc 3.0 ?
SM>> What improvements would you like to see in the compiled library ??
AB> In fact I just wanted to know if there is any advantage to
Also, if you want the real deal, go get emacs, either at
http://xemacs.org
or http://www.gnu.org
It's the best (no flames here), but has a pretty steep learning curve.
-- Original Message --
From: "Steve Brazill" <[EMAIL PROTECTED]>
Reply-To: "Steve Brazil
Don't forget that "WinVI" exists and can be found (and downloaded) at:
http://www.winvi.de/en/
And for those who like the 'code warrior' or 'slickedit' type of stuff
(where different types of 'statements' are highlighted in different colors),
there's "Code Genie" available at:
http://www.c
SELECT ratings.memid, sites.*
FROM ratings LEFT JOIN sites
ON ratings.ID = sites.ID
WHERE ratings.memID = '1' and sites.ID IS NULL;
John Hawkins wrote:
> I'm having a bit of trouble doing a LEFT JOIN. Any input would be
> greatly appreciated.
>
> table 1 (sites, has approx 30 records) has a li
Hi,
I updated my tables to BDB, but it still shows MYISAM.
Do I need to remove mysql and reinstall it compiled for BDB like the
manual suggests? I'm using nusphere's mysql on NT4 server, so I'm not
shure that's even possible.
http://www.mysql.com/doc/B/D/BDB_install.html
Pete
> To compile MySQL w
I have a client using MySQL 3.23.37. We wanted to use the Berkeley tables but
for some reason they are disabled. when I do a show variables I get:
have_bdb NO
What is the best way to permanently enable the BDB type tables??
THX's
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Th
I have an include file that includes my mysql connect information. Its sole purpose is
to login to mysql. Strangely on my Win9x development system with apache, sometimes,
almost randomly, the connection will time out. Then if I press refresh it works
prefectly. I am only connecting once per pa
Hello mysql,
I meet in share ver. of MySQL different lang. driver but no where
UKRAINIAN.
AND now I ask - I wont translete "errmsg.txt" and "errmsg.sys" for
UKRAINIAN lang?
Waiting for ansver!
--
Best regards,
suh mailto:[EMAIL PROTECTED]
At 9:34 AM +0100 7/16/01, Santi Chumbe wrote:
>Interesting position. The NuSpheres people are really very clever.
If I'm reading your statement correctly, you appear to be using "clever"
as an innuendo for "mendacious." If that is so, I must respectfully
disagree, and point out that statements o
Does anyone know why the mysql_install_db file in the scripts directory is
blank with the sol8-x86 distribution? I hit a snafu when I try to start the
db and I assume it's because this file isn't doing something it is supposed
to.
Thanks,
Oliver
I'm having a bit of trouble doing a LEFT JOIN. Any input would be greatly
appreciated.
table 1 (sites, has approx 30 records) has a list of sites with the
following fields:
ID, sitename, url
table 2 has (ratings, has approx 2020 records) has a list of member ratings
for the different sites wi
I've followed the NuSphere vs MySQL AB conflict/debate with great interest
and I really hope that the conflict will be resolved to the satisfaction
of both parties and most of all MySQL users. I was excited when NuSphere
(Progress) joined the MySQL community. Progress knows a lot about
database
Hi,
Compilation fail with the following error message :
makeinfo -I . --no-headers --no-split --output manual.txt manual.texi
Fabrication du fichier text «manual.txt» à partir de «manual.texi».
manual.texi:56: Commande inconnue «setcontentsaftertitlepage»..
manual.texi:5157: itemize exige un arg
Hi,
"eingebaut" is a german word and means something like "build in" or =
integrated.
Best Regards
Bernhard
p.S. This message contains words like: database,sql,query,table
- Original Message -=20
From: "Gerlinde Fischer" <[EMAIL PROTECTED]>
To: "Beatriz Lapaz" <[EMAIL PROTECTED]>; <[EM
I'm having a bit of trouble doing a LEFT JOIN. Any input would be greatly
appreciated.
table 1 (sites, has approx 30 records) has a list of sites with the
following fields:
ID, sitename, url
table 2 has (ratings, has approx 2020 records) has a list of member ratings
for the different sites wi
On 16-Jul-01 Pete Kuczynski wrote:
> I'm fairly new to this, so pardon this ignorant question.
> My tabletype shows as MYISAM, mysql version 3.23.37, will transactions
> still work?
>
No.
alter table da_table type=BDB;
Check the manual
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
> Pete
>
Hi All
-
I dont have a say in a lot of things but want to just give my support to
mySQL and in whatever it decides to do with
this ugly sutiation. MySQL was the first Linux app that I have setup and
runned sucessfully when I started working on linux
and it was always a dream of mine to
I'm fairly new to this, so pardon this ignorant question.
My tabletype shows as MYISAM, mysql version 3.23.37, will transactions
still work?
Pete
Don Read wrote:
>
> On 16-Jul-01 Simon Green wrote:
> > MySQL
> > Will not do transactions till V4...
> > But there are ways to get around this..
yes...yes, I believe we are. Mea Culpa, BDB fans please to forgive. :)
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Sander Pilon" <[EMAIL PROTECTED]>
To: "'Cal Evans'" <[EMAIL PROTECTED]>; "'Pete Kuczynski'"
<[EMAIL PROTECTED]>; <[E
On 16-Jul-01 Simon Green wrote:
> MySQL
> Will not do transactions till V4...
> But there are ways to get around this..
>
If you use BDB or Innobase table types, then transactions _are_ supported.
Since ~ 3.23.26 IIR; no idea if the code is considered "stable" ...
http://www.mysql.com/doc
SG> MySQL
SG> Will not do transactions till V4...
Wrong. InnoDB table type supports transactions.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D
> MySQL supports transactions if you are using either InnoDB or
> Gemini table types.
>
> Cal
Are we forgetting BDB tables? Yes.. yes.. I believe we are!
http://www.mysql.com/doc/B/D/BDB_characteristic.html
-
Before post
Simon Green writes:
> MySQL
> Will not do transactions till V4...
> But there are ways to get around this..
>
> Simon
>
Sorry, but the above is not true.
You can use transactions with 3.23 if you use BDB or InnoDB tables.>
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __
And Berkeley BDB tables!
>>On Mon, 16 Jul 2001 10:04:41 -0500, "Cal Evans" <[EMAIL PROTECTED]> wrote:
>>MySQL supports transactions if you are using either InnoDB or Gemini table
>>types.
>>
>>Cal
>>*
>>* Cal Evans
>>* Senior Internet Dreamer
>>* http://www.calevans.com
>>*
>>- Original M
On Mon, 16 Jul 2001 09:57:26 -0500, Pete Kuczynski <[EMAIL PROTECTED]>
wrote:
>>Can anyone tell me for shure if my version of mysql supports
>>transactions. Version: 3.23.37
>>
>>The bitbybit web site states that is does not, but someone told me that
>>it does, help!
We use, on a shared MySQL s
MySQL
Will not do transactions till V4...
But there are ways to get around this..
Simon
-Original Message-
From: Pete Kuczynski [mailto:[EMAIL PROTECTED]]
Sent: 16 July 2001 15:57
To: [EMAIL PROTECTED]; Carsten H. Pedersen
Subject: transactions
Can anyone tell me for shure if my
MySQL supports transactions if you are using either InnoDB or Gemini table
types.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Pete Kuczynski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Carsten H. Pedersen"
<[EMAIL PROTECTED]>
Sent
Description:
A specific table (see "How-To-Repeat) with a FULLTEXT index causes errors in
the MYI file when inserting new rows.
The error only occurs when the FULLTEXT index is in the table. I've tried to
recreate the table completely, and it still occurs.
The bug is found on the following platf
Can anyone tell me for shure if my version of mysql supports
transactions. Version: 3.23.37
The bitbybit web site states that is does not, but someone told me that
it does, help!
> MySQL doesn't support transactions. If you don't know what transactions are, chances
>are you'll never need them
Most likely that there is a problem with where PHP and Java are looking for
the socket. One more possibility (I don't know for Java, but for PHP) - you
need to install a php-mysql (or mysql-php) package.
Regards,
Milos Rackov
> From: Kalpesh Modha [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July
Hi,
try check your permission in your MySQL and in scripts.
S pozdravem
Michal Dvoracek [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
Hello.
I am trying to get mysql working on RedHat 7.1 and it works fine however,
when I try to make a local connection from either Java or PHP. I get a
connection refused message. Whats missing ?
Thanks for your help in advance.
Regards
Kal.
---
These two statements say the same thing. They shouldn't cause a problem but
the probably don't do what you want.
Try using the first table multiple times and use an alias.
Don't have my book handy but it seems to me that :
Select table1.*, table2.* from table1 as t1, table1 as t11, table 2 as t
Hi!
Is it so that your test inserts, updates, and deletes
rows at random? Can these rows overlap? Do you have big
transactions?
If the above are true, you will inevitably get a lot
of deadlocks and rollbacks. Real-world applications
should be written in a way that deadlocks cannot occur,
or they
Yes. No problem with that.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Nick Davies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 07:59
Subject: Joins.
>
> Hi,
>
> I'm just needing a bit of help with Join
1 - 100 of 132 matches
Mail list logo
