Questions tagged as 'mysql'

1
answer

Save correct and incorrect answers for registered and unregistered user

In the project of my matte game, which is to add two numbers of two figures. I want to save how many correct answers you have made and save that score. If the user is registered friend we will Publishing it in the bbdd so that he can see it o...
asked by 27.10.2017 / 10:39
1
answer

autoincrementable column with letter and numbers depending on another column

I want to create an autoincrementable column that recognizes the type of voucher that will be issued. I have the following table: ------------------------------------------------------------- |id | numcomprobante | tipocomprobante | iddetal...
asked by 15.12.2017 / 06:09
2
answers

Connection problem in MySQL and VisualStudio for a Login [MySql.Data.MySqlClient.MySqlException] [closed]

   MySql.Data.MySqlClient.MySqlException: 'You have an error in your SQL   syntax; check the manual that corresponds to your MySQL server version   for the right syntax to use near '' 12345 '' at line 1 ' I have a problem, at the moment of pl...
asked by 02.10.2018 / 15:41
1
answer

Multiple foreign keys within a field of another table?

Good morning, I am developing an Android application where I have this database. -Tables Food: ID Primary Key char (15) Name char (25) Description char (35) Tags char (35) -Tables Tags: ID Primary Key char (15) Name char (1...
asked by 06.06.2018 / 21:49
1
answer

Group and add in Mysql

Good morning, I have a table made in mysql in the following way: ___________________________________ servicio | estatus | cantidad Agua Potable| ACTIVO | 4 Agua Potable| EN PROCESO | 3 Agua Potable| RESUELTO | 2 Agua Servida|...
asked by 23.11.2017 / 16:04
2
answers

Help to upload an image to a phpmyadmin database with AJAX

Good morning, I have a problem uploading an image to my database. I have several different data and all are saved except the image, which I configured with the column name "IMG" and longblob file type This is my HTML: <div class="control...
asked by 30.11.2017 / 13:43
2
answers

How do I read an array from JavaScript

I have an array generated from a MySql table through PHP, I want to use the script provided by Google to display on a map a marker from the latitude and longitude stored in the array. How would the procedure be, when I have the data of lat and l...
asked by 07.10.2017 / 17:18
1
answer

Error inserting data in MySql database

I get the following error Column 'Nombre' cannot be null when trying to save a record in the database Private sub Create(ByVal cliente As Cliente) Using cn = New MySqlConnection(ConfigurationManager.ConnectionStrings("default").ToSt...
asked by 13.06.2017 / 13:19
3
answers

Error in localhost mysql with xampp

Good evening users, I am new to programming and in class we have all the same problem, I have installed MY SQL WORKBENCH 6.3 AND XAMPP , start of xampp for mysql okey , but when I try to connect to my localhost that appears in the workbench,...
asked by 26.04.2017 / 23:34
2
answers

select an element in a select and bring the id to perform search in mysql

<div id="leftcolumn"> <form class="form-register" action="actualizar_insumo.php" method="post"> <h3>MODIFICAR INSUMOS MEDICOS</h3> <div class="contenedor-inputs"> <input type="hidde...
asked by 15.04.2018 / 21:19