Questions tagged as 'mysql'

Tagged questions
1
answer

Correct creation of tables

Given my classes where Encomenda inherits from Objeto : @Entity @Table(name = "objeto") @XmlRootElement(name = "objeto") @XmlAccessorType(XmlAccessType.FIELD) @AllArgsConstructor @NoArgsConstructor public class Objeto implements S...
asked by 07.04.2017 / 00:04
1
answer

Foreign key relationship problem in PhpMyAdmin - Wamp

I have 'problem' in my Wamp, more precisely in the latest version (Wampserver 3.0.6 64 bit x64). When I create 2 tables, example: CREATE TABLE categoria( id_categoria INT NOT NULL AUTO_INCREMENT, nome VARCHAR(100) NOT NULL, PRIM...
asked by 11.08.2017 / 13:19
1
answer

Dynamic form and send to mysql via jquery and ajax

I've already asked some questions about this, but I've been helped, but the kind of way they said it only works if the form is normal, with inputs with name "something here" my form only has an input "text" name "table "to put the table number t...
asked by 03.02.2017 / 18:55
2
answers

Error Setting Datasource in VS Community 2015 C # + ReportViwer + Mysql

Good afternoon. having a tremendous difficulty to solve this problem. I am in the distribution phase of an App and exactly today I had a serious problem. Generate a report using RiportViwer and Mysql in VSC 2015. Application running smooth...
asked by 31.03.2017 / 22:27
1
answer

How to search any part of the string with mysql

Hello, I use this form to search MySQL string% , but in a sentence "test one two three" if I use ste% it will not return the phrase, how could I search if it contains within the sentence?     
asked by 31.03.2017 / 19:31
2
answers

SQL with 2 of several conditions

I'm having trouble making a Select that meets the 2 or 3 conditions of several selected, for example: Conditions: - Cidade Tal (São Paulo) - Nome Tal (João) - Sexo (Masculino) - Fumante (Não) - Carro Próprio (Sim) I want everyone to meet wi...
asked by 20.02.2017 / 22:42
1
answer

Insert and fetch data in the database per user with Laravel

I need to save information to the database by logged in user. That is, when the user logs in, everything he does will save to the login database. That is, when user X logs in, everything he saves in the database will refer to him (user X)....
asked by 18.02.2017 / 22:29
1
answer

Querys have stopped working

Recently I made a change in the table and after that SELECT and INSERT INTO stopped working. At first INSERT INTO could not include data in the last column that includes (centid), it returned column 'centid' cannot be...
asked by 21.02.2017 / 21:13
1
answer

Search in MySQL database MVC

I have Search searching by name, but wanted to search for both name and place in the same search field. Follow the action: [HttpPost] public ActionResult Search(FormCollection fc, string searchString) { if...
asked by 08.10.2016 / 19:57
1
answer

How to list multiple columns using Inner Join and left join? [duplicate]

How can I get data from two tables? Example. thefields'assunto,nomeremetente,cpfremetente,observacao'databela**protocolos**anddatacriacaoofthedocument_documenttableisofdocument_documentisdataformat(datacriacao,'%d/%m/%Y')asdatacriacaot...
asked by 10.10.2016 / 19:51