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 hor
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. Y
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 c
7 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 co
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 Mai
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 re
On Wed, 28 Sep 2005 04:24:08 -0700
Sujay Koduri <[EMAIL PROTECTED]> wrote:
> does anyone have an idea when mysql guys are going to include
foreign key
> support in myisam tables.
> i have read that it is slated for a future release, but it is not
mentioned
> when it is actually scheduled for.
>
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?
> 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 a
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
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
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:
>
>
>
> > This is the third published Beta release in the 5.0 series. All
> > attention will now be foc
On Tue, 31 May 2005 18:01:48 -0500
Matt Wagner <[EMAIL PROTECTED]> wrote:
> 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 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
phpMyAdm
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: http:
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 new
On Mon, 18 Apr 2005 18:04:46 +0200
Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> 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 diff
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 feature
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 12:09:51 -0500
[EMAIL PROTECTED] wrote:
> Of course, the WAMP alternative is always there, Apache is FREE and
> comes with PHP.
FWIW, the download of apache from the Apache website
(http://httpd.apache.org/) does NOT include PhP, you still have to
download and install ph
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 syste
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 finish
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
>
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 ou
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 Tue, 21 Sep 2004 08:57:21 -0400
[EMAIL PROTECTED] wrote:
> 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 colu
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
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
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 co
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
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 f
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
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 stor
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 fu
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 p2_id
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
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 th
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 IN
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 appli
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. Unl
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
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 willi
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 f
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
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
On Sun, 6 Jun 2004 15:48:37 +0200
Dimitri Bosiers <[EMAIL PROTECTED]> wrote:
> 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
>
> con
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 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
> millise
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 unsub
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, 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_SiteI
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
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 wit
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,
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
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
> proble
On Sat, 15 May 2004 14:38:52 -0500
Paul DuBois <[EMAIL PROTECTED]> wrote:
> >Is there something similar in MySQL?
>
> No.
Dang - oh well. :)
> >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-f
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
t
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
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 l
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
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 c
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 L
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
> ES.DB_
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
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 archiv
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
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 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 or
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
> specifie
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 arc
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
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 mys
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 dele
>> 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 wit
> 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 tab
> 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 ("\n");
echo ("\n");
echo ("\n");
echo
> 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
> 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
> Create the record for the user in the user table (do not forget to do
> password=PASSWORD('pastext'))
> Then insert a record in the db table with the db name you want them to
> access and the options.
Or you could use:
GRANT SELECT, UPDATE, INSERT, DELETE ON somedb.* TO someuser@localhost
IDENT
> 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 th
> Dear Sir, Madam,
>
> I was trying to make a comparison on you website between the mysql
> server, acces 2000, microsoft sql server and interbase. Crash-me
> however does not return any information, it does not work. Is it
> possible that you can provide me with this information? I hope to hea
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, race_event.racer_
> 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;
>>
> 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 fo
> 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, fo
> 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 t
> 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 config
> 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 lo
> 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 firs
> 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 s
94 matches
Mail list logo
