If i am not wrong, We can load the excel sheet as a database into SQL and work on that with SQL queries right?

|
Var 2022-01-21 18:19:40
Client_id default UUID()
Var 2022-01-21 18:19:57
Var 2022-01-21 18:19:40
Client_id default UUID()

This command is not working in mysql

Var 2022-01-21 18:20:21
Any one send me proper syntax please
Js 1019 2022-01-21 20:07:30
Hey
Can anyone help me on stored procedures, i have some doubt on out parameter….
Priya 2022-01-21 23:48:41
MasterZiv 2022-01-21 16:24:55
EXCEL doesn’t work with SQL.

If I have 100 of records how can I proceed?

MasterZiv 2022-01-22 01:39:57
Priya 2022-01-21 23:48:41
If I have 100 of records how can I proceed?

100 is not a lot.
This is offtopic

SKP 2022-01-22 10:51:01
What are data types in SQL?

data types in sql | sql data types | sql types | mysql #14YouTube
varchar, sql datetime, varchar sql,sql decimal, sql float,sql int,date datatype in , mysql tutorial for beginners, mysql workbench , sql tutorial for beginners

✅ SQL Tutorial for beginners: https://www.youtube.com/watch?v=UxRkd…

✅ Python Tutorial for beginners: https://www.youtube.com/watch?v=9kl7_…

✅ Pandas Tutorial for beginners: https://www.youtube.com/watch?v=kL0C2…

✅ Text Preprocessing in python: https://www.youtube.com/watch?v=xgy7L…

#sql #datatypes #datazug

Priya 2022-01-22 12:14:49
MasterZiv 2022-01-22 01:39:57
100 is not a lot.
This is offtopic

Let me reframe the question again ..Need to calculate the commission created table

Priya 2022-01-22 12:15:02
https://sqlize.online/sql/mysql57/f235c28ba0fee294d9f3b9f3a91f3f16/

*************SQLIZE.online
Priya 2022-01-22 12:15:19
With different comission rates
Khushi Hura 2022-01-22 12:22:38
Use sum()
Khushi Hura 2022-01-22 12:22:54
And distinct
MasterZiv 2022-01-22 12:25:13
Priya 2022-01-22 12:14:49
Let me reframe the question again ..Need to calculate the commission created table

Do you have a formula for it?

Priya 2022-01-22 13:32:57
yes
Priya 2022-01-22 13:33:18
we have multiple formulas
Priya 2022-01-22 13:34:37
different commission rates
A1lone_0 2022-01-22 14:38:46
MasterZiv 2022-01-21 16:24:55
EXCEL doesn’t work with SQL.

If i am not wrong, We can load the excel sheet as a database into SQL and work on that with SQL queries right ?

Khushi Hura 2022-01-22 14:39:24
A1lone_0 2022-01-22 14:38:46
If i am not wrong, We can load the excel sheet as a database into SQL and work on that with SQL queries right ?

How does this work

Khushi Hura 2022-01-22 14:39:29
Can u send an example
MasterZiv 2022-01-22 14:40:04
A1lone_0 2022-01-22 14:38:46
If i am not wrong, We can load the excel sheet as a database into SQL and work on that with SQL queries right ?

Let’s start discussion with this guy when he loads his data into mySQL

A1lone_0 2022-01-22 14:40:52
😅 I am completely new.. i just know basics of MySQL , heard we can create a database like that
MasterZiv 2022-01-22 14:40:56
MasterZiv 2022-01-22 14:40:04
Let’s start discussion with this guy when he loads his data into mySQL

Then it will be on topic in this chat

Khushi Hura 2022-01-22 14:41:08
A1lone_0 2022-01-22 14:40:52
😅 I am completely new.. i just know basics of MySQL , heard we can create a database like that

No we can’t

Khushi Hura 2022-01-22 14:41:20
We can’t work with both excel and sql
Khushi Hura 2022-01-22 14:41:31
I mean they don’t work together
MasterZiv 2022-01-22 14:41:48
A1lone_0 2022-01-22 14:38:46
If i am not wrong, We can load the excel sheet as a database into SQL and work on that with SQL queries right ?

This is correct, it is possible

A1lone_0 2022-01-22 14:42:42
Khushi Hura 2022-01-22 14:41:31
I mean they don’t work together

Yeah .. just it is possible to load the entire excel into our database.. then we can work only on MySQL instead of excel. Is what I heard

A1lone_0 2022-01-22 14:44:04
But we need to create same schema of db before loading excel into it
MasterZiv 2022-01-22 14:45:11
A1lone_0 2022-01-22 14:44:04
But we need to create same schema of db before loading excel into it

Correct

A1lone_0 2022-01-22 14:45:31
https://youtu.be/ftlJoXEBmis

How to IMPORT Excel file (CSV) to MySQL Workbench.YouTube
If you don’t want to create a table in MySQL, you can just use excel file or table from Other source like MS Access as your Table in MySql.

👍 Please Like comment and share to support this channel
https://youtube.com/c/EdcelleJohnGulfan?sub_confirmation=1

RELATED CONTENTS
How to download MySql ODBC Connector?

How to download MySql Workbench?

KEYWORDS:
How to export microsoft access to MySQL WORKBENCH,
How to export excel file to mysql workbench,
how to import excel file to mysql workbench,
How to create table in mysql workbench,
How to create database in mysql workbench,
how to import csv file in mysql server using mysql workbench,
Data Engineering,
Data Science.
ms access vba,
import excel to mysql,
import csv file to mysql,
excel to mysql,
csv to mysql,
mysql,
database,
how to export excel file to mysql database,
how to upload excel file to mysql database,
how to export csv file to mysql database,
benefit for .net and access data.

#exceltutorial
#microsoftaccess
#mysqlworkbench
#mysqlserver

MasterZiv 2022-01-22 14:48:52
A1lone_0 2022-01-22 14:45:31
https://youtu.be/ftlJoXEBmis

The problem is not every excel sheet is a relational table

A1lone_0 2022-01-22 14:49:30
MasterZiv 2022-01-22 14:48:52
The problem is not every excel sheet is a relational table

Ok

MasterZiv 2022-01-22 14:49:32
It can be, but not necessarily
A1lone_0 2022-01-22 14:57:17
Priya 2022-01-21 16:03:55
Can you Please help me with this SQL Query. I have Excel sheet which is having almost 5000 records I need to calculate the monthly commission payouts and gross margins per product based on the provided commission schemes

And for this , groupby product, groupby month and sum of commissions, avg of profits .. will give output ? Does this work ??

SKP 2022-01-22 19:34:16
SQL tutorial for beginners

SQL tutorial for beginners | MySQL Tutorial for beginners – YouTubeYouTube
|