Questions tagged as 'mysql'

Tagged questions
1
answer

Query MYSQL prestashop tables

Good morning, My question is that in our web in prestashop there are two rows newsletter and optin that selects the clients. I would like to change by database the clients that have selected optin you can go to newsletter The table is p...
asked by 15.03.2017 / 10:55
1
answer

Error with mysql_fetch_array: wait for a resource but get Boolean

I have this error in my code:    Warning: mysql_fetch_array () expects parameter 1 to be resource, boolean given in ... on line ... It seems to be the syntax of the sql array line, but I do not see how to fix it. Does anyone know what the...
asked by 27.03.2017 / 07:41
2
answers

SQL query - Count with date

Hi, I have a problem with a query in bdd (sql) and it is as follows: how to show how many times from the date of birth (date X) until today (sysdate), it has fallen Saturday (day x of the week) ., thank you in advance.     
asked by 28.03.2017 / 00:48
2
answers

Problem with PHP and SQL [duplicated]

Error:    Fatal error: Uncaught Error: Call to undefined function mysql_connect () in C: \ xampp \ htdocs \ connectionion.php: 7 Stack trace: # 0 C: \ xampp \ htdocs \ index.php (3): include_once ( ) # 1 {main} thrown in C: \ xampp \ htdocs...
asked by 18.05.2018 / 11:59
1
answer

Problems with spool in java

I'm doing a project with four desktop applications in Swing that connect to a database ( Mysql ) that I have on a server. Being three desktop applications where you would have to put the spool configuration. The applications what...
asked by 02.09.2016 / 07:22
2
answers

query relating two unrelated tables

I have an sql query that leads me, I have two tables not linked to each other, of which I want to select users whose year of birth is between the year of beginning of the category and the final year. These are the tables: CREATE TABLE IF NOT E...
asked by 30.06.2016 / 10:05
1
answer

Differences between COUNT (*) and SQL_CALC_FOUND_ROWS *

What is the difference between a SELECT COUNT(*) FROM tabla; and SELECT SQL_CALC_FOUND_ROWS * FROM tabla; SELECT FOUND_ROWS(); ? According to the API it is faster SQL_CALC_FOUND_ROWS but according to other comments on the I...
asked by 18.09.2016 / 11:56
2
answers

Mirror Mysql BD

I would like to know if it is possible to create a mirror of a local database. That is, the master database is on an intranet server and the slave is in a web hosting. Greetings !!!     
asked by 08.06.2016 / 17:02
1
answer

Error in Trigger

I have a problem This code does not work. I miss this error # 1064 - Something is wrong in its syntax near '' on line 6 CREATE OR REPLACE TRIGGER TR_MORA AFTER INSERT on servicios FOR EACH ROW BEGIN INSERT INTO deteconomico(FECHA_PAGAR) VALUES...
asked by 16.10.2017 / 02:32
2
answers

Query yii2 mysql

I am trying to make a query in yii2, I am new and I have not yet become familiar with the query topic, the query is as follows: I need to bring this data: ->select('ingreso.idingreso', 'ingreso.fecha_hora', 'persona.nombre', 'ingreso.tip...
asked by 22.10.2017 / 20:13