| |
| | MySQL Tips |
 | | mysql> insert into agents (ln,fn,phone) values ('Anderson','Bob','215-782-2134'); mysql> select @ckey:=last_insert_id(); mysql> insert into clients (f_akey,ln,fn,phone) values (@ckey,'Chirico','Abby','215-782-2353'); myslq> insert into clients (f_akey,ln,fn,phone) values (@ckey,'Payne','Zoe','215-782-2352'); The "last_insert_id()" must be assigned to a variable, because the client entries for the two client keys have the same agent. |
 | | From mysql, in the slave, put in the IP of the Master or the hostname. |
 | | Given these constraints from a remote client, say a laptop, it is possible to perform queries and have the results returned to the laptop provided the laptop has ssh access to the server. |
| souptonuts.sourceforge.net /readme_mysql.htm (0 words) |
|