I have loaded a large *.csv spreadsheet into mysql and one number, the
grand total, changes from 16996941 on the Excel spreadsheet to 8388607 in
the mysql database. The numbers surrounding this number are correct at
all stages. I have reloaded, checked formatting and done various other
th
How do I exclude some rows in a table? I am merging columns from three
tables all of which show all congressional districts in all states. I
want to exclude those congressional districts in TX, PA and ME. My coding
that brings up data for all congressional districts is shown below.
Than
I didn't get a response to the question below, and my alternative solution
produced another error message as follows. Rather than try to establish a
new database, I used the Test database established when I reinstalled
mysql. With a csv file saved under mysql/data/test, I did a load data
I have mysql installed on a pc running Windows 98. I recently had to
reformat a partitioned c drive. My tables were stored in a database
called samp_db. When I give the command "use samp_db" I get Error 1044:
Access denied for user: '@localhost' to database 'samp_db' When I give
the co
Thanks to everyone for responses, but the conclusion I'm reaching is that
there is no simple command to stop scrolling of the table list in dos. As
Hassan Schroder said, "pager doesn't work in Windows, anyway." I did try
mysql>SHOW TABLES \P less;
and got an error message. I just don't unders
When I do
mysql>SHOW TABLES \p less;
I get the error message "You have an error in your SQL syntax near 'less'
in line 1" I am using dos, not unix.
Ken
**
On Mon, 31 May 2004 21:19:28 -0700, Robert J Taylor
<[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
Ultimately simple, but I don't
Ultimately simple, but I don't find the answer: how to stop a list from
scrolling to the bottom when the command SHOW TABLES is entered.
Ken
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've just tried the three column solution (designating each column as
null), but the empty cells produce a "0" just as the two cells with an
actual "0." How do I avoid that, preferably with a blank in that place?
*
On Thu, 13 May 2004 13:53:37 -0400, Bill Easton <[EMAIL PROTECTED]>
wrote:
That didn't do it. I got 0,0,1050,1168,1195, 1975, 150,155,16500,170,178.
. . The non-numerics came out last (which I want). There are two zeros
but no negative numbers. Any alternatives?
Ken
**
On Wed, 12 May 2004 07:47:11 -0400, Bill Easton <[EMAIL PROTECTED]>
wrote:
You could also
How do I set up a column (cost) that contains numbers and text so that the
numbers will sort the numbers accurately? Using varchar results in a sort
based on the first digit, so that I get e.g. 1, 10, 100, 3. . . when the
command is "order by cost." Almost all of the text is "By County."
Ken
There was some discussion in December of converting MS Access databases to
Mysql and the DBManager program was recommended. I have DBManager running
and select "Tools=>Data Management=>Import/Export Wizards," but the
command is greyed out and won't activate. I am using Office 2000 and I
have m
11 matches
Mail list logo
