Verified. this is a bug
empty table or 1 record returns expected result, insert one more record and
the result of now() is empty.
mysql> select now(), count(*) from t where a in (2);
| now() | count(*) |
| 2001-04-21 08:12:03 |0 |
1 row in set (0.00 sec)
mysql> inser
I'll try to translate:
in oracle one can turn off indexes within a query (full-table-scan) by
using: +0 or ||''.
for example:
SELECT *
FROM tabelle
WHERE eigenschaft||'' = 'text';
SELECT *
FROM tabelle
WHERE id+0 = 1;
can one do this with mysql?
- Original Message -
From: "Hagen Schmied
Yusuf,
i don't understand why you are so angry and are trying to fight it out on
this list.
1. Loads of computer-related things are vulnerable for different
explanations. especially with software that is easily ported between
platforms, it's also easy to have a manual that is not dedicated for o
on my linux boxes this is:
/etc/rc.d/init.d/mysql stop | start
- Original Message -
From: "Martin Cabrera Diaubalick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 9:42 AM
Subject: Help restarting mysqld !!
> Hello everyone! This is the first time I post her
take a look at /var/mysql :)
- Original Message -
From: "Philip Mak" <[EMAIL PROTECTED]>
To: "feldekis" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 11:59 PM
Subject: Re: there is no mysql/var directory
> On Wed, 18 Apr 2001, feldekis wrote:
>
> > Hi every
lol. guess yusuf gots some point here.
Obviously, for one reason or another m$ decided to place some files in the
%windir%, and some in the %windir%\system32 dir. Although it never became
totally clear to me what structure they had in mind (if there is any).
Roughly said: %windir% is for executa
well, start with reading a book about designing databases, especially about
the subject 'normalisation'.
normalisation is a way to split up data ('entities') in a way that every
piece of data only occurs once in your database. (although sometimes for
practical reasons you may decide otherwise, but
escape the apostrof with a backslash:
select ID from table where sentence = 'does\'t take'
you should do this for some other characters as well, like the backslash
itself.
if you'd use php you could use the function 'addslashes()';
basically what you should do to make a string binary-safe is re
select sum(a)/3 from atable order by record_id desc limit 3;
- Original Message -
From: "Kevin Xin Lin" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Sunday, April 15, 2001 9:04 PM
Subject: how to get average value for top n records?
> Hi, if I have a table with only one fie
the 'integers' you insert as key are too big to fit in the size of a
integer.
mysql replaces such a big or small integer by the biggest or smallest value
possible.
if you look closely at your query, you see that the key returned by mysql
are not the same values as you inserted.
you have to: or cha
you try to select the march 87. 2001 ;)
read the manual about date/time conversion and math:
mysql> select current_date(), current_date()-0, current_date()-14;
| current_date() | current_date()-0 | current_date()-14 |
| 2001-04-12 | 20010412 | 20010398 |
1 row in set (0.00 se
although it somehow _is_ possible (even documented but i don't know where,
registry settings should do) to run services on win 9x, like virus scan and
other stuff...
if someone knows details :)
- Original Message -
From: "Dan Harrington" <[EMAIL PROTECTED]>
To: "Sylvain Besson" <[EMAIL PR
i'm very suprised this table definition works for you.
on a -some elder- version of mysql i could not create something like:
create table test (
t integer,
unique (t)
);
well, i then get a warning form mysql, about the field being able to be NULL
so that it could not be unique.
create
stop mysql service, restore the backup from the mysql.user table (or: copy
from a other mysql with known users, or: copy from the installation files),
restart mysql.
- Original Message -
From: "Bob Dushok" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 1:09 PM
Su
not for speed, but i defitively prefer your second query. Reason for this is
simple: you name the field you want to insert.
with your first query, if you'd ever alter the table you would have to check
all your source code that interacts with this table.
speed difference should be very minimal an
try
delete ... limit n;
where n is a reasonable (small) amount. repeat until 0 rows affected :)
- Original Message -
From: "Basil Hussain" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 7:10 PM
Subject: Question about low priority deletes
> Hi,
>
rapid answering...
regards,
rene
- Original Message -----
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Amazing-Books.Com" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 5:16 PM
Subject: Re: Complexe query
> select book.ti
excuse, this just won't work.
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Amazing-Books.Com" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 5:16 PM
Subject: Re: Complexe query
> select book
well, as easy as is: store the original password, or use a php/your
programming_language_specific function like encrypt() and decrypt().
password function is (and should be) irreversable, like a md5 hash. that's
where it's ment for.
- Original Message -
From: "Kevin Williams" <[EMAIL PRO
select book.title, video.title, music.title from provider, book, video,
music where provider.name='providername' and
book.provider_id=provider.provider_id and
video.provider_id=provider.provider_id and
music.provider_id=provider.provider_id;
- Original Message -
From: "Amazing-Books.Com"
make sure the field definition where you store your password is at least 16
bytes size (i.e. char(16) or varchar(255) or something). i guess such must
be a problem since your query looks just fine.
gl
rene
- Original Message -
From: "jsimlo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
make sure you send the right mimetype to the client with the php header
function.
some browsers try to detect the mime-type based on the file extension if
they are unsure about the sent mime-type, but you should not rely on this
and different browsers/version are likely not to generate the result
platform independency, reasonable portability, performance(!), optimal
load/performance ratio, loads of access methods including odbc and web based
scripts like php,asp, active development, integration with apache
authentication, very very good & personal online help (this mailing list :),
low net
well, i think you'll have to work with frames. 1 php script shows your
refreshing data, 1 script allows the user to enter data (this could be a
single script called with different parameters as well).
then in the refreshing script you put something like this before sending any
other data:
header
maybe he hasn't got telnet server. probably win32 < w2k.
- Original Message -
From: "Seung-woo Nam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 23, 2001 6:41 AM
Subject: Re: howto: telnet shell
> Why not just telnet into the server where mysql is running and log into
where's the second option?
about your construction:
> We populate 2 tables:
> one containing the documents (text and ID)
> one containing all the words and the documents ID containing each word
how you plan to make 1 table with words, and several (unlimited)
document_ids?
what you'll need is:
1
the email list seems to be very slow now and them... wouldn't it be an
option to make a web-based list ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Regarding to the manual there is no difference between blob and text fields,
except that searching on text fields is case-insensitive and searches on
blobs are binary safe.
However, i'm quite stunned if you say you cannot use mysql_query to query
binary data, i've never experienced this problem:
m
what about:
CREATE UNIQUE INDEX id ON thistable (APPCODE, EMAILID);
regards,
rene
- Original Message -
From: "Duke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 4:02 PM
Subject: Wats the CREATE TABLE statement?
I would like to know how to write a SQL st
copying tables between databases:
create table db2.table2 select * from db1.table1;
however, you'll loose meta data (indexes) on this table, so you'd have to
create them again.
second method:
use the explorer or a dos shell to rename any table or db as shown in the
\mysql\bin directory. From wi
's not only libmysql.dll that suffers from this problem, it's also
the (original) client...
regards,
rene
----- Original Message -
From: "Boulat Khakimov" <[EMAIL PROTECTED]>
To: "René Tegel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursda
t as far as i see this php.ini
dramatacally changes with any version.
sorry mysql list, it has in fact nothing to do with mysql.. but it took me
several hours on several days within the last year...
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: &quo
I've ran into some problems when connecting to a mysql server over a
long-distance connection (i.e.: the internet). The first time a client
reconnects from a idle connection this reconnect fails, only the second time
it succeeds.
The main problem is that i've written a win32 app that connects to t
use ftp to copy your database/table files :)
- Original Message -
From: "rozakdemir" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 10:05 PM
Subject: win to linux
Hello,
I am using MySQL on windows platform. How can I port mt datas from MySQL
server on wind
you chowned mysql.cnf to owner/group mysql ?
- Original Message -
From: "Bill Marrs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 1:16 PM
Subject: setting simple mysqld options in /etc/my.cnf
> Hi,
>
> I like to run mysqld with these 3 options:
>
> --log-s
I've ran into some problems when connecting to a mysql server over a
long-distance connection (i.e.: the internet). The first time a client
reconnects from a idle connection this reconnect fails, only the second time
it succeeds.
The main problem is that i've written a win32 app that connects to t
, especially when releasing
minor upgrades/patch levels. This stuff can take loads of time from the
programmer, just by changing platform version from v4.01 to 4.04pl1
regards,
rene
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: "René Tegel"
this was true on php 4.01 but not on php 4.04pl1, i have to escape my
strings again. or it's some switch or conf setting i never
seen/heard/thought of...
i now use $var=addslashes($var) on php4.0.4pl1 redhat 7 where i do not have
to on a other system running php4.0.1 redhat 6.2 !
especially php
d the mod_auth_mysql this weekend and did not experience
any problem as well.
So there sure is some kind of conflict which I wouldn't dare to tell which,
but it probably is not mysql 3.23.34 to blame!
regards,
rene
- Original Message -----
From: "René Tegel" <[EMAIL
I installed the MySQL 3.23.34-1 rpm on my redhat 7 box. It all seemed to
work fine, but suddenly i got this error in numerous of my php scripts. it
happens only on update and insert statements. The data however might have
been stored in the db.
Warning: MySQL: Unable to save result set in /var/ww
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Thomas Morton" <[EMAIL PROTECTED]>
Sent: Sunday, March 11, 2001 8:42 PM
Subject: Re: May I ask for your assistance?
> Thomas,
>
> as far as i know, i didn't notice _any_ diff
Well yes, i had troubles with the list as well - i did not see any message
on nor the mysql list nor the win32-mysql list... i figured i could be our
is' mail server, so i offered to join the list with another e-mail account.
I only got it confirmed after >> 24 hours...
So there are networking pr
The documentation describes the use of "set password = password ('newpass')
as:
"PASSWORD = PASSWORD('some password')
Set the password for the current user. Any non-anonymous user can change his
own password!"
Well, nice I thought, a user can change it's password without having access
rights to m
i guess the calculation returns a result (ie: whether it's successfull or
not), so '1-1' evaluates true; but 1-A evaluates false because A is not a
number so you can't calculate on it.
So in your case, this would be:
where user_num+"AL011-33"
if user_num='0':
where '0'="%any%"; /// returns True
You did use
flush privileges;
after inserting the new users? elsewise mysql won't recognize them until a
restart.
- Original Message -
From: "Michael Fischer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 2001-02-18 7:55 AM
Subject: Unable to designate host
>
> Ok, I looked throu
> Sometimes it says something like 'NTLM authentication
> required'. I have IIS 5 installed. Does anyone know what I can do to
> connect?
well yes (although this is in fact not mysql related).
w2k offers it's own telnet server, very handy to connect to a w2k machine
with the command prompt (and
easy:
linux/unix:
mysql -h myhost -u myuser -p [mydatabase] < mysqcript.sql
nt:
type myscript.sql | mysql -h myhost -u myuser [mydatabase]
where "mydatabase" is optional.
tip: read the manual, it's all in there :)
gl
rene
- Original Message -
From: "Andris Jancevskis" <[EMAIL PROTE
i agree .. the mysql server _should_ accept telnet sessions. Maybe in a
future release ? it'd really be very handy
- Original Message -
From: "Quentin Bennett" <[EMAIL PROTECTED]>
To: "'@ndYD'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 7:56 PM
Subject: RE
Well, depends how you want to connect.
For example, if you have the mysql odbc driver, you could use odbc to
connect.
However, i personally prefer to use libmysql.dll, with a delphi interface
file.
I can send you the interface file i use if you want (originally written by
bob silva, but i adjusted
?
regards,
rene
- Original Message -
From: "Tim Samshuijzen" <[EMAIL PROTECTED]>
To: "René Tegel" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 3:07 PM
Subject: Re: amazingly slow
Yep, all requested fields are indexed.
At 02:25 PM 6-2-2001 +0100, you
gards,
rene
- Original Message -
From: "Tim Samshuijzen" <[EMAIL PROTECTED]>
To: "René Tegel" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 1:58 PM
Subject: Re: amazingly slow
Dear René,
Thanks for your reply.
Oops, the 513 was a typing mistake.
Tim,
1. i'd remove 1 Mb from your 513 Mb machine... maybe it's an very old edo
simm or something.
2. you put an index on all requested fields (maintable.recordnumber and
wordindex.word) ? I bet not.
> - Original Message -
> From: "Tim Samshuijzen" <[EMAIL PROTECTED]>
> To: <[EMAIL
go to www.codecity.com
mysql just does not support in :(((
it's good, but far for 'sql compliant'...
gl
rene
- Original Message -
From: "Henrik Lebtien Mohr" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 7:46 PM
Subject: newbie: problem with "
If you mean you link table techadress to table domains, and then billing & admin
adress to techadress, then i think you'r odd..
You should learn some about 'normalization', look for it on the web or in a book.
I'd suggest something like this:
Customer
client_id
clientaddr_id
..details...
D
I have some problems with the win32 interface dll libMySQL.dll.
Everything works out fine when only retrieving correct queries.
However, when executing an incorrect query, everything behaves normal until i
terminate the application (and thus unload the dll).
With other types of access (mysql co
You might want to try the php-nuke 'construction kit'. Looks good
(www.wageningen.org was build using this, take a look)
- Original Message -
From: "John Williams" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 8:44 PM
Subject: Web Interface
> I'm running
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Jeff Harris" <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 9:09 PM
Subject: Re: system requirements?
> Jeff,
>
> yes the win32 version of mysql runs perfectly under nt.
>
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Redvers Davies" <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 7:17 PM
Subject: Re: [CGI] Gas Prices
> This sure would be a reason for microsoft to distribute less cd
mistake, sorry. works not either (see last message)
- Original Message -
From: "Remco van den Berg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 3:15 PM
Subject: Re: How to select the 10 last items from a table?
> On Wed, Jan 31, 2001 at 08:00:23AM -0600,
This works:
select * from db.table A, db.table B WHERE A.id=B.id order by B.id,A.id desc
limit 10;
regards
rene
- Original Message -
From: "Remco van den Berg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 3:15 PM
Subject: Re: How to select the 10 last i
Barry,
This can be done using normal insert/update statements. You only have to
'escape' the binary zero, the backslash and the quotes (' or ") out;
suppose jpg contains the binary data, the following code will do the trick:
(pseudo code:)
for (i=length(jpg); i--; i>0) {
if (jpg[i] in [#0,
The most lovely feature of auto_increment is one of the reasons why we
switched from interbase to mysql. Instead of having to call a stored
procedure every time you need a unique id, or obtain one by triggers, or
create a semi-unique one the way you do, one just have a flexible and
controlable uni
Yes tim, buy better/faster hard drives and/or put more memory in your
machine.
this 60% idle is the time your proc is waiting for the hard drive reading
data.
- Original Message -
From: "Tim Samshuijzen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 4:03 PM
Very nice. Recommend to go there, could come a awfull lot of tricks & things
to know there, in a entertaining way.
- Original Message -
From: "Jeff Cordova" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 6:54 PM
Subject: New way to learn Mysql?
> I've spent t
Tor-Erik,
If 'I' was a language syntax interpreter, i'd see
"where not field like pattern" as
where (not(field) like pattern
and
"where field not like pattern" as
where (field !like pattern)
notice that not(field) probably returns 'False' so your first query is:
where False like pattern
wit
I really miss a function to retrieve the free disk space on a MySQL server.
Previously this was not a problem since a ran PHP and MySQL on the same server, but
for performance reasons i split them.
However, there seems no function to get the free disk space automatically via MySQL,
so a 'inte
I really miss a function to retrieve the free disk space on a MySQL server.
Previously this was not a problem since a ran PHP and MySQL on the same server, but
for performance reasons i split them.
However, there seems no function to get the free disk space automatically via MySQL,
so a 'inte
67 matches
Mail list logo