Questions tagged as 'mysql'

Tagged questions
1
answer

How to change alphabetic and numeric pager?

How can I change this code so that it works as follows in case it puts the initial letters of each item added in $ aInitials in the case it clicks it filters listing all the items with that initial letter with all numbers, characters and symbols...
asked by 16.11.2014 / 22:16
1
answer

Add data in database through a link

I gave a quick search but did not find it, so I'm posting here. I want to get the following SQL code: INSERT INTO 'rooms' ('id', 'roomtype', 'caption', 'owner', 'description', 'category', 'state', 'users_now', 'users_max', 'model_name', 'pub...
asked by 19.09.2014 / 22:26
1
answer

How to insert this information in the mysql database?

$pegacodigos = mysql_query("SELECT CODIGO FROM imovel"); while($codigo = mysql_fetch_array($pegacodigos){ ... Deleting and rewriting everything: The $pegacodigos through a loop takes all CODIGO in the IMOVEL...
asked by 08.09.2014 / 21:57
2
answers

How to pass the code (id) by my viwer using thymeleaf and spring mvc for the controller?

My entity: package local.demo.models; import java.io.Serializable; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; @Entity public class Evento i...
asked by 14.03.2018 / 15:49
1
answer

GENERATE PHP REPORT

I have a database in which you have two tables: CLIENTS TICKETS InmyVIEW(Codeigniter),theuserwillselectaperiod(Ex01/03/2018to03/31/2018)togenerateareportofalltheticketsthatwerepaidwithinthisperiod.Inthisreport,Ineedalltheinformationfrom...
asked by 10.03.2018 / 04:55
1
answer

How to do Select all of the ids of a table except the first 2?

I need to make a select in mysql of all users of a table, however I can not receive the first two users of the table and I need to do this without specifying id, since when more users are registered I need the first two not to appear . I tried s...
asked by 19.11.2018 / 01:03
1
answer

My SQL Query does not work correctly?

I have a system that uses dates for logging and I separate the date by an arrays-formed explode and register them in a database, but when I do the query it looks for them in order, the order stumbles. Following code examples - >...
asked by 14.11.2018 / 02:49
1
answer

Several buttons on the same page with different functions

I have the following code that has 3 buttons, at the push of a button, it should change a value in my table in Mysql, but when I press one of the buttons, it is the same as pressing all the other buttons at the same time time. Follow the code...
asked by 18.11.2017 / 19:35
1
answer

Pick up all product tables and move in only one

Type I have the bank products and the tables, I want all these tables to be in just one how can I make it easier?     
asked by 25.11.2017 / 23:53
1
answer

create Linked in MySQL between different instances [duplicate]

Hello, I have Instance A (Local) and another instance B, I need to do a query where I have table A (Local instance) relate to table B of (instance B) is possible?     
asked by 17.09.2018 / 21:07