Questions tagged as 'mysql'

Tagged questions
1
answer

What are the SQL Server Express and MySQL limits?

What are the limits of SQL Server Express and MySQL? How many bases are possible? How big is each base? The size of index files?     
asked by 16.07.2015 / 16:49
2
answers

Delete cascading table data

I have some relationships in my tables and I'm wanting to delete them in reverse. In my system the user will have the option of deleting a category, here comes my doubt as I will do this, because it should delete the pages, category descript...
asked by 13.06.2015 / 20:35
1
answer

Limit login attempts by time and quantity

I am working on a login system with php and mysql and this doubt arose because I do not know if this can only be considered something "acceptable" as another security tool in the login process. > Well say the idea is to limit the...
asked by 05.06.2016 / 19:09
1
answer

SELECT with sequential counter does not accept LEFT JOIN

Why does a SELECT return a sequence number does not work if it has LEFT JOIN ? SELECT @ROW_NUMBER:=@ROW_NUMBER+1 AS ROW_NUMBER, P.PEDIDOID FROM PEDIDO AS P, (SELECT @ROW_NUMBER:=0) AS T LEFT JOIN PEDIDOPRODUTO AS PP ON...
asked by 27.05.2015 / 00:11
1
answer

Database Indexing [closed]

What is the advantage of maintaining an indexed database, with foreign key and indexing of the most used fields as in searches?     
asked by 14.05.2015 / 13:02
1
answer

MySQL Backup with Event Scheduler

I would like some tips on how to back up a mysql database with Event Scheduler. I just got in my searches, find event to back individual tables. I would like to be able to backup the whole database, can anyone help me? (this code is just...
asked by 05.01.2015 / 14:07
1
answer

What is the difference between the MySQL Trigger exception and MySQL Event?

I would like to create an Email trigger scheduler , if possible, without using cron , and would like to know if you can do this through MySQL >. Searching the Internet I've seen some examples of creating a non-cron event : CREATE...
asked by 14.12.2015 / 13:38
1
answer

Rollback in specific table Laravel 4

I am manipulating a MySQL database with Laravel 4. I want to know if there is any way to do a rollback on just one of the database tables. For example, my migration included the x, y, and z tables. I want to do a rollback only on the table and....
asked by 14.12.2015 / 12:57
1
answer

htmlspecialchars () expects parameter 1 to be string, object given

I'm trying to make a select button on the blade with @foreach to get the list of all MySql databases. Only @foreach works, I can get the values, but I can not put the bases inside select . It is giving error:    htm...
asked by 26.01.2017 / 14:07
2
answers

SELECT returning data that was not seen by a certain user

I'm having a hard time putting together Query I have 2 tables: video_visualizacoes with fields visualizacao_id, video_id, conta_id (This field refers to the user who viewed the video) ". videos with fields vi...
asked by 15.01.2016 / 20:01