Questions tagged as 'mysql'

Tagged questions
1
answer

transfer from one database to the other [closed]

Hello, I'm developing a real estate website, but it already exists, so I'm just going to update it, my question is whether it is possible to transfer the properties already registered in the old site to the new one or is it impossible? obs: t...
asked by 26.04.2017 / 04:25
1
answer

How to make a submit with button type="button"?

I have created some and I need them to perform the same functions (with database) as register, change, etc. Can someone help me or explain to me how I do this? Thank you!     
asked by 27.04.2017 / 20:21
2
answers

MySQL query excluding empty LINES [duplicate]

I have to make a query (which will be taken to a PHP application) in the table below. I would like to query so that the rows that do not contain prices (that is, they are null) in columns 'gnbr' to 'sprd' are not selected. I do not want to del...
asked by 11.10.2016 / 02:18
1
answer

MySQL syntax [closed]

I can not see the error: UPDATE clientes SET txtEndereco=\"Rua Xingú, 823\", txtBairro=\"Val Paraíso\", txtCEP=\"09060-050\", txtUF=\"35\", txtCidade=\"14933\", regiaos=\"\", Obs=\"Princesa fada\") WHERE idCliente = \"2\    You have...
asked by 13.10.2016 / 15:46
1
answer

Sensitive case MYSQL

I need my bank to accept capital letters in table names, for example when I create the table tbl_ALGUMACOISA It appears to me tbl_algumacoisa This also works with the fields, how should I solve these problems?     
asked by 10.07.2016 / 17:31
1
answer

Create tables in a mysql database hosted on Locaweb

I need to add a table in my database. How do I add a table to this bank hosted on locaweb? Do you have to have any software or can I upload some files?     
asked by 18.11.2016 / 13:36
2
answers

Save reports to a table or execute a query to the database?

I am setting up an e-commerce where I have an area to generate sales reports. These reports are broken down by year and month. Currently I have a query sql where I segment the results by year and month and then I get the results I want...
asked by 11.11.2016 / 14:39
1
answer

Help in logic not to overlap a time range already exists in the base

Good morning. As suggested by a member of the community, In the post that started this , I have come to ask for collaboration in a logic. I have a table that contains the start-time and dead-time fields. I need a routine that makes it impos...
asked by 21.03.2017 / 13:09
2
answers

Vector make a mysql query

Hello, I'm trying to make a query using vector, but as far as I've learned the sql command does not hold the vector of the form I'm doing so my result is empty. $idcliente=$_SESSION['id_cliente']; $loja=$_POST['loja']; $quant[0]=$_POST['quant'...
asked by 16.06.2016 / 15:04
2
answers

# records in SQL PHP

Good, I have a question regarding the number of records in a given table. SELECT COUNT Nome FROM 'tb_utilizador' I want to display the number of records in a table in php. <?php include("Config.php"); $sql = mysql_query("Select *...
asked by 14.06.2016 / 15:47