OY.workplace to be
the same.
_____
Scott Gerhardt, P.Geo.
Gerhardt Information Technologies
_
-
Before posting, please check:
http://www.mysql.com/manual
My pennies worth:
The manual is excellent, read it! Be patient, it may take you a while to
find exactly what you are looking for. You can always try entering "mysql
your_key_words_here" in the google search http://www.google.com to see what
else pops up.
Actually the MySQL docs search is pretty
I was reading the information on foreign keys in the manual
http://www.mysql.com/doc/e/x/example-Foreign_keys.html
and noticed that there is no mention of locking the tables.
It seems to me that using the example verbatim could lead to loss of
referencial integrity if INSERTS did not occur in seq
So referential integrity is maintained but AUTO_INCREMENT values may not be
chronological?
Connection A's LAST_INSERT_ID() may be 3 at 15:20
AND
Connection B's LAST_INSERT_ID() may be 4 at 15:18
- Scott
> In the last episode (Jan 16), Scott Gerhardt said:
> >
Thanks for your responses Jeremy,
I'm just trying to clarify any misunderstandings I may have.
So, as far as the example goes, the relationships between shirts and people
is maintained by using the LAST_INSERT_ID (in one connection) but
referential integrity is not maintained in terms of foriegn
Thanks for clearing that up Benjamin!
It all makes sense now :-D
- Scott
>
> On Tue, Jan 16, 2001 at 07:22:48PM -0600, [EMAIL PROTECTED] wrote:
> > So referential integrity is maintained but AUTO_INCREMENT
> values may not be
> > chronological?
> >
> > Connection A's LAST_INSERT_ID()
6, 2001 at 07:22:48PM -0600, Scott Gerhardt wrote:
> > So referential integrity is maintained but AUTO_INCREMENT
> values may not be
> > chronological?
> >
> > Connection A's LAST_INSERT_ID() may be 3 at 15:20
> > AND
> > Connection B's LAST_INSERT_I
Hello Cindy,
I posted this in response to another date formatting question, hope it
helps.
The link should be helpful if you haven't found it already.
SELECT fields, DATE_FORMAT(datefield, '%M %d, %Y');
I just looked it up myself...It's all in the manual at:
http://www.mysql.com/doc/D/a/Date_an
BD,
Sorry I can't help you with your corrupted data but here are some related
links for backing up MySQL data the proper way:
There are also some good "canned" shell scripts out there tha do what you
want as well.
It is a good idea to stop the server or lock the tables when copying or
backing up
This is a slightly biased overview of all the negative things about MySQL
vs. Postgress
http://openacs.org/philosophy/why-not-mysql.html
>
>
>
> Does someone want to point out the main differences or send me a link that
> might explain the differences of MySQL and PostGress. I am quite familia
As far as hardware goes, you should be able to increase performance with
more RAM and faster disks such as UW-160 SCSI.
Also, I don't think they make dual processor motherboards for Athalons.
- Scott
> (The total throughput we need is on the order of 100 indexed updates
> per second; currently
You can connect to the DB on Linux using ODBC over any TCP/IP network, and
you don't need to worry about NFS, File sharing, Samba etc.
All you need is MySQL on Linux connected to your network and ODBC will
connect on port 3306 over TCP/IP, that's all you need.
A system built this way can use many
Hello Ann,
The answer to you question depends on how you plan to use the database (i.e.
financial trancactions, serving data on the web etc.) as well as financial
considerations. MySQL is free and Oracle is expensive.
Here are some questions you should answer:
1.) Do you need full Transaction
Dear mail overload,
Here are some things you can do:
1.) Make sure that you set your mail client to delete messages off the
server when deleted.
2.) Download the messages and Delete all the messages you don't want.
3.) Make sure to remove yourself from the list before you go away next time.
4.)
Sir,
What OS are you running?
What version of MySQL are you trying to install?
What RPMs are you trying to install?
- Scott
> -Original Message-
> From: lkeeton [mailto:[EMAIL PROTECTED]]
> Sent: January 25, 2001 10:56 AM
> To: [EMAIL PROTECTED]
> Subject: Uninstalling and Troubleshoo
Does this help?
SELECT
ArgumentCalendar.Docket
, ArgumentCalendar.Date
, DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date
, CaseID.CASEID
, CONCAT(Party1, ' v. ', Party2) AS name
, Blurb
FROM
ArgumentCalendar
, CaseID
, Part
The answer to your question depends upon depends on the nature of the text
information you are going to store:
- The length of text you want to store.
- Database size and fragmentation considerations.
- Uppercase/Lower case significance
- Indexing (prior to 3.23).
> I am trying to determine w
Your Query is making me thirsty ;-)
Unfortunately your tables got garbled so I had to improvise.
Next time don't paste the tables beside each other...
Also, I'm not sure if I understand your problem or what you are trying to
accmplish.
Are you trying to de-normalize your data and display the Be
of data such
> as the hosts name and the events date. What seems to be making it
> difficult is grabbing only the begining and ending points of the crawl.
>
> I appreciate you help.
>
> Richard
>
> Scott Gerhardt wrote:
> >
> > Your Query is making me thirsty
Hello Anna,
According to the MySQL Crash-Me the maximum numbers for 3.23.xx are:
- Columns in table 3398
- max table row length (without blobs) 65534
- table row length with nulls (without blobs) 65502
If you understand the concepts of DB normalization don't bother reading the
following:
300
I was just wondering what the "USAGE" privilege is good for and where it
would be used?
Pauls's book says that USAGE is a special "no privileges" privilege.
___
Scott A. Gerhardt P.Geo.
Gerhardt Information Technologies
[EMAIL PROTECTED]
___
Slight correction, for some reason the query below does NOT work on my
sample DB unless I quote the date values.
This should work now:
SELECT IP, Size, Date FROM your_table
WHERE Date BETWEEN '2001-02-01' AND '2001-05-01';
>
> so and i have Mysql table with
> IP | Size
Have you tried adding an index on id?
> -Original Message-
> From: taree [mailto:taree]On Behalf Of Manuel Capinha
> Sent: January 27, 2001 12:10 PM
> To: [EMAIL PROTECTED]
> Subject: 3 million+ records problems.
>
>
> Hi!
>
> I've got a table with 3 million+ records. This table has o
Adding another 192megs of ram or so would really boost performance.
When I increased the RAM on my PIII 450Mhz from 128 to 256Mb, performance
almost doubled for most queries on a 72k record table.
> > From a mysqldump:
> >
> > #
> > # Table structure for table 'names'
> > #
> > CREATE TABLE n
What sort of hardware are you running?
- Amount of RAM
- CPU speed.
>
> Hi There..
> I'm running mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu
> (i686) on a RedHat 6.1 Os.
> The server is installed and the configuration is almost by default.
> The problem is that most of the time the m
SELECT * FROM item
ORDER BY ID
LIMIT 10
or change to "ORDER BY ID DESC" to get the desired result.
- Scott
> May be it could work
> SELECT * FROM item ORDER BY ID LIMIT count(*)-10,10
> or
> SELECT * FROM SELECT * FROM item ORDER BY ID DESC LIMIT 10 ORDER BY ID
>
>
>
MySQL always updates the first timestamp column on update, regardless.
> -Original Message-
> From: Alex Dusty [mailto:[EMAIL PROTECTED]]
> Sent: February 1, 2001 7:28 PM
> To: [EMAIL PROTECTED]
> Subject: Severe problem in handling timestamp column type
>
>
> >Description:
> There is a
27 matches
Mail list logo
