icketing ";
hans
Rhino wrote:
> - Original Message -
> From: "Hans Bernard" <[EMAIL PROTECTED]>
> To:
> Sent: Wednesday, April 06, 2005 6:06 AM
> Subject: DATE & TIME
>
> > Hello,
> >
> > i need to have the time in this output
Hello,
i need to have the time in this output. in MySQL database
phpmyadmin always puts -00-00
i need it to be like this
01-APR-2005 >> DD-MMM-
the time needs to be like this
22:55 >> HH:MM
can somebody help
hans
--
MySQL General Mailing List
For list archives: http://lists.mysql.
araison at URL:
http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
Regards,
Bernard
On Thursday 02 December 2004 06:48, Vlad Shalnev wrote:
> Hi, All
>
> It's happen after upgrade from 3.23.46.
>
> Just look at this set of queries
>
> mysql>
.
For MS WIndows I cannot really help you! Probably using the "at" command.
Under Linux you can use cron to automatically start mysql
with your update statement. You can run it as often as you wish.
The command might look like: mysql -u -p -e "update ..."
Bernard
On Wednes
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 nee
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_tim
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 cas
I have a webapp that runs from a slave (read-only) database. Sometimes the
slave database is unable to connect to the master and the data becomes
stale. Is there a way to query out the time of last replication (or the
time elapsed since last replication) so that I can warn the user of the
webapp
es to ``MySQL, Inc.'' In
fact, MySQL, Inc. and MySQL GmbH are examples of MySQL AB subsidiaries. They
are located in the US and Germany, respectively.
Bernard
On Thursday 10 June 2004 05:03, mc wrote:
> Hi,
>
> I would like to know what does the 'AB' in MySQL AB stan
---+--
+-+
| Test | ref | K0| K0 | 17 | const |1 |
Using where; Using filesort |
+---+--+---+--+-+---+--
+-----+
Thanks for any help
-
Bernard Cha
WHERE last LIKE "d" AND (choice1="2" OR choice2="2" OR
choice3="2");
Bernard
On Friday 07 May 2004 13:51, Bob Cohen wrote:
> Here's my question. I wrote this query:
>
> Select * FROM name WHERE last LIKE "d" AND choice1="2&quo
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
tall
MySQL from the RPM.
Salutations,
Bernard
On Wednesday 24 March 2004 05:01, sanaâ Aitouchen wrote:
> j'ai le red hat 9 et j'ai télécharger mysql-3.23.58-pc-linux-i686.tar.gz
> j'ai crée le repertoir /usr/local/src et j'ai fais
> gunzip mysql-3.23.58-pc-linux-
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 prod
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.
>
> -Ro
--+
| 2004-02-29|
+-------+
1 row in set (0.00 sec)
Bernard
On Monday 01 March 2004 05:15, Campanella Danilo wrote:
> Hi,
>
> Look at what happened today :
>
> mysql> select curdate(
/local/mysql/lib/mysql from your gcc command line). In which case do
not forget to run ldconfig -n
OR
Set the environment variable LD_LIBRARY_PATH to where the library is installed
(again from your gcc command line it seems to be /usr/local/mysql/lib/mysql).
Regards,
Bernard
On Wednesday 25
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:
>
> rp
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
address='';
If one or more of my assumptions are wrong PLS provide us with the structure
of your table with "describe tables ..."
Bernard
On Tuesday 17 February 2004 14:16, Caroline Jen wrote:
> Please help. What is the syntax of idenfying those
> who "do not&
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 W
vilege, is is really what you want to do?
BTW, nex time also supply the error text.
Regards,
Bernard
On Sunday 08 February 2004 08:49, Daniel Audette wrote:
> Hello
>
> I am new to mysql. What I want to do is give a user a right to create
> databases with all rights but I d
1 | 32768 |
+--++
3 rows in set (0.00 sec)
Note I add a row with "1" and another with "16".
Bernard
On Friday 06 February 2004 16:22, Greg Vines wrote:
> With sets if you select the set, you get a comma delimited list, but if
> you add z
Some answers within your message.
I would suggest you to browse the reference manual.
Bernard
On Thursday 05 February 2004 17:27, /dev/null wrote:
> wow, nice product. Pretty easy to use and install - I like it.
>
> I know enough about SQL and databases to just about break any
00 sec)
mysql> 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'
>
>
>
>
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
> the
never used the product myself but it seems to be a good part of
your solution.
Bernard
PS I am not associated with the company making MySQL Manager, i.e. I am not
paid for marketing or selling it.
On Wednesday 28 January 2004 16:27, Annie Law wrote:
> Hi,
>
> I would appreciate he
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
er shown in the syntax description. For example, a HAVING clause must come
after any GROUP BY clause and before any ORDER BY clause. "
Bernard
On Sunday 18 January 2004 06:21, Ian O'Rourke wrote:
> Any idea what is wrong with the following:
>
>
> SELECT * From articles ORDER B
you seem to have mixed single and double quotes.
this might be your problem
- Original Message -
From: "Hassan Shaikh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 10, 2004 7:06 AM
Subject: Automatic conversion from `char` TO `varchar`
> Hi,
>
dia.
Good luck!
Bernard
On Friday 09 January 2004 22:29, Amanullah wrote:
> I'm also interested to take up the certification exam on Mysql,
> pl. guide me how to proceed to get certification on the same,
> I'm in India (chennai).
>
> -aman.
>
> Arjun Subramanian
Hello marc,
Look at the URL: www.mysql.com/training/courses/using_and_managing_mysql.html
There are courses coming soon at Boston and another one in Washington DC which I think
is fairly in the Northeast of the US.
Regards,
Bernard
Marc Dver <[EMAIL PROTECTED]> wrote ..
> This might
now.
Good luck,
Bernard
On Thursday 18 December 2003 09:32, Augusto Cesar Castoldi wrote:
> Hi,
>
> I searching for a database, with the 'complete' world Countries, cities,
> states
>
> Just like http://www.datingplace.com/servlet/NewRegistration
>
> I need
I think you have done all it could be done using YaST.
You need now to jump into the documentation of MySQL.
I will suggest that you read the tutorial in section 3 of MySQL's
documentation. (URL: http://www.mysql.com/doc/en/Tutorial.html).
>
> I would be very happy to get some help.
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:
>
could be
used to take a snapshot in MySQL. However, I could be wrong here.
Bernard
On Tuesday 18 November 2003 05:12, Simon Green wrote:
> Has any one use LVM to take a snapshot in MySQL and use this to back up
> data?
>
> Simon
>
> -Original Message-
> From:
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 ?
--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 p
ivation of
mysqladmin that generate the error.
I cannot really tell what you have to do to have mysqladmin to work correctly.
Probably you will have to specify a user with some kind of "root" permission.
I hope that I have been helpful.
Regards,
Bernard
On Friday 07 November 2003 14:47, An
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.!
>
>
would do using
SELECT for a field in a specific table and then ORDER BY?
Thank you for any help,
Bernard
__
Post your free ad now! http://personals.yahoo.ca
hello
in delphi the type for max(date) if tstring.
the only problem is there is no CAST in mysql 3.23.49
bye
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: "'Jean Bernard'" <[EMAIL PROTECTED]>
Sent: Thursday, April 25,
i write a program using MyIsam,and i want uses Innodb.
the query:
select max(date_comp) as mdate from pieces
on MyIsam mdate is a date.
on InnoDB mdate is string.
win2000
delphi6
zeosdbo
it's normal?
-
Before posting, plea
Sequence+1) ;
select * from Generator ;
+--+
| Sequence |
+--+
| 0065535 |
+--+
Here something doesn't work, or I probably not undestood !
Thank you for any help
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul de LYON)
Tél : 04 72 69 42 18
http://
Hi
i have this error with create table (Innodb)
Error: 1005 - Can't create table '.\pdx\factures.frm' (errno: 150)
?
Thank's
MySQL 3.23.47 win32
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
esult() in a dummy function. (by dummy, i mean nusefull)
but I still got 'out of sync'
Perhaps, the solution is to close and open a new connection
in such a case ?. But before that, I want to understand.
Thank you for your help
Regards.
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul
tes: 0
r_requests: 0
reads: 0
handler status:
read_key: 5704
read_next:1706
read_rnd47
read_first:394
write:1447
delete 0
update:465
Table status:
Opened tables: 26
Open tables:
The query concerned is a small select (only 1 field) on a small table (6 fields)
(the max_allowed_packet is set to 16M )
Has anybody encountred a similar problem ?
Is there a relation with the net_read_timeout (set to 30)
Thank you
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul de LYON)
Tél :
admin processlist', I see about 10 threads of
insert/update/select
worst, if I do a 'mysqladmin kill ...' to kill some thread, nothing
happens
The only way to recover, is to kill the mysqld processes and restart mysql
Thank you for your help
--
Bernard CHAMBON
IN2
i log administrator
i have created the directory c:\ibdata\ibdata1
same error..
Regards,
Jean
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, November 01, 2001 10:59 AM
Subject: Re: error starting mysql
> Hi!
>
i have installed MySQL on W2000
my my.ini is :
[mysqld]
basedir=C:/MySQL
#bind-address=192.168.0.1
datadir=C:/MySQL/data
#language=C:/MySQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
innodb_data_home_dir = c:/IbData
innodb_data_file_path = ib
the connection process. Once connected I can deal
with the SQL side of things.
Regards
Bernard Davis BA, M.Phil.
http://www.authorware.org.uk
[EMAIL PROTECTED]
http://www.castlecs.co.uk
-
Before posting, please check:
http:
The problem is still there !
The autocommit option seems to be an session command.
Is there any way to set it for the whole server ?
Thank you for your help
Sincerely.
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul de LYON)
Tél : 04 72 69 42 18
http://www.in2p3.fr/CC
-
i know scratch the project
.. seriously ?)
Cheers
Bernard Clist
Bernard-Olivier Clist
Administrateur du site Internet de l'OGE
Site Web : http://www.geometre-expert.fr/
Mél : [EMAIL PROTECTED]
-
Before posting, please
-ez/ezmlm-cgi?1:mss:67632) but could not get any
solution.
I hope one of you will able to give me a clue...
Thanks a lot in advance!
Bernard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
55 matches
Mail list logo
