Re: copying data!!!
Check this out. http://dev.mysql.com/doc/refman/5.0/en/insert-select.html On 12/9/05, Sachin Bhugra <[EMAIL PROTECTED]> wrote: > Hello Friend, > > Can you please let me know how to copy data from a column in table A > to a column in table B. e.g. I want to copy value of column "age" from > table 2 to column "age" in table 1, provided the entries in column > "name", which is there in both the table, should match. In MySQL v 4 > it could be done using Update tbl1,tbl2 syntax, but i have now MySQL > 3.23 which does not supports this Update syntax... > > Also, can i use ldap to authenticate the MySQL users, if yes, please > tell me how?? > > Tnax. > > Sachin > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: moving the datadir
Thanks. On 11/24/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote: > Hi Ezra, > > I fixed the root user by following the instructions laid out at > http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html > . > > The root user was somehow corrupted. > > I started mysql with the mysqld_safe --datadir=/my/new/location ... plus the > other parameters set out in the docs. > > The db was always working fine over JDBC - it was just the cmd line > utilities [like /usr/local/mysql/bin/mysql] that were acting strange. > > RO > > > > On 11/24/05, Ezra Taylor <[EMAIL PROTECTED]> wrote: > > > > How did you accomplish that? > > > > Ezra > > > > On 11/24/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote: > > > Thanks Gleb, Ezra. > > > > > > Fixing the root user was the trick. > > > > > > I've got it working now. > > > > > > ~mm > > > > > > > > > On 11/24/05, Ezra Taylor <[EMAIL PROTECTED]> wrote: > > > > > > > > Did you set the permissions on the new datadir? > > > > > > > > Ezra > > > > > > > > On 11/18/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > > I'm on Solaris 9 with mysql 4.1. > > > > > > > > > > I've moved the datadir to a new location, and edited the mysql start > > > script > > > > > directly so that it now has the line: > > > > > > > > > > datadir=/export/www1/data > > > > > > > > > > The server restarts no problem, and my phpBB web app can talk to it > no > > > > > problem. > > > > > > > > > > However when I try to connect to it using the > /usr/local/mysql/bin/mysql > > > > > client I get: > > > > > > > > > > [EMAIL PROTECTED]:/usr/local/mysql:> ./bin/mysql --user=mysql > > > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > > > > Your MySQL connection id is 3 to server version: 4.1.10a-standard > > > > > > > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > > > > > > > mysql> show databases; > > > > > +--+ > > > > > | Database | > > > > > +--+ > > > > > | test | > > > > > +--+ > > > > > 1 row in set (0.00 sec) > > > > > > > > > > mysql> > > > > > > > > > > -- > > > > > > > > > > I'm not sure where it's getting the 'test' db from, but it's not > showing > > > the > > > > > phpBB database - or other databases I have. > > > > > > > > > > I've tried creating a /etc/my.cnf file - but I can't get it to work. > > > > > > > > > > Thoughts? > > > > > > > > > > Thanks, > > > > > -RO. > > > > > > > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: moving the datadir
How did you accomplish that? Ezra On 11/24/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote: > Thanks Gleb, Ezra. > > Fixing the root user was the trick. > > I've got it working now. > > ~mm > > > On 11/24/05, Ezra Taylor <[EMAIL PROTECTED]> wrote: > > > > Did you set the permissions on the new datadir? > > > > Ezra > > > > On 11/18/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote: > > > Hi, > > > I'm on Solaris 9 with mysql 4.1. > > > > > > I've moved the datadir to a new location, and edited the mysql start > script > > > directly so that it now has the line: > > > > > > datadir=/export/www1/data > > > > > > The server restarts no problem, and my phpBB web app can talk to it no > > > problem. > > > > > > However when I try to connect to it using the /usr/local/mysql/bin/mysql > > > client I get: > > > > > > [EMAIL PROTECTED]:/usr/local/mysql:> ./bin/mysql --user=mysql > > > Welcome to the MySQL monitor. Commands end with ; or \g. > > > Your MySQL connection id is 3 to server version: 4.1.10a-standard > > > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > > > mysql> show databases; > > > +--+ > > > | Database | > > > +--+ > > > | test | > > > +--+ > > > 1 row in set (0.00 sec) > > > > > > mysql> > > > > > > -- > > > > > > I'm not sure where it's getting the 'test' db from, but it's not showing > the > > > phpBB database - or other databases I have. > > > > > > I've tried creating a /etc/my.cnf file - but I can't get it to work. > > > > > > Thoughts? > > > > > > Thanks, > > > -RO. > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: moving the datadir
Did you set the permissions on the new datadir? Ezra On 11/18/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote: > Hi, > I'm on Solaris 9 with mysql 4.1. > > I've moved the datadir to a new location, and edited the mysql start script > directly so that it now has the line: > > datadir=/export/www1/data > > The server restarts no problem, and my phpBB web app can talk to it no > problem. > > However when I try to connect to it using the /usr/local/mysql/bin/mysql > client I get: > > [EMAIL PROTECTED]:/usr/local/mysql:> ./bin/mysql --user=mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 3 to server version: 4.1.10a-standard > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> show databases; > +--+ > | Database | > +--+ > | test | > +--+ > 1 row in set (0.00 sec) > > mysql> > > -- > > I'm not sure where it's getting the 'test' db from, but it's not showing the > phpBB database - or other databases I have. > > I've tried creating a /etc/my.cnf file - but I can't get it to work. > > Thoughts? > > Thanks, > -RO. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Heikki: What will become of InnoDb once MySQL license runs out
Relax Paul: If you noticed it put the words Haha Haha at the end of my statement. Anyway, as I said, Oracle is out to make money. They will crush anyone that gets in there way. Ezra On 11/4/05, Paul DuBois <[EMAIL PROTECTED]> wrote: > At 21:49 -0500 11/4/05, Ezra Taylor wrote: > >Last one people: > > I just realized that Heikki is > >monitoring our post pertaining to innodb. This guy/gal is an oracle > >employee. The enemy is amongst us. Beware. Haha Haha > > > >Ezra > > Ezra, > > Your basis for claiming that Heikki is "the enemy" is ... what? > > > > > > >On 11/4/05, Ezra Taylor <[EMAIL PROTECTED]> wrote: > >> To Mysql users: > >> Just to remind you all, Oracle is a > >> business that expects to make money. As you all know, Mysql is a > >> threat to the fat cats such as Oracle,DB2,MSSql and others. If you > >> think Oracle is going to play fair with us then you will believe that > >> crack will one day be a multi vitamin. For those you that don't know > >> what crack is, it's a drug that will fuck your life up. > >> > >> > >> Ezra Taylor > >> > >> On 11/4/05, Heikki Tuuri <[EMAIL PROTECTED]> wrote: > >> > Mike, > >> > > >> > - Original Message - > >> > From: "mos" <[EMAIL PROTECTED]> > >> > Newsgroups: mailing.database.myodbc > >> > Sent: Saturday, November 05, 2005 12:11 AM > >> > Subject: Heikki: What will become of InnoDb once MySQL license runs out > >> > > >> > > >> > > Heikki, > >> > > I am about to start a large MySQL project that requires > >>transactions and I > >> > > need to know if InnoDb will be around for MySQL after MySQL's > >>license for > >> > > InnoDb runs out in 2006. > >> > > >> > the current GPL version of MySQL/InnoDB will of course be > >>available then by > >> > the very nature of the GPL license. > >> > > >> > The MySQL AB - Innobase Oy OEM agreement is about commercial non-GPL > >> > MySQL/InnoDB licenses. About that agreement I want to refer to > >>the official > >> > press release of Oracle Corporation: > >> > http://www.oracle.com/innodb/index.html > >> > > >> > > If yes, will you still be supporting it or will > >> > > it be up to MySQL AB? > >> > > >> > I want to refer to the official press release where Charles > >>Rozwat, Oracle's > >> > Executive Vice President in charge of Database and Middleware Technology > >> > says: "Oracle intends to continue developing the InnoDB technology and > >> > expand our commitment to open source software." > >> > > >> > > TIA > >> > > > >> > > Mike > >> > > >> > Regards, > >> > > >> > Heikki Tuuri > >> > Vice President, server technology > >> > Oracle Corporation > >> > > >> > > >> > -- > >> > MySQL General Mailing List > >> > For list archives: http://lists.mysql.com/mysql > >> > To unsubscribe: > >>http://lists.mysql.com/[EMAIL PROTECTED] > >> > > >> > > >> > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Heikki: What will become of InnoDb once MySQL license runs out
Last one people: I just realized that Heikki is monitoring our post pertaining to innodb. This guy/gal is an oracle employee. The enemy is amongst us. Beware. Haha Haha Ezra On 11/4/05, Ezra Taylor <[EMAIL PROTECTED]> wrote: > To Mysql users: > Just to remind you all, Oracle is a > business that expects to make money. As you all know, Mysql is a > threat to the fat cats such as Oracle,DB2,MSSql and others. If you > think Oracle is going to play fair with us then you will believe that > crack will one day be a multi vitamin. For those you that don't know > what crack is, it's a drug that will fuck your life up. > > > Ezra Taylor > > On 11/4/05, Heikki Tuuri <[EMAIL PROTECTED]> wrote: > > Mike, > > > > - Original Message - > > From: "mos" <[EMAIL PROTECTED]> > > Newsgroups: mailing.database.myodbc > > Sent: Saturday, November 05, 2005 12:11 AM > > Subject: Heikki: What will become of InnoDb once MySQL license runs out > > > > > > > Heikki, > > > I am about to start a large MySQL project that requires transactions and I > > > need to know if InnoDb will be around for MySQL after MySQL's license for > > > InnoDb runs out in 2006. > > > > the current GPL version of MySQL/InnoDB will of course be available then by > > the very nature of the GPL license. > > > > The MySQL AB - Innobase Oy OEM agreement is about commercial non-GPL > > MySQL/InnoDB licenses. About that agreement I want to refer to the official > > press release of Oracle Corporation: > > http://www.oracle.com/innodb/index.html > > > > > If yes, will you still be supporting it or will > > > it be up to MySQL AB? > > > > I want to refer to the official press release where Charles Rozwat, Oracle's > > Executive Vice President in charge of Database and Middleware Technology > > says: "Oracle intends to continue developing the InnoDB technology and > > expand our commitment to open source software." > > > > > TIA > > > > > > Mike > > > > Regards, > > > > Heikki Tuuri > > Vice President, server technology > > Oracle Corporation > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Heikki: What will become of InnoDb once MySQL license runs out
To Mysql users: Just to remind you all, Oracle is a business that expects to make money. As you all know, Mysql is a threat to the fat cats such as Oracle,DB2,MSSql and others. If you think Oracle is going to play fair with us then you will believe that crack will one day be a multi vitamin. For those you that don't know what crack is, it's a drug that will fuck your life up. Ezra Taylor On 11/4/05, Heikki Tuuri <[EMAIL PROTECTED]> wrote: > Mike, > > - Original Message - > From: "mos" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Saturday, November 05, 2005 12:11 AM > Subject: Heikki: What will become of InnoDb once MySQL license runs out > > > > Heikki, > > I am about to start a large MySQL project that requires transactions and I > > need to know if InnoDb will be around for MySQL after MySQL's license for > > InnoDb runs out in 2006. > > the current GPL version of MySQL/InnoDB will of course be available then by > the very nature of the GPL license. > > The MySQL AB - Innobase Oy OEM agreement is about commercial non-GPL > MySQL/InnoDB licenses. About that agreement I want to refer to the official > press release of Oracle Corporation: > http://www.oracle.com/innodb/index.html > > > If yes, will you still be supporting it or will > > it be up to MySQL AB? > > I want to refer to the official press release where Charles Rozwat, Oracle's > Executive Vice President in charge of Database and Middleware Technology > says: "Oracle intends to continue developing the InnoDB technology and > expand our commitment to open source software." > > > TIA > > > > Mike > > Regards, > > Heikki Tuuri > Vice President, server technology > Oracle Corporation > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
