Best answeres tagged with mysql

3

answers

C # mysql reader.read ()

I'm trying to read take the idphone from the phone table, but the reader1 collects the data from this table rarely and almost always he does not. Corroborating that the data I am looking for exists in said table with the search pattern....

asked by 24.04.2016 / 17:14

1

answer

problems with making sql queries in nodejs

The id is passed by parameter to my query function, but it fails to execute the query this is my code: objBD.query('SELECT u.ID_U, u.nombre, l.ID_L,letra, t.ID_T,tiempo from USUARIO u INNER JOIN LETRA l ON u.ID_U = l.ID_U INNER JOIN TIEMPOS...

asked by 05.10.2016 / 18:39

5

answers

how can I include a variable inside double quotes

$articulos= $conexion->prepare( 'SELECT SQL_CALC_ROWS * FROM articulos LIMIT $inicio, $postPorPaginas' ); When it's like this inside php, it appears to me as if it were a simple string although I have declared the varible with it...

asked by 23.01.2018 / 20:13

3

answers

query with several mysql statuses

I have a question with a mysql query. What I need to get are the nombres that have only the estado = 1 . As you can see in the table, the nombre "pepe" has status "1 and 0", is there any way to exclude it? tab...

asked by 11.09.2017 / 16:17

2

answers

Modal with Bootstrap calls link in PHP from MySQL

Good morning, I wanted to consult the following: When generating a modal with Bootstrap and calling from the database, it generates the modal , but even though there is a lot of data, it always shows me the first one it takes....

asked by 07.01.2016 / 04:07

3

answers

Difference between Execute and Query in MySQL

When I run a query in the MySQL database, the Execute command freezes the database completely, whereas the Query command normally runs the query. What is the difference between these two commands?

asked by 14.06.2017 / 17:51

3

answers

Error with PHP and MySQL

I have this connection <?php # Conexion con la Base de Datos $userdb = 'administrador'; $passworddb = '1234567'; $dbhost= 'dbserver'; $dbname = 'sk_modular'; ?> and I have I'm calling the database to bring me some data...

asked by 11.04.2017 / 03:09

2

answers

Case mysql error

SELECT count(*), CASE count(*) WHEN >=0 then Esta vacio end FROM producto By putting this query I get the error #1064 - Algo está equivocado en su sintax I have been reading online and I can not find the solution to this problem ...

asked by 26.04.2017 / 11:16

2

answers

It does not show all the data of the mysql database in my table

Hi, how are you, I come with a doubt because it does not show me the data of my mysql database in a table that believes in my html. You skip the first user, it is worth mentioning that you already check my connection, the name of the fi...

asked by 19.09.2018 / 01:22

2

answers

Difference between query () and execute () [duplicate]

It really is the same: $base->query("DELETE FROM EJ_TABLA WHERE ID='$Id'"); What to do this: $base->prepare("DELETE FROM EJ_TABLA WHERE ID='$Id'")->execute(); ?

asked by 21.08.2018 / 14:26

Questions tagged as 'mysql'