Questions tagged as 'sql'

Tagged questions
2
answers

Error and doubts FireBird sql

I own this table code CREATE TABLE news ( id_news INTEGER NOT NULL, title VARCHAR(128) NOT NULL, slug VARCHAR(128) NOT NULL, text TEXT NOT NULL, PRIMARY KEY (id_news), KEY slug (slug) ); You are experiencing the f...
asked by 27.03.2018 / 16:30
1
answer

Extract and include SQL data with R

I'm designing a database in SQL that will have tables that store collected data and a table that stores calculated indexes of that data for later display on a dashboard. I want to calculate these indexes with the language R. I would like to know...
asked by 31.07.2017 / 14:19
3
answers

SQL to search across the database

Is there any command to do a select on all tables in a mysql database? Type I have multiple tables in my database with miscellaneous content. I need a way for a user to search for a keyword in all tables.     
asked by 10.08.2017 / 19:29
1
answer

Transform array into divs?

I have a page with php that brings me a list of records, however it brings a array and I would like every item of it to come in divs or table with lines. Below what I'm doing: $db = JFactory::getDbo(); $query = $db->...
asked by 16.03.2017 / 21:58
1
answer

Transfer data from SQL Server to SQLite with Android

I have software that is connected to a SQL Server database, but now I'm doing the software on Android using SQLite. I need to transfer the SQL Server database (with data) to my SQLite. Backup works? Even with the views I have in SQL Server...
asked by 10.02.2017 / 06:04
1
answer

Register loop in if loop

I have a registration form: <form action="Cadastro.php" method="post"> Nome de Usuário: <br> <input class="form-control" type="text" placeholder=" algo parecido com o seu nome" size="30px" name="nomeUser"...
asked by 17.01.2017 / 19:42
1
answer

Ignore parameter if null

I have the following method that searches the database: public Collection<Habilidade> pesquisar(HabilidadeForm form) throws Exception { String query = "select u from Habilidade u where u.nome like ?1 and u.geracao = ?2";...
asked by 05.01.2017 / 23:38
1
answer

PHP error with MySQL [closed]

I have an error and I do not understand why. The error: Fatal error: Call to a member function fetch_assoc() on boolean the error snippet: require 'conecta.php'; $sql = "SELECT 'nomep', 'endereco' FROM 'cadastropn' WHERE 'cida...
asked by 02.09.2016 / 00:08
1
answer

How to handle database working with docker?

I started working with docker recently and here's a question and in preparation for a wordpress lamp environment, I came up with my bank and my files. The idea was to leave everything inside a repository within git-hub th...
asked by 10.09.2016 / 06:38
1
answer

MySQL syntax [closed]

I can not see the error: UPDATE clientes SET txtEndereco=\"Rua Xingú, 823\", txtBairro=\"Val Paraíso\", txtCEP=\"09060-050\", txtUF=\"35\", txtCidade=\"14933\", regiaos=\"\", Obs=\"Princesa fada\") WHERE idCliente = \"2\    You have...
asked by 13.10.2016 / 15:46