Questions tagged as 'mysql'

Tagged questions
1
answer

Failed Mysql workbench error 1215

I have to make a database of a hospital, I'm new to mysql and in this forum. I get the error when creating the foreing key. DROP DATABASE IF EXISTS 'hospital2'; CREATE DATABASE IF NOT EXISTS 'hospital2' /*!40100 DEFAULT CHARACTER SET utf8 COL...
asked by 30.04.2018 / 10:32
0
answers

How to get two variables that have expressions in SQL

Someone could help me in this, I have problems in How to get in two query two variables that have expressions in SQL, in this case the image would be the number of projects with status 2 and number of projects with status 3. Thank you    ...
asked by 11.05.2018 / 13:52
1
answer

Select query in php to my database mysql does not return the record because it does not recognize the "&" character

I am making a query select my mysql database to bring the records of the users that I have registered. The query field for the select is the name and the id, in the field name of the table there are records that have characters like "&" or "...
asked by 03.05.2018 / 15:58
0
answers

add bookmarks google maps MYSQL

Do not add the markers on the map, the following code: I clarify that the db has all the data <?php $consultaB = "SELECT * FROM markers "; if ($bus = $enlace->query($consultaB)) { /* obtener el array de objetos */...
asked by 27.04.2018 / 21:18
0
answers

Update table when both conditions are met

I have the following query: UPDATE sm4rtuniversity.badges_members SET active = 'si' WHERE user_id IN (SELECT m.id FROM skill s INNER JOIN skill_rel_user sru ON s.id=sru.skill_id INNER JOIN user u ON u.id=sru.user_i...
asked by 27.04.2018 / 19:41
1
answer

Transactions with PDO and Singleton

I have the pattern singleton and a class ticket : public function registrar(){ //me conecto a la bd $conexion = Conexion::singleton_conexion(); try{ $conexion->beginTransaction(); $queryid="select comprobante from identi...
asked by 29.04.2018 / 15:33
1
answer

Databases, intermediate table relations

First of all I do not have much knowledge about MySQL, nor databases in general, so I regret the inconvenience that may cause. I have a database with two tables, registered, and product, registered has attributes such as ID (primary key), the...
asked by 29.04.2018 / 17:43
2
answers

VB.NET- Combobox Validation using ErrorProvider

Hello good afternoon everyone, along with hello I wanted to ask you, someone has used the errorprovider in the validation of a combobox? I have a button that in the click event asks to validate that a value is entered in a textbox and that an...
asked by 26.04.2018 / 18:15
1
answer

By displaying the records insert them at the same time

I have a 3 tables in my database fecha_busqueda fecha_encontrar fecha_resultado ------------- --------------- ---------------- id_fechab int id_fechae int id_fechar int...
asked by 27.04.2018 / 03:31
0
answers

Make a pdf

Hi, I would like to make a pdf, where the sentence can be filled in with a post but I get an error and I do not know why, the library I use is TCPDF $usuario = 'SELECT divisiones.start_date AS Fecha_Inicio, divisiones.tipo_liga AS Tipo_de_...
asked by 27.04.2018 / 07:49