Questions tagged as 'mysql'

Tagged questions
1
answer

Full Text Index for Ecommerce Database!

I have read several posts here in the SOPT about creating índices which got me a lot of doubts I had, but my main one is about FULL TEXT ! In a database that is exclusively targeted to ecommerce , where inserts , u...
asked by 13.03.2017 / 13:57
4
answers

Get the id from where the max (value) was found

I've tried this, but the correct value is not coming SELECT id, data, max(valor) FROM teste WHERE data BETWEEN '2017-03-01 00:00:00' AND '2017-04-01 00:00:00' The maximum value comes perfect, but it takes the first id within that date. Ho...
asked by 14.03.2017 / 21:01
1
answer

Get the previous record of a date

I need to make an appointment, where I need to get the penultimate record, that is, the previous record and the date as well. SELECT DISTINCT prt_partner.razao_social, prt_partner.end_cidade, prt_partner.end_estado, prt_partner_status.nome, (...
asked by 29.03.2017 / 19:17
1
answer

Searching for objects in mysql

Good afternoon, I am using WorkBeanch 6.3 and I need to search the MySql database if a particular Column exists and what its Table, I also need to know if the particular Column is used in a Procedure or View, for example in Sql Server I do this;...
asked by 21.12.2015 / 19:13
2
answers

Is there a paid localhost server? [closed]

I searched the internet and found nothing related. I want to set up a localhost server to test my applications. I have already tested Xampp, Wampserver EasyPHP and others ... Is there a paid system? The correct way to speak is "Local...
asked by 30.12.2015 / 13:22
3
answers

How to create tables when starting Sisitema with JSF and JPA?

Well, how do I get the system started when the tables are created automatically? The way my system is, tables are only created when some kind of bank access is done. For example in the login screen just press the button log that the tables are c...
asked by 11.10.2016 / 15:11
2
answers

Select inverting row and column

I have a table like this: codigo ano quant 100 2014 15 100 2015 13 100 2016 20 101 2015 15 102 2016 22 102 2014 05 I want to create a query that lists the code like this: codigo 2014 2015 2016 1...
asked by 04.11.2016 / 15:36
1
answer

Make a Foreach in XML with ids and store in a variable to insert data into a given table

Good afternoon, Next, I have a system that already has the ids registered in a table, (of cars, are optional of cars) and in the other table where is registered the cars calls these IDS already registered, the system only le in the bank of da...
asked by 07.11.2016 / 18:06
1
answer

PDO with type BIT

I was now doing a statement with on duplicate and I have some fields like BIT . My DB class does typing using PDO::PARAM_STR , PDO::PARAM_BOOL , PDO::PARAM_INT ... but the use of these constants is optional, and when...
asked by 18.08.2015 / 04:10
1
answer

Select with Update

Would anyone know if there is a SQL layer to run a SELECT using LOCK IN SHARE MODE in the registry and running an UPDATE at the same time? example: SELECT * FROM Nome_Tabela WHERE id = 5 LOCK IN SHARE MODE (UPDATE AQUI) Any su...
asked by 21.07.2015 / 19:16