Best answeres tagged with mysql

2

answers

Difference between relational table and online record

I have a structure of companies and categories organized into 3 tables: empresa - > Register of all registered companies. categoria - > Registration of all registered categories. rel_categoria - > Relatio...

asked by 14.06.2016 / 21:09

2

answers

NOT EXISTS in update?

I have the following SQL: insert into teste (id,nome) select 2,'João' from dual where not exists(select * from teste where nome = 'João') Would you like to do the same with update? Is there any way?

asked by 18.06.2016 / 01:37

2

answers

WHM - Monitor Mysql by site

I need to monitor the use of Mysql by the user in my Cpanel. How can I monitor the use of separate Mysql per Cpanel client in my WHM? Is there any solution for this?

asked by 23.06.2016 / 14:51

1

answer

Problems with PHP connection - MySQL

Error Warning: mysqli_connect () [function.mysqli-connect]: (HY000 / 1130): Host '10 .1.1.25 'is not allowed to connect to this MySQL server in /home/a1570220/public_html/register.php on line 2 Warning: mysqli_prepare () expects p...

asked by 20.08.2016 / 09:49

2

answers

Correct way to make a large inner join

Good day, people. I'm a beginner in php and I'm developing a program for file box control. I have a database in which the "box" table is the main one, it has several references to other tables. Here's how: <br>CREATE TABLE 'caixa' (<b...

asked by 10.06.2016 / 15:40

2

answers

Insert in mysql with strtoupper is not accepting numbers and letters

I'm doing the following insert: <?php include "conexao.php"; $v_tipo = $_POST ["tipo"]; $v_funcao = $_POST ["funcao"]; $v_numero = $_POST ["numero"]; $v_responsavel = strtoupper($_POST['responsavel']); $v_tag...

asked by 10.05.2016 / 17:02

1

answer

Multiply SELECT value with INPUT value

How could I multiply the value of one SELECT with one INPUT and show it in another INPUT?  <select name="papel"> <option value="">Tipo Papel</option> <?php $query = $conn-&g...

asked by 11.08.2018 / 22:42

2

answers

Get names of a form in a php page and put it in a select type list on another php page [closed]

I have 2 pages cadastrar_loja.php and cadastra_documento.php . In cadastrar_loja.php there is a text field named Nome da loja , I would like to get that name from the database, and insert it into a <select>...

asked by 25.01.2016 / 19:44

2

answers

Copying data from one column from one table to another from the same table

Hello, I have a question. I need to copy the data from one column of the integer to another column of the decimal type of the same table, this in MySQL. Is it possible? can there be any inconsistencies in the data? And how can I do it?

asked by 09.03.2016 / 01:48

1

answer

Sql Server Management Studio can handle any database?

I'm asking this question because I find this DBMS simply fantastic, so I'd like to use it with another database (not because I want to, but because most of the databases I have are in Mysql). Is there any adapter, plugin, or any feature that...

asked by 04.03.2016 / 15:33

Questions tagged as 'mysql'