Questions tagged as 'mysql'

Tagged questions
4
answers

Doubt on date in SQL

I'm setting up a database for a store to learn SQL. My goal is to have a movie return date. For this, I created the table with a column named "return" to store when the movie will return to the store, using the following format: create table a...
asked by 21.01.2016 / 16:30
0
answers

Delimiter in procedure mysql

I am running procedure , but my web application formats this procedure and runs it on mysql . The problem is that when the procedure is executed, it stays in only one line (without breaking lines). For example: DELIMITER // CREATE...
asked by 17.03.2016 / 01:27
0
answers

how do I check for a text file is empty in php and if it is finished executing?

I have a code that runs a simple query like this select * from tabela where coluna1 = 'valor'; Then I have a variable that brings a txt file $filename = "C:/Programfile/arquivo.txt"; Then I make this condition below if (file_exists($...
asked by 19.04.2016 / 14:14
1
answer

method to log in using DataSnap

I'm doing an Android application using Delphi, I have a server with the methods to get the data from the Mysql database, I would like to know how I can do a method to get the users that are already registered in the database and then how call th...
asked by 17.02.2016 / 14:29
0
answers

Apostille caelum fj21 error driver mysql

Good afternoon guys, Beginning I'm studying the caelum Java WEB booklet but the following error is showing up. I already imported the MySQL driver, I switched between the commented line and commented the above, but it is not working the brows...
asked by 18.01.2016 / 17:56
0
answers

How to update the database when reordering list by sortable

Daew lads, I'm using the sortable to reorder a list. How do I make the change in the bank within the function? Here is my code: <?php session_start(); if ($_SESSION['clienteLogado']=="") { header("Location:login.php");...
asked by 19.01.2016 / 17:30
0
answers

Creating Points in Google Maps api with data using PHP / MySQL [closed]

I'm trying to learn how to tinker and make maps using google maps API but I want to know if I have and how to do a map automatically using points (coordinates) that were registered in the database through a form. And if these points are repeated...
asked by 25.02.2016 / 15:13
1
answer

PhpMyAdmin Import file size

I'm having trouble importing a 600mb .sql file. My PHP is already authorized to receive files of this size: memory_limit =1000M post_max_size = 1000M upload_max_filesize = 1000M max_execution_time = 30000 max_input_time = 30000 But still...
asked by 28.12.2015 / 20:46
1
answer

I am getting this error Can not connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Everything was working, but after a while I started to get this error constantly:    Can not connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) The mysql server seems to be constantly dropping. Then I reboot, and...
asked by 27.12.2015 / 21:35
1
answer

Group content by month and day [closed]

Good afternoon Guys, I'm having a problem with grouping content in the following structure: Month Day In the query I have two tables, "schedule" and "user". In the calendar table I have a field of type "date" that "should" group the cont...
asked by 22.02.2016 / 21:17