Questions tagged as 'mysql'

Tagged questions
1
answer

Counter button with Update

I'm having problems getting a button in javascript to perform an update without giving refresh on the page, at the moment it is not entering the database and is doing refresh hehehe in index.php <form> <button data-id='$futid'...
asked by 28.11.2018 / 19:43
2
answers

Query two tables without foreign key and relationship

I have two tables tb_pedido and tb_pagamento , I put an example below with some dummy data. I need a report that shows the data of tb_pedido and tb_pagamento , all in a single table as in example 3. I thought about doin...
asked by 28.11.2018 / 19:06
1
answer

How to connect to a mysql database from another network via PHP?

I would like to make a PHP connection to the MYSQL database that is on another computer from another network. I have the external IP of this machine that hosts the database and I made the following PHP connection: <?php $servidor = 'servido...
asked by 26.11.2018 / 11:03
2
answers

Database not returning any value

I have the following code: $sql="SELECT * FROM imoveis WHERE (suite LIKE '%".$suites."%' OR banheiro LIKE '%".$banheiro."%' OR quarto LIKE '%".$quarto."%' OR garagem LIKE '%".$garagens."%')...
asked by 11.12.2018 / 00:00
1
answer

Index size of a mysql database

What would be the structure of a query to get the total size in MB of all index of the tables of a certain banco de dados in mysql ?     
asked by 03.11.2016 / 11:28
1
answer

How to Merge 2 SELECT statements

How to merge these 2 selects ? MY TABLES EVENT TITLE DESCRIPTION CATEGORY_ID CATEGORY NAME COLOR ICON DESCRIPTION this select below works perfectly makes the count right I need to do the same without count on the other tw...
asked by 10.11.2016 / 20:00
1
answer

What is the best database to store a list of information [closed]

I'm thinking about developing a project, in this case a website. I will need to have a database connection, I will opt for mysql . On the site people can create an account, and subsequently create a list of information about them. List...
asked by 10.11.2016 / 14:13
1
answer

how to do an insert of an input adding the value to the column of the database? Mysql + php

I am a beginner in php and I am doing a project for tcc of my technical course where, I have to register for an employee. how do I, when doing the insert add the value with what is already registered in the bank?     
asked by 18.11.2018 / 17:22
1
answer

How to recover a database in MySQL

I had a problem with a client that the operating system stopped working. I was able to access the disk and there is a MySQL database inside the C:\ProgramData\MySQL\MySQL Server 5.7\Data\BDados folder that contains the .FRM and...
asked by 15.11.2018 / 17:29
1
answer

Any explanation for this SQL?

$alters = " ALTER TABLE imovel MODIFY COLUMN ENDERECO VARCHAR(150), MODIFY COLUMN BAIRRO VARCHAR(150)"; $pdo->exec($alters); As I lower the value of varchar, it will update, but if I increase the value of varchar it does not work anymor...
asked by 26.12.2014 / 19:16