Questions tagged as 'mysql'

Tagged questions
1
answer

Search with date in Laravel

I have the following query:
asked by 02.10.2018 / 20:19
1
answer

Convert all mysql bank to lowercase

Is it possible to convert all columns of tables in a mysql database to lowercase letters? I have several records and several tables, all of them are a miscellaneous case (and some with emphasis). Detail: the type is InnoDB ; collation...
asked by 04.10.2018 / 00:12
2
answers

Get an item from each Row

How can I get an Item from each Row? For example, I have a column with the following Rows: TEST TEST TEST2 TEST2 TEST3 As I wanted: TEST TEST2 TEST3 My code: public void carregar(){ qy = "SELECT TESTEROWS F...
asked by 27.09.2018 / 19:43
1
answer

PHP code to query MYSQL leaking memory

All good people? Guys I'm having a problem that I had not encountered before. I wrote the code below and at the time of opening the page by localhost in the browser it returns the following error:    Fatal error: Allowed memory size of 134217...
asked by 28.09.2018 / 02:14
1
answer

How to use friendly URL?

I'm doing my TCC and the theme is SEO, to complete I need to put friendly URL since the current link is like this:    post.php? id = 79 Well, I already looked for the .htaccess and managed to leave the main pages (blog.php, contato.php, i...
asked by 23.09.2018 / 03:39
2
answers

Parameter passing in the LIMIT of Mysql

I am creating a paging system and in mysql I am using it this way I get from record 1 and walk to 20 SELECT * FROM sistema LIMIT 1 , 20 I get from record 2 and walk to 21 SELECT * FROM sistema LIMIT 2 , 21 and so on but I want it to...
asked by 24.09.2018 / 01:46
1
answer

MYSQL Time interval

I need to search a server, through a command, for a 2 hour interval of a saved data in relation to the server time. Example : An employee opens a call; this call will be saved to the bank on date X with the 12:00:00 time and its status will...
asked by 11.10.2018 / 20:04
2
answers

Avoid double quotation marks in CSV file exported with PHP

It is possible to prevent the CSV file from coming with aspas duplas in string fields, I am using the script below, but the nome field is coming between aspas duplas , how can I avoid this? <?php//export.phpif(is...
asked by 01.10.2018 / 19:37
2
answers

PHP Warning: mysqli_close () expects parameter 1 to be mysqli, boolean given

I'm having this problem. Does anyone know why? This is from a php book Mylogcontainsthis[Warning:mysqli_query()expectsparameter1tobemysqli,booleangivenin/var/www/html/php-oo/lv-77/mysql_lista.phponline7,referer: link mysqli_close () expec...
asked by 01.10.2018 / 04:02
1
answer

Python - KeyError

Someone can help me! I am reading from a csv file and then I do an INSERT on the MySQL database, but I get the following error KeyError: 'id' I have checked the CSV file several times, the file has all the columns and exactly the same...
asked by 01.10.2018 / 23:53