Hi,
We just upgraded our server's RAM from 1 GB to 5 GB - I'd like to
now make some adjustments in my.cnf to better tune my server to
this new memory amount. I was looking in the MySQL 4.1.21 source
dir's support-files at the example my.cnf files provided with the
distribution, but these seem
On Mon, 31 Jul 2006 06:26:01 -0700 (PDT)
Phong Nguyen [EMAIL PROTECTED] wrote:
My question is if we decide to switch server 1 to
server 2 (oracle database to mysql) or server 2 to
server1 (mysql to oracle). Then, what happen to
sqlplus (oracle) and sql (mysql) using with
application. You can
and 3765. But bug 1591 is still
listed as To be fixed later. Is that correct? If it is is there a
different bug against how MySQL 4 handled OUTER JOINS which was fixed
in MySQL 5 that I can reference in my justification letter?
Thanks,
Josh Trutwin
FWIW - here is an off-list conversation
Kenneth Wagner wrote:
Speed. Especially where related files are concerned. Foreign keys. Links
on integer
fields are faster, smaller and more efficient. Keys remain smaller and
faster.
This in my mind is one of the biggest reasons to use an AUTO_INCREMENT
column as a primary key when other
I don't think I remember a time when MySQL only had stable production
releases available for download (at least not off the website) since
v3. Any idea if the next alpha is on the way?
Thanks, 5.0 looks great, I've been using it for over a year with very
few problems.
Josh
--
MySQL General
On Fri, 30 Sep 2005 13:08:31 -0700
Jacek Becla [EMAIL PROTECTED] wrote:
Hi,
I had asked similar question few days ago, and then checked with
the developers as no one was able to answer on this mailing list.
I was told it is very likely we'll get it in 5.2.
Thanks - now that 5.0 is release
On Fri, 16 Sep 2005 10:32:23 -0400
[EMAIL PROTECTED] wrote:
You asked basically two questions:
a) what are the differences between ORACLE SQL plus and MYSQL?
snip
depends on how they are with MySQL already. One well-known point on
how
MySQL and Oracle differ is in how to define a JOIN in
On Thu, 4 Aug 2005 23:36:01 -0700 (PDT)
David Blomstrom [EMAIL PROTECTED] wrote:
I wondered if anyone on this list has had experience
with Plone and could explain how their system compares
to PHP/MySQL. I'll be working with animal kingdom data
- child-parent relationships and recursive
On Wed, 8 Jun 2005 21:57:25 -0600
George Sexton [EMAIL PROTECTED] wrote:
I think MySQL has a little ways to go yet before I would
subjectively call it best.
ok.
I posted twice to the list with questions about porting my
application that runs on (SQL Server, Oracle, PostgreSQL, Sybase SQL
On Thu, 09 Jun 2005 14:28:56 +0100
Gordan Bobic [EMAIL PROTECTED] wrote:
My understanding was the timestamp fields were only set when the
record is created. They are not changed when the record is
modified.
http://dev.mysql.com/doc/mysql/en/timestamp-4-1.html
The first TIMESTAMP column in
On Tue, 31 May 2005 18:01:48 -0500
Matt Wagner [EMAIL PROTECTED] wrote:
snip
This is the third published Beta release in the 5.0 series. All
attention will now be focused on fixing bugs and stabilizing 5.0 for
later production release.
Just curious - was there a 5.0.5-beta release? The last
On Wed, 1 Jun 2005 10:40:10 -0500
Josh Trutwin [EMAIL PROTECTED] wrote:
On Tue, 31 May 2005 18:01:48 -0500
Matt Wagner [EMAIL PROTECTED] wrote:
snip
This is the third published Beta release in the 5.0 series. All
attention will now be focused on fixing bugs and stabilizing 5.0
On Tue, 17 May 2005 17:17:31 +0100
S.D.Price [EMAIL PROTECTED] wrote:
Hi,
can anyone explain how I would export a database created in Access
to MySQL using PHPMyAdmin - I can't seem to import the data as csv
or txt.
Acess should allow exporting to CSV. Otherwise you can skip
phpMyAdmin and
On Fri, 22 Apr 2005 22:44:44 +0300
Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
Make a bug or feature report at http://bugs.mysql.com.
Already did - 10098 - it was recently closed, guess it was already
fixed in 5.0.5.
Josh
--
MySQL General Mailing List
For list archives:
Would it be possible to add:
ENGINE=MyISAM
To all the CREATE TABLE statements in the mysql_fix_privilege_tables
script? The server (tested with 5.0.3 and 5.0.4) crashes when
creating/altering these tables if the following is in /etc/my.cnf:
default-table-type=innodb
I had to drop all the
On Mon, 18 Apr 2005 13:28:24 +0200
Joerg Bruehe [EMAIL PROTECTED] wrote:
Hi,
A new version of MySQL Community Edition 5.0.4-beta Open Source
database management system has been released. This version now
includes support for Stored Procedures, Triggers, Views and many
other features. It
On Mon, 18 Apr 2005 18:04:46 +0200
Joerg Bruehe [EMAIL PROTECTED] wrote:
snip
Are you sure it did not get damaged during transfer, or by your
browser? All I can recommend is to try another mirror.
I'm using elinks text browser, which has worked great for this in the
past. I tried about 4
On Tue, 15 Mar 2005 18:49:38 +0900
ninjajs [EMAIL PROTECTED] wrote:
What do you think about MySQL vs PostgreSQL ?
Both are great products and have their ups and downs. On a MySQL list
you will not get an un-biases answer to this question.
If you really want to know what people on the MySQL
On Wed, 29 Dec 2004 10:42:45 -0500
GH [EMAIL PROTECTED] wrote:
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
It doesn't really matter but I'd suggest MySQL first as I think there
is one file you need to copy from the MySQL installation to the
C:\Windows (or whatever
On Wed, 29 Dec 2004 12:09:51 -0500
[EMAIL PROTECTED] wrote:
snip
Of course, the WAMP alternative is always there, Apache is FREE and
comes with PHP.
snip
FWIW, the download of apache from the Apache website
(http://httpd.apache.org/) does NOT include PhP, you still have to
download and
Yes, this has been reported on this list a couple times already.
Really baffling how this one made it out of QA.
Josh
On Thu, 23 Dec 2004 21:43:27 +0200 (EET)
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
SQL
Hello, All!
IMHO this the bug in 4.1.8 to create library shared libraries
On Fri, 17 Dec 2004 16:19:25 -0200 (BRST)
[EMAIL PROTECTED] wrote:
Description:
Mysql 4.1.8 installs libmysqlclient as libmysqlclient.14.0.0
instead of libmysqlclient.so.14.0.0 which is the correct for
Linux.
I wish you were about 1/2 hour faster, I just finished
On Wed, 8 Dec 2004 08:21:54 +0200
Heikki Tuuri [EMAIL PROTECTED] wrote:
dumps do contain that setting in 4.1.7. Below is a start of a dump
file.
[EMAIL PROTECTED]:~/mysql-4.1/client ./mysqldump test dump
[EMAIL PROTECTED]:~/mysql-4.1/client cat dump | more
-- MySQL dump 10.9
--
-- Host:
On Tue, 07 Dec 2004 16:51:10 -0700
Titus [EMAIL PROTECTED] wrote:
On page 822 of the pdf copy of the documentation
that I have, it says:
To make it easier to reload dump files for tables
that have foreign key relationships, mysql automatically
includes a statement in the dump output to
On Tue, 21 Sep 2004 08:57:21 -0400
[EMAIL PROTECTED] wrote:
snip
There are up to three layers of record filtering that happen during
any query. First is the JOIN filtering. That is where the ON
conditions are used with the table declarations to build a virtual
table that consists of all
On Tue, 21 Sep 2004 10:49:31 -0400
[EMAIL PROTECTED] wrote:
Hmmm. you want to see a student, all of the classes they are
enrolled in and how many times they attended? I understand the
relationships between the student, class, and class_attended tables
(that's all related to attendance and
On Mon, 20 Sep 2004 09:33:56 -0400
[EMAIL PROTECTED] wrote:
Sounds like your 4.0.20 may be the buggy installation... let me see
if I can explain.
Except this is a 5.0.1 installation. The query worked as is in 4.0.20
(and it also worked in 5.0.0), only after playing with 5.0.1 did the
results
On Mon, 20 Sep 2004 10:25:16 -0400
[EMAIL PROTECTED] wrote:
I think you missed my point. I think the 5.0.1 behavior was correct
and the others are wrong. There is a known bug (or two) about mixing
outer joins and inner joins and it looks like it may be fixed. IF
you want to see all of the
Is there a known bug with outer joins in MySQL 5.0.1?
I tried the following query on 5.0.1:
SELECT s.tech_id, s.full_name, sa.points_awarded, sa.date_submitted
FROM student s
INNER JOIN enrollment e ON e.tech_id = s.tech_id
INNER JOIN submitted_assignment sa ON sa.tech_id = s.tech_id
RIGHT JOIN
On Wed, 18 Aug 2004 11:37:03 -0400
leegold [EMAIL PROTECTED] wrote:
Question I have wondered about: Is it a good practice to put html in
a text field, then (eg. via php) when the marked-up text renders in
a user's browser it's good looking html. If not, then I'd just
sandwitch field content
On Tue, 10 Aug 2004 23:40:39 +0200
Jochem van Dieten [EMAIL PROTECTED] wrote:
On Tue, 10 Aug 2004 16:49:26 -0400, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Well, since you admitted to being a newbie, I would suggest that
you learn with MySQL. It supports several types of data storage
On Tue, 10 Aug 2004 23:34:49 +0200
Jochem van Dieten [EMAIL PROTECTED] wrote:
On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote:
One area where MySQL beat Postgres is in Windows installation.
Installing postgres on Windohs is like pulling your fingernails
off slowly.
It is more
On Wed, 11 Aug 2004 17:20:45 +0200
Jochem van Dieten [EMAIL PROTECTED] wrote:
SHOW TABLES does not make sense. How are you going to join the
output of SHOW TABLES against the output of SHOW COLUMNS and SHOW
INDEXES?
SELECT * FROM INFORMATION_SCHEMA.TABLES makes sense.
And as for easy
On Wed, 11 Aug 2004 12:09:34 -0700
Jim Winstead [EMAIL PROTECTED] wrote:
On Wed, Aug 11, 2004 at 07:03:18PM +0200, Jochem van Dieten wrote:
MySQL strives to ful SQL standard compliance (ISO/IEC 9075), so an
INFORMATION_SCHEMA must be planned for someday. However, that day
does not appear
On Tue, 10 Aug 2004 16:45:29 -0400
Brad Tilley [EMAIL PROTECTED] wrote:
No need for flames. I think the two are converging.
One area where MySQL beat Postgres is in Windows installation. Installing postgres on
Windohs is like pulling your fingernails off slowly. I hear they are close to full
On Thu, 22 Jul 2004 12:14:58 -0400
Roy Harrell [EMAIL PROTECTED] wrote:
Can a child table have multiple foreign key references linking
its records to two or more parent tables?
yes - something like:
CREATE TABLE child (
p1_id INT,
p2_id INT,
INDEX p1_id_ind (p1_id),
INDEX
On Mon, 12 Jul 2004 12:05:53 +
Ben David, Tomer [EMAIL PROTECTED] wrote:
when is mysql 4.1.x going to be released for production?
When it is ready I'd guess. :)
If history is a predictor though I would expect 4.1.x to go though 5-7 more beta
releases though. Help the developers out by
On Fri, 2 Jul 2004 06:34:39 -0700
bruce [EMAIL PROTECTED] wrote:
i'm investigating what needs to be done to allow mysql on a server
to be used remotely by client machines. each machine is running
iptables. so i'm wondering what has to be in the iptables for the
machine being used as the mysql
On Mon, 28 Jun 2004 07:11:04 -0300
Carlos J Souza [EMAIL PROTECTED] wrote:
hello all
What is more important? triggers or stored procedures.
I think that triggers they are a lot more important than stored proc. because stored
procs they can be implemented in the front end application.
Noticed something interesting about UNION and INTO OUTFILE
If I do this:
(SELECT a FROM b)
UNION
(SELECT a INTO OUTFILE 'out.txt' FROM c);
The query executes - no results printed to the screen but rather saved to the out.txt
file, as intended. But if I do:
(SELECT a FROM b)
UNION
(SELECT a
On Tue, 22 Jun 2004 16:34:44 +0100
Nic Skitt [Real Productions] [EMAIL PROTECTED] wrote:
Hi All,
I have noticed a lack of comments re Views.
Is it 5.0 or 5.1 that we will have Views capability?
I had hoped it was in the most up to date public development release
of 5. Unless I am
On Thu, 17 Jun 2004 09:01:57 -0500
Scott Johnson [EMAIL PROTECTED] wrote:
Hi Every one,
I'm back to using Mysql after being away doing too many Microsoft
job. hahaha
I'm installing my first MySQL in about five years and I'm perplexed
with the the added formats of batabase table. What are
On Thu, 10 Jun 2004 15:55:31 +0300
Dobromir Velev [EMAIL PROTECTED] wrote:
I've made a simple perl script that uses the
show master logs
and
purge master logs to 'mysql.???'
queries to remove all but the last seven logs and it works perfectly
for me.
Would you be willing to share
On Wed, 9 Jun 2004 18:25:11 +0200
Markus Källander [EMAIL PROTECTED] wrote:
Hi all,
Can someone tell me what is wrong with this statement?
UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull);
I use MySQL 3.23.49.
^^^
4.1 or higher is required for
On Mon, 07 Jun 2004 12:36:47 +
shaun thornburgh [EMAIL PROTECTED] wrote:
Hi,
Is it possible to DELETE from more than one table in one command?
Thanks for your help
DROP TABLE IF EXISTS table1, table2, table3;
http://dev.mysql.com/doc/mysql/en/DROP_TABLE.html
Josh
--
MySQL General
On Sun, 6 Jun 2004 15:48:37 +0200
Dimitri Bosiers [EMAIL PROTECTED] wrote:
snip
INSERT INTO
pages(hidden,name,page_number,data,is_section_root,layout_id,group_
id) VALUES(1,'nieuwe pagina',100,'',2,1,@LID);
this fails with a ERROR 1216: Cannot add a child row: a foreign key
On Sat, 5 Jun 2004 21:10:42 -0600
Daniel Isenhower [EMAIL PROTECTED] wrote:
First off, I assume you are using a version of mysql able to
handle
sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries)
Ugh... I feel dumb :) I'm using 4.0
No worries, there are too many versions
On Sat, 5 Jun 2004 19:48:44 -0600
Daniel Isenhower [EMAIL PROTECTED] wrote:
This is my first email to the list, so be nice ;-)
Welcome, this is a very helpful list...
I'm having some difficulty with a subquery that I'm trying to do,
and was wondering if anyone here can shed some light on the
On Fri, 4 Jun 2004 09:39:44 -0300 (ART)
Leandro Melo [EMAIL PROTECTED] wrote:
Hi,
i`m using mysql in a j2ee application with JBoss.
For best design practices i cannot add the
foreign-keys to the tables in the same insert as i
add the table data. Basically, i`ll add it a few
milliseconds
On Thu, 3 Jun 2004 13:06:54 -0700
Chris Dietzler [EMAIL PROTECTED] wrote:
Running 4.0.18
I am trying to run a query where the query gets the offer_ID of a
certain customer from the offer table and displays in the results
the offer_Name associated with the offer_ID. Right now the way the
On Thu, 3 Jun 2004 15:22:36 -0500
Josh Trutwin [EMAIL PROTECTED] wrote:
Or in preferable INNER JOIN syntax which makes it easier to forget a
JOIN condition:
Oops - I meant harder to forget not easier to forget. Doh.
SELECT c.cst_SiteID, c.cst_IDC, a.asset_ID, o.offer_ID,
o.offer_Name
On Thu, 3 Jun 2004 22:36:55 +0100
Andrew Dixon [EMAIL PROTECTED] wrote:
Hi Everyone.
I have the following SELECT statement the get information from two
tables. The statement only works when it finds a value for the
image_archive.circuit value in the circuits table. However, not all
On Thu, 03 Jun 2004 14:56:23 -0500
Tom Murdock [EMAIL PROTECTED] wrote:
Good evening,
I would like to subscribe to MySQL mailing list.
Thank you.
Your wish appears to have been granted. :)
Josh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Tue, 1 Jun 2004 14:50:11 +0200
Bungarz, Kai [EMAIL PROTECTED] wrote:
Hi!
I'm using mysql-max-nt, Version 5, running on Windows 2000.
While inserting rows into a table from a perl script, i get error
1146:table mysql.proc doesn't exist.
The application ran without any error with mysql,
On Tue, 18 May 2004 10:38:25 -0400
Thomas Trutt [EMAIL PROTECTED] wrote:
Hello everyone,
Is there a way to have the data in a table encrypted so that
the MYD file
can't be opened with a text editor and read??? I need to encrypt or
some how make illegible numeric, date, text,
On Sun, 16 May 2004 13:51:29 -0700
Ron Gilbert [EMAIL PROTECTED] wrote:
I am going to upgrade from 3.23 and was wondering if 4.1.1 is stable
enough? This is just for some personal websites, nothing mission
critical, but on the other hand, I don't want to deal with endless
problems.
On Sun, 16 May 2004 16:02:06 -0700
Ron Gilbert [EMAIL PROTECTED] wrote:
If I switch to 5.0, are there any issues with PHP? Will my 4.2.2
version of PHP work just fine with 5.0? I also have a Windows C++
program that talked to mysql over the Internet via the C API, will
it still work after
Hi,
I teach a class using Oracle and MySQL and I store a few things like creating tables
for student labs in SQL files. I have them load these files by typing:
SOURCE filename.sql;
from the MySQL prompt.
A nice feature in Oracle is that you can set a default path where the client looks for
On Sat, 15 May 2004 14:38:52 -0500
Paul DuBois [EMAIL PROTECTED] wrote:
snip
Is there something similar in MySQL?
No.
Dang - oh well. :)
snip
Also, any idea why SOURCE filename.sql; works in MySQL 5.0.0 and \.
filename.sql; does not?
Leave out the trailing semicolon for short-form
On Fri, 14 May 2004 14:00:46 +0100 (BST)
A Z [EMAIL PROTECTED] wrote:
Hi,
How can I write this query?
Insert into table1 (field1) select (a.field1) from
table2 a where a.field1 not exists (select c.field1
from table1 c)
http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html
Josh
On Thu, 13 May 2004 10:34:37 -0700 (PDT)
David Blomstrom [EMAIL PROTECTED] wrote:
I thought that only InnoDB tables could be joined -
and only if they had foreign keys. But it sounds like
any kind of table can be joined, and it doesn't need a
foreign key.
Exactly, you can do a join with any
On Fri, 14 May 2004 04:38:56 +0200
Lorderon [EMAIL PROTECTED] wrote:
Will MyISAM support transactions in the future versions? Is it
possible?
Not at the moment, I think 5.1 will support foreign keys in MyISAM, but not sure about
transactions...
Josh
--
MySQL General Mailing List
For list
On Mon, 10 May 2004 11:15:25 -0300
Ronan Lucio [EMAIL PROTECTED] wrote:
Is the Primary Key Column mandatory?
Supposing:
If I have two tables: Clients and Cars, and a third table
Clients_R_Cars, that is a relationship between Clients and Cars.
I only need to know what cars the clients
On Tue, 04 May 2004 14:44:26 -0700
Ron Gilbert [EMAIL PROTECTED] wrote:
Is there a better way to be doing this given the huge amount of
binary data I have?
You may wish to also look into replication, which is a cinch to setup with MySQL.
Josh
--
MySQL General Mailing List
For list archives:
On Wed, 5 May 2004 09:18:01 -0700 (PDT)
My Sql [EMAIL PROTECTED] wrote:
Hi all,
I have got one serious doubt.
Can we access mysql database from the front end html. If it all it
is possible, we have to right in javascript. ofcourse we can write
it using JDBC(provided we have a servlet engine
On Wed, 5 May 2004 19:12:00 +0200
Julien Martin [EMAIL PROTECTED] wrote:
Hello,
I have a sql query as follows:
**
SELECT
DB_ESTABLISHMENT_NAME,
AVG(DB_GRADE)
FROM
ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON
On Wed, 5 May 2004 19:41:32 +0200
Julien Martin [EMAIL PROTECTED] wrote:
Hello,
Thanks a lot for the replies. I have changed the query as follows:
**
SELECT
DB_ESTABLISHMENT_NAME,
AVG(DB_GRADE)
FROM
ESTABLISHMENTS ES LEFT OUTER
On Tue, 4 May 2004 09:46:27 -0400
Tucker, Gabriel [EMAIL PROTECTED] wrote:
Hello All:
I am having a problem with both V4.0.16 and 4.0.18. Let me explain:
I have a database with two InnoDB tables in v4.0.16. I backup up
this database every night using the following command:
On Tue, 4 May 2004 11:01:59 -0400
Tucker, Gabriel [EMAIL PROTECTED] wrote:
Luciano
I am confused... As far as I can tell, the set
foreign_key_checks=0; is used with the load data infile command.
Actually, I think that it is used for all operations on the DBMS, not just load data
infile,
On Mon, 3 May 2004 12:39:48 -0500
Boyd E. Hemphill [EMAIL PROTECTED] wrote:
My boss says that if you do a select statement against a table the
result set always comes back in the same order. I say that this is
a myth and that the result is random, except when some ordering is
specified in
On Mon, 03 May 2004 13:21:56 -0500
Bob Ramsey [EMAIL PROTECTED] wrote:
Ah, but the ordering is not random. As your example has it, the
results are in the order that the entries were inserted into the
table. There is an explanation for the order of the returned data.
Conceptually, row order
On Fri, 30 Apr 2004 17:04:57 +0100
joe collins [EMAIL PROTECTED] wrote:
Are there any plans to have triggers introduced into MySQL?
version 5.1 - probably a ways off with 5.0 still alpha.
http://dev.mysql.com/doc/mysql/en/ANSI_diff_Triggers.html
--
MySQL General Mailing List
For list
On Thu, 29 Apr 2004 12:27:46 -0300 (ART)
Leandro Melo [EMAIL PROTECTED] wrote:
Hi,
i got a table wich its pk is an auto_increment field.
I have 10 elements in this table, wich makes the pk_id
field = 10.
I inserted incorrectly anoter row in this table (the
11th) and imediately deleted it.
On Thu, 29 Apr 2004 16:05:56 -0400 (EDT)
[EMAIL PROTECTED] wrote:
hi,
i have a huge database and i want to transfer the data to a
file. can i
tranfer the result of a query to a file for eg.
if i say select * from tablename;
it selects all the tables. but the mysql
On Thu, 29 Apr 2004 23:59:05 +0200
Bjoern Wuest [EMAIL PROTECTED] wrote:
Dear All
I work on a small application with database support. For development I use
the MySQL database which is just doing fine. During testing I experienced a,
in my opinion, strange bug.
I have the following
Does anyone know where I can read more on how to redirect incoming
email (via Sendmail) into MySQL for a given email address?
I understand that I can use [EMAIL PROTECTED] | /path/mysql ... in the
/etc/aliases file to do this, but I would like to see if anyone has
had success with this. I
hi there i was wondering if mysql 4 will become production quality soon
? i would like to convince work to start using it, so i can start using
the transactions, sub selects and query cache
I don't think MySQL 4.0 has sub-selects, that's 4.1.
I've been using 4.0 on two different ISPs for a
MySQL,
My first post, please go easy if this is the wrong pleace!
I'm trying to find an IMAP server which used MySQL so that my Mozilla
Email client can file it's email a little faster.
Has anybody heard of such a device?
I just finished configuring courier-imap to use a MySQL table to
Hi All
Is it possible to mix javascript and PHP in the same script??
Client-side Javascript can be sent to the user along with your html.
For Example:
echo (HTMLHEAD\n);
echo (SCRIPT TYPE=\text/javascript\\n);
echo (!--\n;
echo (function hello() {\n);
echo ( alert('Hi');\n);
echo (}\n);
Anybody seen a general page or study guide for the beta test yet? There
used to be a section on the MySQL site
(http://www.mysql.com/training/candguide/sec-core.htm) but its 404 now
and taking the test here in a couple days. Looked around on the site
but the information doesn't seemed to
Hello All,
I would like to know the some details regarding the transaction
support in Mysql Version 4. May i know where can i find the related
stuffs.
Transactions are supported in the current 3.23.53 release of MySQL-Max and
MySQL 4 (Pro version I think) with the InnoDB table type.
Hi folks,
I just upgraded to mysql-max-3.23.52-1 because I realized that the
standard mysql does not support transactions. I still have a transaction
problem with many clients reading the same data (every read causes an
update on one column so that the read value should be unique in the
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
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few on
http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
than two tables.
Thanks for any suggestions.
I wish there were more examples as well!
I use this for
Josh Trutwin wrote:
SELECT table1.bunch, table2.of, table3.stuff FROM table1
INNER JOIN table2 ON table2.some_id
INNER JOIN table3 ON table3.some_id
WHERE table1.some_id = table2.some_id AND table1.some_id =
table3.some_id;
Your where is sort of in the wrong place ...
SELECT table1
Here is the query that I had in a PhP script that joins a bunch of
tables (I'll try to make this look readable). If you're curious, it's for
a motorcross site (www.springcreekmx.com):
SELECT standings.rank, race.race_date, class.class_name,
racer.racer_name, cycle.cycle_desc,
Hi,
can anyone tell me how can i set the default datetime as current
datetime in the mysql. so that every time i insert a record in the table
current datetime automaticall inserted.
Thanks in advance.
From MySQL manual section 6.5.3:
Default values must be constants. This means, for
I use mysql 3.23.4 max on linux and it have worked just fine.
Now I want to use Transactions so I thougt that I should use the my.cnf
to configure for that.
Trouble is there is no my.cnf file on my computer.
Do I have to create the file myself ?
or is the InnoDB settings configured
We are moving a databse over from Oracle to MySQL 4.0.3 and I was
wondering if I should use MyISAM or InnoDb. The databse currently has
800-900 updates and inserts done to it in a day along with about 1000
selects. Would I run in to any table locking problems with MyISAM?
If you want to
SELECT *
FROM Projects
INNER JOIN KeywordLink ON Projects.Id = KeywordLink.Pid
INNER JOIN Keywords KeywordLink.Kid = Keywords.Id
WHERE Keyword LIKE '%historical%' AND
Keyword like '%scenic%';
Out of curiousity, does the order matter?
I have a JOIN with about 6 tables, some are very small,
Is this an error in Mysql?
I do the follwing command from a shell
grant insert on mydb.* to username@localhost identified by user
'pwd';
When I check the permissions the insert_priv field on user table of
mysql db is set to 'N'.
This always gave me a lot of confusion at first. If
Hi all,
I am writing an application that requires my application to possibly
update the length of a char field while data is being imported into the
db. First, can I update the size/type of a column using UPDATE? Would
someone be willing to give me an example?
You will want to look at
92 matches
Mail list logo
