There are 100 records in a table, I want to read from 10th record to 20th record how would I achieve this task, could anyone answer please?

|
2022-02-07 14:52:01
How to start study ?
mkingofeveryone 2022-02-07 14:57:07
2022-02-07 14:51:10
Hello ,
Is that anyone completed mysql certification ? Please help me on this how to provided…

Ha?

2022-02-07 15:11:07
Any course or certification to complete online for MySQL?
Seventh_hokage007 2022-02-07 15:11:27
Hey can anybody help me with this problem
Seventh_hokage007 2022-02-07 15:11:40
mysql_en-17184.jpg

mkingofeveryone 2022-02-07 15:52:10
Seventh_hokage007 2022-02-07 15:11:40

Retry

Seventh_hokage007 2022-02-07 17:40:40
Same
amuelle1 2022-02-07 17:59:07
seems that root without password is not allowed to access, provide passwort or give root without pwasword the right to access from this location
SKP 2022-02-07 19:08:55
SQL tutorial for beginners

SQL tutorial for beginners | MySQL Tutorial for beginners – YouTubeYouTube
Khushi Hura 2022-02-07 22:03:09
Does anyone know how to export mysql database in pendrive?
Khushi Hura 2022-02-07 22:03:23
And it must work in other system as well
MasterZiv 2022-02-08 07:02:05
Khushi Hura 2022-02-07 22:03:09
Does anyone know how to export mysql database in pendrive?

Use mysqldump utility

hrishihargude 2022-02-08 11:13:28
Help me guys
Tony 2022-02-08 11:20:58
MasterZiv 2022-02-08 07:02:05
Use mysqldump utility

Can this be used in MySQL? Do you mind giving one example?

MasterZiv 2022-02-08 11:44:12
Tony 2022-02-08 11:20:58
Can this be used in MySQL? Do you mind giving one example?

There are many examples of using mysqldump in MySQL documentation.

Mr R 2022-02-08 15:00:29
There are 100 records in a table, I want to read from 10th record to 20th record how would I achieve this task, could anyone answer please?
My approach is
select empname from emp order by emp name offset 10 rows limit 10;
Will this work?
MasterZiv 2022-02-08 15:03:49
Mr R 2022-02-08 15:00:29
There are 100 records in a table, I want to read from 10th record to 20th record how would I achieve this task, could anyone answer please?
My approach is
select empname from emp order by emp name offset 10 rows limit 10;
Will this work?

No

MasterZiv 2022-02-08 15:04:27
Mr R 2022-02-08 15:00:29
There are 100 records in a table, I want to read from 10th record to 20th record how would I achieve this task, could anyone answer please?
My approach is
select empname from emp order by emp name offset 10 rows limit 10;
Will this work?

there is no notion of any order on a relational table.

amuelle1 2022-02-08 15:05:54
[LIMIT {[offset,] row_count | row_count OFFSET offset}] will help
amuelle1 2022-02-08 15:06:19
MasterZiv 2022-02-08 15:04:27
there is no notion of any order on a relational table.

sorry this is not true, he has an order in the query

MasterZiv 2022-02-08 15:09:08
amuelle1 2022-02-08 15:06:19
sorry this is not true, he has an order in the query

There are 100 records in a table, I want to read from 10th record to 20th record how would I achieve this task,

this task is nonsense. that’s what I’m saying

amuelle1 2022-02-08 15:10:11
MasterZiv 2022-02-08 15:09:08
There are 100 records in a table, I want to read from 10th record to 20th record how would I achieve this task,

this task is nonsense. that’s what I’m saying

abolsutly not nonsence, think about paging

MasterZiv 2022-02-08 15:13:37
amuelle1 2022-02-08 15:10:11
abolsutly not nonsence, think about paging

Paging is nonsense, too

amuelle1 2022-02-08 15:14:50
MasterZiv 2022-02-08 15:13:37
Paging is nonsense, too

paging is nonsense, so whats you solution to brows through a large nummer of data e.g. in a web app?

MasterZiv 2022-02-08 15:16:49
amuelle1 2022-02-08 15:14:50
paging is nonsense, so whats you solution to brows through a large nummer of data e.g. in a web app?

My solution is not to browse through large number of data.

amuelle1 2022-02-08 15:17:08
MasterZiv 2022-02-08 15:16:49
My solution is not to browse through large number of data.

like a hero 😅

MasterZiv 2022-02-08 15:17:23
amuelle1 2022-02-08 15:14:50
paging is nonsense, so whats you solution to brows through a large nummer of data e.g. in a web app?

Because what you describe is also nonsense

amuelle1 2022-02-08 15:19:29
MasterZiv 2022-02-08 15:17:23
Because what you describe is also nonsense

I recommend that you apply to Google, this will give the search engine a completely new impetus.

MasterZiv 2022-02-08 15:22:47
amuelle1 2022-02-08 15:19:29
I recommend that you apply to Google, this will give the search engine a completely new impetus.

Good idea!

Khushi Hura 2022-02-08 15:23:52
How to do this
Can u plz elaborate
Khushi Hura 2022-02-08 15:24:19
Actually I want to open the same db in other system with mysql server version 6.0
Khushi Hura 2022-02-08 15:24:31
But my system has mysql server 8.0
Khushi Hura 2022-02-08 15:24:40
So anyone has solution to this?
Khushi Hura 2022-02-08 15:24:59
Because mysql 6.0 doesn’t makes its bin folder
amuelle1 2022-02-08 15:36:49
Khushi Hura 2022-02-08 15:24:19
Actually I want to open the same db in other system with mysql server version 6.0

dump the database with mysqldump (—compatible herhaps don’t know), transfer dump to target server and load it with source in a mysql shell

|