Questions tagged as 'phpmyadmin'

Tagged questions
2
answers

How to automatically add two columns from two different tables and perform insert into another table in MySQL?

I'm starting the database work and would like to do some smart action on the database. I have two tables that hold different sensor information, each with its own columns. I would like to get a column of each table (of my choice) and perfo...
asked by 01.05.2018 / 05:07
2
answers

How to check if data already exists or has been left blank?

I was testing the site registrations I made, and I noticed that I was able to register the same username twice, even though I declared "UNIQUE" in the table. And another thing, I also noticed that although I left the fields obligatory, in cas...
asked by 13.10.2018 / 18:52
1
answer

How to add a value to the current one in each of the rows of a mysql table?

I have the following table in a mysql database: Iwouldlikeacommandtoruninphpmyadmin,addthecurrentvalueoftherating_sumcolumnto5,andrating_countto1,thus: I want to add these values (5, 1) to all table rows, without any restrictions. I tri...
asked by 16.06.2017 / 04:49
2
answers

MySQL, help to understand data export

Previously when I exported a database it looked like this: CREATE TABLE 'config' ( 'ID_Config' int(1) NOT NULL AUTO_INCREMENT, 'nome_site' varchar(255) DEFAULT NULL, 'thema' char(50) NOT NULL, PRIMARY KEY ('ID_Config') ) ENGINE=MyISAM...
asked by 05.01.2016 / 18:10
1
answer

Avoid Duplication in the PHP + MySQLi Registry

Good evening! How do I prevent registration with the same information? Currently my "processa.php" is this way, and I wanted to include the function mentioned above ... <?php session_start(); include_once ("conexao.php"); $nome = fi...
asked by 03.09.2018 / 00:21
1
answer

Can I create an event in PhpMyAdmin?

I want to create an event in PhpMyAdmin, where every day it implements +1 in a field of type int , but in my local server it works normally, in the hosting it says that I need the user super global , all right until then, the head I...
asked by 06.11.2017 / 07:23
1
answer

Foreign key relationship problem in PhpMyAdmin - Wamp

I have 'problem' in my Wamp, more precisely in the latest version (Wampserver 3.0.6 64 bit x64). When I create 2 tables, example: CREATE TABLE categoria( id_categoria INT NOT NULL AUTO_INCREMENT, nome VARCHAR(100) NOT NULL, PRIM...
asked by 11.08.2017 / 13:19
1
answer

Safe Updates in PHPMyAdmin

In MySQL Workbench it has a very useful function called: "Safe Updates", which prevents Updates in a column without WHERE, for example. In PHPMyAdmin, does this function exist? I could not find it.     
asked by 02.06.2014 / 16:58
0
answers

What's wrong with my code? insert a die and then insert no more! [closed]

html: <!doctype html> <html lang="pt-br"> <head> <meta charset="utf-8"> <title>Untitled Page</title> <meta name="generator" content="WYSIWYG Web Builder 12"> <meta name="viewport" content="width=dev...
asked by 19.10.2017 / 18:16
1
answer

Create and query Wp

Is it possible to create a table in the Wp database to insert values and change them, or would it block me? I wanted to create a simple table just to validate, insert a number and if necessary to change that number.     
asked by 18.08.2017 / 15:35