Questions tagged as 'mysql'

Tagged questions
1
answer

get id of a modified query

Good morning, I would like to know if there is a function similar to msqli_insert_id (this function returns the id or primary key of the query to be executed), but that it is applied after an update. That is, a function that tells me which is th...
asked by 29.12.2016 / 05:00
1
answer

how to do one followed by numbers in mysql

In a database I have the following problem: ID premio ordenar precio Fecha escala_Vencida 1 1 1 1000 30-12-2016 si 2 1 2 2000 30-12-2016 si 3 1 3 3000 30-12-2016 si 4 2 4 4000...
asked by 14.01.2017 / 13:28
1
answer

From Sqlite to MySql (several records at once)

How to make a selection to the records that I created with my "high" method (to see that I save them as I want) my problem is that I want to create the table without a PK, and I also wanted to know what the form is more useful to upload the data...
asked by 22.12.2016 / 17:39
0
answers

Why does not this AJAX website show results?

NOTE will not explain anything about this script because it was something that I was building from another website COPIE and PEGUE said that I only made these two files I do not know where the error is . THE PROBLEM is that the query is...
asked by 16.01.2017 / 19:39
0
answers

Use MySQL database or save data in file for sales system

I'm starting as a software vendor. I have been asked for a system to control sales and stock of a small commercial establishment. I thought about making a desktop application with Java and MySQL (Netbeans and WAMP Server). My question is this...
asked by 17.01.2017 / 14:30
2
answers

Manipulate .asc file with PHP and MySQL

I want to upload a file .asc and insert it into my MySQL database. The content of the file is similar to this:    3884 | 5000007 | 160 | 1 | IN | 160 || HME980330SL3 | MESJ540212HDFRNR02 | 14.71800 | 0 | 0 | 0 | 0 | 0 | 8827.700 | 7...
asked by 26.12.2016 / 08:18
0
answers

Can you compare conditionals in MySQL?

Can you make comparisons between IF e IFNULL ? I mean I want to compare an IFNULL statement with other IFNULLs and take the largest one out of them, but I do not know how to do it or if it can be done. At the same time I have...
asked by 01.02.2017 / 04:41
0
answers

nested query in codeigniter with mysql

good. I have a query that already works in mysql but I have not been able to make it work in my codeigniter model, I have exactly syntax problems like this query could translate: select t1.id_tabla1 as , t1.condicion, greatest(coalesce...
asked by 14.12.2016 / 01:17
0
answers

Problem when importing database with phpmyadmin

I have a Database with innodb tables on my local server. The tables have primary keys, indexes and relationships. I need to host it in a web hosting that has support for innodb tables. When I export it from my local server, it does it corr...
asked by 15.12.2016 / 14:34
2
answers

Error uploading images to the server

I hope you can help me, you will see I have the following: A file called index.php with the following code: <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; char...
asked by 07.01.2017 / 04:25