escape characters

[Theodore Morse]

Hello everyone!
 
I have an SQL insert statement that contains ' symbols in it, however
as I use the ' symbol to denote the differences between columns in the
VALUES(...) part, I was wondering if there was another way of doing it
so I could include more characters like ' in the statment, a sample
would look something like this:

INSERT INTO parts VALUES('val1', 'val2', 'val3') 

if I did something like:
 
INSERT INTO parts VALUES('val1', 'bob's value', 'val3')

it would die, is there anyway to make that valid, like doing a
\' instead of just '?
 
Theodore Morse 

--
Theodore Morse
CIHOLAS Enterprises
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: multi-table delete

[Anibal Cascais Santos]

Oladapo,

Following Rafal's suggestion, I've tried this and it worked like a charm:

DELETE Customers, orderdetails, orders FROM
Customers, orderdetails, orders
WHERE Customers.customerid =20 AND
orders.CustomerID =20 and
orderdetails.orderid=orders.OrderId;

Thank you

- Original Message -
From: Oladapo Carew [EMAIL PROTECTED]
To: Anibal Cascais Santos [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 4:45 PM
Subject: RE: multi-table delete



 I think you have to specify the join from the customers table to the other
 tables ..

 -Original Message-
 From: Anibal Cascais Santos [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, June 20, 2002 3:38 PM
 To: [EMAIL PROTECTED]
 Subject: multi-table delete


 Hi,

 I'm rather new to mySQL, so maybe that's the problem, but here it goes:
 I'm using version 4.0.1 alpha-max-nt running on W2k server
 the tables I'm using

 CREATE TABLE `customers` (
   `CustomerID` int(11) NOT NULL auto_increment,
   `FullName` varchar(50) default NULL,
   `EmailAddress` varchar(50) default NULL,
   `Password` varchar(50) default NULL,
   PRIMARY KEY  (`CustomerID`)
 ) TYPE=MyISAM;

 CREATE TABLE `orderdetails` (
   `OrderID` int(11) NOT NULL default '0',
   `ProductID` int(11) NOT NULL default '0',
   `Quantity` int(11) default '0',
   `UnitCost` decimal(19,4) default '0.',
   PRIMARY KEY  (`OrderID`,`ProductID`)
 ) TYPE=MyISAM;

 CREATE TABLE `orders` (
   `OrderID` int(11) NOT NULL auto_increment,
   `CustomerID` int(11) default '0',
   `OrderDate` datetime default '-00-00 00:00:00',
   `ShipDate` datetime default '-00-00 00:00:00',
   PRIMARY KEY  (`OrderID`)
 ) TYPE=MyISAM;

 I'm trying to delete Customer 19 and all related orders (in table orders
and
 orderdetails) in one statement (don't even know for sure if it's
possible).
 After reading the documentation I've come up with this:

 DELETE Customers, orderdetails, orders FROM
 Customers, orderdetails, orders
 WHERE Customers.customerid  orders.CustomerID =19;

 this deletes customer 19 from table Customer and all ocurrences of
customer
 19 in table Orders.
 The problem is it also deletes ALL entries from table OrderDetails.
 I want to delete ONLY entries in table OrderDetails that don't have a
 corresponding ocurrence in table Orders, i.e., I need to check wich
orderID
 is present in Orderdetails table that don't exist in the Orders table and
 delete that (too confusing?).
 So, I've tried this

 DELETE Customers, orderdetails, orders FROM
 Customers, orderdetails, orders
 WHERE (Customers.customerid  orders.CustomerID =19)
 AND orders.OrderID  orderdetails.OrderID;

 The result is the same: deletes all rows from OrderDetails.
 Don't really know what else to do...

 Really apreciate any help you can provide

 Thank you
 Aníbal
 --
 Anibal Cascais Santos
 www.engrenagem.net
 --


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Separate List For administration

[Gelu Gogancea]

..Subscribe 


- Original Message - 
From: Nilesh Shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 19, 2002 11:27 PM
Subject: Separate List For administration


MySQL Team,

Can we have separate list for  MySQL administration and replication?.

I am sure there are lots of people here are only interested in Advance
things in mysql.

This is very general list.

Any one agrees with me?.

Nilesh

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: multi-table delete

[Oladapo Carew]

I think you have to specify the join from the customers table to the other
tables ..

-Original Message-
From: Anibal Cascais Santos [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 3:38 PM
To: [EMAIL PROTECTED]
Subject: multi-table delete


Hi,

I'm rather new to mySQL, so maybe that's the problem, but here it goes:
I'm using version 4.0.1 alpha-max-nt running on W2k server
the tables I'm using

CREATE TABLE `customers` (
  `CustomerID` int(11) NOT NULL auto_increment,
  `FullName` varchar(50) default NULL,
  `EmailAddress` varchar(50) default NULL,
  `Password` varchar(50) default NULL,
  PRIMARY KEY  (`CustomerID`)
) TYPE=MyISAM;

CREATE TABLE `orderdetails` (
  `OrderID` int(11) NOT NULL default '0',
  `ProductID` int(11) NOT NULL default '0',
  `Quantity` int(11) default '0',
  `UnitCost` decimal(19,4) default '0.',
  PRIMARY KEY  (`OrderID`,`ProductID`)
) TYPE=MyISAM;

CREATE TABLE `orders` (
  `OrderID` int(11) NOT NULL auto_increment,
  `CustomerID` int(11) default '0',
  `OrderDate` datetime default '-00-00 00:00:00',
  `ShipDate` datetime default '-00-00 00:00:00',
  PRIMARY KEY  (`OrderID`)
) TYPE=MyISAM;

I'm trying to delete Customer 19 and all related orders (in table orders and
orderdetails) in one statement (don't even know for sure if it's possible).
After reading the documentation I've come up with this:

DELETE Customers, orderdetails, orders FROM
Customers, orderdetails, orders
WHERE Customers.customerid  orders.CustomerID =19;

this deletes customer 19 from table Customer and all ocurrences of customer
19 in table Orders.
The problem is it also deletes ALL entries from table OrderDetails.
I want to delete ONLY entries in table OrderDetails that don't have a
corresponding ocurrence in table Orders, i.e., I need to check wich orderID
is present in Orderdetails table that don't exist in the Orders table and
delete that (too confusing?).
So, I've tried this

DELETE Customers, orderdetails, orders FROM
Customers, orderdetails, orders
WHERE (Customers.customerid  orders.CustomerID =19)
AND orders.OrderID  orderdetails.OrderID;

The result is the same: deletes all rows from OrderDetails.
Don't really know what else to do...

Really apreciate any help you can provide

Thank you
Aníbal
--
Anibal Cascais Santos
www.engrenagem.net
--


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: JDBC driver problem

[Alec . Cawley]

 I have a problem with the installation of the JDBC driver for Mysql.
 I have Windows XP and Java2 SDK 1.4.01
 I tried to install the JDBC driver org.gjt.mm.mysql.Driver but every time
I
 try to connect to my database, I get a ClassNotFoundException:
 org.gjt.mm.mysql.Driver error, although I have put the org directory into
 the path of XP.
 I follow the installation notes very carefully but nothing happens.
 Does anyone know anything about this?
 Do you have a better driver to suggest?

You have not been very clear abput how you have done the installation.
However, what you say does not seem to me to match any of the possible
ways of installing the driver.

Firstly, the windows PATH variable is not relevant to java at all. Did you
mean
the CLASSPATH variable? If so, you would have to put the directory *above*
the org directory into the classpath, and compile the mm.mysql sources into
this directory, However, this is *not* the way that I would recommend to
install the driver.

There are two ways I would recommend to install the driver. One is to put
the
mm.mysql.jar file into your CLASSPATH. Not the directory, and not the
you-must-unjar-me file - the mm.mysql.jar file you find inside it. The
second,
which I prefer, is to copy the same file to the %JAVA_HOME%\jre\lib\ext
directory, where JAVA_HOME is the installation directory of the Java SDK -
possibly c:\j2sdk1.4.01 for you.

The mm.mysql driver is by far the most widely used JDBC driver for MySQL,
and is very reliable. I would reccoment that you get it to work fo you
and give it s good try before considering any other better driver.

  Alec Cawley




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: 3.23.51 LIMIT efficiency problem

[central]

At 09:03 PM 6/19/2002, you wrote:
I am using MySQL 3.23.51 on Linux.  I have a fixed-length table with 45
million rows.  It appears MySQL has an efficiency issue with the LIMIT
command.  When I run SELECT a FROM b LIMIT 0, 100   -- that's one
million
The query finishes almost immediately.

But when I run 20 million rows into the dataset, it really slows down.
(pretend the commas aren't there)
SELECT a FROM b LIMIT 20,000,000, 1,000,000

Why would it slow down?  We're dealing with a fixed-length table here.  This
is just mathematics to figure out where row 20,000,000 is.

Confused,
Mark

Mark,
 The slow down is caused by your offset in your limit clause. MySQL 
still has to traverse the offset # of rows (otherwise how would it know 
when to start fetching rows?). Rather than doing an offset, why not do a 
rcd_id range? This will use the index and will be quite fast.

Example:
Select a from b where rcd_id  100 and rcd_id  2000

or

Select a from b where rcd_id  100 limit 100

Because you're not using an offset, it should be quite fast. :)

Mike



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

to mysql list administrators

[Anibal Cascais Santos]

To list mysql list administrator:
Why do I receive this auto responder after posting to this list

-- start
We acknowledge with thanks your email and thanking you once again in showing
your interest with our organization.


Our HRD Team will get back to you as soon as possible.



Best Regards

Team Pentagon Consultants
-- end

Is this a list problem?
Thank you
--
Anibal Cascais Santos
www.engrenagem.net
--



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Lock Issue

[Luciano Barcaro]

Can anyone help me with monitoring locks?

mysql, sql, query


___
Alvaro Online Mail (c) 2001



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Separate List For administration

[Brian Reichert]

On Wed, Jun 19, 2002 at 04:27:59PM -0400, Nilesh Shah wrote:
 MySQL Team,
 
 Can we have separate list for  MySQL administration and replication?.

You can start any mailing you'd like; no one's stopping you.

 I am sure there are lots of people here are only interested in Advance
 things in mysql.
 
 This is very general list.

You're welcome to take any steps you want in moderating any mailing
list you start up, to prevent it from becoming too general.

 Any one agrees with me?.

In gernal, I do. :)

 
 Nilesh
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Can't create a new thread (errno 12). ( 3.23.49 and Linux )

[David BORDAS]

Hi list,

just have this when connecting to my mysql dedicated server :(
The server is like this :
bi PIII 1 Ghz
1Go of ram
Raid 5 scsi hdds

Here is a tail of the error log :
020619 08:03:09  mysqld started
/usr/local/mysql/bin/mysqld: ready for connections

The system don't swap.
Using Linux 2.4.7-10smp #1 SMP
And mysql : 3.23.49 from tar.gz binary 



Here's the my.cnf :
# The MySQL server
[mysqld]
port= 3306
#socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=256M
set-variable= back_log=150
set-variable= record_buffer=1M
set-variable= sort_buffer=1M
set-variable= max_allowed_packet=1M
set-variable= thread_cache_size=8
set-variable= thread_stack=128K
set-variable= max_connections=700
set-variable= max_connect_errors=100
set-variable= table_cache=256
set-variable= net_read_timeout=180
set-variable= net_write_timeout=180
set-variable= wait_timeout=3600

I only have one database and one table ( MyIsam ).
Forums.frm ( 8922 bytes )
Forums.MYD ( 935258712  bytes )
Forums.MYI ( 77645824 bytes )

Show staus say me that max_used_connection is 611.

Did someone have an idea about this ?

Thanks
David 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Separate List For administration

[Don Vu]

agreed...

-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 12:06 PM
To: Nilesh Shah; [EMAIL PROTECTED]
Subject: Re: Separate List For administration


..Subscribe 


- Original Message - 
From: Nilesh Shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 19, 2002 11:27 PM
Subject: Separate List For administration


MySQL Team,

Can we have separate list for  MySQL administration and replication?.

I am sure there are lots of people here are only interested in Advance
things in mysql.

This is very general list.

Any one agrees with me?.

Nilesh

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: 3.23.51 LIMIT efficiency problem

[Benjamin Pflugmann]

Hi.

On Wed 2002-06-19 at 20:03:32 -0600, [EMAIL PROTECTED] wrote:
[...]
 But when I run 20 million rows into the dataset, it really slows down.
 (pretend the commas aren't there)
 SELECT a FROM b LIMIT 20,000,000, 1,000,000
 
 Why would it slow down?  We're dealing with a fixed-length table here.  This
 is just mathematics to figure out where row 20,000,000 is.

And how do you know, how many deleted records are in the range, which
you have to skip?

And as someone else pointed out, without an ORDER BY the query you do
is meaningless, as the implied order undefined (i.e.  the order may
change without notice).

Bye,

Benjamin.

-- 
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can't create a new thread (errno 12). ( 3.23.49 and Linux )

[Gerald Clark]

perror 12

Error code 12:  Cannot allocate memory.

Either :
1. Add memory ( good )
2. Add swap ( Not so good )
3. Tune for less memory usage.

David BORDAS wrote:

Hi list,

just have this when connecting to my mysql dedicated server :(
The server is like this :
bi PIII 1 Ghz
1Go of ram
Raid 5 scsi hdds

Here is a tail of the error log :
020619 08:03:09  mysqld started
/usr/local/mysql/bin/mysqld: ready for connections

The system don't swap.
Using Linux 2.4.7-10smp #1 SMP
And mysql : 3.23.49 from tar.gz binary 



Here's the my.cnf :
# The MySQL server
[mysqld]
port= 3306
#socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=256M
set-variable= back_log=150
set-variable= record_buffer=1M
set-variable= sort_buffer=1M
set-variable= max_allowed_packet=1M
set-variable= thread_cache_size=8
set-variable= thread_stack=128K
set-variable= max_connections=700
set-variable= max_connect_errors=100
set-variable= table_cache=256
set-variable= net_read_timeout=180
set-variable= net_write_timeout=180
set-variable= wait_timeout=3600

I only have one database and one table ( MyIsam ).
Forums.frm ( 8922 bytes )
Forums.MYD ( 935258712  bytes )
Forums.MYI ( 77645824 bytes )

Show staus say me that max_used_connection is 611.

Did someone have an idea about this ?

Thanks
David 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Creation query problem!!

[Me]

Hello, will someone please point out what I am missing
here for these creation query, one uses backquotes,
while the other does not, for some reason, the one
without back quotes errors!! What am i missing??
Is there a reserved word I am missing??
MySQL 3.23.41 

CREATE TABLE email (
  emailid int(11) NOT NULL auto_increment,
  oprid varchar(50) NOT NULL default '',
  folder varchar(50) NOT NULL default '',
  content text,
  custid varchar(20) NOT NULL default '',
  read varchar(5) NOT NULL default '',
  replied varchar(5) NOT NULL default '',
  row_insert_oprid varchar(50) NOT NULL default '',
  row_insert_dt datetime NOT NULL default '-00-00
00:00:00',
  row_update_oprid varchar(50) NOT NULL default '',
  row_update_dt datetime NOT NULL default '-00-00
00:00:00',
  PRIMARY KEY  (emailid)
) TYPE=MyISAM;
ERROR 1064: You have an error in your SQL syntax near
'read varchar(5) NOT NULL default '',
  replied varchar(5) NOT NULL default '',' at line 7

CREATE TABLE `email` (
  `emailid` int(11) NOT NULL auto_increment,
  `oprid` varchar(50) NOT NULL default '',
  `folder` varchar(50) NOT NULL default '',
  `content` text,
  `custid` varchar(20) NOT NULL default '',
  `read` varchar(5) NOT NULL default '',
  `replied` varchar(5) NOT NULL default '',
  `row_insert_oprid` varchar(50) NOT NULL default '',
  `row_insert_dt` datetime NOT NULL default
'-00-00 00:00:00',
  `row_update_oprid` varchar(50) NOT NULL default '',
  `row_update_dt` datetime NOT NULL default
'-00-00 00:00:00',
  PRIMARY KEY  (`emailid`)
) TYPE=MyISAM;

=


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Creation query problem!!

[Jay Blanchard]

I got caught this morning, now it's your turn. read is a reserved word in
MySQL

-Original Message-
From: Me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 12:59 PM
To: [EMAIL PROTECTED]
Subject: Creation query problem!!


Hello, will someone please point out what I am missing
here for these creation query, one uses backquotes,
while the other does not, for some reason, the one
without back quotes errors!! What am i missing??
Is there a reserved word I am missing??
MySQL 3.23.41

CREATE TABLE email (
  emailid int(11) NOT NULL auto_increment,
  oprid varchar(50) NOT NULL default '',
  folder varchar(50) NOT NULL default '',
  content text,
  custid varchar(20) NOT NULL default '',
  read varchar(5) NOT NULL default '',
  replied varchar(5) NOT NULL default '',
  row_insert_oprid varchar(50) NOT NULL default '',
  row_insert_dt datetime NOT NULL default '-00-00
00:00:00',
  row_update_oprid varchar(50) NOT NULL default '',
  row_update_dt datetime NOT NULL default '-00-00
00:00:00',
  PRIMARY KEY  (emailid)
) TYPE=MyISAM;
ERROR 1064: You have an error in your SQL syntax near
'read varchar(5) NOT NULL default '',
  replied varchar(5) NOT NULL default '',' at line 7

CREATE TABLE `email` (
  `emailid` int(11) NOT NULL auto_increment,
  `oprid` varchar(50) NOT NULL default '',
  `folder` varchar(50) NOT NULL default '',
  `content` text,
  `custid` varchar(20) NOT NULL default '',
  `read` varchar(5) NOT NULL default '',
  `replied` varchar(5) NOT NULL default '',
  `row_insert_oprid` varchar(50) NOT NULL default '',
  `row_insert_dt` datetime NOT NULL default
'-00-00 00:00:00',
  `row_update_oprid` varchar(50) NOT NULL default '',
  `row_update_dt` datetime NOT NULL default
'-00-00 00:00:00',
  PRIMARY KEY  (`emailid`)
) TYPE=MyISAM;

=


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

automatically getting type = InnoDB when creating tables

[Robert Kutter]

I have a pre-compiled ODBC program that creates tables and expects them to
be transaction-safe.  I have set up the mysql-max server to support InnoDB
tables.  However, since the program knows nothing about InnoDB tables, it
creates normal tables and fails when it attempts a rollback.  I can fix the
problem using the ALTER command.  I'm wondering if there is a way (using
my.cnf perhaps) that I can tell mysqld to always create tables with type =
InnoDB?

Bob Kutter
TIBCO Software Inc.
http://www.tibco.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Can I be an ASP with PHP?

[René Fournier]

I have a question to which I'm pretty sure the answer will be no, but 
I would like to hope I'm wrong...

I've developed a very simple Content Management tool--called 
Europa--that even retarded monkeys can use to change/update text in 
their web site. It's web-based, user-authenticated (sessions), and runs 
with PHP4 and MySQL.

Now, Europa is pretty much plug and play, so long as the web site is 
getting its text from a MySQL database. There's a web agency in town 
that is interested in Europa for their clients. Their clients want to be 
able to easily and quickly update certain elements of their site without 
begging some outside webmaster. They would really benefit from Europa.

Problem: I don't want to sell Europa, or even install it on someone's 
web server for a one-time fee. I've spent a long time on this little 
tool, and want to continue to improve it. So, I would rather license it 
to companies. They pay a quarterly subscription fee, and get to use 
Europa as it continues to grow and improve.  I'm just a little worried 
about one thing: If I install Europa on their server, and they pay their 
paltry quarterly subscription fee, and then decide they don't need any 
updates, I'm screwed. The value of Europa is much greater than what I 
want to sell subscriptions to it for (not much--I'm not really greedy), 
but I need some kind of control.

The idea: In order for Joe User to update text on his web site, he comes 
to my Europa web site, enters his company name, user ID, password, and 
clicks Login, and--voilà--he sees a handsome list of tables containing 
the text content of his site--which is pulled from a MySQL database 
residing on HIS web site's web host.

And this is the trick: Can PHP somehow fetch MySQL data over the 
Internet? Is this possible? If so, is it necessary for me to resort to 
new, unknown technologies like XML or SOAP, or can I do it with PHP 
alone?

Thanks for your comments.

...Rene

---
René Fournier,
[EMAIL PROTECTED]

Toll-free +1.888.886.2754
Tel +1.403.291.3601
Fax +1.403.250.5228
www.smartslitters.com

SmartSlitters International
#33, 1339 - 40th Ave NE
Calgary AB  T2E 8N6
Canada


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Sub-selects

[Gurhan Ozen]

Take a look at:

http://www.mysql.com/doc/T/O/TODO.html  and
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html

You can do what you want to do easily by using an API (PHP, Perl, etc.) Is
it possible for you to use an external program, or does it have to be SQL
only?
Gurhan

- Original Message -
From: Darley, Terry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 10:29 AM
Subject: Sub-selects


 To Whom It May Concern:

 I've just joined the mailing list for problem sharing/helping and the
first
 2 e-mails I received, demonstrates a need for sub-selects in MySQL. Is
there
 any plan to write this into future releases of MySQL ? If so, when do you
 anticipate this will be released ?

 In the absence of sub-selects how would you solve the problem below ?

 DELETE FROM order_details
 WHERE order_number NOT IN
 (SELECT order_number FROM order_header);

 ... remove all order details where there isn't a record in the order
header
 !

 Much obliged in anticipation.

 Regards,

 Terry


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Creation query problem!!

[Peter Lovatt]

is read a reserved word?

---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
--- 

 -Original Message-
 From: Me [mailto:[EMAIL PROTECTED]]
 Sent: 20 June 2002 18:59
 To: [EMAIL PROTECTED]
 Subject: Creation query problem!!
 
 
 Hello, will someone please point out what I am missing
 here for these creation query, one uses backquotes,
 while the other does not, for some reason, the one
 without back quotes errors!! What am i missing??
 Is there a reserved word I am missing??
 MySQL 3.23.41 
 
 CREATE TABLE email (
   emailid int(11) NOT NULL auto_increment,
   oprid varchar(50) NOT NULL default '',
   folder varchar(50) NOT NULL default '',
   content text,
   custid varchar(20) NOT NULL default '',
   read varchar(5) NOT NULL default '',
   replied varchar(5) NOT NULL default '',
   row_insert_oprid varchar(50) NOT NULL default '',
   row_insert_dt datetime NOT NULL default '-00-00
 00:00:00',
   row_update_oprid varchar(50) NOT NULL default '',
   row_update_dt datetime NOT NULL default '-00-00
 00:00:00',
   PRIMARY KEY  (emailid)
 ) TYPE=MyISAM;
 ERROR 1064: You have an error in your SQL syntax near
 'read varchar(5) NOT NULL default '',
   replied varchar(5) NOT NULL default '',' at line 7
 
 CREATE TABLE `email` (
   `emailid` int(11) NOT NULL auto_increment,
   `oprid` varchar(50) NOT NULL default '',
   `folder` varchar(50) NOT NULL default '',
   `content` text,
   `custid` varchar(20) NOT NULL default '',
   `read` varchar(5) NOT NULL default '',
   `replied` varchar(5) NOT NULL default '',
   `row_insert_oprid` varchar(50) NOT NULL default '',
   `row_insert_dt` datetime NOT NULL default
 '-00-00 00:00:00',
   `row_update_oprid` varchar(50) NOT NULL default '',
   `row_update_dt` datetime NOT NULL default
 '-00-00 00:00:00',
   PRIMARY KEY  (`emailid`)
 ) TYPE=MyISAM;
 
 =
 
 
 __
 Do You Yahoo!?
 Yahoo! - Official partner of 2002 FIFA World Cup
 http://fifaworldcup.yahoo.com
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: How to duplicate records

[Richard DeWath]

Just a thought on something I was reading with temp tables:

1.  extract the records you want to change the date on from your existing 
table to a temp table.
2.  update the date in the temp table
3.  insert the new records back into the original table.

This avoids the csv extract and changing then reinserting.

R.D.

--On Thursday, June 20, 2002 11:32:22 AM -0400 Adam Nelson 
[EMAIL PROTECTED] wrote:

 I have looked at this problem before and I honestly think there is not a
 proper way to do it within mysql.  The only ways are cut  paste,
 programmatically, or subselects (slated for 4.1?).

 -Original Message-
 From: Carlos Fernando Scheidecker Antunes [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, June 18, 2002 2:40 PM
 To: Don Vu
 Cc: MySQL List
 Subject: Re: How to duplicate records


 Don,

 Thank you very much.

 The only problem is that the primary index Code, Model and Year and what
 I
 need is to duplicate the Code, Model and Units for a different year,
 2003,
 that does not exist. If I do the statement bellow it won't work. What I
 need
 is to insert Code, Model, Units for a specific code match but they have
 to
 be duplicated for year 2003.

 Thanks again,

 C.F.



 - Original Message -
 From: Don Vu [EMAIL PROTECTED]
 To: Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED]; MySQL
 List [EMAIL PROTECTED]
 Sent: Tuesday, June 18, 2002 9:38 AM
 Subject: RE: How to duplicate records


 mabye an insert into...select will work, something like:

 INSERT INTO new tablename
 SELECT Code, Model, Units
 from original table
 where Year=2003
 and ((Code = 'N200') or (Code='N205'));

 http://www.mysql.com/doc/I/N/INSERT_SELECT.html

 -Don

 -Original Message-
 From: Carlos Fernando Scheidecker Antunes
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, June 18, 2002 10:25 AM
 To: MySQL List
 Subject: How to duplicate records
 Importance: High


 Hello all,

 I've got some records of a Database that I would like to duplicate if
 possible with an statement.

 The table has Code, Model, Year, units. The primary key is Code, Model
 and
 Year. What I need is to duplicate Code, Model and units for a
 different
 year.

 Say I want to duplicate all records which Code are N200 and N205 with
 the
 same model and same units but for year 2003.

 Is there any select and insert/replace statement to acomplish this?

 There are about 3.000 records and doing that manually is impossible. I
 am
 considering dump the whole file to a .csv and change year to 2003 and
 then
 reinsert it.

 Is there any way to do it in a smart way? Meaning an SQL statement.

 Thank you,

 Carlos Fernando.


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






Richard DeWath
System Administrator
E.L. and Associates
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problems with SQL_SELECT_LIMIT

[Flavio Reis]

Hi.
I have an urgent question:
How can I set the variable sql_select_limit as a global variable, which
everytime that I open the MySQL it's set to the value that I determinated. I
want to know how set this variable in the mysql.conf (where and how), not
inside the BD!
Thank you!!!
Flávio



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: escape characters

[Gurhan Ozen]

Yes...
You can just use \' to denote single quotes..
See: http://www.mysql.com/doc/S/t/String_syntax.html
Gurhan

- Original Message -
From: Theodore Morse [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 11:48 AM
Subject: escape characters


 Hello everyone!

 I have an SQL insert statement that contains ' symbols in it, however
 as I use the ' symbol to denote the differences between columns in the
 VALUES(...) part, I was wondering if there was another way of doing it
 so I could include more characters like ' in the statment, a sample
 would look something like this:

 INSERT INTO parts VALUES('val1', 'val2', 'val3')

 if I did something like:

 INSERT INTO parts VALUES('val1', 'bob's value', 'val3')

 it would die, is there anyway to make that valid, like doing a
 \' instead of just '?

 Theodore Morse

 --
 Theodore Morse
 CIHOLAS Enterprises
 [EMAIL PROTECTED]


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: JDBC driver problem

[Francisco Reinaldo]

Which driver are you using? I use
mm.mysql-2.0.4-bin.jar

Which IDE are you using? If you are using JBuilder 5,
you have to go to required library and add one
pointing to that file. If you are building a jar file
from your classes, you have to make sure that you tell
the library to include this JDBC jar file. You can do
that from the library properties. Then you only have
to execute your application using java myapp.jar.

If you are not building a jar file, you can do two
things:
- Make sure that your CLASSPATH includes the jat file
name with the path.
CLASSPATH=C:\pleasework\jdbc\mysql\mm.mysql-2.0.4-bin.jar
or
- If you don't want to modify the CLASSPATH: java
-classpath
C:\pleasework\jdbc\mysql\mm.mysql-2.0.4-bin.jar
myapp.jar.

Good Luck!
--- Myrto Karyda [EMAIL PROTECTED] wrote:
 I have a problem with the installation of the JDBC
 driver for Mysql. 
 I have Windows XP and Java2 SDK 1.4.01
 I tried to install the JDBC driver
 org.gjt.mm.mysql.Driver but every time I
 try to connect to my database, I get a
 ClassNotFoundException:
 org.gjt.mm.mysql.Driver error, although I have put
 the org directory into
 the path of XP.
 I follow the installation notes very carefully but
 nothing happens.
 Does anyone know anything about this?
 Do you have a better driver to suggest?
 
 
 

-
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list
 archive)
 
 To request this thread, e-mail
 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Can I be an ASP with PHP?

[Peter Lovatt]

No problem

I have a mysql server sited 150 miles from the php server (more by accident
than design, but it works day in day out)

Just set the connection parameter with the IP of the Mysql server and it
works. php doesn't know or care whether mysql is on the same machine or one
the other side of the world

mysql_connect ( 123.456.123.456 , username , password )

HTH

Peter

---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---

 -Original Message-
 From: René Fournier [mailto:[EMAIL PROTECTED]]
 Sent: 20 June 2002 19:33
 To: [EMAIL PROTECTED]
 Subject: Can I be an ASP with PHP?


 I have a question to which I'm pretty sure the answer will be no, but
 I would like to hope I'm wrong...

 I've developed a very simple Content Management tool--called
 Europa--that even retarded monkeys can use to change/update text in
 their web site. It's web-based, user-authenticated (sessions), and runs
 with PHP4 and MySQL.

 Now, Europa is pretty much plug and play, so long as the web site is
 getting its text from a MySQL database. There's a web agency in town
 that is interested in Europa for their clients. Their clients want to be
 able to easily and quickly update certain elements of their site without
 begging some outside webmaster. They would really benefit from Europa.

 Problem: I don't want to sell Europa, or even install it on someone's
 web server for a one-time fee. I've spent a long time on this little
 tool, and want to continue to improve it. So, I would rather license it
 to companies. They pay a quarterly subscription fee, and get to use
 Europa as it continues to grow and improve.  I'm just a little worried
 about one thing: If I install Europa on their server, and they pay their
 paltry quarterly subscription fee, and then decide they don't need any
 updates, I'm screwed. The value of Europa is much greater than what I
 want to sell subscriptions to it for (not much--I'm not really greedy),
 but I need some kind of control.

 The idea: In order for Joe User to update text on his web site, he comes
 to my Europa web site, enters his company name, user ID, password, and
 clicks Login, and--voilà--he sees a handsome list of tables containing
 the text content of his site--which is pulled from a MySQL database
 residing on HIS web site's web host.

 And this is the trick: Can PHP somehow fetch MySQL data over the
 Internet? Is this possible? If so, is it necessary for me to resort to
 new, unknown technologies like XML or SOAP, or can I do it with PHP
 alone?

 Thanks for your comments.

 ...Rene

 ---
 René Fournier,
 [EMAIL PROTECTED]

 Toll-free +1.888.886.2754
 Tel +1.403.291.3601
 Fax +1.403.250.5228
 www.smartslitters.com

 SmartSlitters International
 #33, 1339 - 40th Ave NE
 Calgary AB  T2E 8N6
 Canada


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Creation query problem!!

[Gurhan Ozen]

Yes it is..
For a list of reserved words, see:
http://www.mysql.com/doc/R/e/Reserved_words.html
Gurhan

- Original Message -
From: Peter Lovatt [EMAIL PROTECTED]
To: Me [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 2:29 PM
Subject: RE: Creation query problem!!


 is read a reserved word?

 ---
 Excellence in internet and open source software
 ---
 Sunmaia
 www.sunmaia.net
 [EMAIL PROTECTED]
 tel. 0121-242-1473
 ---

  -Original Message-
  From: Me [mailto:[EMAIL PROTECTED]]
  Sent: 20 June 2002 18:59
  To: [EMAIL PROTECTED]
  Subject: Creation query problem!!
 
 
  Hello, will someone please point out what I am missing
  here for these creation query, one uses backquotes,
  while the other does not, for some reason, the one
  without back quotes errors!! What am i missing??
  Is there a reserved word I am missing??
  MySQL 3.23.41
 
  CREATE TABLE email (
emailid int(11) NOT NULL auto_increment,
oprid varchar(50) NOT NULL default '',
folder varchar(50) NOT NULL default '',
content text,
custid varchar(20) NOT NULL default '',
read varchar(5) NOT NULL default '',
replied varchar(5) NOT NULL default '',
row_insert_oprid varchar(50) NOT NULL default '',
row_insert_dt datetime NOT NULL default '-00-00
  00:00:00',
row_update_oprid varchar(50) NOT NULL default '',
row_update_dt datetime NOT NULL default '-00-00
  00:00:00',
PRIMARY KEY  (emailid)
  ) TYPE=MyISAM;
  ERROR 1064: You have an error in your SQL syntax near
  'read varchar(5) NOT NULL default '',
replied varchar(5) NOT NULL default '',' at line 7
 
  CREATE TABLE `email` (
`emailid` int(11) NOT NULL auto_increment,
`oprid` varchar(50) NOT NULL default '',
`folder` varchar(50) NOT NULL default '',
`content` text,
`custid` varchar(20) NOT NULL default '',
`read` varchar(5) NOT NULL default '',
`replied` varchar(5) NOT NULL default '',
`row_insert_oprid` varchar(50) NOT NULL default '',
`row_insert_dt` datetime NOT NULL default
  '-00-00 00:00:00',
`row_update_oprid` varchar(50) NOT NULL default '',
`row_update_dt` datetime NOT NULL default
  '-00-00 00:00:00',
PRIMARY KEY  (`emailid`)
  ) TYPE=MyISAM;
 
  =
 
 
  __
  Do You Yahoo!?
  Yahoo! - Official partner of 2002 FIFA World Cup
  http://fifaworldcup.yahoo.com
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: How to duplicate records

[Keith C. Ivey]

On 20 Jun 2002, at 11:35, Richard DeWath wrote:

 Just a thought on something I was reading with temp tables:
 
 1.  extract the records you want to change the date on from your existing 
 table to a temp table.
 2.  update the date in the temp table
 3.  insert the new records back into the original table.
 
 This avoids the csv extract and changing then reinserting.

You don't need a separate step to update the date.  When extracting 
the records into the temporary table, just change SELECT Code, 
Model, Units, Year to SELECT Code, Model, Units, 2003 in your SQL.

-- 
Keith C. Ivey [EMAIL PROTECTED]
Tobacco Documents Online
http://tobaccodocuments.org

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Transaction with InnoDB - how to lock?

[Morten Winther]

Hello

I have a system where users are able to buy tickets to shows etc. 

Right now I use the MyISAM as tabletype but I would like to try InnoDB to
make safe transactions. For the moment I use a TABLE LOCK to make sure that
the same ticket isn't sold twise.

One of the table consists on these 3 fields: (order_id, show_id, seat_id)

So a normal script does this:

Lock tables
select to see if the tickets is already sold
insert new sold ticket if no one is already there
unlock

Obviously I don't want another user to insert a new ticket just after if
checked but right before current user inserts.

Now - how would I do this with InnoDB to make it safe?

Best regards

Morten

(now pass the maillist filter; sql, mysql, query) 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Unicode

[toby -]

i asked the same very question just yesterday 
 heres the reply i got for it ... i hope it helps u too 
good luck ...

toby 



Not natively (i.e. you can't sort on a Unicode field, for example), but
you can still store Unicode text in fields.  Just use a BLOB or you can
even use VARCHAR(), et al, but remember that you only get half as many
Unicode characters as you specify in the field width...

If you're using the native mysql API, you've also got to remember to
escape all your text properly (i.e. cast it to a char * and convert any
NULs to \0, etc).  Some of the other APIs out there (JDBC or ODBC,
etc) might have better binary support (i.e. you might not have to worry
about it for them, just give a data pointer and field length to them)
but I don't use them, so I'm not sure...

Also realise that almost all the client tools out there don't recognise
Unicode and so will only display the first character of your string (or
something similar, depending on what's actually stored in the string).

My application uses Unicode for almost everything (though I don't need
to sort on any text fields so it's OK) and I've not had any problems...

Dean Harding.


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: automatically getting type = InnoDB when creating tables

[Mark Matthews]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Robert Kutter wrote:
| I have a pre-compiled ODBC program that creates tables and expects them to
| be transaction-safe.  I have set up the mysql-max server to support InnoDB
| tables.  However, since the program knows nothing about InnoDB tables, it
| creates normal tables and fails when it attempts a rollback.  I can
fix the
| problem using the ALTER command.  I'm wondering if there is a way (using
| my.cnf perhaps) that I can tell mysqld to always create tables with type =
| InnoDB?
|
| Bob Kutter
| TIBCO Software Inc.
| http://www.tibco.com

No problem. In your my.cnf add the line

set-variable = default-table-type=InnoDB

And then restart your server.

-Mark



- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

~   __  ___ ___   __
~  /  |/  /_ __/ __/ __ \/ /  Mark Matthews [EMAIL PROTECTED]
~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
~   ___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6-2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAj0SM0AACgkQtvXNTca6JD98WgCeJefl2qOO6Z/5+jVuSO9/iCMF
WpcAn1kshjSbC51LUyzqysWdzWIJl4OG
=a39+
-END PGP SIGNATURE-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: locking on row level ...

[Galen Wright-Watson]

On Wed, 19 Jun 2002, Silmara Cristina Basso wrote:

 I'm newbie MySQL and I'm using MySQL-max 4.0.1(Innodb), with one application
 developed in Delphi and connect through MyODBC. The question is ...
 How can i do to lock one row so that it is editing in the application?



The impression I get from the documentation is MySQL only supports table
locking for ISAM/MyISAM and HEAP tables and page level locking for BDB tables.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Left Join Query Too Slow

[Galen Wright-Watson]

On Thu, 20 Jun 2002, Javier Campoamor wrote:

 Hi,

 I have a problem with the next query because it's too slow (10 seconds) and
 I need to do 10 queries like this one to show a page.

 QUERY

   SELECT
   h.Hour, count(c.Amount) As NumberOfCalls, sum(c.Amount) As Amount
   FROM
   Bill b, Hour h
   LEFT JOIN
   Call c
   ON
   c.Type='N' AND
   b.date = '2001-06-01' AND
   b.date = DATE_SUB('2001-06-01', INTERVAL 1 MONTH) AND
   b.BillNumber = c.BillNumber AND
   h.HourId = HOUR(c.Hour)
   GROUP BY
   h.Hour
   ORDER BY
   h.HourId;

 /QUERY
snip
 I have already created index for the Call.BillNumber and the Bill.BillNumber
 fields, and it has helped (from 40 second to 10 seconds) but it doesn't
 solve the problem.


What about creating more indices, on (say) Bill.date, Hour.HourID or Call.Type?


 Do you have any idea about the way to optimize it?

 Thanks in advance

 Javier




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL: Temporary Tables / Subselects

[Galen Wright-Watson]

On Thu, 20 Jun 2002, Seth Yount wrote:

 Hello experts

I'm glad you think so highly of us.


I am trying to decide which would be the most efficient way of
 retrieving data, Subselects (nested queries?) or Temporary Tables?

 Does MySQL even support these yet?

MySQL supports temporary tables, but not sub-selects. Manual section 6.5.3 has
details on the CREATE TEMPORARY TABLE ... command and A.6.3 lists a few
problems with temporary tables.  Section 1.4.4.1 discusses sub-selects.


Any advice / examples would be greatly appreciated.

 Seth --



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL jdbc updateable recordsets

[Mark Matthews]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Morris Ford wrote:
| Mark,
|   I verified that I am using the latest version. I
| have written a small test java program using jdbc
| to test updating through a resultset and whenever
| I use resultSet.updateString(x, y), I get an
| exception that the resultset is not updateable.
| Are there any issues involved with required
| structure of the table in tha database or
| something else like that? I have attached the
| source for the java program.
| Morris Ford
|
| --- Mark Matthews [EMAIL PROTECTED]
| wrote:
|
|-BEGIN PGP SIGNED MESSAGE-
|Hash: SHA1
|
|Morris Ford wrote:
|| Several Questions:
||
|| Does the 'MM' jdbc driver for MySQL support
|| updateable record sets?
|
|Yes, it has for a year or so. You should make
|sure you're using the
|latest version, 2.0.14, available from
|http://mmmysql.sourceforge.net/
|
|
- -Mark
|
|
|
|-BEGIN PGP SIGNATURE-
|Version: GnuPG v1.0.6-2 (MingW32)
|Comment: Using GnuPG with Mozilla -
|http://enigmail.mozdev.org
|
|
|
| iEYEARECAAYFAj0R50cACgkQlyjUJM+7nP7a7gCgjIh0SRgPyG9e4g2DamDbaZgD
|
|LDsAn04fYBQhFr4stgg2oN+yijRNUaGL
|=gb8M
|-END PGP SIGNATURE-
|
|
|
|
| -
|
|Before posting, please check:
|   http://www.mysql.com/manual.php   (the
|manual)
|   http://lists.mysql.com/   (the list
|archive)
|
|To request this thread, e-mail
|[EMAIL PROTECTED]
|To unsubscribe, e-mail
|
|
| [EMAIL PROTECTED]
|
|Trouble unsubscribing? Try:
|http://lists.mysql.com/php/unsubscribe.php
|
|
|
|
|
|
| __
| Do You Yahoo!?
| Yahoo! - Official partner of 2002 FIFA World Cup
| http://fifaworldcup.yahoo.com

Have you read the JDBC spec? ResultSets are not updateable if the result
set references more than one table, or does not include the primary
key(s) of the table. Your table must have primary keys, and you must
have them selected in the query that generates the ResultSet. Otherwise,
~ the driver can not uniquely identify the row you are trying to update.

-Mark

- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

~   __  ___ ___   __
~  /  |/  /_ __/ __/ __ \/ /  Mark Matthews [EMAIL PROTECTED]
~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
~   ___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6-2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAj0SP+IACgkQtvXNTca6JD+GEACeM60s7PGBnpURr+LJyu4lnIxM
cFYAoJogiAQn6xYYKriTCMvUBMxRoOoF
=bYWY
-END PGP SIGNATURE-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MD5

[Kiss Dániel]

Hi everyone,

Can anyone tell me how to create an MD5 checksum on a file.
I tried to do this by using the MySQL MD5 function, but it does not work on 
too big files (above 650MB), even if I set max_allow_packet size very big.
Is there any small program to do this, anyway?

Thx
Daniel




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problems with SQL_SELECT_LIMIT

[Galen Wright-Watson]

On Thu, 20 Jun 2002, Flavio Reis wrote:

 Hi.
 I have an urgent question:
 How can I set the variable sql_select_limit as a global variable, which
 everytime that I open the MySQL it's set to the value that I determinated. I
 want to know how set this variable in the mysql.conf (where and how), not
 inside the BD!
 Thank you!!!
 Flávio


After going through the documentation (and messing with the server
configuration file), it appears there is no method of setting sql_select_limit
(or select_limit) from the server config file.  However, if you're running MySQL
on a Unix system, you could 'alias mysql mysql -O select_limit=$LIMIT' in the
global login scripts, or 'mv mysql mysql.orig' and create a shell script called
'mysql' with the line 'mysql -O select_limit=$LIMIT' (replace $LIMIT with
whatever value you want).



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RES: Problems with SQL_SELECT_LIMIT

[Flavio Reis]

Hi Galen!
The problem is that command act on client, I need a command to act on server
(mysqld)!
Thanks
[]s
Flavio

-Mensagem original-
De: Galen Wright-Watson [mailto:[EMAIL PROTECTED]]
Enviada em: quinta-feira, 20 de junho de 2002 18:18
Para: Flavio Reis
Cc: [EMAIL PROTECTED]
Assunto: Re: Problems with SQL_SELECT_LIMIT




On Thu, 20 Jun 2002, Flavio Reis wrote:

 Hi.
 I have an urgent question:
 How can I set the variable sql_select_limit as a global variable, which
 everytime that I open the MySQL it's set to the value that I determinated.
I
 want to know how set this variable in the mysql.conf (where and how), not
 inside the BD!
 Thank you!!!
 Flávio


After going through the documentation (and messing with the server
configuration file), it appears there is no method of setting
sql_select_limit
(or select_limit) from the server config file.  However, if you're running
MySQL
on a Unix system, you could 'alias mysql mysql -O select_limit=$LIMIT' in
the
global login scripts, or 'mv mysql mysql.orig' and create a shell script
called
'mysql' with the line 'mysql -O select_limit=$LIMIT' (replace $LIMIT with
whatever value you want).



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: locking on row level ...

[Heikki Tuuri]

Hi!

- Original Message -
From: Galen Wright-Watson [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, June 20, 2002 11:32 PM
Subject: Re: locking on row level ...



 On Wed, 19 Jun 2002, Silmara Cristina Basso wrote:

  I'm newbie MySQL and I'm using MySQL-max 4.0.1(Innodb), with one
application
  developed in Delphi and connect through MyODBC. The question is ...
  How can i do to lock one row so that it is editing in the application?
 
 

 The impression I get from the documentation is MySQL only supports table
 locking for ISAM/MyISAM and HEAP tables and page level locking for BDB
tables.

InnoDB type tables in MySQL have row level locking. Call SET AUTOCOMMIT=0 or
wrap your transaction in BEGIN ... COMMIT.

Make sure you have an index on column 'mycol' so that InnoDB finds the row
without a table scan. Then you can lock a row:

SELECT * FROM mytable WHERE mycol = xxx LOCK IN SHARE MODE;

or

SELECT * FROM mytable WHERE mycol = xxx FOR UPDATE;


The upper query sets a shared lock (= read lock), and the lower one an
exclusive lock (= write lock) on the row.

Note that if you do

UPDATE mytable SET mycol2 = yyy WHERE mycol = xxx;

then InnoDB automatically locks the row with an exclusive lock.

Note also that an ordinary SELECT

SELECT * FROM mytable WHERE mycol = xxx;

does NOT lock the row. It is a 'consistent read' which reads the database as
it is at a point in time, seeing only the committed transactions (and also
the current transaction of the user who does the SELECT).

Best regards,

Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MD5

[Joshua J . Kugler]

If you are running Linix, at the prompt type:

md5sum filename

I'm sure you can get md5sum for other Unices as well.

j- k-

On Thursday 20 June 2002 13:00, Kiss Dániel wrote:
 Hi everyone,

 Can anyone tell me how to create an MD5 checksum on a file.
 I tried to do this by using the MySQL MD5 function, but it does not work on
 too big files (above 650MB), even if I set max_allow_packet size very big.
 Is there any small program to do this, anyway?

 Thx
   Daniel
-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Newbie question

[Emma Grant]

Hi, I am just starting out with mysql. 

MySQL allows anon access so I don't have to log on to the sql just the
linu server. 

I am trying to create a test database 'test2'. I am logged on as my user
'emil' (not root) on a test linux  server. When I go to create the
database: 

mySQL CREATE DATABASE test2; 

It gives me the following error. 

Error: 1044: Access denied for user '@localhost' for database test2

I then log in as root and change my privelages: 

mySQL  GRANT ALL ON test2.* for emil;

But still I get the same error when I try to create it.

In fact, I can't get on to a database even if the root creates it and
then I GRANT the user 'emil' ALL to the newly created database.

Can someone direct me in the right place?   

Thanks, 

Emma



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: locking on row level ...

[Cal Evans]

Short answer:
You don't. That's not the way SQL databases work.  When you hear of 'row
level locking' it means something different than you are used to if you are
coming from Access/Foxpro.

If you are using InnoDB tables then you can:
BEGIN TRANS
  statement
  statement
  statement
COMMIT or ROLLBACK


Long answer:
If you are coming from a FoxPro background (as I am) then you are used to
being able to issue a RLOCK() and the database will place a lock on that
record not allowing anyone else to touch it into you are done with it. (If
your background is not FoxPro then I'm sure the desktop DB you are using has
something similar).

You don't do that in SQL.

However, in times past, when I've felt the overwhelming urge to regress, I
have built systems that have a LOCK field. (i.e. userLock varChar(10))  Then
when someone wanted to 'lock' the record, I would write their userID in the
lock field with an update statement.

Then before granting someone else a lock on the record, I would check to
make sure that someone else didn't already have it locked. The downside to
this methodology is that you are increasing your hits on the database
server.  If your application is not busy then it's not a major deal. If,
however, you have a busy server, this will cause it to be busier.

Once the user with the lock issues their UPDATE statement then I issue a
second UPDATE to clear the lock (or if you want to get fancy, clear it in
the first UPDATE with a userLock='')

Anyhow, if you study how databases are built in SQL you won't find a lot of
this type of programming.  I now rely much more on transactions to keep
things straight. Yes, this means that two users could issue updates almost
at the same time.  Last one to the database wins.

HTH,
=C=

-Original Message-
From: Silmara Cristina Basso [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 19, 2002 1:10 PM
To: [EMAIL PROTECTED]
Subject: locking on row level ...


I'm newbie MySQL and I'm using MySQL-max 4.0.1(Innodb), with one application
developed in Delphi and connect through MyODBC. The question is ...
How can i do to lock one row so that it is editing in the application?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MD5

[Ed Carp]

 -Original Message-
 From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, June 20, 2002 4:30 PM
 To: Kiss Dániel; [EMAIL PROTECTED]
 Subject: Re: MD5

 If you are running Linix, at the prompt type:

 md5sum filename

 I'm sure you can get md5sum for other Unices as well.

It's either md5 or md5sum on most UNIX-like operating systems.  I don't think the 
MySQL MD5 function is designed for large amounts
of data.  Escapade provides it's own MD5 function because of this, I'm not sure about 
PHP.
--
Ed Carp, N7EKG  http://www.pobox.com/~erc   214/986-5870
Director, Software Development
Escapade Server-Side Scripting Engine Development Team
Pensacola - Dallas - London - Dresden
http://www.squishedmosquito.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Foreign Key Worries

[Michael Ivanyo]

Friends,

I am designing a MySql DB schema that will use foreign
keys similar to:

create table orders(id int auto_increment primary key,
amount double(7,2) );

create table orderItems(id int, item char(20), price
double(5,2), quantity int, key(id), foreign key id
references orders (id));

I am currently not using a version that supports
foreign keys but hope to be in the future.  In the
meantime I'll need to implement the foreign key
constraints through my application.  My concern is
that if either of the tables get corrupted or out of
sync I won't be able to match up the order items with
the orders.

Is there anything that I might do to ensure that I'll
be able to recover if the tables get out of sync? 
I've thought of adding timestamp columns to each table
as an aid in matching up the records but am not sure
how helpful this would be or if it would be worth the
extra storage space.  Any comments about your
experience using foreign keys and MySql would be
appreciated.

--Michael



__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Newbie question

[Cal Evans]

The problem is that you don't have permissions to create the database test2.
Therefore you can't grant yourself any permissions on it becuase it does not
exist yet.

Have you mysql administrator give you permission to create databases or have
him/her create it for you and give you access to it.

=C=

-Original Message-
From: Emma Grant [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 4:31 PM
To: [EMAIL PROTECTED]
Subject: Newbie question


Hi, I am just starting out with mysql.

MySQL allows anon access so I don't have to log on to the sql just the
linu server.

I am trying to create a test database 'test2'. I am logged on as my user
'emil' (not root) on a test linux  server. When I go to create the
database:

mySQL CREATE DATABASE test2;

It gives me the following error.

Error: 1044: Access denied for user '@localhost' for database test2

I then log in as root and change my privelages:

mySQL  GRANT ALL ON test2.* for emil;

But still I get the same error when I try to create it.

In fact, I can't get on to a database even if the root creates it and
then I GRANT the user 'emil' ALL to the newly created database.

Can someone direct me in the right place?

Thanks,

Emma



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem importing data from SQL server 2000 to mysql

[Roma Gupta]

Hi,

I want to migrate data from SQL Server 2000 to Mysql.

My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command 

LOAD DATA INFILE c:/mysql/roma/mailmessagetext_table.txt INTO TABLE
mailmessagetext_table;

For the field messagetext - varchar(7900), it only migrated few
characters, not the complete length

Please help
Thanks
Roma




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Sub-selects

[Jon Frisby]

In MySQL 4.0.x:

DELETE order_details FROM order_details LEFT OUTER JOIN order_header ON
(order_details.order_number = order_header.order_number) WHERE
order_header.order_number IS NULL;

-JF
 -Original Message-
 From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, June 20, 2002 11:35 AM
 To: Darley, Terry; [EMAIL PROTECTED]
 Subject: Re: Sub-selects


 Take a look at:

 http://www.mysql.com/doc/T/O/TODO.html  and
 http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html

 You can do what you want to do easily by using an API (PHP, Perl, etc.) Is
 it possible for you to use an external program, or does it have to be SQL
 only?
 Gurhan

 - Original Message -
 From: Darley, Terry [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, June 20, 2002 10:29 AM
 Subject: Sub-selects


  To Whom It May Concern:
 
  I've just joined the mailing list for problem sharing/helping and the
 first
  2 e-mails I received, demonstrates a need for sub-selects in MySQL. Is
 there
  any plan to write this into future releases of MySQL ? If so,
 when do you
  anticipate this will be released ?
 
  In the absence of sub-selects how would you solve the problem below ?
 
  DELETE FROM order_details
  WHERE order_number NOT IN
  (SELECT order_number FROM order_header);
 
  ... remove all order details where there isn't a record in the order
 header
  !
 
  Much obliged in anticipation.
 
  Regards,
 
  Terry
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Left Join Query Too Slow

[Francisco Reinaldo]

Hola Javier,

It is difficult to tell because you did not include
the table structures, relationships, indices, etc.
But... at a first glance we is killing you query
anyways is this:
   FROM
   Bill b, Hour h
The poor db engine is probably creating a huge
temporary table with all possible combinations between
Bill and Hour. Is this really what you want to do?

Good Luck!
--- Javier Campoamor [EMAIL PROTECTED] wrote:
 Hi,
 
 I have a problem with the next query because it's
 too slow (10 seconds) and
 I need to do 10 queries like this one to show a
 page.
 
 QUERY
 
   SELECT
   h.Hour, count(c.Amount) As NumberOfCalls,
 sum(c.Amount) As Amount
   FROM
   Bill b, Hour h
   LEFT JOIN
   Call c
   ON
   c.Type='N' AND
   b.date = '2001-06-01' AND
   b.date = DATE_SUB('2001-06-01', INTERVAL 1 MONTH)
 AND
   b.BillNumber = c.BillNumber AND
   h.HourId = HOUR(c.Hour)
   GROUP BY
   h.Hour
   ORDER BY
   h.HourId;
 
 /QUERY
 
 In this query the Calls table is big (70.000 rows)
 but the two other tables
 are really small (24  20 rows).
 
 When I try to show only the summary for the hours
 when there has been Calls
 (without the Hour table and the LEFT JOIN), it takes
 only 0,5 seconds but I
 need to use the Hour table to obtain also the
 summary for the hours when
 there hasn't been calls.
 
 I have already created index for the Call.BillNumber
 and the Bill.BillNumber
 fields, and it has helped (from 40 second to 10
 seconds) but it doesn't
 solve the problem.
 
 I though that the problem were in the HOUR(c.Hour)
 but I used a fixed value
 and the query is still slow.
 
 Do you have any idea about the way to optimize it?
 
 Thanks in advance
 
 Javier
 
 
 

-
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list
 archive)
 
 To request this thread, e-mail
 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [PHP] Installing Syncronizing

[Dave Goodrich]

On Thu, Jun 20, 2002 at 07:26:37PM -0300, César Aracena wrote:
 Hello all,
  
 I have this client who has a T connection and would like to run a PHP /
 MySQL based program in local mode, but also be able to make the data
 available from the web but hosted in a remote server… kinda strange u
 think? Me too… The problem is that his server doesn’t run with IIS but
 with a little ap called WinGate, which gives him all the approach for
 his little network. Have anyone installed the PHP / MySQL under MS NT4.0
 running WinGate before? Anything to tell me that will help me in the
 process?

Do you mean the Wingate connection sharing software? 

The experiences I have with clients running Wingate were not good. My
thoughts are that if the customer can pay you for the application then
they can pay for a gateway router. SOHO routers are not expensive. 

The customers connection will work better, his application will be more 
stable, and your task will be easier. Everyone wins.

But then again, it is just my opinion ;^)

DAve


-- 
Dave Goodrich
System Administrator
TLS.NET
Columbus IN
http://tls.net
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Using web forms and webpages to access/view mysql data

[Emma Grant]

Hi all, 

I successfully created and added data to my database!

Does anyone know any good websites where I can learn to insert, update
data using a web form and CGI?

How does mysql perform when displaying images (jpg, gif) on a web page,
that have been stored as BLOB file?

I am new to this stuff, and I am really having a good time with it. 

Thanks, 

Emma 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Using web forms and webpages to access/view mysql data

[Gerald R. Jensen]

Emma:

It really depends on the language you wish to use ... could be Perl, ASP,
PHP, etc.

If you choose PHP, check out http://www.phpbeginner.com. You can obtain PHP
(and find other useful links) from http://www.php.net

Gerald Jensen

- Original Message -
From: Emma Grant [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 6:43 PM
Subject: Using web forms and webpages to access/view mysql data


Hi all,

I successfully created and added data to my database!

Does anyone know any good websites where I can learn to insert, update
data using a web form and CGI?

How does mysql perform when displaying images (jpg, gif) on a web page,
that have been stored as BLOB file?

I am new to this stuff, and I am really having a good time with it.

Thanks,

Emma



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Using web forms and webpages to access/view mysql data

[Ed Carp]

 -Original Message-
 From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, June 20, 2002 7:10 PM
 To: Emma Grant; [EMAIL PROTECTED]
 Subject: Re: Using web forms and webpages to access/view mysql data

 It really depends on the language you wish to use ... could be Perl, ASP,
 PHP, etc.

Don't forget Roxen and Escapade, both of which are significantly easier to learn and 
use than PHP, ASP, or Perl.  For example,
Escapade lets you run a query like SQL select * from table rather than having to 
laboriously set up the connection like you have
to do with other server-side scripting languages.

And while Escapade is a commercial product, Escapade is freeware, as opposed to ASP 
which is not.
--
Ed Carp, N7EKG  http://www.pobox.com/~erc   214/986-5870
Director, Software Development
Escapade Server-Side Scripting Engine Development Team
Pensacola - Dallas - London - Dresden
http://www.squishedmosquito.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: to mysql list administrators

[Benjamin Pflugmann]

Hi.

On Thu 2002-06-20 at 17:24:53 +0100, [EMAIL PROTECTED] wrote:
 To list mysql list administrator:
 Why do I receive this auto responder after posting to this list

I am not a list administrator, but know the answer anyhow. ;-)

You get this mail, because someone with a very poor auto-responder[1]
has subscribed to the list with the wrong address[2].

The problem can be solved either by the list adminstrator, by
unsubscribing the offending address. Or by the owner/postmaster of the
offending address by using a less crappy auto-responder (or by
re-subscribing with a more reasonable address).

Regards,

Benjamin.


[1] any reasonable auto-responder would recognize that it is a bulk
mail from a mailing list and would not answer.

[2] there is no sense to subscribe with an address which is obviously
used for commercial contact purposes.


[...]
 -- start
 We acknowledge with thanks your email and thanking you once again in showing
 your interest with our organization.
 
 
 Our HRD Team will get back to you as soon as possible.
[...]

-- 
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Foreign Key Worries

[Benjamin Pflugmann]

Hi.

On Thu 2002-06-20 at 14:50:07 -0700, [EMAIL PROTECTED] wrote:
 Friends,
 
 I am designing a MySql DB schema that will use foreign
 keys similar to:
 
 create table orders(id int auto_increment primary key,
 amount double(7,2) );
 
 create table orderItems(id int, item char(20), price
 double(5,2), quantity int, key(id), foreign key id
 references orders (id));
 
 I am currently not using a version that supports
 foreign keys but hope to be in the future.  In the
 meantime I'll need to implement the foreign key
 constraints through my application.  My concern is
 that if either of the tables get corrupted or out of
 sync I won't be able to match up the order items with
 the orders.
 
 Is there anything that I might do to ensure that I'll
 be able to recover if the tables get out of sync? 

IMHO, the interesting question is: how could the tables get out of
sync, in a way that foreign keys would be able to prevent? I am not
able to see a way in everyday work (explicitly filling in nonsense
does not count).

The only thing I can see that could happen in normal use is that you
get an entry for orders but none in orderItems, because a program is
interrupted. That could happen with foreign keys as well.

A method to guard against this is to insert orders with a column set
to incomplete, insert orderItems, then update orders to complete.
Write your programs to ignore rows without status=complete (best if
this is capsulated into an own class which all programs have to use).

 I've thought of adding timestamp columns to each table
 as an aid in matching up the records but am not sure
 how helpful this would be or if it would be worth the
 extra storage space.

Good idea. I do that to all tables. I cannot count how often it
enabled me to reproduce what strange strings others did. In fact, I
add to timestamp columns, one as creation time and one as last-changed
time, the latter beeing automatically updated by MySQL every time.

Regarding storage: I only leave them away for tables which will change
very seldom (e.g. a country list) or where I really know, that the
space difference will matter (you can always delete them later, you
know).

 Any comments about your experience using foreign keys and MySql
 would be appreciated.

Regards,

Benjamin.


-- 
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL, ext3 and noatime

[Jeff Kilbride]

Does mounting ext3 MySQL data directories with the noatime option improve
performance? I ran across an article that said it really helped with ext2
and was wondering if the same benefits applied with ext3.

Thanks,
--jeff



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Check for DBI support

[Emma Grant]

Hey all, 

I have decided to go with CGI for my programming language. Reason being
is that I know it a tiny bit better then I do PHP. 

Does anyone know a command line command (?) to find out if I have a DBI
for mysql support installed? 

I am attempting to connect to a mysql database using a quick CGI script,
and then I am going to attempt to do the same thing on a web page. Right
now when I run the script that I have, which I got from many different
sources from the net, the error that the script gives me (not the die
error that I can't connect to the database), is telling me that I am
using a 'Bareword' where and 'operator' is expected. So I assumed that
it does not understand 'use DBI' 

Thanks for any feed back 

Emma


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Check for DBI support

[Paul DuBois]

At 18:51 -0700 6/20/02, Emma Grant wrote:
Hey all,

I have decided to go with CGI for my programming language. Reason being
is that I know it a tiny bit better then I do PHP.

Does anyone know a command line command (?) to find out if I have a DBI
for mysql support installed?

% perldoc DBI
% perldoc DBD::mysql

If these work, they're installed.


I am attempting to connect to a mysql database using a quick CGI script,
and then I am going to attempt to do the same thing on a web page. Right
now when I run the script that I have, which I got from many different
sources from the net, the error that the script gives me (not the die
error that I can't connect to the database), is telling me that I am
using a 'Bareword' where and 'operator' is expected. So I assumed that
it does not understand 'use DBI'

Hard to say w/o seeing your code.  But I'd guess it's not what
you're thinking.


Thanks for any feed back

Emma



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL, ext3 and noatime

[Benjamin Pflugmann]

Hello.

On Thu 2002-06-20 at 18:29:35 -0700, [EMAIL PROTECTED] wrote:
 Does mounting ext3 MySQL data directories with the noatime option improve
 performance? I ran across an article that said it really helped with ext2
 and was wondering if the same benefits applied with ext3.

Yes, of course. ext3 mainly is ext2+journaling. Because the noatime
option improves read performance (avoid writing atime on reads), it
should not matter if you have journaling.

Bye,

Benjamin.

-- 
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

file permissions

[Michael Sellers]

I'm very new to mysql. Just learning. I'm trying to correctly set up the
permissions for the files under the mysql/ directory.  I've included a
list. I would appreciate it if some one could look over it and recommend
changes. Thank you.

Michael Sellers


/usr/local/mysql

total 4752
drwxr-xr-x2 root root 4096 Jun 19 00:05 bin
-rw-r--r--1 root mysqlgrp   122213 Jun  3 05:39 ChangeLog
-rwxr-xr-x1 root mysqlgrp  773 Jun  9 08:13 configure
-rw-r--r--1 root mysqlgrp19106 Jun  8 09:57 COPYING
-rw-r--r--1 root mysqlgrp47577 Jun  8 09:57 COPYING.LIB
drwxr-x---4 root mysqlgrp 4096 Jun 19 23:02 data
drwxr-xr-x2 root mysqlgrp 4096 Jun  9 08:13 include
-rw-r--r--1 root mysqlgrp   147458 Jun  8 09:57 INSTALL-BINARY
drwxr-xr-x2 root mysqlgrp 4096 Jun  9 08:13 lib
drwxr-xr-x2 root mysqlgrp 4096 Jun  9 08:13 man
-rw-r--r--1 root mysqlgrp  2336774 Jun  8 09:56 manual.html
-rw-r--r--1 root mysqlgrp85892 Jun  8 09:56 manual_toc.html
-rw-r--r--1 root mysqlgrp  2021070 Jun  8 09:56 manual.txt
drwxr-xr-x6 root mysqlgrp 4096 Jun  9 08:13 mysql-test
-rw-r--r--1 root mysqlgrp 1976 Jun  3 05:39 README
drwxr-xr-x2 root mysqlgrp 4096 Jun  9 08:13 scripts
drwxr-xr-x3 root mysqlgrp 4096 Jun  9 08:13 share
drwxr-xr-x7 root mysqlgrp 4096 Jun  9 08:13 sql-bench
drwxr-xr-x2 root mysqlgrp 4096 Jun  9 08:13 support-files
drwxr-xr-x2 root mysqlgrp 4096 Jun  9 08:13 tests


/usr/local/mysql/bin

total 15696
-rwxr-xr-x1 root root   619808 Jun  9 08:13 comp_err
-rwxr-xr-x1 root root   749524 Jun  9 08:13 isamchk
-rwxr-xr-x1 root root 1474 Jun  9 08:13 msql2mysql
-rwxr-xr-x1 root root   828488 Jun  9 08:13 myisamchk
-rwxr-xr-x1 root root   747244 Jun  9 08:13 myisampack
-rwxr-xr-x1 root root   630504 Jun  9 08:13
my_print_defaults
-rwxr-xr-x1 root root   759028 Jun  9 08:13 mysql
-rwxr-xr-x1 root root   111547 Jun  9 08:13 mysqlaccess
-rwxr-xr-x1 root root 1702 Jun  3 05:39 mysqlaccess.conf
-rwxr-xr-x1 root root   601236 Jun  9 08:13 mysqladmin
-rwxr-xr-x1 root root   615144 Jun  9 08:13 mysqlbinlog
-rwxr-xr-x1 root root 9731 Jun  9 08:13 mysqlbug
-rwxr-xr-x1 root root   595304 Jun  9 08:13 mysqlcheck
-rwxr-xr-x1 root root 3144 Jun  9 08:13 mysql_config
-rwxr-xr-x1 root root 2976 Jun  9 08:13
mysql_convert_table_format
-rwxr-xr-x1 root root  3835316 Jun  9 08:13 mysqld
-rwxr-xr-x1 root root18415 Jun  9 08:13 mysqld_multi
-rwxr-xr-x1 root root96797 Jun  9 08:13 mysqld.sym.gz
-rwxr-xr-x1 root root   609244 Jun  9 08:13 mysqldump
-rwxr-xr-x1 root root 4986 Jun  9 08:13 mysqldumpslow
-rwxr-xr-x1 root root 2654 Jun  9 08:13 mysql_find_rows
-rwxr-xr-x1 root root 4437 Jun  9 08:13
mysql_fix_privilege_tables
-rwxr-xr-x1 root root27610 Jun  9 08:13 mysqlhotcopy
-rwxr-xr-x1 root root   591904 Jun  9 08:13 mysqlimport
-rwxr-xr-x1 root root15255 Jun  9 08:13
mysql_setpermission
-rwxr-xr-x1 root root   592800 Jun  9 08:13 mysqlshow
-rwxr-xr-x1 root root   614688 Jun  9 08:13 mysqltest
-rwxr-xr-x1 root root 3104 Jun  9 08:13 mysql_zap
-rwxr-xr-x1 root root   707928 Jun  9 08:13 pack_isam
-rwxr-xr-x1 root root   625528 Jun  9 08:13 perror
-rwxr-xr-x1 root root   633800 Jun  9 08:13 replace
-rwxr-xr-x1 root root   625204 Jun  9 08:13 resolveip
-rwxr-xr-x1 root root   624232 Jun  9 08:13
resolve_stack_dump
-rwxr-xr-x1 root root 8463 Jun 19 00:03 safe_mysqld


/usr/local/mysql/data

total 44
-rw-r--r--1 mysqladm mysqlgrp 3527 Jun 20 19:22 laptop.err
-rw-rw1 root mysqlgrp29777 Jun 20 19:22 log.01
drwxr-x---2 root mysqlgrp 4096 Jun 17 11:51 mysql
drwxr-x---2 root mysqlgrp 4096 Jun 17 14:08 test


/usr/local/mysql/include

total 400
-rw-r--r--1 root mysqlgrp21021 Jun  9 08:07 config.h
-rw-r--r--1 root mysqlgrp 9394 Jun  3 05:39 config-win.h
-rw-r--r--1 root mysqlgrp 3445 Jun  3 05:39 dbug.h
-rw-r--r--1 root mysqlgrp 2082 Jun  3 05:39 errmsg.h
-rw-r--r--1 root mysqlgrp 1819 Jun  3 05:39 ft_global.h
-rw-r--r--1 root mysqlgrp 4799 Jun  3 05:39 getopt.h
-rw-r--r--1 root mysqlgrp31380 Jun  3 05:39 global.h
-rw-r--r--1 root mysqlgrp 2364 Jun  3 05:39 hash.h
-rw-r--r--1 root mysqlgrp 5599 Jun  3 

RE: Check for DBI support

[Emma Grant]

Hi, 

Thanks for your help. 

I tried to run both the commands that you gave me on the command line. I
got the following message back from the shell: 

Superuser must not run /usr/bin/perldoc without security audit and taint
checks. 

Do you know what this means? 

Thanks, 
Emma

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, June 20, 2002 7:25 PM
To: Emma Grant; [EMAIL PROTECTED]
Subject: Re: Check for DBI support

At 18:51 -0700 6/20/02, Emma Grant wrote:
Hey all,

I have decided to go with CGI for my programming language. Reason being
is that I know it a tiny bit better then I do PHP.

Does anyone know a command line command (?) to find out if I have a DBI
for mysql support installed?

% perldoc DBI
% perldoc DBD::mysql

If these work, they're installed.


I am attempting to connect to a mysql database using a quick CGI
script,
and then I am going to attempt to do the same thing on a web page.
Right
now when I run the script that I have, which I got from many different
sources from the net, the error that the script gives me (not the die
error that I can't connect to the database), is telling me that I am
using a 'Bareword' where and 'operator' is expected. So I assumed that
it does not understand 'use DBI'

Hard to say w/o seeing your code.  But I'd guess it's not what
you're thinking.


Thanks for any feed back

Emma




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Check for DBI support

[Paul DuBois]

At 19:36 -0700 6/20/02, Emma Grant wrote:
Hi,

Thanks for your help.

I tried to run both the commands that you gave me on the command line. I
got the following message back from the shell:

Superuser must not run /usr/bin/perldoc without security audit and taint
checks.

Do you know what this means?

It means you shouldn't run perldoc as root.

Run it as a normal unprivileged user.

You're not *really* running routine commands as root are you?


Thanks,
Emma

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 7:25 PM
To: Emma Grant; [EMAIL PROTECTED]
Subject: Re: Check for DBI support

At 18:51 -0700 6/20/02, Emma Grant wrote:
Hey all,

I have decided to go with CGI for my programming language. Reason being
is that I know it a tiny bit better then I do PHP.

Does anyone know a command line command (?) to find out if I have a DBI
for mysql support installed?

% perldoc DBI
% perldoc DBD::mysql

If these work, they're installed.


I am attempting to connect to a mysql database using a quick CGI
script,
and then I am going to attempt to do the same thing on a web page.
Right
now when I run the script that I have, which I got from many different
sources from the net, the error that the script gives me (not the die
error that I can't connect to the database), is telling me that I am
using a 'Bareword' where and 'operator' is expected. So I assumed that
it does not understand 'use DBI'

Hard to say w/o seeing your code.  But I'd guess it's not what
you're thinking.


Thanks for any feed back

  Emma


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql's ignoring query.. error

[Franco M Gabriel]

Hello to everyone!

I'm using mysql-3.23.41 and initially able to use it without any problem.  However, 
after I issued this command,  grant all privileges on *.* to root@localhost 
identified by 'mypassword' with grant option; , mysql will simply display the message 
Ignoring query to other database after issuing any command such as show databases;.

I am able to access mysql using : mysql -root -p, and entering the my password.

Would appreciate any assistance.

Best regards,
Franco


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Installing Multiple Versions of MySql on the Same Computer

[Michael Ivanyo]

Hi,

I am currently running MySQL-3.23.51 on RedHat Linux
7.2 and would like to gradually switch to
MySQL-Max-3.23.51.  My question is, would I be able to
install them both if I only run one at a time?  

I am really looking forward to trying out transations
and foreign keys using InnoDB and am interested in BDB
as well.

I'd appreciate hearing about any problems or things to
avoid when setting up InnoDB.

--Michael


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [PHP] Installing Syncronizing

[Mark]

I think you're confused. the only WinGate I know of is an alternative
to windows' internet connection sharing. It's not a web server.

and what's a T connection?

On Thu, 20 Jun 2002 19:26:37 -0300, César Aracena wrote:
Hello all,

I have this client who has a T connection and would like to run a
PHP /
MySQL based program in local mode, but also be able to make the data
available from the web but hosted in a remote server… kinda strange
u
think? Me too… The problem is that his server doesn’t run with IIS
but
with a little ap called WinGate, which gives him all the approach
for
his little network. Have anyone installed the PHP / MySQL under MS
NT4.0
running WinGate before? Anything to tell me that will help me in the
process?

Also, I would need the MySQL people to tell me how can I make the
local
 remote databases to stay synchronized let’s say with a one hour
interval top… Is this possible? FYI the remote db is hosted under a
Cobalt RAQ4i server running Red Hat Linux Apache Web server.

Thanks in advance.

mailto:[EMAIL PROTECTED] Cesar Aracena
CE / MCSE+I
Neuquen, Argentina
+54.299.6356688
+54.299.4466621






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SIGSEGV with 3.23.51 compiled with --with-libwrap

[Kristofer T. Karas]

Description:

MySQLd 3.23.51 receives a SIGSEGV (aborting the backtrace with an
fp=(nil)) connecting via TCP/IP when compiled with --with-libwrap.
Connecting via a Unix socket works.  MySQLd 3.23.49 and below are not
affected.

I've spent the entire day compiling with various options, and on
various Linux platforms, to identify the culprit.  The bug does not
seem related to compiler (tried egcs-1.1.2 and gcc-2.95.3), libc
(tried both glibc 2.1 and 2.2), linux kernel (2.2 and 2.4), or other
code-altering configuration options tried (--enable-assembler,
--with-berkeley-db).  The only ingredient necessary to trigger the bug
is to add in --with-libwrap, and then connect via TCP/IP.

How-To-Repeat:

linux:~# mysql -uadmin -pxyzzy -h127.0.0.1 -P3306
ERROR 2013: Lost connection to MySQL server during query
linux:~#

Fix:


Submitter-Id:  submitter ID
Originator:Kristofer T. Karas
Organization:
CareGroup,
Boston, MA US

MySQL support: none
Synopsis:  Use of --with-libwrap segfaults mysqld under misc. conditions.
Severity:  serious
Priority:  low
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.51 (Source distribution)

Environment:

System: Linux enterprise 2.2.21 #1 SMP Tue May 21 16:21:06 EDT 2002 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx   1 root root   13 Mar 29  2000 /lib/libc.so.6 - libc-2.1.3.so
-rwxr-xr-x   1 root root  4184716 Jan 15 13:56 /lib/libc-2.1.3.so
-rw-r--r--   1 root root 20313466 Jan 15 13:56 /usr/lib/libc.a
-rw-r--r--   1 root root  178 Jan 15 13:56 /usr/lib/libc.so
Configure command: ./configure --quiet --prefix=/usr/local/mysql 
--localstatedir=/data/mysql --enable-shared --enable-static --enable-assember 
--with-libwrap --with-mysqld-user=mysql --without-debug --with-berkeley-db 
--without-bench

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php