Search results for query: *

Some InnoDB expert told me this: http://www.innodb.com/ibman.html#InnoDB_foreign_keys there must be an index where the foreign key and the referenced key are listed as the FIRST columns. Above the column Creditor_Id is not listed as the FIRST column in the primary key. You have to create...

so how do we list all the users in mysql? the only one i know is "SHOW GRANTS FOR BOB" and it shows the grants for bob. how the heck do we list/show all the users? please help!

i tried it and i get the following error. what is wrong? please help! CREATE TABLE Creditors_Customers( Customer_Id bigint( 20 ) NOT NULL default '0', Creditor_Id bigint( 20 ) unsigned NOT NULL default '0', Debt_Amount varchar( 20 ) default NULL , PRIMARY KEY ( Customer_Id, Creditor_Id ) ...

ah i get it now. you are marking both clientId and creditorId as primary keys and making this a multiple-column index, but how will this work? i am still a bit confused.

swampboogie, thanks for the reply. but i still have a couple of questions. i see that you create a table for clients, and another table for creditors. how does the third table link them? what does primary key(clientId,creditorId) do ? so i could have multiple entries for each client in the...

hi... just 2-3 days of mysql here... i want to set up a database... it might have about 50-60 columns... basically for the finance industry we have to list creditors for each of our clients. some clients have 4 creditors. some have 12. some have 15. so what is the best way to design this? just...