Questions tagged as 'mysql'

Tagged questions
1
answer

Syntax error when putting a number as mysql table name

Hello, I'm doing the following query with the variable $fechaActual = date('dmy'); dasd $mysqli->query("CREATE TABLE ".$fechaActual." (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY)") This gives me syntax error but if I do this: $...
asked by 25.02.2017 / 05:44
1
answer

Modeling in Workbench

Good afternoon, you know how I can visualize the logical and / or physical model in Workbench ?, I used Erwin before and you could visualize both, but now they ask me in Workbench and I can not find that option to change views.     
asked by 20.03.2017 / 23:00
1
answer

create excel in java by consulting in MySQL

I'm trying to create an excel file using a mysql query, what happens is the following I do the sql query with the data I need to make a sums and divides then I add all those results to an arraylist what is not how to do to get each of these data...
asked by 08.02.2017 / 16:09
1
answer

Connecting to database with socket.io and node.js

Is this the correct way to connect to a database ?, but it worked for me ... many times I find answers: "this form is obsolete", and my question is that, this is a good way to connect to a bd and to make queries? (or the only one), I found it ve...
asked by 06.02.2017 / 13:09
2
answers

Counter of records or columns of a Mysql database using PHP

I would like to know the total of numbers of columns or records entered in a table and display it on the screen. For example, in the table I have three records or columns and I need you to give me the number 3 What I have is the f...
asked by 05.02.2017 / 17:00
1
answer

PDO, are these guides updated? [closed]

I would like to learn the use of prepared sentences and have I got these pages online, will they be updated? , because I've seen some use MYSQL link link link link     
asked by 14.02.2017 / 00:15
1
answer

Left Join does not return null values in PHPmyAdmin

Hi, I'm trying to make this query: SELECT consulta.id_consulta,actu_consulta.fecha_actu FROM consulta LEFT JOIN actu_consulta ON consulta.id_consulta=actu_consulta.id_consulta_actu And the funny thing is that this query i...
asked by 14.02.2017 / 11:42
1
answer

update data in a remote database android studio

I'm trying to insert data into a remote mysql database .. I'm stuck .. I've looked for examples but nothing like that This is my java code import android.app.ProgressDialog; import android.content.Context; import android.content.Intent;...
asked by 14.03.2017 / 19:57
1
answer

database modeling

I have the following diagram, I have 2 questions. 1) a user has variables, these variables are times, errors and others, so that the change is flexible, should he create another intermediate table? 2) a user has errors and time...
asked by 09.02.2017 / 15:57
1
answer

SQL statement to calculate fine value

I have a system to calculate a payment of fines to a user, this has the following two tables: FINES and FINES_USERS    NOTES: // In the table fines I have inserted the two types of fines, both normal and special, just change their typ...
asked by 09.02.2017 / 19:13