Questions tagged as 'mysql'

Tagged questions
1
answer

When creating a temporary table in MySQL and assigning data from another table is it necessary to specify the data types?

I have a question, I am using the following query: Create temporary table tbl as Select * from bd.tbl2 where date < '2018-09-08' The issue is that I still do not understand if when creating a temporary table and assigning data from another...
asked by 08.09.2018 / 17:15
1
answer

Upload data and images of a form with Node.js - form / data

I am developing a web page in which in one of its sections the user must register a product (DATA) and upload an image (optional) concerning it. When you click on the "Save" button you should upload the image to the server, register the data in...
asked by 24.10.2018 / 04:20
1
answer

Count or Account in a SELECT MySQL

I would like to make a query with a column that lists the results but to a certain extent and then restart the account: For example: The query lists my 8 results .. in this case, name. Carolina Claudia Daniel Francisco Jose Mari...
asked by 23.10.2018 / 18:44
1
answer

Use of IN and OUT in Stored Procedures

A procedure stored as such is a routine that contains the sql statement (s) to which it is accessed as follows CALL nombrePA(); A simple example we have of a PA is like the following DELIMITER // CREATE PROCEDURE fetchAll() SELEC...
asked by 10.11.2018 / 01:49
2
answers

How to show a row of a table first?

Having this table as I would do so that row number 3 appears first in a query and the rest is like this .. but in the query all records appear, just vary the order I would like the result of the consultation to be something like this...
asked by 11.11.2018 / 20:36
3
answers

Creating a csv file in mysql with current date

How can data from mysql be exported to a file cvs with date and time of day? I try this code but I get an error. I'm trying to do a evento My Event CREATE DEFINER = 'admin'@'localhost' EVENT 'Respaldo Ordenes' ON SCHED...
asked by 09.11.2018 / 18:54
1
answer

QUERY does not run correctly in PHP

I have two queries in php , after using echo $id_inspirador the value of the first query is printed correctly, but I have an error regarding the second Notice: Undefined index: id_proyecto , I do not know if the value o...
asked by 28.11.2018 / 19:54
1
answer

Warning: mysqli_fetch_array () expects at most 2 parameters, 3 given

Does anyone know how I can do so that the mysqli_fetch_array can read me 3 parameters ? $registros = 1; //registros por página $sql = "SELECT * FROM base1"; $result = mysqli_query($conec, $sql); $reg_total = @mysqli_num_rows($result); //tota...
asked by 05.08.2018 / 01:13
3
answers

Leave empty cells in an HTML table

How can I leave empty cells in a table if I do not want anything to appear in that field? I am sending to call names of some subjects registered in my database, I send them to call and bring them to me there is no problem, the problem is when in...
asked by 04.08.2018 / 08:43
2
answers

ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' when loading sql

Version: Server version: 10.1.32-MariaDB I have trouble setting a password in mysql o mariadb use xampp 5.6 I install xampp I enter the console and with mysql -u root log me in. Following different examples that I...
asked by 04.08.2018 / 16:09