You could try with the <> operator.
!=, <>Not equal operator
Or you could try it this way - ISNULL(col_or_data_to_check).
Example:
mysql> SELECT ISNULL(1+1);
+-+
| ISNULL(1+1) |
+-+
| 0 |
+-+
1 row in set (0.02 sec)
Aleksander
Chris wrote:
C
How about sending the file via SCP? (it would be a much more safer to
transfer files)
-Aleksander
Chris wrote:
ioannes wrote:
I am trying to:
- check whether an image file exists on a server,
- check whether it does not exist on another server, and if not exists
- to copy from the first loca
It seems you missed my point :) if you would need all the data then
select them all, but if you need only partial data from the table then
you could limit yourself to that specific columns. I doubt everybody
need everything all the time. True?
Aleksandar
Chris wrote:
Aleksandar Vojnovic
I would also suggest to limit yourself to things you actually need not
to select the whole table.
Aleksandar
Jim Lucas wrote:
Colin Guthrie wrote:
Martin Marques wrote:
SELECT * FROM company WHERE id NOT IN (SELECT companyID FROM contacts);
Not ideal as has been mentioned else where in thi
Hi,
you should do it like this
- Aleksandar
Ruprecht Helms wrote:
Hi,
I have the problem that a phpscript is not able to read out a value from
the browserline. In the browserline I have the URL
/?id=. The id-Value I want to process within the
script but a echo $id shows me no value.
The P
In addition to Chris's suggestions you should also alter the homeid
column (set default to NULL and update the whole database which
shouldn't be a problem) so you don't have to do a double check on the
same column. I would also suggest that the TSCN_MEDIAid column should be
an int not a varchar
60k records shouldn't be a problem. Show us the query you're making and
the table structure.
OKi98 wrote:
Rob Adams napsal(a):
I have a query that I run using mysql that returns about 60,000 plus
rows. It's been so large that I've just been testing it with a limit
0, 1 (ten thousand) on
try comparing the type:
if("0" === 0)echo 'Its not equal';
if(0 === 0)echo 'Its equal';
OKi98 wrote:
Hello,
Why does anything compared to 0 return true?
I know it might seem to be a bit off-topic, but for me it is important
for detecting if NULL value in table has been changed (for example