Yeah, but when we talk about CHAR and VARCHAR in MySQL then CHAR is a fixed length data Type and VARCHAR is a Variable Length Data Type so what is the meaning of Variable Length Data Type here?
select a.name_prov as prov,city,a.cases
from
(select c.name_prov,b.city,a.cases,
row_number () over (partition by c.name_prov order by cast(a.cases as int) desc) as rn
from tb_cases a
join tb_city b on a.id_city = b.id_city
join tb_prov c on a.id_prov = c.id_prov
order by c.name_prov
) a
where rn in (1,2,3)
order by a.name_prov,rn
thank you Swapnil , can code like this also be implemented in CI
Swapnil2022-06-03 16:03:34
CI ?
mkval32022-06-03 16:03:53
code igniter
Swapnil2022-06-03 16:04:31
Not Sure
Andres Pereira2022-06-03 20:02:39
Do U have some manual to learn?
Andres Pereira2022-06-03 20:02:54
or any recommended traiinings
DG_Fook2022-06-04 07:25:32
I just started Learning MySql. I am stucked in starting.
Can anyone explain what is Variable – Length Data Type in simple words?
Swapnil2022-06-04 08:48:21
DG_Fook2022-06-04 07:25:32
I just started Learning MySql. I am stucked in starting.
Can anyone explain what is Variable – Length Data Type in simple words?
Variable in simpler words is kind of placeholder for some values that can be used once or resuse throught the procedure/function
DG_Fook2022-06-04 09:49:39
Swapnil2022-06-04 08:48:21
Variable in simpler words is kind of placeholder for some values that can be used once or resuse throught the procedure/function
Yeah, but when we talk about CHAR and VARCHAR in MySQL then CHAR is a fixed length data Type and VARCHAR is a Variable Length Data Type so what is the meaning of Variable Length Data Type here?
Swapnil2022-06-04 09:54:07
DG_Fook2022-06-04 09:49:39
Yeah, but when we talk about CHAR and VARCHAR in MySQL then CHAR is a fixed length data Type and VARCHAR is a Variable Length Data Type so what is the meaning of Variable Length Data Type here?
When you exactly dont know the expected value to be stored in variable
DG_Fook2022-06-04 09:59:33
Thanks, let’s take a example.
If I declare a Column with VARCHAR (60) and declare another Column with CHAR(not fixed size) .
So in that case, VARCHAR would not be a Variable Length Data Type..(just as a example)
Mahesh2022-06-04 12:27:40
MySQL Tutorial for Beginners FULL COURSE – Part 5
MySQL Tutorial For Beginners Part 5: Integrity Constraints | Primary Key | Foreign Key | Views | TCL – YouTube This video explains about the topics mentioned below:
1) NOT NULL
2) UNIQUE KEY
3) PRIMARY KEY
4) FOREIGN KEY
5) CHECK
6) DEFAULT
7) AUTO_INCREMENT
8) LIMIT
9) Views
10) Index
11) TCL (Commit & Rollback) commands
Checkout the Playlists:
👉 Java Tutorial For Beginners:
👉 Design Patterns in Java
👉 Tricky Java Interview Questions
👉 Important Java Programs for Interview:
https://www.youtube.com/watch?v=Dhcy6mcNbx8&list=PLzte2IQYFUVG0Q3rEFQzGa_eFKIUGwZIZ
👉 How to Avoid Common Mistakes as a Java Beginner
👉 Interview Coding Challenges
👉 MySQL Tutorial For Beginners:
👉 What is Agile | Understanding Agile Software Development Process:
👉 Selenium with Java Tutorial For Beginners:
https://www.youtube.com/watch?v=FtbszUgPxUY&list=PLzte2IQYFUVEvMsjxPSSTQ5CcLMcQhw9M
LIKE | SHARE | SUBSCRIBE 😊
👇👇👇
Follow me on
LinkedIn: https://www.linkedin.com/in/mahesh-babu-mande-65920724/
Telegram: https://t.me/techstack9
Twitter: https://twitter.com/mahesh1049
gagahappy2022-06-04 16:57:08
how disable auto configure/build mysql-source when I run vscode
Manoj K2022-06-04 18:12:36
Can we use “WHERE” & “HAVING” clause alternatively?
ColonelMustang2022-06-04 18:15:22
Manoj K2022-06-04 18:12:36
Can we use “WHERE” & “HAVING” clause alternatively?
no
RJ2022-06-05 04:52:52
Hi guys, please help me with this…i need this output
YALLAPU SATHISH KUMAR2022-06-05 05:50:52
RJ2022-06-05 04:52:52
Hi guys, please help me with this…i need this output
Call me , I will explain
YALLAPU SATHISH KUMAR2022-06-05 06:45:22
YALLAPU SATHISH KUMAR2022-06-05 06:45:29
RJ2022-06-05 04:52:52
Hi guys, please help me with this…i need this output
Swapnil2022-06-05 10:53:32
YALLAPU SATHISH KUMAR2022-06-05 06:45:29
will this not give output as Naveen_1 aswell ?
ruydar2022-06-05 11:39:27
hello, i have select id,name from tbl where id = 1 i need get filed name in return ti sub query for examle select id,name,(select count name = name from tbl) from tbl reg
ruydar2022-06-05 11:41:35
select id,name from tbl where id = 1
ruydar2022-06-05 11:41:43
select id,name,(select count name = name from tbl) from tbl reg
ruydar2022-06-05 11:48:03
Fransitpro2022-06-06 01:27:11
Frans Renzo De La Cruz Jo:
Buenas tardes grupo
Una consulta se puede tener conectores en Windows 11
Mysql y excel
smlkw2022-06-06 01:28:50
Fransitpro2022-06-06 01:27:11
Frans Renzo De La Cruz Jo:
Buenas tardes grupo
Una consulta se puede tener conectores en Windows 11
Mysql y excel
Please, use English here
Fransitpro2022-06-06 01:30:32
good afternoon group A query can have connectors in Windows 11 mysql and excel
smlkw2022-06-06 01:57:10
Fransitpro2022-06-06 01:30:32
good afternoon group A query can have connectors in Windows 11 mysql and excel
I have not seen something like this
Liran2022-06-06 11:58:30
how can i dump database with his data without locking tables?
Dude2022-06-06 12:10:31
–single-transaction-only
svart2022-06-06 12:29:53
Fransitpro2022-06-06 01:30:32
good afternoon group A query can have connectors in Windows 11 mysql and excel
you can’t query xls files but you try to use CSV storage engine to query csv files.
