/tmp/db.sql
...
--
Don Readdon_r...@att.net
It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
,
--
Don Readdon_r...@att.net
It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
', 'scan', 'done') not null default 'new';
When proc two runs, it should
UPDATE noticed='scan' WHERE noticed='new'
Then repeat the scan with SELECT ... WHERE noticed='scan'
...
and finally it should UPDATE domain=whatever, ... noticed='done'
Regards,
--
Don Read
On Sat, 26 Dec 2009 10:43:55 +0800 Eva said:
2009-12-26 2:36, Don Read :
Change noticed to enum('new', 'scan', 'done') not null default 'new';
When proc two runs, it should
UPDATE noticed='scan' WHERE noticed='new'
Then repeat the scan with SELECT ... WHERE noticed='scan
know or haven't yet found the proper translation
for a phrase it will default to the english language.
* Note the locale field is varchar(5).
There is a de, a de_DE, and a de_CH locale!
Have fun!
--
Don Readdon_r...@att.net
It's always darkest before
SET seen='GOT' WHERE seen='GET';
lather, rinse, repeat.
--
Don Readdon_r...@att.net
It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General Mailing List
For list
is that the query runs faster the second time around but i dont
have ...
snipage
--
A: It reverses the normal flow of conversation.
Q: What's wrong with top-posting?
A: Top-posting.
Q: What's the biggest scourge on plain text email discussions?
Anybody else see the irony here?
--
Don
invented the
things we are talking about
(http://en.wikipedia.org/wiki/Edgar_F._Codd)
Cheers
Claudio Nanni
And Claudio for the WIN!
--
Don Read donr...@sbcglobal.net
It's always darkest before the dawn. So if you are going to
steal the neighbor's
($qry, 'area', $area);
if (! empty($interest))
$qry = andclause($qry, 'interest', $interest);
echo 'span class=ddt', $qry, '/span';
$res = SQLQuery($qry);
...
Have fun.
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you
())
$rank[$row['user_id']] = $row['rank'];
$dbconn-Execute('UPDATE user SET rank=0');
foreach($rank as $id = $r) {
$qry = UPDATE user SET rank=$r WHERE user_id=$id;
$dbconn-Execute($qry);
}
}
Regards,
--
Don Read
.
hittime DATETIME NOT NULL DEFAULT '-00-00',
prd MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
...
KEY idx_p (prd),
...
UPDATE tbl SET prd=EXTRACT(YEAR_MONTH FROM hittime) ...
Then query it with
SELECT ... WHERE prd=200408 etc.
--
Don Read [EMAIL
error near .. very useful or am I giving up to easy?
Howzabout :
mysql_query($qry) or
die(sprintf('pBorked query at file %s line %d :br /%s',
__FILE__, __LINE__, nl2br($qry)) .'br /'
.mysql_errno() .'br /' .mysql_error());
--
Don Read [EMAIL
mediumint(6) unsigned zerofill NOT NULL auto_increment,
idcust mediumint(5) unsigned zerofill NOT NULL,
...
);
You can make some pretty decent reports with a shell script if the DB
lends a hand with formatting.
--
Don Read [EMAIL PROTECTED]
-- It's
A;
This return's up to ten characters after the name, somethimes this is
to
much, sometimes to many. Does anybody knows how to go from here.
LEFT(SUBSTRING_INDEX(foo, ';', 1), 10)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So
and run the query:
UPDATE tbl SET ts= DATE_SUB(ts, INTERVAL 10 HOUR) WHERE ...
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General
(membershiptype + 1, '2', '0', '1') ASC
-- or --
MAKE_SET(membershiptype, 'a','b') DESC
Regards
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL
On 25-Mar-2004 [EMAIL PROTECTED] wrote:
Not using perl or php I came up with:
mysqlshow -u user --status db_name | awk -F| '{print $2,$5}' | grep
-i pattern
Is there a query to do the same thing?
SHOW TABLE STATUS
--
Don Read [EMAIL PROTECTED
TEMPORARY TABLE
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Support section.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
update, and then
go
around all of them at backup time :(
Anyone got any other ideas?
SHOW TABLE STATUS
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's
while
Header(Content-type: text/tab-separated-values);
Header(Content-Disposition: inline; filename=data.tsv);
echo $output;
snip
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal
.
This is a subselect done in two steps. Look if you could
combine/modify your original query (that produced $value) and this
query to a single JOIN query.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal
;
- or -
SHOW TABLES LIKE 'asdfzxcv1234';
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table
with this?
In your init script (before the section that calls safe_mysqld) put:
TZ=EST; export TZ
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
[table] SET [timestamp]=[timestamp], ...
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query
for clues as to what is missing why.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query
On 19-Sep-2003 Dan Anderson wrote:
I am trying to make my PHP script autodetect when a table in a mySQL
database exists, and when it doesn't, create it.
snip
function tableexists($tbl) {
$res = @mysql_query(SELECT 1 FROM $tbl);
return ($res ? true : false);
}
Regards,
--
Don
On 19-Sep-2003 Don Read wrote:
On 19-Sep-2003 Dan Anderson wrote:
I am trying to make my PHP script autodetect when a table in a mySQL
database exists, and when it doesn't, create it.
snip
function tableexists($tbl) {
$res = @mysql_query(SELECT 1 FROM $tbl);
return ($res
'.
PHP example:
echo 'table';
$res=mysql_query('SELECT * FROM TName');
while ($row=mysql_fetch_array($res) ) {
unset($row['dateOB'], $row['idSCHOOL']);
echo 'trtd', implode('/tdtd', $row), '/td/tr';
}
echo '/table';
Regards,
--
Don Read [EMAIL PROTECTED
AS b2
WHERE b1.cid=b2.cid and b1.bid != b2.bid);
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql
of '==' and why the commas in your WHERE clause ?
$sql = SELECT Realtor, ...
WHERE Bathrooms ='$a' AND Bedrooms ='$b' AND ...
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper
specified, and
the price where the majver and minver are the largest combination for
each iid?
See above, --the problem solves itself.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's
that will export that info to a file
without the contents of the tables themselves?
$ mysqldump -d dbname
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
;
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list
:
SELECT countries_id, countries_name FROM TABLE_COUNTRIES ORDER BY
countries_name;
SELECT IF(countries_id='US', 0, 1) as ctsort, countries_id, countries_name
FROM TABLE_COUNTRIES
ORDER BY ctsort, countries_name
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's
---
Regards
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
when executing the SQL query it thinks they
are
the same. Any suggestions would be helpful.
SELECT * FROM tablename WHERE fieldname LIKE CONCAT('%', CHAR(0x??), '%');
UPDATE tablename SET fieldname=REPLACE(fieldname, CHAR(0x??), ' ');
Regards,
--
Don Read
.
If you're pre 4.0 then:
SET @cnt:=SELECT COUNT(*) FROM orders WHERE member_id='2';
SELECT @cnt + COUNT(*) AS totcnt FROM old_orders WHERE member_id='2';
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal
so that you don't
pass the password on the command line.
~/.my.cnf
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
--where=date_time $INPERIOD db tbl tbl.dmp \
mysql -e DELETE FROM tbl WHERE date_time $INPERIOD db
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
NAME=ageselect[] value=15 CHECKED
input TYPE=CHECKBOX NAME=ageselect[] value=20 CHECKED
input TYPE=CHECKBOX NAME=ageselect[] value=25
...
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal
.
I know how do use the regexp for SEARCHING, but can I do a replace on
the same cmd with an UPDATE?
UPDATE foo SET url=REPLACE(url, 'disciplines/', 'programs/')
WHERE url LIKE 'disciplines/%';
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest
$DUMP
mkdir -p $DIR
rm -f Today
ln -sf $DIR Today
cd $DIR
for K in $DBS
do
TBLS=`mysql -N -e show tables $K`
for I in $TBLS
do
mysqldump -e -q --add-drop-table $K $I $K.$I.sql
rm -rf $K.$I.sql.gz
gzip $K.$I.sql
done
done
Regards,
--
Don Read
(
idinv int unsigned not null, // invoice number
line tinyint unsigned auto_increment,// line number
idprod, qty, uom, price, cogs, // product shipped
...
primary key(idinv, line)
)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's
) {
... so either would be the correct construct here.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t
it into your table.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL
that into B.
But are there better way's of doing something like this ?
INSERT INTO tbl_B (A_id, ...)
VALUES (LAST_INSERT_ID(), ...)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal
.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
|
+-+
1 row in set (0.00 sec)
mysql SELECT CONCAT(LEFT(@v, 4), 'e', SUBSTRING_INDEX(@v, 'e', -1)) as v;
+--+
| v|
+--+
| 1.35e-28 |
+--+
1 row in set (0.00 sec)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always
16:36:37 Aborting
Did you run mysql_install_db after installation?
Directories in /etc/my.cnf (or command line opts) correct?
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's
) + 1, LEN ( name )),
fname = SUBSTRING ( author, PATINDEX ( '% %', name ));
author =TRIM(author),
fname=SUBSTRING_INDEX(author, ' ', 1),
lname=SUBSTRING_INDEX(author, ' ', -1)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So
dap_cell SET my_new_date=
REPLACE(CONCAT(RIGHT(my_date, 4), LEFT(my_date,5)), '/','');
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
source to see if the query is what you think it is.
snip
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t
|
++-+---++++---
+---+-+
*unwrapped*
xterm +aw
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql
, like PHP, PERL, VBScript, etc.
You can also do the counting there when outputting each row from the
query results.
Or HTML :
Ordered (i.e. numbered) lists take the form:
OL
LI ... first list item
LI ... second list item
...
/OL
Regards,
--
Don Read
need to keep using mysqlcc because it is very simple to use,
but it is very time consuming.
Any suggestions?
SET @rank:=5;
UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
UPDATE music SET chart=chart+1 WHERE chart@rank;
Regards,
--
Don Read [EMAIL
the lack of the age_range number 2: 15-29).
SELECT ELT(1+ (age/15), '0-14', '15-29', '30-44', '45-59') AS age_range
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's
/MySQLWiz/page1.html;
Cross-tabulationA
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query
and then use COUNT(*) ... GROUP BY
to get your totals.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql
|
+++
| billboard | 0 |
| classified | 2 |
| newspaper | 1 |
| radio | 0 |
+++
4 rows in set (0.02 sec)
(BTW, I think your field names are horrid ...)
Regards,
--
Don Read
? Something along
delete * in 'table' where num=1 and num=13 and num=34 etc.
Thanks a lot.
Pag
DELETE FROM tbl WHERE num IN (4,78,34,23)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going
: No space left on device
localhost.dread$
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query
had some buggy pconnect problems.
Last resort:
Don't use pconnect unless you really --and I mean *really* need it.
mysql_connect() is fast enough for just about everything.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So
%';
(stabbing wildly in the dark.)
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General
you very much in advance.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query
On 30-Mar-2003 Daniel Rossi wrote:
hi guys is this possible ? select tablename1 as table1, id from
tablename1 , tablename2 ?
select 'tablename1' as table1, id from ...
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So
) .
WEEK()
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing
/libexec/mysqld --basedi
2889 ?? IN 0:02.03 /usr/local/libexec/mysqld --basedi
133 con- I+ 0:00.02 /bin/sh /usr/local/bin/safe_mysqld
localhost.dread$
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going
, pcfvar, hour);
---
Kelly. You owe me two virtual beers.
Shiner Bock or Miller High-Life tall-boys will be fine.
Invoice to follow.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's
pissing around for an
oversight.
TIA
mysql_query (INSERT INTO userdata (email, passwd, firstname, alias)
VALUES
('$entered_email','$entered_passwd','$name','Hello'));
or die('PDatabase error :', mysql_errno(), mysql_error(), 'BR');
Regards,
--
Don Read
?
- Ville
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
or more inserts.
HTH.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL
be greatly appreciated.
Thanks in advance
anirudh
DATE_FORMAT(ts, '%Y-%m-%d %T')
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
entries, the sum(val)
will total both rows in the group --probably not what you want.
A Perl script could help clear up any duplicates.
Then you could add a UNIQUE key to keep 'em out.
my $0.02.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest
in my crystal ball but the Magic eight-ball sez:
'declare your globals.'
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
, (sORI + ':' + sDamionCode) as sCode FROM tblORI
Any hints would be appreciated.
MySQL uses CONCAT(sORI, ':', sDamionCode) AS sCode ...
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal
,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives
where release
=
curdate()-1;
Query OK, 2438 rows affected (0.11 sec)
Records: 2438 Duplicates: 0 Warnings: 0
mysql
Any ideas on how I can get rid of the bug wars???
Again. How about some examples?
Regards,
--
Don Read [EMAIL PROTECTED
be working with DECIMAL().
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL
)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
On 24-Mar-2003 James E Hicks III wrote:
snipage
mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode:
13), when using table: thefile
localhost.dread$ perror 13
Error code 13: Permission denied
localhost.dread$
--
Don Read
|
++---+--+
mysql select id,name, (@nc:=ncust) as next from b where [EMAIL PROTECTED] LIMIT 1;
Empty set (0.00 sec)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's
wishes,
Strahil Minev a.k.a. DLHelper,
BuFu TeaM mailto:[EMAIL PROTECTED]
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
') |
+---+
| 0 |
+---+
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
`
AND depo.`Iptal` = 0
AND urun.`HizmetUrunu` = 0
GROUP BY urun.`ID`
But i dont want to get a row which `Mevcut Miktar`=0
How i can modify my query.
HAVING `Mevcut Miktar` 0
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn
to eliminate
that? If not, that is just fine.
mysql -N -e select * from tbl_name db_name output
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time
$querystring\n\n);
mysql_query($querystring);
will output..
select * from mytable;
You can check the syntax of the command this way.
Yep. My code is littered with:
// echo $qry;exit;
-- and --
echo !-- $qry --;
Regards,
--
Don Read [EMAIL
);
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query
denied
Error code 2: No such file or directory
localhost.dread$
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
`
for I in $TBLS
do
mysqldump -e -q --add-drop-table $K $I $K.$I.dmp
rm -rf $K.$I.dmp.gz
gzip $K.$I.dmp
done
done
---
This gives a 7 day rotation, Mon-Sun.
With the latest dump in the 'Today' directory.
Regards,
--
Don Read
);
}
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query
);
$message1='Digitized for ' .$vals[$k];
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query
) - TO_DAYS(@b) as FebDays;
+-+
| FebDays |
+-+
| 28 |
+-+
1 row in set (0.00 sec)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time
the SELECT statement?
You'll probably need an 'ORDER BY' somewhere in there.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
montoya | [EMAIL PROTECTED] |
++---+-+
3 rows in set (0.01 sec)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time
obvious if I'd put the 'a.memberid=1' clause
first. Sorry ...)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do
:
mysql_connect($DBHost,$DBUser,$DBPass)
or die(Could not connect: . mysql_error());
$qry=UPDATE items SET ItemSKU='$ItemSKU', ...sniptherest;
echo 'P', $qry, 'P';
$res = mysql_query($qry)
or die(Invalid query: . mysql_error());
Cheers
Andrew
Regards,
--
Don Read
for 'LEFT JOIN' in the manual.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query
of.
Depending on the application language it might be easier to post-process:
$result = mysql_query('SELECT * FROM mytable');
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
unset($row[34]);
echo 'The values :', implode(', ', $row), 'br';
}
Regards,
--
Don Read
1 - 100 of 270 matches
Mail list logo