Questions tagged as 'mysql'

Tagged questions
2
answers

problem with cookie and user table mysql php

Hello people I am doing the part of "Keep the session started" in the following way: two cookies are created, one with the user and the other with a series of random numbers (which are a field of the user table) , the problem that I have is that...
asked by 06.05.2017 / 09:17
1
answer

How to correct multiple choise exam

I am doing a multiple choise exam system with php and mysql (a question may have 1 or several correct answers). The problem I'm having is when it comes to correcting the exam, I do not know how to do it. Can someone give me an idea as to the...
asked by 07.05.2017 / 22:09
0
answers

Can not connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock

Lately it has happened that a database in MySQL has been failing. The error that comes out is this: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' I have looked for solutions in other places and the...
asked by 07.03.2017 / 02:09
2
answers

"Update" in java does not update the data in MySQL

Good morning, I have a code that theoretically seeks me first if the record is already included in the database and if so, I update the data, otherwise it includes it. However, the data is not updated, nor do I get it back, that is, I unde...
asked by 07.03.2017 / 14:22
4
answers

Problem Left join mysql [closed]

I need to do a left join in MySql and it's not working. I have 4 tables: articulos , subcategoria , categoria and ventas . I want to show all the independent items that have sales or not. Each article has a sub...
asked by 23.03.2017 / 15:24
1
answer

Annual SQL query grouped by dates

I need to make an annual consultation grouped by months of all registered users in the period of one year. The query would be the following: SELECT COUNT(*) AS total_users, YEAR(created_at), MONTH(created_at) FROM 'users'...
asked by 23.03.2017 / 13:03
0
answers

Problems with Mariadb when creating table from java

Good morning, I can not find the solution to my problem. From java, I create a table in phpmyadmin and insert data, which apparently does it well, I do not get any errors, however I find that if I want to enter data in a column that I created...
asked by 01.03.2017 / 21:31
1
answer

How to delete mysql database image and have it deleted from the folder where it was saved? [closed]

What I want to do is that the extention that is saved in the database is deleted but the image of the folder where it was saved is also deleted     
asked by 12.03.2017 / 03:33
2
answers

How to work with SimpleMembership in ASP.Net MVC in MySql? To deny and allow access to users

When you create a project in asp.net from visual studio, and choose the web application option, it generates some files that allow you to place some headings that are the following: [Authorize] [InitializeSimpleMembership] These...
asked by 16.02.2017 / 18:52
3
answers

Concatenate multiple rows in a single mysql

I really do not know if it will be possible, I hope for answers Join rows according to the name and name, doing the operation: (weight * note) / 100 at the end add each result and put it in a single row, leaving something like this: nombre...
asked by 18.02.2017 / 21:05