Hi guys
Please tell me the command syntax, how to add a colmmen foreign key in
alter syntax
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I've been doing some experimenting with the data model from the "MySQL"
book (Addison Wesley). I have no trouble understanding joins between
two tables, but I'm finding it's a little confusing when 3 or more
tables are involved. I'm going to cite a particular set of tables and a
specific quer
On May 16, 2009, at 12:28 AM, Simon J Mudd wrote:
I also, in section [mysqld]
# Begin slave config 05/14/2009
server-id = 2
master-host = ip.add.re.ss
master-user = user-replicate
master-password = xx
master-port = 3306
# End slave config
No. not necessary as the information is stored in t
On Fri, May 15, 2009 at 12:48:18AM -0700, Scott Haneda wrote:
>
> Also, how do I set the slave to be read only? I set read-only in
> my.cnf and it made all databases read only.
SET GLOBAL read_only = true;
and as you've done in the my.cnf file.
Unless the user has SUPER rights he can't chang
On Thu, May 14, 2009 at 04:45:44PM -0700, Scott Haneda wrote:
> >It's true that initial mysql replication setup is a bit fiddly, but
> >once you've done it once or twice it's not so hard.
>
> I have it set up and working in test. I will redo it again once I get
> a better handle on it. I am
