 | | | MySQL General | | Chua Choon Keng <choonkeng@(protected) > wrote
> Dear all
>
> I am new to mysql replication. I know how to use
> the --replicate* options but I would like to know
> whether the options act as fiSo what are you asking? I 'm confused. Are you asking just to get
'Tuesday '? (SELECT DAYNAME( '2004-03-23 ') ) The value of Tuesday where
inventoryid 1? (SELECT DAYNAME( '2004-03-23 ') FROM inventor
Hello
I have been running mysql3.23 on FreeBSD server for a long time.Lately i decided to upgrade mysql3.23 to mysql4 using ports. So i first did "make uninstall " in usr/ports/databases/mysql323In the last episode (Mar 23) Jacque Scott said
> I need to create a query that will sort by a alpha numeric field. I
> need the ID field returned and one problem that I will face is that when
> Are you wanting to turn off replication from the master or the slave?
On Tue 23 Mar 2004 Sam Yathira wrote
>
I would like to join the group.
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.Hi
I 'm trying to understand LOCKing mechanism but it is not enough described in the manual so I have to test it myself.
To see what happens when I use tables I haven 't locked I created a PHP "Kevin Carpenter " <CARPENTERKE@(protected) > wrote
>
> I try to start it at the command line using - mysql mysqld mysqld_safe -
> I 've tried it as root and non-root.
>
> Yes I get errorHi I am using replication to do online backups for my tables. Now my next
task is to automate cleaning up of binary log files from Master server.
Assuming I have more than one slave running and mayJames
I try to start it at the command line using - mysql mysqld mysqld_safe - I 've tried it as root and non-root.
Yes I get errors - they were listed in my origional post - I don 't have theA Z <xtcsuk@(protected) > wrote
>
>
> MySQL 4.0.14
>
> Possible to query for existence of a DB. For example
> connect to MySQL and run run a command to check if
> Database (Test2) existed.
Maybe something like
Select LIKE pkg_name% LIKE site_% version from table group by LIKE
pkg_name% LIKE site_%
but I 'm still a beginner.
Respectfully
Ligaya Turmelle
<Vincent.BadieIn the last episode (Mar 23) Emiliano said
> how is possible that crashing a client that was quering a mysql db
> located in a server this db(not sure a dbms...) it reports the
> errors
>
> "You can get millisecond resolution in MySQL 4.1. Considering most systems
don 't even support *true* millisecond resolution I don 't think you 're going
to find anything that supports microsecond reyou can very well use those files though im not sure if you can check the
table structure bafore restoring it.
HTH
Nitin
----- Original Message -----
From "dan " <dan@(protected) >
To <mysqlHas anyone had experience with running MySQL on Trusted Solaris?
Thanks
Jack
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //lists.mYe That Know
Short Does YaST really install MySQL 'all-the-way ' or do I now need to run 'make ' and/or 'make install ' or other similar commands?
Long
Previously <last week > I had install
"joe collins " <joe.collins@(protected) > wrote on 23/03/2004
14 33 13
> can operators be used in MySQL e.g.
>
> a table Table X with column A column B column C
>
> AllVinay <vinay@(protected) > wrote
> Hi i 'm trying to write an sql statement which will make a copy of a
> table including all its data and indexes. The problem comes with the
> fact that the table c
Hi all
This morning my server wasn 't running. For some reason it had shutdown
which the error log shows but what 's causing it is a riddle to me. I 'm
now running with --log and --log-updat-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi again all --
...and then David T-G said...
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problemDavid T-G <davidtg-mysql@(protected) > wrote
>
> I have just moved my web site from one server to another (whew!) and I am
> having a problem with a mysql user definition for a calendar prograHello colleagues I 'd like to know
IF by enabling the binary logs production I 'll affect meaningfully the
MySQL DB performances and
HOW MUCH the performances are impacted
Any witnesses on this
I 'm getting unexpected results when using GROUP BY. If you specify a
WHERE match in the query I get the desired result but if I remove it
to show all results the set returned is inaccurate.
OK the scenario I 've got is that I 'm using MySQL 4.1 and Python (using
mysql-python to access the server).
I have a script like the following
############
conn MySQLdb.connect(....) # BOK first off this website is kinda infuriating. Why can 't I click on
the message thread on the web and reply that way? I 'm not even sure
this message will reach it 's recipients. </rant >.
Anyho "Qiang.zhou " <qiang.zhou@(protected) > wrote
> Dear All
>
> At oracle8i i can write this sql
> select decode(a.id null 'NULL ' 2 "God ' 3 'Norma ' 'Animal ') from user
>
> Then i wRick Duley <rick@(protected) > wrote
> Hi folks
>
> I am running MySQL 4..0.7-gamma on Red Hat Linux 7.2.
>
> I wish to download data from my database.
>
> I have a directory called 'Hi all
I am working on a project that uses Mysql.
My task is to provide a fault taulerant platform for it.
I would like some help to optimize the two ends of this platform.
There are few thHello
I have a redhat system that is running mysql with openssl for secure connections.
There was just a rpm update from redhat for openssl. I applied that and mysql/openssl connections seem fi |
|
|
