Foreign Key

Hi all: I have a table A(Id, Type). Primary Key is "Id" I have another table B(Id, State). Primary Key is "Id" I also have another table C(Id, ConditionId). Primary Key is "Id". But, "ConditionId" could be "Id" values from Table A or Table B. So i want to make it a foreign key. But how can i

MySQL++ hates me

Hi all, How should i compile a simple MySQL++ file? I tried to compile "simple1.cc" file provided in the examples directory in "mysql++-1.7.9". But i failed. All the "*.hh" files that will be created when you do "make install" are there in "mysql++-1.7.9/MYLIB/lib" and "mysql++-1.7.9/MYLIB/incl

Creating new users

Hi all, I have MySQL server installed in Solaris 2.8. 1. How can i change the existing password for a user? 2. How can i delete an existing user? 3. How can i create a new user and associate a password for that new user? Could anyone please help? Best regards and thanks in advance, -skd ___

Server shutdown

Hi all, I am completely new to MySQL. I installed the source version of MySQL on Solaris 2.8. I did "mysql_install_db". I started the server by saying "bin/safe_mysqld --user=mysql &". The server started my creating "mysql.sock" file in the /tmp directory. Now i want to stop the server. How s

mysql_install_db prblem

Hi all, I am completely new to MySQL. I am trying to install MySQL on SUN SPARC Solaris 2.8. I downloaded mysql-3.23.52-sun-solaris2.8-sparc.tar.gz and did "gunzip" to unzip the file and then did "gtar". When i try to run mysql_install_db, i get the following error : **

Problem with mysql_install_db

Hi all, I am completely new to MySQL. I am trying to install MySQL on SUN SPARC Solaris 2.8. I downloaded mysql-3.23.52-sun-solaris2.8-sparc.tar.gz and did "gunzip" to unzip the file and then did "gtar". When i try to run mysql_install_db, i get the following error : *