what is exact requiement ?
What is the maximum number of indexes we can add?
How to build these indexes correctly?
how will it work faster?
Can I build indexes without the first four popular fields?
COALESCE falls under the index ?
Do I need to run Optimize Table after introducing new indexes?
How to build indexes on OR ?
How can I get the information of a column as a list in Python?
Query statement on how to transfer data from one table to another
I wanted to learn SQL from scratch to advance can u please share the resources it will be helpful
Please anyone help me with resources
pm me
I have done message
Insert into tbl_year2
select * from tbl_year1
I am currently developing filtering on one of the projects, and this filtering should, if possible, be like that of Amazon
many dynamic filters (if the whole table is denormalized and everything is in one table except 1 join to another table 🙂 )
My questions:
How stupid is Mysql 5.6 and you need to adjust the conditions WHERE a=1 AND b=1 or for example WHERE b=1 AND a=1 (it will do it under the hood?, but if there are more than 10 of these conditions?)
What is the maximum number of indexes we can add?
How to build these indexes correctly? Check me:
1 – the most popular field
2 – sorting by these fields (date/price/name)
Can everything stop now? or:
3 – the next most popular lattitude field
4 – longitude
5 …
6…
16 …
and so it turns out that there are 3 sorts
means 3 composite indexes on (4 fields) am I right?
this way we will speed up for example most requests
and to speed up, for example, narrow-profile queries, should I create new indexes and set all these conditions up to the limit of 16 columns in the index? Or to add here in the previous indexes at once? (which I doubt because there is a left prefix rule, apparently which says the order in the WHERE clause is important)
how will it work faster?
Can I build indexes without the first four popular fields?
Also what to do if there is filtering (example of WHERE of a real query)
((ams.seller_type = ‘PRIVATE’ AND ams.year >= YEAR(CURRENT_DATE()) – 14 AND ams.inspection_place_latitude BETWEEN 43.68760853 AND 46.38557461 AND ams.inspection_place_longitude BETWEEN 37.16931132 AND 40.98654368 AND ams.km_distance0 < .is_pledged, 0) = 0 AND ams.published = 1)) ORDER BY ams.sale_started_at DESC LIMIT 50 OFFSET 900
COALESCE falls under the index ?
Do I need to run Optimize Table after introducing new indexes? after all, the optimizitor will already walk along well-trodden paths? (or better use FORCE INDEX construct in queries)
And after we deal with the above
How to build indexes on OR ? (multi filtering)
WHERE(
((ams.seller_type = ‘PRIVATE’ AND ams.year >= YEAR(CURRENT_DATE()) – 14 AND ams.inspection_place_latitude BETWEEN 43.68760853 AND 46.38557461 AND ams.inspection_place_longitude BETWEEN 37.16931132 AND 40.98654368 AND ams.km_distance0 < .is_pledged, 0) = 0 AND ams.published = 1))
) OR (
((ams.seller_type = ‘NO PRIVATE’ AND ams.year >= YEAR(CURRENT_DATE()) – 14 AND ams.inspection_place_latitude BETWEEN 43.68760853 AND 46.38557461 AND ams.inspection_place_longitude BETWEEN 37.16931132 AND 40.98654368 AND ams.inspection_place_longitude BETWEEN 37.16931132 AND 40.98654368 AND ams.km0 0 ams.is_pledged, 0) = 0 AND ams.published = 1))
)

Use CONCAT function over name and teachercode

How to get @got_error value in node js mysql query
Can anyone help
Use IP address instead of localhost
IP address in dynamic not static
Okay use percentage in the last digits right

Can any one explain why I can’t enter words in Varchar

Does anyone have this course
Every varchar/text has to be inserted with single quote
Example
Insert into tablename
values
(‘soumith’,’reddy’)
Example
Insert into tablename
values
(‘soumith’,’reddy’)
Thanks for the reply
How can I get the information of a column as a list in Python?



