If there's not a way to do this I would suggest it be added to the next version of
MySQL, but has anyone ever heard of an EXCEPT FOR clause that can be used in MySQL's
SELECT statements? For instance... SELECT * FROM products EXCEPT FOR colors WHERE
sizes LIKE '%small%'
Thanks...
Jed
On 12-Jun-2003 Wong Zach-CHZ013 wrote:
Hi
1 - I have a column whose datatype is longtext. Its content is
08/06/2003;
I created a new column whose datatype is DATE. Its content is null now.
How do write a SQL statement that
inputs each row from 08/06/2003 in the
old column to 2003-08-06 in
MySQL 4.0.12 max on AIX 4.3.2
Following are part of .err log file:
030615 1:29:44 Aborted connection 163 to db: 'New' user: 'happy' host:
`192.168.5.108' (Got an error reading communication packets)
030615 1:29:54 Aborted connection 167 to db: 'New' user: 'happy' host:
`192.168.5.108' (Got
MySQL 4.0.12 max on AIX 4.3.2 HA. When I use show full processlist on localhost, all
Hosts show as localhost. but when I use show full processlist from remote, all Hosts
show as remote IP.
as follow:
mysql show full processlist;
I don't think that solves the problem. There are multiple test chains with
Id's less than 7.
ie
7-6-4-3-2
5
1
and your query looking for history on testId=7
SELECT * FROM tests WHERE testID=7 AND connect0;
could return testId's 5 and 1 as well if they were part of longer chains
How about SELECT (column1, column2, column3, etc.) FROM products...
I believe something along the lines of EXCEPT FOR would be a huge violation of
SQL standards. It might be useful for you, but it's likely that most users
would simply declare the desired columns or exclude one programatically.
Consider going over Section 5.2.9 of the manual.
http://www.mysql.com/doc/en/Insert_speed.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Shane Bryldt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, 15 June, 2003 01:12
Subject: Question about
As my post suggested, I have already addressed the tweaks this this
section of the manual addresses, and was hoping there might be some insight
on my original question, the process of INSERT vs UPDATE. That chapter was
helpful initially, but I have already addressed most of what that chapter
Greetings-
I request your help constructing a query to return a list of active members based on
the following:
CREATE TABLE Members(
member_number int unsigned AUTO_INCREMENT,
name varchar(25),
PRIMARY KEY(member_number))
CREATE TABLE Status(
member_number int unsigned
After delete a large amount of data from an innodb table, the free memory
available to innodb tables as reported by 'show table status' decreased
significantly rather than increasing.
I am guessing this is caused by fragmentation? If so, I am guessing the
only way to regain the free memory is
The solution depends on which version of MySQL you are using. If you
are using 4.1, you the easiest solution is to use a sub-select.
Something like this may work:
SELECT m.member_number, m.name, s.status, s.date
FROM members AS m, status AS s ON
WHERE m.member_number = s.member_number
AND
Hello,
I have a table with just one column and with 1000 rows. It's indexed using
full text.
I've tried MATCH with AGAINST and LIKE and nothing works right!
I've tried:
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*');
but if I do
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvore*');
Hi!
I have redhat 7.3 with the mysql packages that came with it.
Since RHSA-2003:093-14 came out I upgraded mysql with
mysql-3.23.56-1.73.i386.rpm
mysql-devel-3.23.56-1.73.i386.rpm
mysql-server-3.23.56-1.73.i386.rpm
When I try to start mysqld I get the following error message
in the log:
Table
On Sunday, June 15, 2003, at 01:36 PM, Nuno Lopes wrote:
I have a table with just one column and with 1000 rows. It's indexed
using
full text.
I've tried MATCH with AGAINST and LIKE and nothing works right!
I've tried:
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*');
but if I do
SELECT
Ethan,
- Original Message -
From: Ethan Joffe [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Sunday, June 15, 2003 6:16 PM
Subject: free table memory shrinks when data deleted
After delete a large amount of data from an innodb table, the free memory
available to innodb
Hi *
I'm running MySQl 3.23 and I'm trying to run a very simple command that
basically finds the highest number in a column and then for all matching
rows sets their card number to be current highest +1. The code looks
like this:
#cardnumb is actually a string of the form SNx so set
On Sunday, June 15, 2003, at 01:36 PM, Nuno Lopes wrote:
I have a table with just one column and with 1000 rows. It's indexed
using
full text.
I've tried MATCH with AGAINST and LIKE and nothing works right!
I've tried:
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*');
Hi
I'm unclear whether the address I'm using here (referenced on page 29
of the manual) is the correct one but I hope one of them may either
get me an answer or a reference to where else I might seek help.
DETAILS
OS: Windows 2000 Professional, 5.0.2195 SP3 build 2195
MySQL version 4.0.13 for
Phill,
I think the solution is simple, remove the part of the code you are having
problems with, it's redundant. Instead, according to your statement, use
this:
UPDATE Ops
SET [EMAIL PROTECTED]
WHERE newphoto=1 AND tbprinted=1;
As for myself, I would actually use the client implementing the
As my post suggested, I have already addressed the tweaks this this
section of the manual addresses, and was hoping there might be some insight
on my original question, the process of INSERT vs UPDATE.
Gotcha. I wasn't sure if you'd checked the manual or just run a huge number of
EXPLAINs on
Murdoch Mactaggart ,
The WINDOWS Environment needs the --console switch in order to output the
return of mysqld to DOS commands.
Please ref to: http://lists.mysql.com/list.php?list=win32#b
my.cnf will never be looked for by the WINDOWS Binary. Return to using
my.ini from
Shane Bryldt wrote:
I think the solution is simple, remove the part of the code you are having
problems with, it's redundant. Instead, according to your statement, use
this:
UPDATE Ops
SET [EMAIL PROTECTED]
WHERE newphoto=1 AND tbprinted=1;
Thanks for the response Shane. I don't think I
I'm not sure I entirely understand your solution. A datestamp would only
work if you stamped the record when it's updated, and then when the next
update is called, you'd have to have, throughout the program, snippets of
code to edit the last modified timestamp, so it knows to update those
hello and thank you for your time.
how should i code:
select * from stores,subcategory,category where stores.category and
subcategory.category = $category-id and stores.city or stores.zip =
$cityzip order by name
thank you again, tad
--
Addison Ellis
small independent publishing co.
114 B 29th
I have installed MySQL in Win98SE, with connection ASDL and Fixed IP.
In the same machine, works web server (Apache2+PHP) and e-mail e ftp server.
Everything works perfectly accessing from my INTRANET (local network). I
obtain access to MySQL without problems.
In Internet, all servers works
Ahh, yes, thank you for clarifying. My code would obviously have been no
help.
Hmm, I have not tested the theory, but I believe you could add to your
SELECT statement, a declaration of the return and use it in the next INSERT.
That is, SELECT @high:=convert(...) AS a FROM Ops;
And then a refers
I have all privileges to all the databases and tables, with user 'root'.
User 'root' likely doesn't have access from the desired IP. Users are
configured by both name and approved hosts. Try this:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY 'password';
Edward Dudlik
Becoming
With proper syntax. ;) Your WHERE conditions are improperly arranged.
SELECT * FROM stores,subcategory,category
WHERE (stores.category = $category-id AND subcategory.category =
$category-id)
OR stores.zip = $cityzip
ORDER BY name;
Also, assuming you're coding this in PHP, you need
Try specifying someuser at all hosts.
GRANT ALL ON * TO [EMAIL PROTECTED] IDENTIFIED BY 'somepass';
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Timothy Waters [EMAIL PROTECTED]
To: MySQL mail [EMAIL PROTECTED]
Sent: Saturday, 14 June, 2003 22:54
Hi...
I created the following function to move a record from one table to another. The only
difference in the table structures are the auto-incremented id column.
The purpose of my function is to allow Admin to get user input from the queue table
and after approving it she puts it in a
Sorry... I clicked send before pasting. Here is the function I was talking about.
function approvesignup($lid){
global $prefix, $dbi, $signqid, $ev_title, $ev_location, $ev_descrip, $ev_datetime,
$ev_organizer, $ev_contact, $ev_children, $ev_number, $ev_cost, $ev_phone;
sql_query(INSERT into
Hi,
while trying to handle severl key values,
I wonder if it is more efficient to put
those values in a row seperated by a
certain seperator (eg. comma).
The talbe has two fields and looks like;
UID ForeinID
1 2,3,4,6
27,9,4,5
33,4
41,5,7,9
52,3,4,5
and the values of
You are welcome. Sorry I havent been more precise - at this time I didnt find
it.
Have a look at the UC presentations Moving towards MySQL 5.0 from Matt
Wagner and State of the Dolphin from David Axmark and Michael (Monty)
Widenius
http://www.mysql.com/events/uc2003/highlights.html
Read a
I didn't know where to send this, so I'm sending it anyway.
---
Spelling error in MySQL Reference Manual
Where it reads: Portugise error messages.
Should read: Portuguese error messages.
Where it reads: A Portugese mailing list
Should read: A Portuguese mailing list
I believe this should be
How do I unsub from this list? The unsub link doesn't work?
?php
If( $_POST['beer'] == 24)
{
echo(Life is good!);
exit(1);
?
}
echo(Quick it's all most closing time!!!);
more_help();
?
-Original Message-
From: [EMAIL PROTECTED]
Hi,
I'm a newbie too. Was faced with this the other day.. I'm using
Redhat 8.0 PHP-4.2.2-8.07 and when this problem surfaced, found out that
phpinfo() states that it is compiled with the --with-mysql=shared. But I did
not install php-MySQL*.rpm
Did a rpm -Uvh php-MySQL*.rpm and it
You need to create a cookie session using start_session() and something like
that. I'm actually reading up on it on this book
PHP MySQL Web development - luke welling Laura thomson (i think)
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
Simply I didn't know where the password was located in myphpadmin.
The password is not in myphpadmin. It is in the database. Log in as root
and look at the mysql database.
Also, read sections 4.2 and 4.3 of the MySQL manual.
I
wanted it secure but I wanted to be able to get to the data
38 matches
Mail list logo