mysql -u -root -p
use db_name
ALTER TABLE TABLE_NAME ADD INDEX (COLUMN_NAME(length));
DROP INDEX name on table
show index from table
ANALYZE TABLE articles;
mysql -h yourhostname -u username -p databasename < yoursqlfile.sql
<p class="is-6 is-paddingless"><small class="has-text-grey-light">{{ url('/').'/tin-tuc/'.$article->category_slug.'/'.$article->slug}}</small></p>



true: select * from user where email=email and password=password
false: select * from user where email='đấ' and password='đasa'

select * from user where email='' or 1=1; /* ' and password='*/--'

SELECT * FROM users where username=' ' or 1=1; /* and password=''*/

SELECT * FROM users where username='nhi' and password='' or ''=''

select B.title,B.category_id,B.slug,B.published_at,B.description from
(
select articles.id from articles
where (match (title, description, content)
against ($query2, IN BOOLEAN MODE)) A
inner join articles B using (id)
where locate($query,concat(title, description, content)>0));

DROP PROCEDURE IF EXISTS article_update_status;
DROP TRIGGER IF EXISTS article_update_status;
select B.title,B.category_id,B.slug,B.published_at,B.description from ( select articles.id from articles where (match (title, description, content) against ("+trieu+tien" IN BOOLEAN MODE))) A inner join articles B using (id) where locate("trieu tien",concat(title, description, content))>0;



select title,category_id,slug,published_at,description from articles where match (title, description, content) against('$query' in BOOLEAN MODE) inner join  and status='4' limit 60000