Questions tagged as 'sql'

Tagged questions
1
answer

error in a PHP sentence - WARNING

I receive the following error: Warning: mysqli::query(): Couldn't fetch mysqli in /database.class.php on line 96 and the line is as follows: public function query($query) { $this->result = $this->mysqli->query($query); // Est...
asked by 30.10.2018 / 21:29
0
answers

Error in query dates and collations charset - illegal mix of collations

Hi, I have the following problem: I have all my MySQL DB, tables and columns with charset utf8 and collation utf8_spanish_ci When I run this query: SELECT * FROM profesionales INNER JOIN horarios ON profesionales.id = hora...
asked by 30.10.2018 / 22:14
0
answers

Create a Checkbox

My question is the following as I can call from a mysql database in my view in laravel, and filling that data in a list with checkbox so that I can choose the user to whom I want to upload a file of type pdf or doc or txt if you could help me wi...
asked by 25.10.2018 / 19:32
0
answers

Bring "zeros" from the DB of a String sql-vba field

I searched through all the sites and could not find a solution. I have a project in VBA that brings data from SQL sql. The field I need to bring is a varchar type, so the variable in my project is of the string type. If I execute the query in...
asked by 25.10.2018 / 19:21
1
answer

MySQL Show all data to the LEFT of a table

I have the following problem. I formulated an SQL query that gives me data of trucks that work during the current week , the problem is that I need to show all the trucks, including those that have not worked during the current week (with data...
asked by 25.10.2018 / 21:47
0
answers

linked server and transactions SQL server to MYSQl

Good morning, the issue is like this, I have two databases sql server and mysql, every time an insert is made (this side of sql server) in a table, these changes must also affect the table in mysql , I have a linked server, I decided to make a t...
asked by 23.10.2018 / 18:02
0
answers

how to get the fields of all the rows of a SQL query in Java?

Good afternoon someone could help me with the following please ... I want to obtain the ID of the rows obtained by the following SQL query and save them in a variable but I do not know how to do it. SELECT * FROM productos; But if I know ho...
asked by 23.10.2018 / 18:57
2
answers

Convert from Date and Time only Time and Minutes in SQL

Good morning I have this query convert(char(8), Horario.HoraInicio, 108) but when I give it run I get 00:00:00 but yosolo I want me to% of 00:00 some idea, Thanks     
asked by 23.10.2018 / 18:29
0
answers

how to include in a table (orders) several records of another table (products)

Hello is my first question on this site, first of all I am new in the world of programming and others, my problem is that I have a table orders and another table products, the problem is that I do not know how they have to be related tables amon...
asked by 23.10.2018 / 18:59
1
answer

How to update a database from Qt?

I have a program that opens a database and presents the database through a model in a table view in Qt. I am able to add and delete rows in my database through some buttons that activate the action and some text boxes where to put the informa...
asked by 24.10.2018 / 08:08