TechieX
I have been playing with MYSQL, and familiar with DB's. I use SQL server @ work, and understand the basics of SQL, but just starting out with MYSQL.
Any recommendation on reading material to learn MYSQL?
Also I am using the MYSQL Control Center, and there seems to be very little info on it, but just in case I missed something is there anyhting out there on how to use it?
Lastly I created some table's in my test DB, how do I see the relationships? Like in Access, or SQL server you can see the Keys that connect but I do not know where in MYSQL. I dont even know if this matters, as long as the foriegn key references a primary key in another (parent) table. Would this be safe to assume :confused: .
Any recommendation on reading material to learn MYSQL?
Also I am using the MYSQL Control Center, and there seems to be very little info on it, but just in case I missed something is there anyhting out there on how to use it?
Lastly I created some table's in my test DB, how do I see the relationships? Like in Access, or SQL server you can see the Keys that connect but I do not know where in MYSQL. I dont even know if this matters, as long as the foriegn key references a primary key in another (parent) table. Would this be safe to assume :confused: .