ERROR 1044: Access denied for user: '@localhost' to database 'test1'
seems like guest login...
login with a user having appropriate priviliges.
regds,
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 15:07
To: [EMAIL PROTECTED]
Subject: Re:
do not use Ctrl-F, it will retrieve all the records and then try to find the
specific record.
Instead change the form record source property dynamically with SQL
statement having appropriate where clause, result will within eye blink.
regds,
-Original Message-
From: Sean Meegan
u can use highly customizabe MySQL DATE_FORMAT() function for retrieving
date in desired format. Relevant portion from manual is reprodcued below
inside quotes.
For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date)
function to return unix timestamp of the date and use the php
what do you mean by row number? afaik, in RDBMS primary key is the
identifier for a particular row.
u hv to use the primary key of the row in the where clause...
SELECT * FROM table WHERE primary_key_column=primary key of the row to
retrieve
regds,
-Original Message-
From: Marc Bakker
`
HAVING `Mevcut Miktar`0
regds,
-Original Message-
From: Aziz DURMAZ [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 22, 2003 13:54
To: Uttam; [EMAIL PROTECTED]
Subject: RE: A query problem...
Its gives an error
SELECT DISTINCT
table1.column1,
table1.column3,
table2.column1,
table2.column2,
table3.column3,
table3.column4
FROM
(table1LEFT JOIN table2 ON table1.column1=table2.column1)
LEFT JOIN table3 ON table1.column3=table3.column3;
you can
But i dont want to get a row which `Mevcut Miktar`=0
How i can modify my query.
-
SELECT urun.`StokKodu`,
urun.`Isim`,
(SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar))
AS
`Mevcut Miktar`
FROM rootdata.urun AS urun,
*if you create a column of the type TIMESTAMP instead of DATETIME then it
automatically stores the time when the record was inserted/last updated. If
you have more that one column of type TIMESTAMP in the same table then only
the first TIMESTAMP column gets updated automatically. (Don't confuse
is a crosstab is what you want?
pls. give the result (output of the query) that you expect from the example
and what you are actually getting.
regds,
-Original Message-
From: Charles Kline [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 15, 2003 20:53
To: [EMAIL PROTECTED]
Subject:
try this:
SELECT PG1.*
FROM project_group_list AS PG1 LEFT JOIN project_group_list AS PG2
ON PG1.ref_project_group_id = PG2.project_group_id
WHERE
(PG1.root_project_group_id=10 AND PG1.inherit=1 AND PG2.inherit=1)
OR (PG1.project_group_id=10)
OR
select f2 from tt where f1=1 having f2=max(f2);
Empty set (0.00 sec)
The correct way to get the desired results in MySQL is two step:
*SELECT @a:=max(f2) from tt where f1=1;
*SELECT f2 from tt where f1=1 and [EMAIL PROTECTED]
regds,
-Original Message-
From: Bruce Feist [mailto:[EMAIL
HAVING is applicable only when you are using GROUP BY clause, HAVING acts on
the resultset after records are grouped while WHERE restricts the records
which are used in grouping.
Manual clearly states (under WHERE optimisation) that:
HAVING is merged with WHERE if you don't use GROUP BY or group
Hi Bruce,
yep, u r right.
Anyway, MySQL query optimizer will take care of it ;)
regds,
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 02, 2003 04:00
To: [EMAIL PROTECTED]
Subject: Re: A Simple Query!
Hello, Uttam;
We can simplify this, actually
*DISTINCT omits data bases on selected fields only. i.e. if you have
thousand rows having different dates in 'mydate' but all having year 2002,
then SELECT DISITNCT YEAR(mydate) will return only 1 row i.e. 2002.
* DISTINCTROW omits data based on entire duplicate records, not just
duplicate
here's my version of the answer:
SELECT
F.idFilm, F.title
FROM
Films F LEFT JOIN Loans L ON F.idFilm = L.idFilm
WHERE
(L.idFilm IS NULL) OR (L.dateReutrn IS NULL)
;
regds,
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01,
have you indexed table on uniqueref field? if the table is not indexed on
uniqueref than your query will require a full table scan.
(my goodness, that's a HUGE table!)
regds,
-Original Message-
From: John Berman [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 03:34
To: [EMAIL
Does anyone know how to pass a variable from a page embedded with a .swf (flash)
object to a .php file for processing, and pass back the results to the same page
containing the .swf file?
Thanx in advance!
17 matches
Mail list logo