Questions tagged as 'mysql'

Tagged questions
1
answer

mysql syntax error [closed]

Database error Error: # 1064 - Something is wrong in its syntax near 'source int, refers to varchar (20), results_called int, date_cite date, time_cit' on line 1 Code: create table Llenado (id int not null primary key AUTO_INCREME...
asked by 20.09.2018 / 13:28
2
answers

what is the error of this php code? [closed]

<?php //paso 1 es conectarnos con el servidor //esta manera ya esta obsoleta!! $link = mysql_connect('localhost', 'root', ''); if(!$link){ echo'No Se Pudo Establecer Conexion Con El Servidor: '. mysql_error(); }else{ /...
asked by 17.06.2018 / 17:03
1
answer

Views mysql in Laravel [closed]

Can I use call table view with the model in laravel? What good practice is it? or is it preferable to call it with the DB selector? Example = vusers / Model: User     
asked by 08.06.2018 / 23:44
1
answer

Error PHP line quotes [closed]

I have an error in the quotes of this sentence of MySQL in PHP, since the LIMIT does not take it as such, I hope your help. $sqlP = 'SELECT * FROM coleccionPublicaciones WHERE id_publicacion='.$row["id_publicacion"].' LIMIT 1';     
asked by 03.07.2018 / 13:03
1
answer

Select sum of records by id with PHP, MySQL [closed]

I want to use a query to bring the sum of some records, but I want the records to be X element only. What I want is to use a form with ajax to select a vehicle, which I have identified by id_vehicle, so that the query will return the sum of t...
asked by 30.08.2018 / 01:11
1
answer

mysql, simultaneous queries

how many queries does mysql support simultaneously? I know that the connection is not the same as simultaneous consultation, and that if there are 3,000 users on a website, it does not even remotely mean that the 3,000 make a query at the sam...
asked by 13.09.2017 / 23:11
1
answer

Help with the time I can not show am or pm in my database

I have this code in android studio to show the time in an EdiText. //MOSTRAMOS HORA Thread t = new Thread() { @Override public void run() { try{ while(!isRestricted()){...
asked by 15.06.2017 / 17:25
2
answers

Someone who manages PDO bindParam, I would greatly appreciate your help [closed]

SELECT * from contact_company inner join company on company.id_company = company_contact.business_enterprise WHERE contact_state = 'ACTIVE' AND company_contact_id! = 0     
asked by 15.09.2017 / 22:36
1
answer

migrate MySQL database to postgreSQL

I have a database in MySQL and I have been asked to use postgreSQL now the question as the step? It is 12 tables and 250 records, the documentation that I find is old, I do not know if there will be new methods.     
asked by 01.09.2017 / 04:45
2
answers

Display data of a selecct with JQuery, if the value comes from MySql

How to show the selected option of a select with JQuery, in a form at the moment of modifying the data, if the value of the selected object comes from MySql This is my php code ... <div class="form-group" id="selectRama"> <...
asked by 13.06.2017 / 18:59