Hi,
I'm a little rusty in my SQL statements, and I'm not all that certain
that this can be done.
IF I have a field with the contents like:
http://beta.somedomain.com/url/url/url=2;
where 2 is the record ID value. And I need to change the contents of
that field to read:
Folks,
Thanks for the 'help'. Oy.
I figured it out from some help on the Lasso discussion list.
All I had to do was properly address ALL the tables I wanted to touch.
So this:
UPDATE tbe_gallery
SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper
WHERE tbe_gallery.gallery_id =
Hi,
I'm wondering if the following can be done
UPDATE tbe_gallery
SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper
WHERE tbe_gallery.gallery_id = tbe_images.img_rel_id AND
tbe_images.img_orig_filename = tbe_gsa.gsa_id
Let me explain:
I have 3 tables and only 1 of them
Hi,
Can anyone tell me if this is the correct syntax for a self reference
Index ?
-- ALTER TABLE `RPI_CTYPE` ADD FOREIGN KEY (`RPI_CT_REPLCID`)
REFERENCES `RPI_CTYPE`(`RPI_CT_ID`);
-- CREATE INDEX RPI_H_REPLCID_idxfk ON RPI_HOW (RPI_H_REPLCID);
M i l e s.
--
MySQL General Mailing
+
+++
Note the order_piececount column.
What do I need to do to my SQL statement to perform this action ?
My guess that I need to perform a secondary query inside the
statement to get the computed value of order_piececount.
Anyone ?
M i l e s.
--
MySQL General Mailing List
For list archives
? And how best to resolve it ?
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Im wondering if there is a way to combine the following queries into
ONE query, or at the very least fewer queries... (DATE) is
today's date.
SELECT DISTINCT ip_address
FROM logfile
WHERE site_id = x
AND date_time LIKE (DATE)
GROUP BY
Hi,
Im wondering if there is a way to combine the following queries into
ONE query, or at the very least fewer queries... (DATE) is
today's date.
SELECT DISTINCT ip_address
FROM logfile
WHERE site_id = x
AND date_time LIKE (DATE)
GROUP BY
in the right direction ???
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Rhino,
Thanks for all the info.
It was as simple as %% in the statement...
DUH!
I can't believe I missed that.
Sorry to have bothered.
Thanks anyway.
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
statement correct ?
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Michael,
My apologies for not formatting the request properly for readability.
I was typing fast...
THanks for the tip...I'll try it out
Most Sincerely,
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
- Hi and Welcome to -
LASSO TIPS FOR MYSQL: 3.4
I'm your host, M i l e s.
First and foremost, a good place for you to start with Lasso is the
following 5 things:
The FIRST LASSO TIPS FOR NEWBIES
- http
- Hi and Welcome to -
LASSO TIPS FOR NEWBIES: 3.3
I'm your host, M i l e s.
First and foremost, a good place for you to start with Lasso is the
following 5 things:
The FIRST LASSO TIPS FOR NEWBIES
- http
- Hi and Welcome to -
LASSO TIPS FOR MYSQL: 3.2
The FIRST LASSO TIPS FOR MYSQL
- http://www.listsearch.com/lassotalk.lasso?id=143312
The LAST LASSO TIPS FOR MYSQL
- http://www.listsearch.com/lassotalk.lasso?id=154176
10
- Hi and Welcome to -
LASSO TIPS FOR MYSQL: 3.0
I'm your host, M i l e s.
First and foremost, a good place for you to start with Lasso is the
following 5 things:
The FIRST LASSO TIPS FOR NEWBIES
- http
- Hi and Welcome to -
LASSO TIPS FOR MYSQL: 3.0
I'm your host, M i l e s.
First and foremost, a good place for you to start with Lasso is the
following 5 things:
The FIRST LASSO TIPS FOR NEWBIES
- http
- Hi and Welcome to -
LASSO TIPS FOR MYSQL: 2.9
I'm your host, M i l e s.
First and foremost, a good place for you to start with Lasso is the
following 5 things:
The FIRST LASSO TIPS FOR MYSQL
- http://www.listsearch.com
question is HOW.
And I have thousands of rows like this and its just ONE field that's
the stumbling block.
Any suggestions ?
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jason,
The only way that I can think to do this is the change its status as
a primary key field...
Once you do that, you can rename the field, and then reinitiate it as
a primary keyfield.
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
never been there) so I hear. However,
that's NOT what I want.
1.) What should the db collation be set to if I am in the USA -
latin_1_bin ?
2.) and would doing so cause a problem that anyone can think of ?
Thanks.
I'm running 4.1.12 on OS X.4.2.
Thanks.
M i l e s.
--
MySQL General
i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, search_members.Property_ID
ORDER BY pDATE DESC
I have a feeling that the COUNT line should be something similar to
select distinct statement
Any ideas ?
Sincerely,
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Shawn,
Took me a bit to digest what you were sayin but if I get it the way
you splain'd it
then the following should work:
++
SELECT
cmc_search_members.PropertyName AS pNAME,
cmc_search_members.PropertyEmail AS pEMAIL,
Hi,
I updated my 4.0 install to 4.1 and now NONE of my
databases and tables show up at all.
Im on OS X.3.9.
All the files are there in the data folder, permissions are
set, what did I do wrong ? Any suggestions as to how to get it
back ?
M i l e s.
--
MySQL General Mailing List
For list archives
thats on the list and thereby
sending these msgs to anyone that's posted to the list,
quite ingenious really.
M i l e s
+++
President Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box 414, Northampton, MA 01060
http://www.magicmiles.com/
[EMAIL PROTECTED]
aim/yahoo
Hi,
I got them too. A few days ago.
I bounced the msg to spamcop directly.
No matter...
If I were a bettin man, and Ive been known to partake
from time to time...I'd guess that there is a harvester
address in the list.
That would be one guess.
M i l e s
+++
President
Rodney,
Did you EVER get a response to your question ?
Im keenly interested to know the answer.
M i l e s
+++
President Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box 414, Northampton, MA 01060
http://www.magicmiles.com/
[EMAIL PROTECTED]
aim/yahoo/msn
the error:
can't get stat of
'/Babylon5/Library/WebServer/Documents/~milesfiles.com/
eims_errorlog.txt'
What am I doing wrong ?
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does anyone know of a way for all three fo these to talk to
one another ?
--
M i l e s
President Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box 414, Northampton, MA 01060
http://www.servicetoolbox.com/
http://www.workshoptoolbox.com/
http://www.healingartstoolbox.com/
http
Hi
Im a more than a lil confused about how to set up multiple
users for EXTERNAL access to MySQL.
Ive granted permissions to the Local user, but how to I grant permissions
to external users ?
Sincerely,
--
M i l e s
President Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box
31 matches
Mail list logo