 | | | MySQL General | | Bonnet R?my <remy_bonnet@(protected) > wrote
> Hello
>
> I have a database which is flushed every four hours
> and
> I want to replicate it without replicating the delete
> queries . Is this posI haven 't tried but it seems quite difficult for one thing both sql
engines are very differents. So the short answer would be a plain no.
Now trying something exotic would be making a odbc bridgeHi Group
A question about locking. In my code (delphi but that doesn 't much matter)
I fire ad-hoc queries (select). Before the query i fire a locking query
(read) for that particular tables. S "Luiz Rafael Culik Guimaraes " <culikr@(protected) > wrote
> Dear Friend
>
> an friend of mine told that the follow line bellow dont work with mysql
> version 4.0.x
>
> * Support for subqueries Stefan Kuhn wrote
> Hi everybody
> I have three mysql servers doing a circular replication. They (still) run
> Redhat 7.3. I started with Mysql 3.23 upgraded to 4 and yesterday I tried
> 4.1.OS X 10.3 and mysql 4.x I have a situation where after time certain queries
get really slow in the area of 30 seconds. I seem to have pinned it down
to my use of my-large.cnf. If I remove this fYou could try MySQL 5(it is in alpha state) which comes with stored
procedures mixing stored procedures and prepered statements could be a
possibility.
About Sybex 's book haven 't read it but "Mulugeta Maru " <mmaru@(protected) > wrote
> I am using MySQL 5 issuing the following query when the application died on me three times.Query Select name year_of_birth from players where year_of_in case someone hasn 't answered you yet..
do you know that you can specify a database.tablename.column syntax in
your queries to go across multiple databases?
Daniel Ek wrote
> Dear list
>Daevid Vincent wrote
> Is there a way to disable this 'max_connect_errors ' thing?
> http //www.mysql.com/doc/en/Blocked_host.html
>
> Tried "max_connect_errors 0 " but then it shows up as "max_cSome key in the table is null when it shouldnt be or the type of the join
keys isnt the same. i have had issues when importing data from a dump so
i 've had to do a FORIEGN_KEY_CHECKS 0
>
> So I hI am having trouble undertanding a few things with mysql.
OS X 10.3 MySql 4 current stable
I cp 'd my-large.cnf to /etc/my.cnf
This is the first time I have ever had this file in use I have justFreddie Sorensen wrote
> Randy
>
> Thanks but I am not really sure where the connections are kept alive or
> 'asleep '
>
> I am quite sure that I am closing my objects setting them to nothingGilbert
You might want to look at the ByteFX provider
Freddie
-----Urspr?ngliche Nachricht-----
Von Gilbert Wu [mailto gilbert.wu@(protected)]
Gesendet Donnerstag 4. M?rz 2004 18 28
ADear Friends
Running the follow query
select max( sr_recno) from test_table down work for re
the error id returned by mysql_errno is 3731792
server is 4.1.1a-alpha
Table structure is
SDan Liu wrote
> Hi
>
> I have a question about 'create table '.
>
> If two persons create table both name 'table1 ' at the same time in same
> database what would happen?
>
It cannot hapAre you using ODBC Links or are you importing the table into MS Access
from MySQL? Are there unique constraints on the table to prevent
duplicate data from being entered?
> > > > > > > > > > > > > > > > > > OrigiTest Email - Disregard
- >Kevin Carpenter
CHOP - Biomedical Engineering
(215) 590-5762
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscriThe MySQL server is not running. Did you start the MySQL server?
> > > > > > > > > > > > > > > > > > Original Message < < < < < < < < < < < < < < < < < <
On 3/4/04 1 19 28 PM Scott Bounds <scott.bounds@(protected) > wrote
regarTable ProductSums has not been created. Can you create this table when
you insert data into it?
INSERT INTO ProductSums
SELECT DISTINCTROW IndenturedList.NSIPartNumber
Sum(tblInvTransaction.Hi
> I have a table where I would like members of a uid field to be limited
> by the range of values that are in another field. What I am looking for
> would be taken care of with the enum() op "Nate Blanchard " <nate@(protected) > wrote
> According to the C API docs on mysql_get_metadata
> " If a statement passed to mysql_prepare() is one that produces a result
> set mysql_get_metadata() rMyODBC/MySQL connections can be made DSN less.
> > > > > > > > > > > > > > > > > > Original Message < < < < < < < < < < < < < < < < < <
On 3/4/04 11 28 19 AM Gilbert Wu <gilbert.wu@(protected) > wrote
regarding OLEDB ProvideCan you do a ps -ef | grep mysql and post the results? Also can you log
in using mysql --user mysql -p -P3306
Original Message dated 3/4/04 10 43 26 AM
Author Scott Bounds <scott.bounds@(protected)
> What operating system are you using? What does your my.cnf look like for
> the sections
--8 <--
Please don 't overquote like that.
--
Martijn
--
MySQL General Mailing List
For What operating system are you using? What does your my.cnf look like for
the sections
[mysqld]
...
socket...
Can you connect to the MySQL server?
> > > > > > > > > > > > > > > > > > Original Message < < < < < < < <Does the socket actually exists? Are you able to connect via port?
> > > > > > > > > > > > > > > > > > Original Message < < < < < < < < < < < < < < < < < <
On 3/4/04 9 04 02 AM root <root@(protected) > wrote regarding Can 'tYou have no join criteria between your tables.
> > > > > > > > > > > > > > > > > > Original Message < < < < < < < < < < < < < < < < < <
On 3/4/04 9 23 41 AM Erich Beyrent <erich.beyrent@(protected) > wrote
regarding DuplicatesAt the moment we have 6 webservers (RedHat) behind a loadbalancer which use
one dedicated MySQL server (plus two smaller dedicated MySQL servers for a
few special sites) for their data.
On setting Gabriel Alessandria <galessan@(protected) > wrote
> There exists the possibility of doing a SELECT where the list of IN()
clause
> is the result of another select ?
>
> Like this for example
|
|
|
