Questions tagged as 'banco-de-dados'

What are the main differences between engines MyISAM and InnoDB and what is the most appropriate situation for each? I know that MyISAM does not support FOREIGN KEY but supports FULLTEXT , while InnoDB...

By modeling addresses in an application, I naively followed the standard form when representing in the DB (ie separate tables for country , status strong city , neighborhood etc - joins everywhere), and in the user interface (html) I p...

What type of CPF or CNPJ field in database VARCHAR or INT ? I've seen some posts suggesting to use INT to optimize performance in JOIN and filters. If you have 0 on the left, you can only complete it according...

When should I make this direct recording at the bank? What are the situations? I know I can save the image path to the bank.