What do people recommend for storing money amounts? I've seen people use
NUMERIC(18,3) and other use NUMERIC(18,4). Which one is more appropriate
and why? This is considering various existing currencies, some having
low rates (like IDR, in which you can have large amount up to hundreds
of
At 02:03 2003-12-03, David Garamond wrote:
What do people recommend for storing money amounts? I've seen people use
NUMERIC(18,3) and other use NUMERIC(18,4). Which one is more appropriate
and why? This is considering various existing currencies, some having low
rates (like IDR, in which you
no problems that i see.
- Original Message -
From: p shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 12:23 PM
Subject: Mysql Date column type
Hi,
I have one question regarding date column type in
MYSQL.
Can I use the column type for date as
Hello there,
I have a table including information about my projects, the structure
has each id and name. Then I have another table including status
information of each project: entryid, projectid, status and timestamp.
Is there any possibility to fetch a list of projects with the most
recent
- Original Message -
From: lamjoun
To: [EMAIL PROTECTED]
Sent: Monday, December 01, 2003 2:31 PM
Subject: mysql request problem.
Hi,
I have a problem with this request.
insert into table month_var (year,month,var_cd,val) select '2003','10',var_cd,0 from
var and
var_cd not in
Dan Muey [EMAIL PROTECTED] wrote:
I have a table that I create with=20
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID)
);
I use that same thing to create a the same table
Hello there
Could anyone help me with this error message ??
Warning: mysql_pconnect(): Client does not support authentication protocol
requested by server. Consider upgrading MySQL client
What could be wrong ??
My preferences:
FreeBSD 5.1
mysql-client-4.1.0
r u getting this problem while coonecting through MySql Front or directly to
the server?
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 3:23 PM
Subject: Client does not support authentication protocol requested by server
Hello
Warning: mysql_pconnect(): Client does not support authentication
protocol
requested by server. Consider upgrading MySQL client
#1249 - Client does not support authentication protocol requested by
server.
Consider upgrading MySQL client ??
I have MySQL 4.1 on Linux. The mysql_fix
Good question - mysqlimport seems to work siliently and not report any errors. I had
read that this was to be improved in 4 - has it ??
appreciate answers
Thomas
-Original Message-
From: Greg G [mailto:[EMAIL PROTECTED]
Sent: 02 December 2003 15:22
To: [EMAIL PROTECTED]
Subject:
Dear colleagues!
I need to create my own aggregate UDF, so I decided to test UDF_example
from Windows MySQL source.
I've created udf_example.dll and udf_example.lib with VC++ 6.0.
Then, I haven't any problem with all of udf's, excepting the aggregate
udf avgcost.
On my SELECT avgcost(a,b) from t1;
Hi Listers,
I have just installed mysql following the instructions for the binary
distro under linux and I added my root user and password using
mysqladmin as mentioned in scripts/mysql_install_db.
In the mysql.user table I see my [EMAIL PROTECTED] and [EMAIL PROTECTED]
but I also see two
Hi,
We're using replication (1 master + 1 slave), and we want to block updates /
deletes, issued by the users, to the slave.
Because sometimes they get confused and use the slave as the master... got
it?
Any clue?
Thanks,
Eduardo
--
MySQL General Mailing List
For list archives:
Hi All,
I have an issue that someone in the MySQL community might be able to help me
with:
I am running a web application, a web bulletin board system (Ikonboard) and
a Ticket Tracking system (OTRS) and
I want to integrate the three of them. They all run on a MySQL database. The
three systems
Eduardo,
On Wed, Dec 03, 2003 at 10:25:28AM -0200, Eduardo D Piovesam wrote:
We're using replication (1 master + 1 slave), and we want to block updates /
deletes, issued by the users, to the slave.
Because sometimes they get confused and use the slave as the master... got
it?
Give their
Hi Fred, thanks for reply.
But we want to replicate the mysql database... we want a exact copy of the
master.
Is there another way?
Thanks,
Eduardo
- Original Message -
From: Fred van Engen [EMAIL PROTECTED]
To: Eduardo D Piovesam [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
You will need to start MySQL with --OLD-PASSWORDS option.
Or simply put OLD-PASSWORD in [mysqld] section of your options file.
Or when creating your passwords, make sure you update the password column
using OLD_PASSWORD() function.
For example,
UPDATE mysql.user SET
Eduardo,
On Wed, Dec 03, 2003 at 10:56:56AM -0200, Eduardo D Piovesam wrote:
But we want to replicate the mysql database... we want a exact copy of the
master.
You would just be missing the mysql.* tables and those are only used for
permission related stuff. Permissions are exactly what you
Adam Hardy [EMAIL PROTECTED] wrote:
I have just installed mysql following the instructions for the binary
distro under linux and I added my root user and password using
mysqladmin as mentioned in scripts/mysql_install_db.
In the mysql.user table I see my [EMAIL PROTECTED] and [EMAIL
Hi Duncan,
Great tip!
It's not exactly what I was looking for (block only updates, and permit
selects), but it's the best option...
Removing the mysql db from replicating, and then granting only selects to
the users, will cause more work to us when the master crash... we'll need
to rebuild all
Batara,
thank you for the bug report. I have to fix this bug when I overhaul the
foreign key constraint naming conventions.
Yes, to fix the problem you can drop the foreign key constraint manually in
the slave.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys,
Hi Fred,
You would just be missing the mysql.* tables and those are only used for
permission related stuff. Permissions are exactly what you want to be
different between slaves and master.
We want to have a full copy of our database, to put it online again if
something goes wrong with the
You could replicate the master's mysql db to a different db on the slave.
i think it's 'replicate-rewrite-db'.
On Wednesday 03 December 2003 13.56, Eduardo D Piovesam wrote:
Hi Fred, thanks for reply.
But we want to replicate the mysql database... we want a exact copy of the
master.
Is
Hi,
We are programming a Delphi application that interacts with the MySQL server
from Windows.
Normally we would need a client side licence ?
But if we use a set of components (from a third party) that allow us to
interact with the MySQL server without using the MySQL client. In this case,
do
About a year ago, I set up mySQL on a computer running linux (probably
RH7.1). At the time I thought that I would investigate how I could use this
server in my business, but then I had more pressing issues and so neglected
the subject. Now that I have some spare times and correct tools (Delphi 7),
No'am
I had the same problem a few days ago, and various people on the mailing
list helped me solve it.
The way that I understand it is, mysql allows to create a user for a
specific remote host, or for all remote hosts.
therefore, you will have to create a database user for
[EMAIL PROTECTED],
Ladies, gentlemen,
Upscene Productions is happy to announce the next
version of the popular database development tool:
Database Workbench 2.4.1 has been released today!
Download a trial at: http://www.upscene.com
Features and fixes: http://www.upscene.com/news/20031203.htm
Database Workbench
Noamn [EMAIL PROTECTED] wrote:
About a year ago, I set up mySQL on a computer running linux (probably
RH7.1). At the time I thought that I would investigate how I could use this
server in my business, but then I had more pressing issues and so neglected
the subject. Now that I have some spare
Hi there. I am trying to find what these
ON DELETE NO ACTION
ON UPDATE NO ACTION
would provide ib my db. What are the options and what each of them do?
-
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
Hi,
Hi there. I am trying to find what these
ON DELETE NO ACTION
ON UPDATE NO ACTION
would provide ib my db. What are the options and what each of them do?
These have to do with Foreign Key Constraints. If you're using
InnoDB tables, you could let MySQL automatically drop any
child
Would using firewall style access control be an option? You would
configure iptables (or whatever access filter the slave computer
supported) to deny access from users to the MySQL port of the slave
machine.
Fred van Engen wrote:
Eduardo,
On Wed, Dec 03, 2003 at 10:56:56AM -0200, Eduardo D
Dan Muey [EMAIL PROTECTED] wrote:
I have a table that I create with=20
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID)
);
I use that same thing to create a
You can setup a circular replication stream. Make sure that the
replicated data gets written to the output binlogs. From the
manual:
`log-slave-updates' Tells the slave to log the updates from the
slave thread to the binary log. Off by default.
Thanks to all who responded to my query. Had I read a bit more of the mySQL
manual, I would have seen exactly what I needed (section 4.4.5).
The only problem was that the mySQL monitor has to be run from the same
computer on which mySQL is running; yesterday I disconnected the screen from
my
Hi,
I have error 1191 can't find fulltext index matching the column list,
but I am certain that all columns in the list are present in my Fulltext
index. Does anybody else had this problem? I am using 4.1.0.
thanks,
Mirza
--
MySQL General Mailing List
For list archives:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Noam --
...and then Noamn said...
%
% Thanks to all who responded to my query. Had I read a bit more of the mySQL
% manual, I would have seen exactly what I needed (section 4.4.5).
It's often that way :-)
%
% The only problem was that the mySQL
If you do a fulltext search on multiple columns at once, there must be a
combined fulltext index on this exact set of columns. Just having an index
on them individually will not work.
On Wed, 3 Dec 2003, Mirza wrote:
Hi,
I have error 1191 can't find fulltext index matching the column list,
Mirza [EMAIL PROTECTED] wrote:
I have error 1191 can't find fulltext index matching the column list,
but I am certain that all columns in the list are present in my Fulltext
index. Does anybody else had this problem? I am using 4.1.0.
Show your table structure and query, please.
--
Dan Muey [EMAIL PROTECTED] wrote:
Dan Muey [EMAIL PROTECTED] wrote:
I have a table that I create with=3D20
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID)
);
I use
Dan Muey [EMAIL PROTECTED] wrote:
Dan Muey [EMAIL PROTECTED] wrote:
I have a table that I create with=3D20
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID)
);
John,
Thank you for your reply. I have read the replication chapter and this
seems to be easier, but I do have a few questions.
1. I am using InnoDB tables, at least there are innodb argument to
mysqld in the start script, so should I use mysqldump instead of tar-ing
the data dir to create the
On Wed, 2003-12-03 at 09:22, lamjoun wrote:
I have a problem with this request.
insert into table month_var (year,month,var_cd,val) select
'2003','10',var_cd,0 from var and
var_cd not in (select var_cd from pers_var where year='2003' and
month='10');
after execution I have this error
Hi
I have an error in my request the right request is
insert into table month_var (year,month,var_cd,val) select
'2003','10',var_cd,0 from var and
var_cd not in (select var_cd from month_var where year='2003' and
month='10');
thanks
- Original Message -
From: Diana Soares [EMAIL
- Original Message -
From: Ville Mattila [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 4:07 AM
Subject: Join only the latest entry...
Hello there,
I have a table including information about my projects, the structure
has each id and name. Then I have
You guys are right, as Cuck said I need each machine acts as server and
slave, I did it with two servers in a circular replication and works pretty
fine, but when add a third machine, there comes the problems, because the
central server must be the master (no problem) and the slave of two
Hi,
But will the search be any faster using Integer or
BigInt column type compared to using Date or DateTime
columnd type.
Regards,
--- Nitin [EMAIL PROTECTED] wrote:
no problems that i see.
- Original Message -
From: p shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Am Wednesday 03 December 2003 18:21 schrieb rubn ruvalcaba:
You guys are right, as Cuck said I need each machine acts as server and
slave, I did it with two servers in a circular replication and works pretty
fine, but when add a third machine, there comes the problems, because the
central
Hi,
I have a problem with this request.
insert into table month_var (year,month,var_cd,val) select
'2003','10',var_cd,0 from var and
var_cd not in (select var_cd from month_var where year='2003' and
month='10');
thanks
I get this from ../configure --with-berkeley-db=/usr/local/BerkeleyDB.3.3
checking for BerkeleyDB... supplied
configure: error: didn't find valid BerkeleyDB:
'/usr/local/BerkeleyDB.3.3' doesn't look like a BDB directory (invalid
version 3.3.11 (must be version 3.2.3h or ))
The configure script
Hi all -
I've got a database along the lines of the following
--
| Transactions | | Products | | TransDetails |
--
| TransID | | ProdID | | TransID |
| TransDate| | ProdName | |
On Wed, 03 Dec 2003 11:07:28 +0200 Ville Mattila
[EMAIL PROTECTED] wrote:
I have a table including information about my projects, the structure
has each id and name. Then I have another table including status
information of each project: entryid, projectid, status and timestamp.
Is there
On Tue, 2 Dec 2003 22:53:47 -0800 (PST) p shah [EMAIL PROTECTED]
wrote:
What are the pros and cons for using Integer column
type for the date?
Please reply at the earliest.
Well there are *some* drawbacks but I dunno if they apply to you. For
instance, using PHP, when I do a select on a
From: lamjoun [mailto:[EMAIL PROTECTED]
Hi,
I have a problem with this request.
insert into table month_var (year,month,var_cd,val) select
'2003','10',var_cd,0 from var and
var_cd not in (select var_cd from month_var where year='2003' and
month='10');
thanks
This isn't a problem
Hi!
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 03, 2003 4:46 PM
Subject: Re: on delete|update
Hi,
Hi there. I am trying to find what these
ON DELETE NO ACTION
ON UPDATE NO ACTION
would provide
Stéphane Bischoff wrote:
We are programming a Delphi application that interacts with the MySQL server
from Windows.
Normally we would need a client side licence ?
But if we use a set of components (from a third party) that allow us to
interact with the MySQL server without using the MySQL
MyISAM supports foreign keys doesn't it?
Martijn Tonies [EMAIL PROTECTED] wrote:No. MyISAM tables don't support foreign keys.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server.
Upscene Productions
http://www.upscene.com
-
Noamn wrote:
About a year ago, I set up mySQL on a computer running linux (probably
RH7.1). At the time I thought that I would investigate how I could use this
server in my business, but then I had more pressing issues and so neglected
the subject. Now that I have some spare times and correct
* Alec Smith
I've got a database along the lines of the following
--
| Transactions | | Products | | TransDetails |
--
| TransID | | ProdID | | TransID |
| TransDate| |
Andrew,
Andrew Hall wrote:
John,
Thank you for your reply. I have read the replication chapter and this
seems to be easier, but I do have a few questions.
1. I am using InnoDB tables, at least there are innodb argument to
mysqld in the start script, so should I use mysqldump instead
* Ville Mattila
I have a table including information about my projects, the structure
has each id and name. Then I have another table including status
information of each project: entryid, projectid, status and timestamp.
Is there any possibility to fetch a list of projects with the most
Hey All-
Are there any query equivalencies to mysqldump? I am looking for a way
to get a complete database dump via php and I don't have access to the
system CLI to run mysql dump.
TIA-
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
[snip]
Are there any query equivalencies to mysqldump? I am looking for a way
to get a complete database dump via php and I don't have access to the
system CLI to run mysql dump.
[/snip]
Run mysqldupmp in a php file using exec...see
http://www.php.net/exec
http://www.mysql.com/mysqldump
looks
On Wed, 2003-12-03 at 15:13, Jay Blanchard wrote:
[snip]
Are there any query equivalencies to mysqldump? I am looking for a way
to get a complete database dump via php and I don't have access to the
system CLI to run mysql dump.
[/snip]
Run mysqldupmp in a php file using exec...see
[snip]
I thought about that Jay, but the mysql server is not on the webserver
machine. Any other suggestions?
[/snip]
phpmyadmin will allow you to connect to the remote MySQL server and do
dumps
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi.
I installed MySQL on a Mac (OS 10.1) a while ago with the good
intension of learning to use, and using, MySQL, but other things got in
the way. However, I have finally found some time (so far) and I am now
trying to install the latest version of MySQL (4.0.16) onto OSX 10.2
(on an iMAC
On Wed, 2003-12-03 at 15:22, Jay Blanchard wrote:
[snip]
I thought about that Jay, but the mysql server is not on the webserver
machine. Any other suggestions?
[/snip]
phpmyadmin will allow you to connect to the remote MySQL server and do
dumps
What if I don't have phpmyadmin available?
Hi, I new in this list and I have a problemand I hope that
any of you can resolve or help me,
When I try to delete anything of a table from my
database, appear this error:
ERROR: Unclosed quote @ 46
STR: '
SQL: DELETE FROM `usuarios` WHERE `Login` = \'Root\' AND `Password` =
[snip]
What if I don't have phpmyadmin available? :)
What I am trying to do, it setup a simple script to pull down
essentially a backup of their database and write it to a file on my
development machine so when they mess up their data (..and I said WHEN)
I can be a hero and revert them to the
Do not escape the single ticks.
-Original Message-
From: Jorge Infante Osorio. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 8:32 AM
To: [EMAIL PROTECTED]
Subject: Problem whit DELETE
Hi, I new in this list and I have a problemand I hope that
any of you can resolve or
If you were to simply download and install MySQL at your company
office, then write apps for in-house use at your company, then
you have no license issues. Your apps would not need to be
GPL, and you do not need a Mysql commercial license.
This was discussed by a Mysql AB employee during the
Greetings Mysqlians,
Please comment on the validity of my logic:
In setting the RAID(10/2disks) strip size everything I read says you must
benchmark your particular system. Since that is not an option, my current
logic is to have a large strip size (1024) with the reasoning
I did some tests earlier where I inserted 100,000 rows into a
table (table definition below). First, I did it without using
transactions and it took 243 seconds approximately. Then, I
did the same test using transactions, and it took 28 seconds.
I am using MySQL v4. Here is the table
Hi,
I did some tests earlier where I inserted 100,000 rows into a
table (table definition below). First, I did it without using
transactions and it took 243 seconds approximately. Then, I
did the same test using transactions, and it took 28 seconds.
I am using MySQL v4. Here is the
Alex Brown wrote:
Hi.
I installed MySQL on a Mac (OS 10.1) a while ago with the good intension
of learning to use, and using, MySQL, but other things got in the way.
However, I have finally found some time (so far) and I am now trying to
install the latest version of MySQL (4.0.16) onto OSX
You could try to use the select into {OUTFILE | DUMPFILE} from tablename
where blah=blah...
I think you may be able to do select into local outfile from blah
Which will put the file on the same server as the MySQL client is running
on...
Cheers,
Andrew
-Original Message-
From:
At 03:55 PM 12/3/2003, you wrote:
If you were to simply download and install MySQL at your company
office, then write apps for in-house use at your company, then
you have no license issues. Your apps would not need to be
GPL, and you do not need a Mysql commercial license.
This was discussed by a
Hi to every one.
I want thanks to the peoples of the list that help me with my little problem,
because it work very well
Jorge.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
HI, any one of you know how to work with the command TRANSFORM?
Jorge.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lo all,
What's the format for a sub query in MySQL??
I've tried the below with a few variants but I can't seem to get it
sorted...
SELECT songlist.ID AS ID,
songlist.duration AS Duration,
songlist.artist AS Artist,
songlist.title AS Title,
songlist.filename AS
Chris Knipe wrote:
Lo all,
What's the format for a sub query in MySQL??
I've tried the below with a few variants but I can't seem to get it
sorted...
SELECT songlist.ID AS ID,
songlist.duration AS Duration,
songlist.artist AS Artist,
songlist.title AS Title,
This information may not be current, but I seem to remember hearing some
really nasty stories about people putting MySQL data dirs on NFS
exports. I would research the appropriate documentation before
attempting such a configuration.
-Original Message-
From: mysql-digest-help
I have had some nasty NFS experiences (especially with the server from which
you're mounting the data going down). In my experience (and I'm echoing
previous responses now) replication is better.
Cheers,
Andrew
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:
At 01:26 PM 12/3/2003, Chuck Gadd [EMAIL PROTECTED] wrote:
This is your standard I am not a lawyer type answer, because reading
the text of the GPL can be overwhelming, but the way I understand it,
if you are shipping MySql with your app, then you've either got to
release your app under the GPL,
Ron Albright [mailto:[EMAIL PROTECTED] wrote:
This is somewhat ambiguous. From the statements below it would appear to me
that you can ship MySQL with an application as long as the your application
does not directly link to the MySQL libraries as would be the case if
embedded. But mere
Dear list:
I`m running a syslogd into my Linux
box for logging all event send from our Cisco routers, these event are
logged in text format, for instance:
Dec 3 15:01:36 sin-trj 8351:
Dec 3 15:01:35.322 BO: %SNMP-3-AUTHFAIL:Authentication failure for
SNMP req from host 10.1.10.12
Dec 3 15:01:38
Have a look on sourceforge.
I think it's called mylogd or something similar. It's syslogd with sql support in it.
Alternatively, a simple perl script will be able to parse the data and insert it
manually into a db.
--
me
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
If you have a varchar column (late) that holds a timestamp like:
2003-11-01 08:45:12
Can you use this select statement:
select * from table where DATE_FORMAT(`late`, '%Y-%m-%d') '2003-11-01';
Even though the varchar column is not at datetime,timestamp column...
Rob
--
MySQL General Mailing
[EMAIL PROTECTED] wrote:
Dear list:
I`m running a syslogd into my Linux box for logging all event send
from our Cisco routers, these event are logged in text format, for
instance:
snipped
I`d like to get some suggestion over how can I to load these text file
to a MySql database
Hello all,
How can I calculate the mean/median/mode from a set of data using SQL?
Mean seems to exist as the average (avg):
select name, avg(value) from table group by name
Is there a way to calculate median and mode with a group by clause?
Median: the value at which 50% of the samples are
Hi all.
I have 2 problem about order by and date compare ??
1. I have two column
OrderDate date and OrderCode varchar(5)
the problem is if I use select OrderCode,OrderDate from MyTable
order by OrderCode,OrderDate the result come with error order it does
not display in correct order
Anyone have any ideas about this?
Thanks,
Richard
-Original Message-
From: Richard Bewley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 7:10 PM
To: [EMAIL PROTECTED]
Subject: More database replication
Hi,
I have a mission critical database, that I want to be redundant, so
I did and it is not running.
Victoria Reznichenko [EMAIL PROTECTED] wrote:jeepcreep wrote:
That is what I did.
Check with
ps ax | grep mysqld
if MySQL server is really running.
That's when I get the error 2002 message. Maybe my problem is not with the
mysql.sock file but something else.
Hi all:
Having some doubts with sql select queries here :
Right now, I have a student and a withdraw tables.
For example, when student John has withdrawn, his name will be inserted
into withdraw table but John's record will be kept in student table for a
period of 30 days before it is
Støt Julemærkesagen
Hi,
From my experience, if You have to write
...
LOAD DATA FROM MASTER
Your replication is not setup
correctly.
LOAD DATA FROM MASTER is reload of the whole table,
and by that You also get the updates.
When working correctly, the replication starts when
MASTER and
Hi all:
Having some doubts with sql select queries here :
Right now, I have a student and a withdraw tables.
For example, when student John has withdrawn, his name will be inserted
into withdraw table but John's record will be kept in student table for a
period of 30 days before it is
I see there is an exact situation described above regarding
'read-only tables' that was not answered as yet. I have done the dev.
work on win32 and now trying to get tables with data up to the Redhat
7.3 server. There are various problems. In some tables, doing
'repair' shows a number of
On 12/3/03 7:27 PM [EMAIL PROTECTED] wrote:
Hi,
yah that's what I'm looking for, creating a cronjob whereby this cron will
automatically delete the record once 30 days is up...maybe using something
like that:
DELETE FROM tablename
WHERE (DATA_SUB(NOW()), INTERVAL 30 DAY)
test
Karl James
[EMAIL PROTECTED]
http://www.theufl.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I would like to connect MySQL to COBOL via ODBC, I
have installed MyODBC 2.50 in my localhost and I can
able to create the DSN for the MySQL Database in
remote server.
I am in need of an interface to connect MySQL to
COBOL. Is there any provision already exists with
MySQL? if so can you please
99 matches
Mail list logo