Hi all--
I googled around a bunch but couldn't find a good answer to this question.
How do I open the ERD diagram I made in MySQL WorkBench 5.2CE, which is a
.mwb file-- on another computer that does not have MySQL on it? I want to
be able to print out the file and so I need to be able to open i
the table, I use a temp table to import to
> as varchar, convert the column, the just select from temp table into prod
> table.
>
>
>
> -Original Message-
> From: Stillman, Benjamin [mailto:bstill...@limitedbrands.com]
> Sent: Monday, August 06, 2012 2:05 PM
> To:
wrong
way to solve the problem.
On Sun, Aug 5, 2012 at 9:53 AM, Hassan Schroeder wrote:
> On Sat, Aug 4, 2012 at 8:14 PM, Fred G wrote:
>
> > But I'm sure that I must be missing something here. Is there a way to
> use a
> > DECIMAL-like operator that treats blanks as bl
Hi--
I'm using MySQL 5.2 Workbench, and when I import a csv into MySQL, blank
values become 0 when I define the datatype to be a DECIMAL (in our case
(DECIMAL(12,2)). Since there is the potential for values to be 0, this
poses a problem for us. I initially wanted to make all the DECIMAL values
bec
What are the best ways to conduct financial data mining in MySQL? From
browsing the World Wide Web, it looks like using R to access MySQL and
using some pre-built R financial data analysis packages is the way to go.
Is there anything built-in to MySQL 5.2 Workbench, or, any other
possibilities tha
t
work.
Thanks again
On Tue, Jul 31, 2012 at 5:36 AM, Michael Widenius wrote:
>
> Hi!
>
> >>>>> "Fred" == Fred G writes:
>
> Fred> Thanks Dhaval. Putting the join condition before INTO outfile
> doesn't seem
> Fred> to work, either.
>
Thanks!
On Thu, Jul 26, 2012 at 12:05 AM, wrote:
> 2012/07/26 06:52 +0530, Dhaval Jaiswal
> SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
> ENCLOSED BY '"' LINES TERMINATED BY '\n'
>
> as above give your join condition before INTO OUTFILE.
>
> Right
QL connection was lost.
Does anyone have an idea of what is going on?
On Wed, Jul 25, 2012 at 9:22 PM, Dhaval Jaiswal wrote:
> SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
> ENCLOSED BY '"' LINES TERMINATED BY '\n'
&g
Hi--
I'm trying to do the following:
SELECT db.emp.emp_fname, db.emp.emp_fname, db.sale.sale_date,
db.sale.sale_no, db.sale.sale_total_amt
into outfile 'test123.csv'
FIELDS terminated by ','
FROM db.emp
LEFT OUTER JOIN db.sale
ON db.sale.emp_id = db.emp.emp_id;
The query without exporting the fil
Hi guys--
I am having some trouble importing a csv file correctly as a table in my
new database. In particular, there are 4 NA's in a column with 10,000+
other rows that have decimal values for that column.
How can I get MySQL to read in these "NA's" as some sort of null that is
accepted by the
10 matches
Mail list logo
