Best answeres tagged with sql

2

answers

Update in Zend 2

I'm studying Zend Framework 2 and am needing a hand to do an update on two tables that are related. Come on. I have the table entries with the fields: id_entrada id_notafiscal and in the fiscal_notes table the fields: id_nota...

asked by 24.02.2014 / 23:08

2

answers

What is the cause of using SELECT null FROM RDB $ DATABASE

I'm not understanding this SELECT null FROM RDB$DATABASE : SELECT CK.IDCHEK, CK.DESCHE, (SELECT null FROM RDB$DATABASE) AS ENTEGU FROM TC_CHECKL CK ORDER BY CK.IDCHEK It looks like it goes into an internal table of the b...

asked by 20.02.2014 / 15:20

0

answers

Artificial Intelligence using PHP and MySQL [closed]

I'm looking for information on artificial intelligence using MySQL and PHP only, I did not find much information to guide me correctly, I want to develop a small chat with virtual intelligence capable of responding to the user based on what he s...

asked by 30.12.2014 / 22:16

1

answer

How to know which SQL is generated by the ORM Entity Framework?

With the use of the ORM , and the practice employed we forget that they generate SQLs and return Objetos (vice versa). How can I find out at runtime the SQL generated by the Entity Framework directly in Visual Stud...

asked by 14.06.2014 / 17:48

2

answers

Join SQL tables

I'm having a small problem making a Join between two tables in SQL, I'd like to know if you can help me. There are 2 tables GTM_ITEM_CLASSIFICATION and ITEM_REFNUM , both refer to the ITEM table, but using different keys. For the first t...

asked by 03.07.2014 / 14:24

4

answers

Limit the number of SQL query rows

I have the following Query SELECT estado, num_ocorrencia FROM bra_ocorrencias WHERE nome like 'João' ORDER BY num_ocorrencia DESC It returns me all states with the most relevant occurrence numbers I have in the table, I would like to narrow...

asked by 05.07.2018 / 17:55

4

answers

How to copy column data from one table to another table

I have a table named UC which has an email column, and I have a table backup of it. I need to copy the data (emails) from the email column of the backup table to the email column of the uc table, however I do not k...

asked by 23.05.2014 / 18:28

2

answers

How to select data from different tables

How to make a select by taking a field from each table? I want to get the text field from 4 different tables, how should I do it?

asked by 28.08.2014 / 14:47

4

answers

Most common words among rows

Is there a function in MySQL that gives me the 3 most common words between a column in TEXT format of a table? Example Maria Joaquina Maria Antonienta Maria B.

asked by 30.12.2014 / 00:26

3

answers

What is the best way to check the existence of a record in the database via the application?

Today I use a method that sends a COUNT with the record Id as a parameter to the database. Is there a better, perhaps more performative way to do this?

asked by 27.02.2015 / 14:38

Questions tagged as 'sql'