How can we upload 40000 lines of excel data at a time in sql database?

|
Young_Kenan 2022-09-28 07:48:08
It didn’t work guys🙁
developerjay 2022-09-28 07:51:29
Young_Kenan 2022-09-28 07:48:08
It didn’t work guys🙁

Hide the password and username and send your code

Young_Kenan 2022-09-28 07:52:43
codeslide-100889.jpg
How?
kshamamishra 2022-09-28 07:53:02
pass one parameter
kshamamishra 2022-09-28 07:53:13
password also
kshamamishra 2022-09-28 07:53:24
pass should be blank
kshamamishra 2022-09-28 07:53:34
declare
kshamamishra 2022-09-28 07:53:45
$password = ‘ ‘;
kshamamishra 2022-09-28 07:53:56
like this and try
kshamamishra 2022-09-28 07:56:29
mysqli_connect ( “host”, “username”, “password”, “database_name” )
kshamamishra 2022-09-28 07:56:55
at the end pass database name also
developerjay 2022-09-28 07:57:23
Young_Kenan 2022-09-28 07:52:43
codeslide-100889.jpg
How?

Yes database name is missing

developerjay 2022-09-28 07:57:48
Msqli_connect requires 4 parameters
rahul8180 2022-09-28 07:58:53
Young_Kenan 2022-09-28 07:52:43
codeslide-100889.jpg
How?

Database name is missing

kshamamishra 2022-09-28 07:59:27
yup
Young_Kenan 2022-09-28 08:06:56
It’s a xampp server and my file are in it’s root directory already
RUPEEECOIN_AGENT 2022-09-28 09:00:07
Young_Kenan 2022-09-28 07:52:43
codeslide-100889.jpg
How?

$passowrd = “”;

Change your data to my given data

siddu1rc 2022-09-28 09:04:07
codeslide-100906.jpg

siddu1rc 2022-09-28 09:04:27
How to write code
siddu1rc 2022-09-28 09:04:42
This Question
siddu1rc 2022-09-28 09:05:33
codeslide-100910.jpg

Pmp 2022-09-28 13:59:53
How can we upload 40000 lines of excel data at a time in sql database?
Pmp 2022-09-28 14:00:06
Is it possible?
Qualitycourse1 2022-09-28 14:12:02
Angular course
Qualitycourse1 2022-09-28 14:12:28
Piiing me
RichardMuvirimi 2022-09-28 14:28:19
Pmp 2022-09-28 13:59:53
codeslide-100889.jpg
How can we upload 40000 lines of excel data at a time in sql database?

Mysql (i presume) can import from other sources besides sql

RichardMuvirimi 2022-09-28 14:29:31
Csv being one of them
RichardMuvirimi 2022-09-28 14:31:42
If it’s a one time thing, you can use terminal, if not you provide it with the path to the csv file (convert with phpexcel) and have it handle the importation
Gaurav Agrawal 2022-09-28 15:59:05
I am importing mysql database inside docker container but facing the below issue

Bash: mysql command not found

RichardMuvirimi 2022-09-28 17:34:47
Gaurav Agrawal 2022-09-28 15:59:05
codeslide-100889.jpg
I am importing mysql database inside docker container but facing the below issue

Bash: mysql command not found

Is it installed?

Gaurav Agrawal 2022-09-28 17:36:51
RichardMuvirimi 2022-09-28 17:34:47
codeslide-100889.jpg
Is it installed?

I am not sure but all my containers are there and running

RichardMuvirimi 2022-09-28 17:44:56
Gaurav Agrawal 2022-09-28 17:36:51
codeslide-100889.jpg
I am not sure but all my containers are there and running

I am sure there is a way to enter a container’s terminal and check

RichardMuvirimi 2022-09-28 17:45:41
Sending link pm
Mohammad Arshid 2022-09-28 19:50:47
Hlo
Mohammad Arshid 2022-09-28 19:51:15
codeslide-100984.jpg

|