Best answeres tagged with mysql

2

answers

How to model the products table for an e-commerce?

I'm having a question about how to model the Produto table of a small e-commerce I'm doing. I've been seeing some e-commerces and I came across the following situation: mm same product can have different colors and sizes, so when the cust...

asked by 23.08.2017 / 14:28

2

answers

Which is faster: NULL or NOT NULL (with an empty string)?

I have a table with NOT NULL fields and they end up empty. What is the difference between a NULL (allows null values) and NOT NULL with an empty string ( '' ) inside?

asked by 28.06.2018 / 17:28

2

answers

Why do I need WAMP (example) for MySQL to work? [closed]

When I started studying programming with database access, I had to install software like MySQL and WAMP. I know what WAMP is all about, I know it's a package of tools needed at the time of programming, but I never understood the importance of it...

asked by 05.08.2018 / 08:25

2

answers

How to update data from a table only if the new values are different from the current values?

How can I do an UPDATE only if the submitted data is different from the stored data? I have the following: <?php header('Content-type: application/json'); header('Access-Control-Allow-Origin: *'); include 'database.php'; $cod_oferta...

asked by 12.05.2017 / 00:20

2

answers

How to do inner join in mysql?

I have 2 tables in my bank, Categories and Automoviles. The Categories table has a PK ID_category and Name. Automobiles already has a PK ID_automoveis and the other columns that make up this table INCLUDING the FK Category_ID as you can see in t...

asked by 31.05.2017 / 12:14

2

answers

Error "1146 table 'phpmyadmin.pma__tracking does not exist"

This error prevents me from creating new tables and accessing those already created: Error: 1146 table 'phpmyadmin.pma__tracking does not exist How do I fix this?

asked by 25.07.2015 / 00:05

2

answers

Filter MYSQL results according to the result of a row

I'm having a problem to perform a specific filter on a query in MySQL. I'm building a search system where I have the following tables: Questionnaires : with the name of the questionnaires Questions : containing the questions of the qu...

asked by 19.11.2015 / 15:15

2

answers

Form recording the same data

Good afternoon guys. I have a problem that I can not find a solution for. I made a form to save the registrations of a web site, but many times the same registration is saved several times (see print) Ivalidatetheentireformsoasnottoriskgi...

asked by 30.11.2015 / 18:06

2

answers

Performing update on several records for the same ID

Consider the following scenario for controlling information about licenses in a database Products 1 - Solução x 2 - Solução y 3 - Solução z Suppose you have all 3 solutions Licenses table | ID | CLIENTE_ID | PRODUTO_ID | DATA_...

asked by 27.01.2016 / 16:30

1

answer

Strange character at the beginning of the site pages

I'm developing a website in PHP and MYSQL and all pages are displaying the following characters at the top of the page: ï »¿ Each page (index, about, contact ...) to be opened has in the upper left corner, right at the top, this dirt. I alread...

asked by 28.01.2016 / 02:34

Questions tagged as 'mysql'