SQL/MySQL/ORACLE DBA Learning — messages on 2 January 2024

2 January 2024

Sachin Singh

MySQL

03:41

How to start preparation

03:42

Shaik Irfan

I need to import Excel file in MySQL,is it possible

13:15

As I know only CSV file

13:15

Automation Life

Shaik IrfanI need to import Excel file in MySQL,is it possible

It’s very much easier.. just to some research on YouTube

13:16

Shaik Irfan

I tried on YouTube didn't found

13:16

Nikil (🇮🇳)

Shaik IrfanI tried on YouTube didn't found

Search for converting your excel to cvc file.. and then you will have option to upload in any client

13:17

Nikil (🇮🇳)Search for converting your excel to cvc file.. and then you will have option to upload in any client

Or use MySQL LOAD DATA INFILE

13:18

Shaik Irfan

As I know converting Excel into CSV,but my business recruitment is in Excel files in folder which will be daily updated and need to import in mysql

13:19

Automation Life

Shaik IrfanAs I know converting Excel into CSV,but my business recruitment is in Excel files in folder which will be daily updated and need to import in mysql

Then go with complete automation from stage one to stage final.. Forget on updating manually into DB everytime

Shaik IrfanAs I know converting Excel into CSV,but my business recruitment is in Excel files in folder which will be daily updated and need to import in mysql

Which client u use ?

MySQL workbench 8.0

Shaik IrfanMySQL workbench 8.0

Okay.. manually you can do it on that.. If you want to make it automation on daily basis.. I can do it for you..

13:22

Nikil (🇮🇳)

Shaik IrfanMySQL workbench 8.0

You mean both client and DB are in the same system ? Or your DB is on some cloud ?

13:23

Shaik Irfan

Both in different servers

13:25

Excel file in 153 server and MySQL is in my system

13:25

A snapshot of an open public feed from the search index ChatCrawler — “Google for public Telegram”; refreshed as the venue is crawled. Times are UTC.