John Mistler wrote:
I have two tables 'table1', 'table2' with a matching column 'column1'.
How can I return all rows from table2 where the entry for table2.column1
does not match any entries in table1.column1?
SELECT * FROM table2 WHERE table2.column1 <> table1.column1
returns all the rows,
Hi,
Iam running a mysql server version 5.0.15. My mysql query log is
occupying nearly 21 GB of disk space. how do i truncate the same ?
Thanks in advance,
Abdul.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
Sorry... I thought I had posted the issues, that must have been a support
ticket somewhere instead. heh
I have a main customer table with a handful of other tables that I join with it
via PHP pages. I've written a phone order system that works fine 98% of the
time. Every once in a while, the
I have two tables 'table1', 'table2' with a matching column 'column1'.
How can I return all rows from table2 where the entry for
table2.column1 does not match any entries in table1.column1?
SELECT * FROM table2 WHERE table2.column1 <> table1.column1
returns all the rows, rather than the uniqu
"Subscriptions" <[EMAIL PROTECTED]> wrote on 12/11/2005
10:46:08 PM:
> Okay, so I haven't been able to find any corrupted tables. Has
> anyone ever run into problems with joins between tables that contain
> funky data? I have a table that contains encrypted info and some of
> the characters be
Okay, so I haven't been able to find any corrupted tables. Has anyone ever run
into problems with joins between tables that contain funky data? I have a
table that contains encrypted info and some of the characters being used/stored
are definitely odd.
I'm still trying to find the answer to o
I forgot to copy the list as well
Mark
-- Forwarded Message --
Subject: Re: Need Help with a query
Date: Sunday 11 December 2005 06:47 pm
From: Mark Phillips <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Rhino,
My apologies for leaving out the version of mysql. I ag
Hi John,
Personally, I'd just do a cut and paste job on the .sql file unless it
is too unmanageable. Not knowing your platform, and being a unixy type
person, I would use sed or grep to strip out the lines that I need and
then plonk them straight into another file. I don't know how you could
acco
Thanks for the response, David. How about if I want to import all the
entries from one specific TABLE within that sql file into a table with
identical columns on my MySQL server? Is there a way?
Thanks,
John
On Dec 11, 2005, at 5:29 PM, Logan, David (SST - Adelaide) wrote:
Hi John,
If it
Hi John,
If it is a ".sql" file, with all appropriate SQL statements already in
place then you only have to do the following
$ mysql -u -p databasename <.sql file
This will process all appropriate statements in the file.
Regards
David Logan
Database Administrator
HP Managed Services
148 F
Is there a command that will load in all of the data from a table
within a database ".sql" file on disk? The only import option I am
seeing is "LOAD DATA INFILE" which requires a text file already
exported to disk. How about a way to load in the table data directly
from the database file?
T
Hi Jenifer,
You can use mysqlcheck to confirm any corruption and also to fix it. See
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
or you can also run statements from the mysql client such as CHECK
TABLE, REPAIR and ANALYZE etc.
References to this can be found at
http://dev.mysql.com
Oops, I meant to copy the list on this reply so that others could
benefit
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Mark Phillips" <[EMAIL PROTECTED]>
Sent: Sunday, December 11, 2005 6:19 PM
Subject: Re: Need Help with a query
- Original Message ---
Hi Peter,
40 tables seems to be relatively small, I have several databases that I
manage that have tables that number in the hundreds. In other databases,
I have one site that has 7,500 tables. Have a look at some of the open
source ERP systems around eg. Nola or similar, their tables number in
th
On Sunday 11 December 2005 23:51, Charles Walmsley wrote:
> Dear All,
>
>
>
> I do not have much experience with PHP or MySql although I have used SQL
> quite a lot. I am going to set up a relatively small MySQL database (circa
> 40 tables) and we are expecting a hit rate of about 40,000 visitors
Nathan Whitington wrote:
Hello there,
I've searched long and hard, and pestered many people for a solution
and for help however I can not get around this problem.
I have installed MySQL on my computer which is an Apple iBook G4 which
is running Mac OS X 10.4.2 and I wish to use MySQL so th
Dear All,
I do not have much experience with PHP or MySql although I have used SQL
quite a lot. I am going to set up a relatively small MySQL database (circa
40 tables) and we are expecting a hit rate of about 40,000 visitors per
annum mostly browsing a relatively low number of pages each. We
Hi.
Use the --insert-ignore option of mysqldump.
You can type 'mysqldump --help' on command line to see all options available.
Richard AB.
- Original Message -
From: "Michael Williams" <[EMAIL PROTECTED]>
To:
Sent: Sunday, December 11, 2005 6:19 PM
Subject: mysqldump: getti
Hi All,
I have read thehttp://dev.mysql.com/doc/refman/5.0/en/
mysqldump.html and can find nothing regarding getting dump to
INSERT IGNORE instead of simply INSERT INTO. Is there any way to get
INSERT IGNORE to be dumped? Otherwise, I fear I may be forced to
parse the dump file a
If mysql detects corruption it will stop further access to the table
until you repair it. It is possible for corruption to happen where
mysql can't detect it. If you suspect corruption run a repair on the
table.
On 12/11/05, Subscriptions <[EMAIL PROTECTED]> wrote:
> Hi all,
> Say, is there a way
Hello there,
I've searched long and hard, and pestered many people for a solution
and for help however I can not get around this problem.
I have installed MySQL on my computer which is an Apple iBook G4
which is running Mac OS X 10.4.2 and I wish to use MySQL so that I
can learn something
I have a table with several columns. The ones of interest are flight_id,
angle, and baseline. I want to find the flight_ids for the flights with the
maximum and minimum altitudes, where altitude=baseline*tan(radians(angle)).
For example,
Flights
+++---+
|
No, thanks! It's, in fact, more than enough!
On 12/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> As I read the docs, yes! Is that going to be a limitation for you?
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> sunaram patir <[EMAIL PROTECTED]> wrote on
As I read the docs, yes! Is that going to be a limitation for you?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
sunaram patir <[EMAIL PROTECTED]> wrote on 12/11/2005 05:50:58 AM:
> So you want to mean that i can create (4TB/average_table_size) number
> of tables in a linu
C.R.Vegelin wrote:
Thanks JR, Shawn, Scott, ... for your replies.
I choose to make use of the SELECT ... INTO OUTFILE.
This works fine, but I also want a header-line in the CSV file.
So I made the following statement:
SELECT `ID`, `Code`, `Name`
UNION
SELECT `ID`, `Code`, `Name` INTO OUTFILE 'D:
Hi all,
Say, is there a way to tell if a table has been corrupted? We're having some
weird things happening and the only thing I can think of is possible corruption
of a table, but is there anything you can do to find out?
Jenifer
Thanks JR, Shawn, Scott, ... for your replies.
I choose to make use of the SELECT ... INTO OUTFILE.
This works fine, but I also want a header-line in the CSV file.
So I made the following statement:
SELECT `ID`, `Code`, `Name`
UNION
SELECT `ID`, `Code`, `Name` INTO OUTFILE 'D:/MySQL Datafiles/Uni
So you want to mean that i can create (4TB/average_table_size) number
of tables in a linux(2.6 kernel) operating system assuming i have
that much hard disk space?
On 12/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> sunaram patir <[EMAIL PROTECTED]> wrote on 12/11/2005 12:10:52 AM:
>
>
28 matches
Mail list logo
