Questions tagged as 'sql'

Tagged questions
0
answers

See which user created or changed a Linked server

Sirs, How to audit the creation or change of Linked Servers in SQL Server 2008 or higher? (See who created or changed a linked server).     
asked by 07.08.2015 / 18:35
0
answers

Problems with updating the dataGrid C #

I have a code responsible for stock-taking of a certain product in a product table ... it fills the stock without problems .. but when I go to the product stock surveys form, the product whose stock has been slaughtered does not presents the upd...
asked by 16.07.2015 / 12:13
0
answers

Export MySQL users and permissions to another server

I am making another server with the same databases of the previous server (I have already migrated the databases) and would like to migrate the users and permissions of this previous server to the new server at one time, is it possible? How do y...
asked by 16.07.2015 / 20:20
0
answers

Search for custom fields and tags in Wordpress with delay of results

I have a Wordpress website that has custom fields related to "Photo Albums", which I am now creating a search engine for. The problem is that because it uses Tags in its albums and custom_fields in the photos, when I perform a search where al...
asked by 14.08.2015 / 18:44
1
answer

How to count the number of comma-separated items in MySQL?

I have a field in a table with data separated by a comma: condicao_pagamento: 20,25,35,45,50 . How do I count the number of comma-separated items using MySQL only?     
asked by 06.07.2015 / 06:13
1
answer

Relation between several tables in Eloquent

I'm trying to create models in Lumen based on my current database for a virtual store, but I'm having trouble setting up the relationships between them. So far I have the following Models: * Product <?php namespace App\Models; use Illum...
asked by 10.07.2015 / 19:46
1
answer

SQL Query Optimization

I've set up a series of SQL but I'm having difficulty generating something that stresses less the server, I ask for help from you. Follow SQL: SELECT '2015-06-10 00:00:00' AS 'Hora', COUNT(id_contato) AS 'Total' FROM contato WHERE data_hora...
asked by 10.06.2015 / 22:05
0
answers

Create SQL Tax Table

I'm developing a budget system, and to finish my project, I need to create a tax table. To help you, here is an example of what I want to do: in the raw material table, each material has a purchase tax and this amount of product taxes can be cha...
asked by 06.07.2015 / 18:12
0
answers

Passing sql in array index CAKEPHP

I need to do 3 queries, if x icon is enabled, make X query. If it is the y icon, query y. If the 2 are, I want everything from the query x and y. I can get the query x and y, but at the time of getting all of the 2 queries I can not. Ifs t...
asked by 01.06.2015 / 17:21
1
answer

List evenly 3 column-count

Well I think this is in css what is not my beach, I would like to be listing the results of the bd and pass the next result to the next column I tried to use (summarized) SELECT * FROM anuncios ORDER BY data DESC .recipiente{ -webkit-colum...
asked by 04.06.2015 / 02:56