Questions tagged as 'mysql'

Tagged questions
1
answer

SQL query to obtain a summation

There is some way to get the sum of a table called initial_number, by means of dates, to be more clear I want the year 2011 to show me the total initial_number of that year, the year 2012 show me the total of the initial_number and so on SELEC...
asked by 22.02.2018 / 14:15
0
answers

Do not insert all the fields in my BD

<?php $turno = $_POST['idctg_turno']; $entrada = new DateTime($_POST['hr_entrada']); $salida = new DateTime($_POST['hr_salida']); $arraydia = $_POST['idctg_dia']; $mysqli = new mysqli("localhost", "root", "", "admon"); if ($...
asked by 22.02.2018 / 09:04
0
answers

Error in MYSQL when assigning permissions to user

I already managed to access MYSQL by placing the corresponding password. The problem I have now is that when trying to assign permissions to the root user, it shows me the following error: Access denied for user 'root' @ 'localhost' (usin...
asked by 22.02.2018 / 19:12
0
answers

Problem with MySQL privileges

My problem is that I create a user only with SELECT permissions. However, when I tried using DELETE, this will delete the row that says "Should not you send me an error like" user does not have permission to DELETE? " I remain attentive and th...
asked by 22.02.2018 / 15:44
1
answer

The MySqlConnection type is not defined

Imports MySql.Data.MySqlClient Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load Try Dim conexion As New MySqlConnectionStringBuilder() conexion.Server = "localho...
asked by 22.02.2018 / 21:06
1
answer

Collation problem in MySQL

I have a database in MySQL with respective data spread over tables. The database is already created and I have a problem that does not read the characters well as: tildes accents ñ What happens? I have tried to make the follo...
asked by 20.02.2018 / 13:12
1
answer

Errors in database model? [closed]

Good morning, I am currently creating a system for a library, I have made the model, but I would like some suggestion or know that I can improve it, because I do not feel satisfied and I am not very expert in the subject. Thank you in a...
asked by 19.02.2018 / 04:56
1
answer

Handling dates and times with PHP and MySQL?

Hi, I am working with a system based on PHP and Mysql where I need to make loans of x materials with expiration dates (elimination of requests) and time signs for loans, that is, if the loans are not returned in 3 days start charge fines. I'm...
asked by 19.02.2018 / 03:20
1
answer

Why this error comes up: Uninitialized string offset: 1 in line 13

<?php require("connect_db.php"); foreach($_POST['idctg_dia'] as $index => $value) { // $value tendrá valor desde 1 (lunes) hasta 7 (domingo) $entrada = $_POST['hr_entrada'][$index]; $salida = $_P...
asked by 17.02.2018 / 07:54
1
answer

Can someone help me with Mysql with a query?

Sorry for the inconvenience I am developing a systems of events. The detail is that I have a table exclusively to control all the events, what I am trying to do is eliminate the already expired rows, every so often with the Mysql query. Th...
asked by 17.02.2018 / 18:45