Questions tagged as 'mysql'

Tagged questions
4
answers

Collect text with special characters from a form and insert them into a database

I would like to collect a text with special characters ('´ñ) of a form in html . This will change to codigo.php that will be responsible for inserting it into a database MySQL . The fact is that I have tried a thousa...
asked by 26.05.2017 / 14:33
2
answers

Conditional on SUM (mysql)

I have the table factura_habitaciones , where you enter the room reservations that I will later invoice. I want to calculate the total of all the records in the table with a single sentence in MySQL considering that the days multipl...
asked by 28.10.2018 / 13:32
1
answer

ERROR insert JDBC data MYSQL Java

I've been trying to insert all the data I get through the scanner into the database all day yesterday and I get an error, I can not find the solution anywhere. I get this error message:    Exception in thread "main"   com.mysql.jdbc.except...
asked by 21.03.2018 / 13:07
2
answers

I need help with an elseif

I need help for this else if that does not register it well, I want to register an image in a modal but the one that validates it gives me error no sée if you need something special to validate it correctly because it gives me an error as...
asked by 28.09.2017 / 18:50
3
answers

Error "No suitable driver found for jdbc: mysql: // localhost / dda" when connecting to MySql from Java

I would like to connect to a database that I have locally. I have the service up, and I already have the base created. as shown is localhost, root pass 1234, and I have 2 user and oid tables, I have the following Java class to use...
asked by 02.12.2017 / 22:09
3
answers

Alter Table Mysql gives Error

I have the following query for mysql but in doing it gives me error. ALTER TABLE conexion ADD panel_web varchar (255), panel_web1 varchar (255), panel_web2 varchar (255), puerto_panel varchar (255); The question is, how do I add several c...
asked by 24.05.2017 / 15:05
1
answer

MySQL composite wrench

I need a composite key for a database of 10 fields, in the database schools are registered through its cct (which would be the primary key) but I also need to be able to register the same cct but with a different shift ( field that must be relat...
asked by 23.06.2017 / 02:38
3
answers

Checking duplicate MySQL records

I have a database, where the company's invoices are stored, and I need to see the duplicate records (invoices that have the same series, number and type). For each record I have an id id that identifies them. What I want to list are all the ones...
asked by 07.07.2016 / 23:22
1
answer

Optimize query mysql Sorting result

As the title says, the query I have is this: SELECT id, first_date_order, last_date_order, (SELECT o.created_at FROM orders o WHERE o.customer_id = c.id ORDER BY o.created_a...
asked by 07.03.2017 / 21:01
1
answer

Search in a field a specific data of the database?

I try to select a specific data in a field of the database, in this case I have a field that is called idDepto and it has stored the values 3,4,5,6,7,8 but when executing the query: $sql = "SELECT Correo, idDepto, Notificacion...
asked by 10.08.2017 / 15:47