Questions tagged as 'mysql'

Tagged questions
1
answer

Simplify query mysql

I would like to know if there is any way to group the search. I have a field that is called $ buski and I would like you to search in all the fields of both one table and the other. So far I am defining it by hand one by one type: upper(nombre...
asked by 21.02.2017 / 23:11
2
answers

SQL select one thing from two different tables in the same query

Good, I have two tables, one is called PERSONAL and the other TASK, and I do not know if it is possible through the JOIN operator to select the field "name" of the PERSONAL table and the "description" field of the TASK table that has a certain i...
asked by 23.02.2017 / 20:02
2
answers

Database connection error

I want to connect a database to java but it gives me a mistake and I do not know what it is I hope you can help me The error is this: Here is the code: And here the BD:     
asked by 26.11.2017 / 19:54
1
answer

Warning: Illegal string offset "Error bringing the results of a query"

Good afternoon, I have the following menu: I would like to click on each category to show only the products of that category, but not to show me the products shows me those errors, the code is the following for the logic: <?php i...
asked by 18.04.2017 / 20:07
2
answers

Backup Mysql - JSP

It's the first time I try to make a backup of a BD Mysql from a JSP This is my code (In some forum I saw it). <%@page import="java.sql.*" %> <%@page import ="java.util.Calendar" %> <% try{ Calendar fecha = C...
asked by 19.04.2017 / 19:06
2
answers

error when trying to read data from the database (Connection must be valid and open). C #

What I would like to do is to be able to read record by record as the table is advanced, just to be able to extract the record that I want whenever I want, add a Mysql reader for that, but I do not know why motive marks me the following error:...
asked by 18.01.2017 / 16:29
2
answers

Show total messages by user sessions

I have a problem with a query. I want to show the total number of messages that have been sent to each user. Example: Carlos has 2 messages and Juan has 1 message but when I enter Carlos' session I get 3 messages. I mean, he's telling me abou...
asked by 02.05.2017 / 07:44
1
answer

Count record between multiple columns

Good morning / Good afternoon. My question is the following. I have a table that has 12 columns that are all of different actions, but that each one of those actions can be qualified as EE, EC, OM. What I need is to be able to count how many EE...
asked by 09.03.2017 / 22:58
1
answer

how to autocomplete data with ajax and php?

I have a table in mysql called clients with the fields (id, client_name, client_address, client_phone, client_ email) and I show the data in the following table through a modal window Now what I want to do in another page is to place an in...
asked by 30.11.2016 / 04:17
1
answer

Error creating Foreign Key in MySQL Workbench

I have a table called "maintenance_events" and another one called "maintenance_invitations". Both tables have a column called "date" of type "DATE" and NN. When creating the Foreign Key between these columns I receive the following error:...
asked by 28.11.2016 / 21:37