All Questions
7
questions
1
vote
1
answer
473
views
Excel and Google Sheets calculate different .csv column totals to MySQL and LibreOffice
I have a .csv file with 9273 rows.
I have one column of whole numbers and one column of decimal numbers with values like 0.0001752.
I totalled these columns using Excel's sum function and got totals ...
- 21
-1
votes
1
answer
35
views
Place a String separated by commas into the Excel rows
I have a String like this separated by the commas:
id, payment_request_id, user_id, market_id, exchange_id, type_id, nominal, ask_price, original_rate, min_execution, from_date, to_date, state, ...
- 523
1
vote
1
answer
537
views
.csv file from Excel vs .csv file from Libre Office
I created a simple .csv file with Excel which looks like this:
I also created the same .csv file by using Libre Office.
Both .csv files are looking absolutely the same at TextEdit:
id, questions
1,...
- 131
0
votes
0
answers
1k
views
Error when importing .xslx/.csv file to MySQL database
I have a simple .xlsx file which I filled in manually and which looks like this:
When I open this file in TextEdit nothing shows up and (therefore) this file cannot be imported to the MySQLServer at ...
- 131
0
votes
2
answers
6k
views
csv file to phpmyadmin import error
here is the pattern of my csv file
--------------------------------------------------------------
| col1 | col2 | | col4 | |
---------------------------------------...
- 101
1
vote
1
answer
3k
views
Can I output results of a MySQL query to a csv file via Putty?
I've typed the following code to output the csv file , but it shows an error
mysql> SELECT *INFO OUTFILE 'd:/student.csv' FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\...
- 11
1
vote
1
answer
2k
views
Having formatting problems when exporting table from phpMyAdmin
I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format.
...
- 797