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?

|
Swapnil 2022-06-03 15:52:46
Cast should work fine now in mySQL
mkval3 2022-06-03 16:02:52
Swapnil 2022-06-03 15:52:35
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

Swapnil 2022-06-03 16:03:34
CI ?
mkval3 2022-06-03 16:03:53
code igniter
Swapnil 2022-06-03 16:04:31
Not Sure
Andres Pereira 2022-06-03 20:02:39
Do U have some manual to learn?
Andres Pereira 2022-06-03 20:02:54
or any recommended traiinings
DG_Fook 2022-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?
Swapnil 2022-06-04 08:48:21
DG_Fook 2022-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_Fook 2022-06-04 09:49:39
Swapnil 2022-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?

Swapnil 2022-06-04 09:54:07
DG_Fook 2022-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_Fook 2022-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)
Mahesh 2022-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 | TCLYouTube
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

gagahappy 2022-06-04 16:57:08
how disable auto configure/build mysql-source when I run vscode
Manoj K 2022-06-04 18:12:36
Can we use “WHERE” & “HAVING” clause alternatively?
ColonelMustang 2022-06-04 18:15:22
Manoj K 2022-06-04 18:12:36
Can we use “WHERE” & “HAVING” clause alternatively?

no

RJ 2022-06-05 04:52:52
mysql_en-21327.jpg
Hi guys, please help me with this…i need this output
YALLAPU SATHISH KUMAR 2022-06-05 05:50:52
RJ 2022-06-05 04:52:52
Hi guys, please help me with this…i need this output

Call me , I will explain

YALLAPU SATHISH KUMAR 2022-06-05 06:45:22
mysql_en-21330.jpg

YALLAPU SATHISH KUMAR 2022-06-05 06:45:29
RJ 2022-06-05 04:52:52
Hi guys, please help me with this…i need this output

mysql_en-21331.jpg

Swapnil 2022-06-05 10:53:32
YALLAPU SATHISH KUMAR 2022-06-05 06:45:29

will this not give output as Naveen_1 aswell ?

ruydar 2022-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
ruydar 2022-06-05 11:41:35
select id,name from tbl where id = 1
ruydar 2022-06-05 11:41:43
select id,name,(select count name = name from tbl) from tbl reg
ruydar 2022-06-05 11:48:03
mysql_en-21336.jpg

Fransitpro 2022-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

smlkw 2022-06-06 01:28:50
Fransitpro 2022-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

Fransitpro 2022-06-06 01:30:32
good afternoon group A query can have connectors in Windows 11 mysql and excel
smlkw 2022-06-06 01:57:10
Fransitpro 2022-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

Liran 2022-06-06 11:58:30
how can i dump database with his data without locking tables?
Dude 2022-06-06 12:10:31
–single-transaction-only
svart 2022-06-06 12:29:53
Fransitpro 2022-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.

sajed sajed 2022-06-06 16:20:25
Please i need source for microaoft sql for mac
trilokinathvishnu 2022-06-06 18:00:11
svart 2022-05-30 16:15:44
yes. use rsync

Using rsync will not assure live copying

Correct me if I am wrong

DBA 2022-06-06 19:24:52
mysql_en-21366.jpg
Can I use this to get table size
|