Questions tagged as 'mysql'

Tagged questions
1
answer

Query the most duplicate record

I'm having a problem retrieving the teacher who teaches more subjects in this table, in that case I want to retrieve the code that most has double records in the cod_prof column. create table aluno_professor_disciplina ( matricula int,...
asked by 23.11.2015 / 19:01
1
answer

Doubles Simple School System

Well I'm doing a job for college, I'm already in the middle, but to do the final part I need: The teacher can register a pdf / image, in his area. And the student on his page can see / download this attachment. What I have so far only s...
asked by 16.11.2015 / 03:08
3
answers

How to sort from what has more records to what has less

I have a table where id_produto and ip will be stored. I'll mount a "module" where the system will pull some of the products that have had the most visits, so what I need to do is pull the products that have the most records in the...
asked by 19.04.2016 / 04:19
1
answer

How to list in the listView the results of MySql

Code Structure In this function below I try to get the content of the MySql database and passing it to a List<BDependente> lDep in the line where facade.listDependente(bDep); Employee Method lvDependente.Col...
asked by 20.04.2016 / 11:55
2
answers

Problem with query in php because of quotation marks

I'm having trouble with a query in php as follows, Example: INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway'); This query wor...
asked by 07.04.2016 / 15:20
3
answers

Query mysql with subquery in NodeJs

I have the following structure in the following tables. partner (idPartner, name, email, phone) example Tag partner (old id, tag) What I need to do, a select in the partner table and make a is in the result and query the tableTag partner b...
asked by 14.04.2016 / 22:59
1
answer

Doubt how to query multiple tables with one word

I'm setting up a search system, where the user types in a search box any word, eg "Programmer", mysql will have to search that word in several fields in several tables, if by chance he finds that word in some place get back to me who is the prof...
asked by 27.09.2015 / 07:52
1
answer

Error 1114 (HY000) in MySQL: The table is full

I've exported a MySQL-sized 14GB database from a Windows OS computer and want to import it into MySQL from a computer running Ubuntu 14.04 OS I used the following command to export the "data" database: mysqldump -u root -p dados > teste....
asked by 24.09.2015 / 02:18
2
answers

Trying to make login work, but does not show error but does not enter either

I did the php right as my teacher passed, I changed all the names and it's alright, I checked, but when I do the login, it does not go in, it only refreshes the page and it does not redirect to the profile page of the person as it is to be done....
asked by 14.09.2015 / 21:18
1
answer

Select records in order

I'm doing a virtual store from scratch and the customer asked me to do the following logic: Selects first available products with photo Then select those available without a photo Next select unavailable with photo then select the non-...
asked by 01.08.2015 / 22:24