On 10/24/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Gerard wrote:
> > Currently I am running a concat statement to combine a field with a user
> > name and domain to create and email address. In testing it looks like
> > running the concat is a very s
Currently I am running a concat statement to combine a field with a user
name and domain to create and email address. In testing it looks like
running the concat is a very slow command to run. The select statement
currently looks like this.
select concat(user,'@',domain),servername,port from datab
The comma at the end of the SELECT statement needs to be removed
Naz Gassiep wrote:
Hi,
I'm trying to execute this query:
SELECT group_post.group_thread_id,
FROM group_post
LEFT OUTER JOIN group_post_moderation ON (group_post.group_post_id
= group_post_moderation
Name, Unit, TagName, CalDate, CalPeriod,
CalPeriodType,
(CalPeriod + Unit) AS CalNum
FROM tblTemp
WHERE (CalPeriod + Unit) > 7";
I do appreciate the thoroughness of your effort in coversion to Months,
However the potential for using Days looms ahe
Gerard Gilliland replied:
Michael:
Thank you for your excellent suggestion and quick response.
I now have an operable DATE_ADD.
The solution to break nPeriod into n and Period would not work directly.
That is, in the SELECT statement in the form of ...
$qry = "SELECT PlantName, Unit, Ta
General server information: July 15, 2004
Operating system: Linux
Kernel version: 2.4.26
Apache version: 1.3.31 (Unix)
PERL version: 5.8.0
Path to PERL: /usr/bin/perl
Path to sendmail: /usr/sbin/sendmail
PHP version: 4.3.7
MySQL version: 4.0.18-standard
I would appreciate any help.
Than
he command
mysql> LOAD DATA INFILE '/home/gerard/files/mysql/adress/jpilot.cvs' INTO
TABLE adresses FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY
'\n' IGNORE 1 LINES;
Query OK, 251 rows affected (0.06 sec)
Records: 251 Deleted: 0 Skip
Hi all (again),
Mysql tells methere are warnings during a importW. here can I find the
content of the warnings that occur.
Greetz Gerard, Thanx.
"Who cares if it doesn't do anything? It was made with our new
Triple-Iso-Bifurcated-Krypton-Gate-MOS process ...&quo