I used the following script to import a .csv file into MySQL using MySQL WorkBench :
USE test;
LOAD DATA LOCAL INFILE 'exemplo1.csv' INTO TABLE tabela1 fields terminated by ';' lines terminated by '\r';
I've seen a number of o...
Hello! I am extremely new to programming, so I apologize if I can not explain what I am trying to do or if my code is very wrong. I have a recurring task in my job which is to open a list of restaurants in Ifood, collect the prices of each of th...
It is possible to prevent the CSV file from coming with aspas duplas in string fields, I am using the script below, but the nome field is coming between aspas duplas , how can I avoid this?
<?php//export.phpif(is...
Hello. I am creating a people registration page, with each click on the save button, a csv file is generated, which on the next page loading should be used to show the already done entries on the screen, so that the user can know who has already...
I'm having difficulty getting this part done, I've followed all the steps of several sites, I've reached the end and the application reads the file.
Anyone know what might be happening ??
I am using fopen , to export the return of a select, it is exporting correctly, but in certain fields it is appearing "" as I remove "" from export, leaving only ,
Because it is coming out as follows: "rice", "sw...
I created a process that takes content from a certain web page filters what is necessary and generates a file *.csv of this content, you work correctly however the words that have some accentuation ends up giving error in generating time,...
I'm a beginner in Python and I'm having a hard time.
I have a separate CSV database for ";" with 6 columns.
I'd like to count how many records they have, whose sex is "Female."
Can you tell me how to do or where should I start my studies?...
I'm trying to get 3 different values from 3 distinct csv files and multiply them, but it's giving this error. Where did I go wrong? Or what is missing add?!
Error:
Notice: A non-formed numeric value encountered in C: \ xampp \ htdocs...