Questions tagged as 'mysql'

Tagged questions
0
answers

MySQL connection via IPv6

How can I connect to mysql using IPv6? I'm using a Linux (Virtual Machine) Debian VM and am trying to connect via the prompt When I try like this: mysql --host=9999:9999:9999:1:xxx9:x999:2b23:ccab --user=admin --password This error oc...
asked by 10.08.2018 / 16:29
1
answer

xmlapi.php from cPanel does not create BD Mysql

I have a dedicated server on Hostgator with access to WHM. Yesterday it was suggested to update WHM itself and cPanel to the new version 74.0.4 From this it was no longer possible to create MySQL databases through PHP code and xmlapi.php I...
asked by 09.08.2018 / 20:38
0
answers

Get every month the balance of the previous month dynamically

How do I get the previous month dynamically; I have the Entries and Exits tables. In my report I show the Balance of the month , then I show the balance of the previous month , this works for up to 2 months, in the third month the sum is w...
asked by 09.08.2018 / 20:45
0
answers

Problems running Mysql function using Delphi FireDAC 10.1

In a MySql database I have a fully functional (Not a procedure) function, I can usually access within heidisql. In Delphi, I do the following function ExecutarFuncaoSQL(sFuncao: string; aParams: array of Variant; conBanco: TFDConnection): V...
asked by 10.08.2018 / 22:22
0
answers

Fingertech Nitigen | Compare fingerprints on the bench

I need to find in the database who owns the digital captured. In the SDK there is the method to compare two digital ones but it is a windows dll, I wanted to know if it is possible to do this using PHP with MySQL. Example: The device returns me...
asked by 11.08.2018 / 01:29
1
answer

Can I create a table in mysql that shows the person's age by subtracting today's year - the year it was born?

Question: Can I create a table in mysql that shows the age of the person by subtracting the year from today minus the year of birth? create table idade2 (ID auto_increment Primary key, data_nasc date, idade int as ((year(curdate() - year(d...
asked by 12.08.2018 / 23:11
2
answers

MySQL, PHP and HTML communication

Good night everyone, I already talked about this, but it seems that they are not understanding what I mean, so I'll see if I explain better: so far as I know, I did everything right, in my case I'm using XAMP, I have a mysql command, and I want...
asked by 12.08.2018 / 23:56
1
answer

Registry is not being sent to the database

When I use 'insert into news set?', to register at the bank, it is simply not registered Model: module.exports = function() { ... this.salvarNoticia = function(noticia, connection, callback) { connection.query('insert into...
asked by 13.08.2018 / 01:16
0
answers

Error inserting foreign key PhpMyAdmin [duplicate]

I have 2 tables: Students and Subjects, each student will have their certain materials, I try to add a foreign key ( FK ) in the tables, but gives this error:    Note: Both are in the Engine InnoDB     
asked by 15.08.2018 / 05:54
0
answers

Mysql / MariaDb - Can not connect to local MySQL server through socket '' (111)

I have a program on Linux that runs quietly on a virtual machine with Ubuntu 14 and MySQL 5.5 . However, when you try to migrate to Ubuntu 18 and MySQL 5.7 , the program displays this message:    Can not connect to local MySQL server...
asked by 08.08.2018 / 04:45