Posts by Shaft • 103 points
5 posts
-
-3
votes2
answers232
viewsQ: What is the best way to create tables with users who may have multiple emails?
What is the best way to create the email table, as the client may have several emails, I created two situations one email and another email? what is the best way taking into account processing,…
-
1
votes1
answer139
viewsQ: Category query in Mysql
I’m learning Mysql, I need help, I need to perform a query that returns a sales list by product category. ++++++++++++++++++++++++++++++++++++++++++++++ tb categoria campos: (id, categoria) dados:…
-
3
votes1
answer790
viewsQ: How to open a GUI built in Eclipse by Netbeans?
I have a code using JFrame, but when I open it in Netbeans I can only change the layout by code. How do I use the code and edit the layout by the Swing.
-
4
votes2
answers755
viewsQ: Normalization of Mysql tables
I’m creating a system for employee registration, but I’d like to start in a standard way; tb_funcionario (id_func, id_funcao, id_depto, nome_func, data_nasc, end_fun, dt_admissao, dt_demissao)…
-
1
votes1
answer58
viewsQ: How to view date ranges from another table?
I have a table with date ranges and another with sales data. How can I assemble a query that brings me the sales totals in the last 3 periods from the table datas_periodos ? Tabela (datas_periodos):…