Questions tagged as 'mysql'

Tagged questions
0
answers

MySQL for MYSQLI connection (class) [duplicate]

I would like to make this connection in mysqli, could someone help me? I'm having some difficulties. <?php Class mysql { public $query; public $data; public $result; public $rows; protected $config; protected $ho...
asked by 28.03.2018 / 19:44
0
answers

Error 1215 MySql

First of all, I would like to say that I have checked several questions about this here and no solution worked. I'm giving alter table in the official table to add two foreign keys ... one of them works (num_department) but the other one fo...
asked by 17.03.2018 / 19:25
0
answers

Draw HTML table so you can save the data in mysql

I'm having the following problem: I started working with php now, and I have a problem. I have to make a table that should, after being populated by the user, store the data in mysql. I leave here my table as it is currently: My questio...
asked by 21.03.2018 / 12:34
0
answers

how to receive dynamic data from a form and save it to BD

My difficulty happens because I created a dynamic grid where I generate sequential rows to include products, so I do not have the names of the traditionally fixed input. In this case I assign sequential numbering accordingly that I enter the...
asked by 13.03.2018 / 20:05
1
answer

Error trying to query via HQL

I have the following entities: import java.io.Serializable; import java.util.List; import javax.persistence.CascadeType; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persis...
asked by 15.03.2018 / 17:50
0
answers

Set listview width for input of database data mysql vb.net

I'm having a problem adjusting the width with listview in VB.NET where the data loaded from the database does not fit the width. Example: You have a database record that is 250 characters wide and I put the statement as follows: If MTramo.Text...
asked by 12.03.2018 / 21:19
1
answer

select advanced sql

I would like the column id_post_gru to be populated by 2 based on the number of group id where there is 70 I did this separately works but not together! UPDATE posts SET id_post_gru =( SELECT COUNT(id_grupo) FROM posts WHE...
asked by 12.03.2018 / 22:08
0
answers

How do I keep MySQLDump table names in upper case?

My system was in DBF x Clipper in Windows and I used table names and capitalized fields, today I needed to reactivate an old system that I ported to PHP in Windows now in Linux, it happens that MySQLDump imports the base and How do...
asked by 12.03.2018 / 19:38
0
answers

Alternative for using UNION in mysql / php

Good morning, I'm doing the sum of the elements of a column (which I called MyColumn) in function of another, called "shift". There are three values for shift, so I need the code to return three distinct sum values. For this, I'm using the UN...
asked by 13.03.2018 / 13:03
1
answer

Mysql - Order before grouping

I need to make a selection that will bring the last users who logged in without repeating the names. The problem is that the command below first groups and then sorts: SELECT usuario FROM tab_logins GROUP BY usuario ORDER BY data_login desc...
asked by 11.03.2018 / 17:47