bill_first,c.bill_last))
GROUP BY download_email
ORDER BY orderID DESC, cust_id DESC
--
<--->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
<--->
--
in the list. On top of that I
would also like the ability to assign a priority field for listing in
that order as well. There has to be some kind of solution to this
that I don't see.
Any ideas? Thanks!
--
<------->
At 4:22 PM -0500 6/6/03, Paul DuBois wrote:
At 17:17 -0400 6/6/03, Alex Pilson wrote:
I have an old table that has about 2000 records and hasn't been
modified. I realized it was missing a create_date. Do anyone know
or have any slick SQL code to extract out the date from the
timestamp fiel
hanks!
--
<--->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.642.8225 CELL
<--->
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
ad they used thin enough paper
that it didn't turn into a completely giant book.
I just ordered it on bookpool but it says it is out of stock.
--
<------->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PRO
this command in succession for about twenty
tables?
--
<--->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.822
At 8:23 AM +1100 11/12/02, Daniel Kasak wrote:
Alex Pilson wrote:
I am stumped on how to create a statement that will find all
instances of a field (price) and change the .98 to .99. Looking
through the MySQL book of P. Dubois, it seems I need to do pattern
matching but I can't figur
n off - the shelf query for something like this?
--
<--->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.64
d party MySQL app such as Pro SQL or SQLBoss.
--
<------->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 CELL
<--->
If you want to solve this at a later stage, restart this script with
the --force option
[xserve:/usr/local/mysql] admin%
What am I missing? I do have the DNS setup for this host...
--
<------->
Alex Pilson
FlagShip Interactive,
At 9:20 AM -0400 5/21/02, Reid Sutherland (mysql) wrote:
>Alex Pilson wrote:
>>I was wondering if anyone knew the "proper" way to restart MySQL on OS X?
>>
>>I did mysqladmin -p shutdown then safe_mysqld...is this the same as
>>if the machine started up?
>
I was wondering if anyone knew the "proper" way to restart MySQL on OS X?
I did mysqladmin -p shutdown then safe_mysqld...is this the same as
if the machine started up?
--
<--->
Alex Pilson
FlagShip
At 3:22 PM -0400 5/20/02, Alex Pilson wrote:
>Is it possible to alter or modify a timestamp field to a different date?
Doh. I found the answer...
The answer is yes.
--
<--->
Alex Pilson
FlagShip Interactive, Inc.
Is it possible to alter or modify a timestamp field to a different date?
--
<--->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 CELL
// Web Design
// Lasso
;
I do. So how does that have anything to do with the trademark
character getting encoded correctly into a MySQL field?
--
<----->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 C
...
--
<->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 CELL
// Web Design
// Lasso Application Development
// Filemaker Pro / SQL Development
// Sonic Solutions Creator Authoring
// Apple DVD Studio Pro Authoring
// Macr
to use single quotes and it worked. So does
mysql care if it is single or double quotes?
--
<--------->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 CELL
// Web Design
// Lasso Application
Why is this producing a syntax error at the %? This is supposed to
create a global user, yes?
GRANT ALL ON *.* TO myuser@% IDENTIFIED BY "mypassword";
Is there a quick command to show all GRANTS? or Users?
--
<----->
Alex Pils
Does converting one type of column to a bigger type such as listed in
my subject lose the information that is contained in that row/column
or does it just expand the limit?
--
<->
Alex Pilson
FlagShip Interactive, Inc.
zign/index.html
--
<----->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 CELL
// Web Design
// Lasso Application Development
// Filemaker Pro / SQL Development
// Sonic Solutions Creator Authoring
//
led
>without one, it prints to STDOUT. Here's my code:
Cool. I will give it whirl to see what information it reveals.
--
<->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 CELL
// Web Design
// Lass
.
--
<->
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL PROTECTED]
404.728.4417
404.642.8225 CELL
// Web Design
// Lasso Application Development
// Filemaker Pro / SQL Development
// Sonic Solutions Creator Authoring
// Apple DVD Studio Pro Authoring
// Macr
22 matches
Mail list logo
