Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. darkarchon

    database design help in mysql

    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...
  2. darkarchon

    how to show all users in mysql?

    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!
  3. darkarchon

    database design help in mysql

    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 ) ...
  4. darkarchon

    database design help in mysql

    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.
  5. darkarchon

    database design help in mysql

    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...
  6. darkarchon

    database design help in mysql

    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...

Part and Inventory Search

Back
Top