Questions tagged as 'mysql'

Tagged questions
1
answer

Limit number of rows in a table [closed]

What friends, the question I have is this: I have a table connected to a database, every time you enter a value is automatically updated, the problem I have is that it shows me all the values of the database, how can I limit those rows to show m...
asked by 05.04.2017 / 15:06
1
answer

How can I ignore two results in a specific query?

I have a query that gives me the start and end of each user, but what I want is to omit two users in specific, how can I manage to omit two results? I have the following query: SELECT nombre, MIN(fecha) desde, MAX(fecha) hasta FROM...
asked by 02.05.2017 / 18:58
1
answer

CREATE TABLE mysql query does not work

I have this MySQL query that I try to perform and for some reason it does not work. Can anyone see the error? I have read other questions since yesterday and can not find the answer. I do not find my mistake really. CREATE TABLE IF NOT EXISTS...
asked by 11.03.2017 / 15:04
1
answer

Update records using PDO

Good morning everyone, I have the following problem: I have a form where I retrieve a record from a database and an update button to edit the record in question. The part of the form where I show the data of any registry works well, the pa...
asked by 27.12.2016 / 13:52
1
answer

Avoid viewing a page without going through index.php

I have a index.php that is a form of login and that being correct the user and the password directs to another page. The problem is that if I go to the other page I can see it without having gone through the login and I want to see this...
asked by 24.01.2017 / 19:16
2
answers

Cardinality in workbench in model

I'm not found information about the relationships of the tables. The only one I understand is the automatic, but I do not want to always throw away the automatic. I have been looking through the internet but I have not found the answer. Maybe it...
asked by 01.02.2017 / 10:36
1
answer

FatalErrorException in Book.php line 12: syntax error, unexpected 'public' (T_PUBLIC)

Good morning. I am currently in Laravel making an application for the management of a library and when entering the model a method to upload a file I get this error:    FatalErrorException in Libro.php line 12: syntax error, unexpected   'p...
asked by 09.01.2017 / 10:45
1
answer

What name does this bear? and can you add content to a database? [closed]

What name does this have and how do I add it to a website for mysql? Is that I want to create as well as in the forums a Web text this may or may not include images and link but I do not know where to get the source codes, this could se...
asked by 10.01.2017 / 12:10
1
answer

Insert data in MySQL and Java in Eclipse

I'm having a lot of problems to successfully insert my program data into the table in my database. To connect to MySQL , I have this: import java.sql.*; public class ConexionBD { // Ruta de nuestra base de datos private String se...
asked by 25.11.2016 / 20:58
1
answer

Problem in SQL query

Good morning I am making an inquiry to know the number of rows that are currently planted and the rows that were already planted but the harvest ended and therefore the remaining plants are removed for a new planting per farm. When there i...
asked by 18.11.2016 / 18:35