At 02:57 PM 1/22/2004, David Blomstrom wrote:
I recently installed a preconfigured package with Apache, PHP and MySQL
from "Apache Friends" (XAMPP). It seems to be a pretty slick package, and
I got all three programs up and running without too much trouble. Now I'm
beginning to learn about MySQL
At 12:42 PM 1/3/2004, Ugo Bellavance wrote:
> -Message d'origine-
> De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
> Envoyé : Saturday, January 03, 2004 9:24 AM
> À : [EMAIL PROTECTED]
> Objet : MySQL Control Center!!!
>
>
> Hello:
>
> I have been reading MySQL Control Center. There are sc
At 02:19 PM 1/22/2004, David Blomstrom wrote:
I'm using a preconfigured package that includes PHPMyAdmin, which seems to
be a pretty good program. However, I just read that similar programs are
available, including MySQL Control Center, EMS MySQL Manager, urSAL,
PremiumSoft MySQL Studio and MySQ
access to the SQL server. They would need to access the
webserver which has programs on that allows limited in-direct access to the
SQL server. Hope this helps.
Patrick Shoaf
IT Manager
At 02:41 PM 1/19/2004, [EMAIL PROTECTED] wrote:
Could someone please tell me if tyhe following is possible
At 09:37 PM 1/5/2004, Bryan Koschmann - GKT wrote:
Hi,
I'm trying to get a software designer to write us some software using
MySQL as the database server (he currently requires MS SQL). It is all
windows based software (written in VB).
So far his arguments against it are this (not my words):
-No
It is always best to set fields sizes as small as possible, to both
conserve disk space, as well as improve performance. The smaller the
record the faster the queries. While you do not want to make any field too
small, you also don't want to make it too big. With current databases, you
can e
I have a single table that I need to pull info from can anyone help?
Table: Product
Fields: Itm_Code, Itm_Color, Itm_Size, Itm_Price, Itm_Desc, otherjunk
Primary Key(Itm_Code,Itm_Color,Itm_Size)
I am using ColdFusion MX as my programming language, CF does not permit
queries within queries.
Sampl
Try the following:
SELECT ip_address, url, count(distinct ip_address)
FROM tablename
GROUP BY ip_address, url
At 09:48 PM 10/21/2003, John Kelly wrote:
: > -Original Message-
: > From: John Kelly [mailto:[EMAIL PROTECTED]
: > Sent: Tuesday, October 21, 2003 3:45 PM
: > To: [EMAIL PROTECTED
I have several queries that are taking at least a full minute to process...
From a web page, user submits parameters to a perl program which performs
multiple queries, then spits the info out formatted for the web.
Does anyone have a quick & dirty method of locating a bottle neck slowing
these
I am not very familiar with php, but why are you using an echo within an
echo statement?
echo "$fname $lname$title";
why not try this
echo "$fname $lname";
echo "$title";
echo "";
echo "";
Also, most languages require you to escape " when used within quotes.
At 01:32 PM 10/17/2003, Jordan
I believe the problem is in the ODBC drivers on MS Winx platforms. I have
no problems accessing MySQL from MySQL Control Center or from perl or other
programs NOT using ODBC. I have a MS FoxPro application using ODBC to
connect to MS SQL Server via TCP/IP and MS FoxPro has problems connecting
zes field.)
Is this a 4.1 Bug? I loaded from the 4.1.0-0 Linux x86 RPM files. So far
nothing else appears broken. Any suggestions?
Patrick
At 09:11 AM 9/18/2003, you wrote:
Patrick Shoaf <[EMAIL PROTECTED]> wrote:
> I have a table name product defined as follows:
> Item_Code
> It
I have a table name product defined as follows:
Item_Code
Item_Size
Item_Color
Item_img
Description
Cost
Retail_Price
Category
and other non-essential items, such as qty based on code,size,&color
The data is as follows:
j2400 S BLK j2400blk.jpgBlack Jacket12.00 24.00 Jacket
Try
SELECT * FROM contact INNER JOIN contact_account ON
contact.contact_id=contact_account.contact_id WHERE
contact_account.account_id = 13
At 04:17 PM 8/19/2003, Jack Lauman wrote:
I have two tables, contact_account and contact.
contact_account has two fields: contact_id (pk) and account_id
At 03:18 PM 8/19/2003, you wrote:
I may be trying to do too much in a single query here, but it would be
nice if I could get it working! Apparently, the version of MySQL used by
my work does not support the WITH ROLLUP feature, otherwise I think that
would work.
What I have are 3 tables: gc_inf
I am running the current version which is labeled ColdFusion MX. According
to Macromedia, you need a Pentium Processor, 128M RAM Minimum, 256M RAM
recommended, and 512M RAM preferred, and 350M id HD space. I was running
MySQL, Apache standard & secure, Sendmail for 25 people, ColdFusion MX, an
I am currently running ColdFusion MX on my Linux Servers access both MySQL
from different Linux Servers and MS SQL from a MS2000 WS. ColdFusion and
MySQL are both available and run on both Win & Linux machines. I also have
PHP installed on Linux, but have never attempted to learn & fully utili
Thanks, worked perfectly!
At 04:17 PM 7/9/2003, gerald_clark wrote:
fsttik has dashes in it and your having does not.
Either add dashes to your having or change the alias to min(datein+0) as
fsttik.
Patrick Shoaf wrote:
I am trying to get a SELECT working and not having any luck, can someone
I am trying to get a SELECT working and not having any luck, can someone
please help?
SELECT
strref,acc.acctno,acc.namelast,acc.namefirst,phone1,adddate,min(datein) as
fsttik, sum(amt) as sales,store FROM acc,sdtik WHERE
acc.acctno=sdtik.acctno and voidreason=0 and store>=40 and store<=59 GROU
I have four tables I need to query for information;
acc,accmemo,aard,sdtik where
acc contains basic information about a customer (1 rec per acctno)
accmemo contains multiple Account Memo messages (0 or more recs per acctno)
aard contains credit card(s) information (0 or more recs per acctn
I am using 4 120G IDE Drives with an Adaptec IDE RAID Controller on RedHat
Linux providing 240G of RAID 5 storage. While not quite as fast as SCSI, I
have found this to work very well. You should be able to pickup a nice
dual processor XENON 2.4Ghz system w/1G Ram and IDE RAID loaded with RedH
I tired both statements you suggested. The update is what I would like to
use, but I got an error, ERROR 1064: You have an error in your SQL syntax
near ' sdtik set sales.sales '
I used the REPLACE command, but it had the effect of adding records for
customers not in the statistics file.
I have two tables...
Table 1 newdata contains a lot of statistical data on our customers,
including last 12months sales amt.
table 2 sdtik contains all ticket information for all customers.
Both tables have acctno as primary key.
I can use:
SELECT sum(if(voidreason>0,0,amt)) as sales FROM sdtik
I have a question, when loading dates into mysql I have found I can always
use MMDD or -MM-DD, but frequently I need to load data from ASCII
csv files where the date is M/D/. Currently, I am using perl to read
the datafile and insert each record after converting the date data. I
w
At 09:48 AM 6/4/2003, you wrote:
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2003-06-04 09:17:01 -0400:
I need all data in sales1 and sales2, but only for records from acc that
are in either/both sales1, sales2.
SELECT acc.name, acc.phone, acc.acctno,
sales1.amt AS mo1sales, sale
I am fairly new to MySQL and SQL in general. I have three tables,
acc,sales1,sales2. All have acctno in common. acc is general customer
table with lots of information. sales1 is a generated table of sales for
specific customer from a given month/year. sales2 is the sale as sales1
except for
26 matches
Mail list logo
