Questions tagged as 'mysql'

Tagged questions
0
answers

Hierarchical data. What would be the most appropriate ER Diagram to implement a label system like Gmail?

Something related to hierarchical data. I am implementing a message labeling system for a website that is similar to the gmail label system. This is the summary ER. A message can have one or more labels and each label can belong to more...
asked by 30.10.2018 / 21:04
0
answers

Error installing mysqlclient on MacOS with python 3

Error installing on macOs with python 3 pip3 install mysqlclient on MacOS iMac-de-Qcx:~ gabrielveigalima$ pip3 install mysqlclient Collecting mysqlclient Using cached https://files.pythonhosted.org/packages/ec/fd/83329b9d3e14f734...
asked by 05.11.2018 / 18:15
1
answer

"Uncaught PDOException: could not find driver" error in Wordpress on localhost

I'm trying to put a site in Wordpress in Xampp (localhost) but when I run it, the following error appears: My error: link    Fatal error: Uncaught PDOException: could not find driver in   C: \ xampp \ htdocs \ phdvital \ public_html \ pa...
asked by 11.09.2017 / 22:42
1
answer

LOAD DATA LOCAL INFILE taking 1000 first lines

I'm using "LOAD DATA LOCAL INFILE" to import txt files, only it only imports the first 1000 lines, what do I do? "LOAD DATA LOCAL INFILE 'temp_arq.txt' INTO TABLE 'temp' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' STARTING BY ''...
asked by 23.10.2018 / 13:48
0
answers

Delete function in PHP with mysql

I have the following line: mysqli_query ($ connection, "DELETE FROM itenspauta where CodItem = $ receecod3"); But it excludes the whole line, and I just wanted to delete just one column from this table. Following table: I wanted to d...
asked by 18.10.2018 / 02:45
0
answers

PHP - Showing errors while making submit.

When showing success message after making password change, it shows these errors. -------Thisistheactionusedtochangethepassword---------- NOTE:Theerrorsshownarerelatedtootheractionsonotherforms.     
asked by 18.10.2018 / 03:09
1
answer

How to leave NULL if $ _POST is empty in the MySQL database?

Is there any way I can leave fields that have not been filled as null ? When creating the table, the fields have already been defined as DEFAULT NULL , but when doing insert - in the MySQL database - by $ _ POST , the fields that wer...
asked by 18.10.2018 / 20:00
1
answer

Call the date that table was created

I was seeing this topic where it shows the last time the table was updated. Only I want to know when the table was created.     
asked by 18.10.2018 / 15:49
1
answer

Problem with Expense Calculation with PHP

I'm trying to make an expense calculation on the system but I'm not having success. The system works as follows, the User makes a request involving 1 or more products, these requests are stored in a table. Each Product registered in the system i...
asked by 01.11.2018 / 22:25
1
answer

CRUD in PHP and MYSQL - Delete

I'm having problems with a crud in php and myqsl . My code does not seem to be getting the id to perform the actions. The site has an administrative part where I view the registered users and can edit, delete and detail on each user. Here...
asked by 15.10.2018 / 22:12