Hello Vlad,
The reason is: If one or both arguments are NULL, the result of the
comparison is NULL, except for the NULL-safe = equality comparison
operator.
Thereore, or NULL in your select statement will always returned NULL.
You can find all the rules for comparaison at URL:
You will get your answers by reading carefully the Date Time Functions
in the MySQL Reference Manual.
Look at the URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Bernard
On Wednesday 17 November 2004 16:40, Stuart Felenstein wrote:
While I'm figuring this needs to be
On Wednesday 17 November 2004 16:58, Stuart Felenstein wrote:
--- Bernard Clement [EMAIL PROTECTED]
wrote:
You will get your answers by reading carefully the
Date Time Functions
in the MySQL Reference Manual.
This will tell me how to automatically update the
column in question ?
Stuart
Look at the DATE() fucntion you can find in the REF Manual of MySQL
at URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Regards,
Bernard
On Friday 12 November 2004 12:14, sol beach wrote:
In Oracle TRUNC(data_time_var) returns only the date portion of a
date_time data
Did you tried without the : between web-server2 and 3306?
i.e. put a space insted of :
B
On Thursday 14 October 2004 19:58, Steve Grosz wrote:
I have tried telnet web-server2:3306
Didn't work
Dwalu Z. Khasu wrote:
On Thu, 14 Oct 2004, Steve Grosz wrote:
=If that's the case, its not
Hello MC,
The following is extracted from URL:
http://dev.mysql.com/doc/mysql/en/What_is_MySQL_AB.html
which answers your questions.
By the way, the ``AB'' part of the company name is the acronym for the Swedish
``aktiebolag,'' or ``stock company.'' It translates to ``MySQL, Inc.'' In
fact,
You need parenthesis around cond1 OR cond2 OR cond3 otherwise effectively you
are going to get all records matching the following:
last d AND choice1=2 + choice2=2 + choice3=2
Therefore, you select statement should be written:
SELECT * FROM name WHERE last LIKE d AND (choice1=2 OR choice2=2 OR
Hello Joe,
mysqldump is a seperate programto be execute at the system prompt.
Therefore it is not to be run under the mysql prompt.
Bernard
On Friday 26 March 2004 06:09, joe collins wrote:
I have read the documentation on the MySQLDump, but have been unable to
launch a mysql dump.
Is the
_
MSN Messenger : discutez en direct avec vos amis !
http://www.msn.fr/msger/default.asp
--
Bernard Clement
Info-Electronics Systems Inc.
Technical Director
phone: 514-421-0767 ext: 231
fax: 514-421-0769
email: [EMAIL PROTECTED
Dear Pierre,
I would suggest you to contact directly MySQL AB for such a question at
[EMAIL PROTECTED]
My guess is that you will need to buy a license for the master and the slaves.
Regards,
Bernard
On Wednesday 10 March 2004 03:19, Pierre Luguern wrote:
I want to run a commercial product
To my knowledge it is GPL.
Bernard
On Friday 05 March 2004 17:52, Ronald J. Yacketta wrote:
Folks,
What license does the MySQL C API fall under? I am looking to add client
support to a game that I am creating, but need to know the terms of the
license etc.
-Ron
--
MySQL General
Your select works fine within the month to the exception of the first day
because curdate()-1 is treated as a numeric field (see curdate in
http://www.mysql.com/doc/en/Date_and_time_functions.html)
The following seems to be what you want to do:
mysql select date_format(curdate()- interval 1
Hi Volnei,
Under Linux you do not need the -lsocket. (If I recall correctly that is for
SUN Solaris but I might be wrong)
As for your run-time error, the DLL libmysqlclient.so is not in the library
path.
Either modify /etc/ld.so.conf to include where is that library (it seems to
be
You also need to install the rpm for mysql-client.
Bernard
On Tuesday 24 February 2004 16:37, Database Administrator wrote:
I had MySQL 3.23.52-3 installed on RH Linux 8.0 (default
that comes with it). I decied to install 4.0 and used
this command to install it:
rpm -Uvh --nodeps
Dear Brad,
Your problem is too much experiences not the lack of skills.
I am in the same situation...it is very frustating.
Regards,
Bernard
On Monday 23 February 2004 11:14, Brad Eacker wrote:
Donny Simonton [EMAIL PROTECTED] writes:
But as a manager, the first thing I do is ask for code
Assuming that the address field is of type char or varchar,
Assuming that the address field has a NULL default value the following should
do it
select ... from ... wehre address is null;
In case that the address field has no default value the following should do
it:
select ... from ... where
You can use having instead of where with an alias.
Bernard
On Thursday 12 February 2004 14:46, Ian O'Rourke wrote:
Is it possible to have a 'worked out value' in the WHERE clause. The
problem I have is what I need to check for in the WHERE Clause is not a
column:
SELECT
Hello Daniel,
Try with: revoke show databases on mysql.* from [EMAIL PROTECTED];
If the user [EMAIL PROTECTED] issue show databases il will not see anymore
the databases mysql.
The revoke you were trying was not only on showing the database mysql but
revoke all the privilege, is is really
If you are using 4.0.2 and above you can use cast.
mysql select var1,cast(var2 as unsigned) from test1;
+--++
| var1 | cast(var2 as unsigned) |
+--++
|1 |562949953421312 |
|1 | 1 |
|1 |
a REFERENCE.
Look at the same URL as above for information.
Thanks!
/dev/null
--
Bernard Clement
Info-Electronics Systems Inc.
Technical Director
phone: 514-421-0767 ext: 231
fax: 514-421-0769
email: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hello Howell,
See URL: http://www.mysql.com/doc/en/Legal_names.html for the solution.
Basically enclose FILE# with `, e.g. where `FILE#` = 1332
Bernard
On Thursday 29 January 2004 12:55, Howell, Scott wrote:
I am trying to query a table that has field names with # characters in
them. For
select * from temp where `FILE#`=1332;
Empty set (0.00 sec)
Bernard
On Thursday 29 January 2004 13:44, Howell, Scott wrote:
select * from emp where `file#` = 1332;
returns
ERROR 1054: Unknown column 'file' in 'where clause'
-Original Message-
From: Bernard Clement [mailto:[EMAIL
Hello,
It might be possible to do what you want to do but...I think it will take too
much time and, therefore, will be expensive.
As stated by somebody else OpenOffice with ODBC is effectively an interesting
solution. I have done it for fun and it works quite well (after the small
nightmare
Either a BLOB or TEXT field should be your solution.
See http://www.mysql.com/doc/en/BLOB.html for the description.
Bernard
On Tuesday 27 January 2004 22:29, Eve Atley wrote:
I have a large chunk of text I've attempted to put into a varchar field,
and it chopped off a chunk of it. If I need
My guess will be that the where clause is misplaced.
Try
SELECT * From articles
WHERE SectionID=1
ORDER BY EntryDate DESC
LIMIT 1,10
PLS read URL: http://www.mysql.com/doc/en/SELECT.html
On that page it is stated that: All clauses used must be given in exactly the
order shown in the syntax
Hello Aman,
For instructions on taking the exam in India goto the URL:
http://www.vue.com/mysql/ and click on test center of To register for exams
in India, please contact the test center directly. This will bring you a
window containing all the Pearson VUE Test Center in India.
Good luck!
Hello Augusto,
You might be able to use the list of weather stations available from WMO at
URL: http://www.wmo.ch/index-en.html
Among other thing it contains the country and station name (or city name).
I know that NWS/NOAA also have that list but it seems that the list is not
available right
Hello Franz,
On Sunday 07 December 2003 12:42, Franz Edler wrote:
I do not have specific experiences with SuSE 9.0 (stiil waiting for it from my
distributor) but I do with previous versions of SuSE (7.x and 8.x),
I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it
very
rsynch will do the job correctly only and only if the mysql server on both
sides are not running. Rsynch does not deal with files opened for writing
and my guess is that MySQL is opening the database (i.e. files) for writing.
As for LVM (AKA Logical Volume Manager) I really do not see how it
I think that it is more than backing up the database you want to do. If I am
right you want to synchronize the 2 databases in which case the answer is
replication. Replication is described in the reference manual of MySQL.
Bernard
On Tuesday 18 November 2003 04:59, Paco Martinez wrote:
Is
mysqldump is a program like mysql not a command within mysql.
Bernard
On Monday 17 November 2003 21:46, Lay Hoon Tan wrote:
I keep on getting errors for saving table to an external file. I think
there is something wrong with the syntax. Could someone help me to correct
it ?
mysql mysqldump
Hello Anders,
NOTE: I am actually using SuSE 8.2 Pro Edition. However, those CRON jobs seem
to be at the same place irrelevant of the distro (RedHat or SuSE).
Therefore, I doubt that SuSE Linux Standard Server 8 has changed that.
If the problem occurs once a day then it is within the script
--host
with the hostname associated with your binding will fix the problem.
Regards,
Bernard
On Friday 07 November 2003 15:15, Bernard Clement wrote:
Hello Anders,
NOTE: I am actually using SuSE 8.2 Pro Edition. However, those CRON jobs
seem to be at the same place irrelevant of the distro
Hi Jorge,
Hum! you should use MySQL Control Center (AKA mysqlcc)?
You will not have to worry about configuring (I do not think it is feasible)
openrowset fo connect to MySQL.
Regards,
Bernard
On Thursday 06 November 2003 13:43, Jorge Paiva (f2) wrote:
Hi everybody.!
can i use openrowset
34 matches
Mail list logo