)
and client ( ie machine you'll be running the Perl scripts from ) and it
*somehow* works.
Sorry I'm a bit lean on the details. I've seen it working. Google for it.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922
I used to program for a medical tester.
I used method 2:
2 - a table with 60 rows for one assessment :
results(#assessment_nr, labtest_nr, p, d) where p and d are my two
results.
The BIG advantage was changes to the tests, adding new ones, or deleting
fields. Made it much more flexible.
I think when adding the $ the number gets convert to a string. And then
the query orders it by alpha numberic.
I'm having trouble with this query:
SELECT
CONCAT('$',ROUND(($varA*(establishments^2)+$varB*(establishments)+$varC),2))
as price FROM table ORDER BY price
A note first. The column
I must have done a poor job at explaining this. I already have all
those primary keys, etc. If you are required to do a full table scan on
the table, as I am in my example, please explain to me how an index even
matters in that case. There is _no_ where clause in the query so how
will an
http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
Do not use DELAYED with INSERT ... SELECT.
With respect to the table structure...can you explain how when you have
to read every single row regardless how the structure (assuming you are
going down the path of idexes) affects the query?
--Bruce
There are many different options. php-general list
might have something in the archives.
Usually my preferred method is storing application
wide settings and commonly used functions in a file
that is included on each page.
?php include 'common.inc.php'; ?
You might also take
Think you want:
Select max(job_id)
from job_log_2004
I'm trying to select the last record (row) in a db. I'm trying with a
select:
Select * from job_log_2004 where job_log_2004.JobID = (select
max(job_log_2004.JobID) from job_log_2004) and it fails. The part about
select max works and
Guess you could use the rand() function and look for a matching row id!?!
Is it possible to randomly select from all entries in a table, but have it
be 2 different ones each time? If so, what documentation should I be
looking
at?
I am using PHP and MySQL together, if this helps.
Thanks,
for a MySQL server.
--
sig
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives
Sounds to me like it doesn't the the alias name T2 but might need the full
table name.
Hi,
Can anyone give me a hint to what this error message is trying to say.
Thanks,
Justin Palmer
-Original Message-
From: Justin Palmer [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15,
,
MUCH more stable and we can provide remote access to the DB. But it
certainly is more work to get it running and to make changes.
I've seen code floating around for uploading images to a MySQL DB via a
PHP-driven web site.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific
currently using:
replace(replace(NoteText, '', '#060'), '', '#062') as NoteText
to replace the offending characters with HTML escape codes. Is there a
cleaner way of doing this?
Thanks!
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia
Mark Susol | Ultimate Creative Media wrote:
On 4/15/04 11:49 PM, Daniel Kasak [EMAIL PROTECTED] wrote:
I'm currently using:
replace(replace(NoteText, '', '#060'), '', '#062') as NoteText
to replace the offending characters with HTML escape codes. Is there a
cleaner way of doing
Just thought I'd share my experience with MySQL under Panther. I think
the critical thing that got me going was that the /usr/local/mysql/data
directory was owned by root instead of mysql. I changed that (chown
mysql /usr/local/mysql/data) and everything seems to be a) Hunky b)
Dory, thanks
Which distribution should I install on Mac OS X Panther? Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I find doing this helps to reinitialize the indexes
ALTER TABLE shotlist TYPE=MyISAM;
REPAIR TABLE shotlist QUICK;
I am trying to add a second fulltext index to an already existing table
(named articles).
The first index is for field(column name) text of type longtext
I want to add a
,
Andy
Check the INSTALL-SOURCE file in your source distribution.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL
found somewhere else on the net?
You haven't actually told us what processor ( 'pentium' is a marketing
term, not a processor type ... there are many different types of
pentiums ) you have, but you should be able to use -march=pentium4 or
whatever matches your processor.
--
Daniel Kasak
I have been trying for months to set up mysql on my Mac (Panther) with
no success. I can't run mysqladmin as root. I get an access denied
error message. If I try to use SHELLmysqladmin -u root password
'password' I get access denied as either root or the regular user. I
can't run mysql as
I learned that there are three types of indexes (PRIMARY, UNIQUE, and
INDEX).
Now assuming I create a performance-critical PRIMARY key, will I better have
to specify UNIQUE and INDEX for this column also !? It should be obvious
that a primary key is unique anyway, and an index as well, shouldnt
Sound like a great idea!
Is there an easy way to create an HTML page that will copy selected tables
to backup copies on the same server? I want to create an administration
page for my client to be able to backup their database whenever they see
fit. But, I can't give them direct access to
Patrick Kirk wrote:
Hi all,
I've installed the latest MDAC and Jet service packs on Windows 2000.
On Linux I've the latest MySQL and MyODBC3.51.
Using the ODBC Administrator I've set up a connection and made sure to
check Don't Optimize columns width, Return Matching Rows, Allow
BIG Results,
=4M
[mysqlhotcopy]
interactive-timeout
Daniel
Brazil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a date addition function.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives
Ed Reed wrote:
Thanks Jeff,
After a little more investigation it turns out that the problem only
exists when I run the query through a MS Access database attached to
MySQL via ODBC. If I run the query in MySQLCC or MySQL-Front it runs
just fine.
Any ideas for a work around?
- Ed
Use an
cache is very
good at handling this. Anyway, it's never gone down on decent hardware.
Can't say much more than that :)
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL
in Section 14.1.3.1 Corrupted
MyISAM Tables...
Typical symptoms for a corrupt table is:
You get the error Incorrect key file for table: '...'. Try to
repair it while selecting data from the table.
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http
: checking/recovering table entries in the error log.
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to http://bugs.mysql.com/
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a MySQL table with a Date column in format \-MM-DD\ and I\'m trying to
figure out a query that would return a list of months that have an entry in the above
table. With output like:
Mar-01, Feb-01, Apr-01 etc...
I\'m still pretty new to MySQL and the date functions are still a bit
in the mysql
error log similar to...
Incorrect key file for table: 'referenceEntries'. Try to repair it
But there is no entry in the mysql error log. Any thoughts why not?
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Nowhere have i seen that it tells u to do this ?
mysql INSERT INTO user
VALUES('localhost','ForumUser',PASSWORD
('forum123'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
for a forum i would do
GRANT SELECT,INSERT,UPDATE ON *.* TO [EMAIL PROTECTED]
identified 'somepass'
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
to play
catch up for the next three days.
Daniel Gibby
William Hargrove wrote:
Hello there,
I've just been searching through the newsgroups around this issue, as I now
have the same problem and was wondering if you heard any responce to this. I
can't seem to get any further with it. My slave
to the DB server. This is more
flexible, but slower. Anyway, it's the only option currently.
Dan
--
signature
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED
Does anyone know what this replication Slave_SQL error means?
Error initializing relay log position: Could not find target log during
relay log initialization
How do I specify the target log other than what I'm doing? See below for
details.
Daniel Gibby wrote:
The problem isn't that it can't
Newsletter wrote:
After install the MySQL Administrator version 1.0.2b alpha there is an error about a msvcr70.dll not found. This problem was found in Windows 98SE and Windows 2000 server systems.
Thanks for your attention
Reinaldo Melo Filho
from Brazil
I searched for that dll on google
You already can insert a column before or after another column.
ALTER TABLE blah_table ADD COLUMN column_new VARCHAR(25) AFTER
column_existing;
Don't count on my syntax being perfect, but it is pretty easy to do what
you are saying using the MySQL client
Daniel Gibby
David Griffiths wrote:
1
more than a few
hours.
What I have a problem with is people piggy-backing off other people's
threads. If you have a new topic, start a new topic...
--
signature
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676
on it anywhere.
Am I going about recovering this correctly? HELP!
Thanks,
Daniel Gibby
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
One way is to execute the SHOW VARIABLES command in the mysql client.
Then you can see what all the values are set to and figure it out.
You could also read the documentation and determine the order that
locations are searched for to find my.cnf and figure it out.
Daniel Gibby
David B Hamby
position: Could not find target log during
relay log initialization
Daniel Gibby
[EMAIL PROTECTED] wrote:
Did you look in the error log for the slave to find out the reason it can
not contact the master?
Original Message
On 3/15/04, 1:39:44 PM
-ldflags=-lstdc++' '--with-embedded-server' '--with-vio' '--with-openssl' '--without-docs' '--without-bench' '--without-readline' '--with-extra-charsets=all' '--with-berkeley-db' '--with-innodb'
Yeah, I know what's wrong with that.
--
signature
Daniel Kasak
IT Developer
NUS Consulting Group
Mulugeta Maru wrote:
I am using MySQL 5.0 at the moment with a number of databases. These databases are created to learn MySQL. Some of the tables are Innodb.
I would like to remove MySQL 5.0 and install 4.0.18. What do I need to do to reserve the databases so that I can continue to use them in
Aaron wrote:
How can I select the last record that was inserted? An ASP/VB example would
be great too!
I believe you have it already.
I use:
select last_insert_id() as MyID
but from memory @@identity is a synonym of last_insert_id()
Dan
--
sig
Daniel Kasak
IT Developer
NUS
cron schedule it ?
Hi,
Is there any function for MySQL database to do automatic backup?
Let say, i can set the time, that MySQL will automatic backup
between 7.00pm-8.00pm everyday.
Thank you very much.
regards,
florence
Thank you very much.
regards,
They most probably got it from this list, i too have had virus emails
sending emails with my email and name in the header !! but i dont have a
virus !!
Sturgeon, Jon wrote:
[EMAIL PROTECTED] wrote:
Look it through
Can the list administrator figure out who this moron is and remove him
t opposing the FTA. See
http://yro.slashdot.org/article.pl?sid=04/03/05/229228mode=thread
for the latest Slashdot story on it...
Sorry about the political rant, but this stuff is important and we
don't have much time.
--
signature
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacif
No I did not. Thank you very much!
Regards
Daniel
-Ursprungligt meddelande-
Från: Jeff Mathis [mailto:[EMAIL PROTECTED]
Skickat: den 5 mars 2004 00:48
Till: Daniel Ek
Kopia: [EMAIL PROTECTED]
Ämne: Re: Querying serveral databases (Views?)
in case someone hasn't answered you yet..
do
will be implemented, or other solutions to the problem? And
with that I don't mean the make more connections fix, since I don't
feel it's a neat way to solve it.
Thanks in advance
Regards
Daniel Ek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Sasha Pachev wrote:
Daniel R. Anderson wrote:
Whenever I start up mysql through mysqld (in my rc.d file), I get the
following error:
Warning: asked for 196608 thread stack, but got 126976
(Note: numbers vary)
Is this bad, and what (if anything) should I do about it?
In theory, it could
()-- MySQL -- Apps that relies on MySQL data
I would be thankful to any comments and/or suggestions I can get
Regards
Daniel Ek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Some key in the table is null when it shouldnt be, or the type of the join
keys isnt the same. i have had issues when importing data from a dump so
i've had to do a FORIEGN_KEY_CHECKS=0
So I have made a table called 'uid' where on uid is the only field in
the table. Then I make another table
Hi there, i happened to be peering into the Sybex book on Mysql4 , it was
pretty expensive about 100 AUD is it a good one ? Anyway i had reference to
be able to compile c code into Mysql to add functions into it. Is there
anyway posible to avodi doing this and add it using queries ? Let me know
You can ALTER TABLE
http://www.mysql.com/doc/en/ALTER_TABLE.html
I´'m new with mysql and have following question:
I have a table, that has a primary key with two columns and want to add a
third column to this primary key.
Is this possible and when yes: Do I have to delete all tables, that
Whenever I start up mysql through mysqld (in my rc.d file), I get the
following error:
Warning: asked for 196608 thread stack, but got 126976
(Note: numbers vary)
Is this bad, and what (if anything) should I do about it?
Thanks in advance,
Dan
--
MySQL General Mailing List
For list archives:
Luiz Rafael Culik Guimaraes wrote:
Dear Friends
Talking with an friend, he told he that mysql 4.0.x has many problems with
lock and transactions, is this true. All table that i use are innodb
Regards
Luiz
I haven't had any problems.
Did your friend elaborate?
--
signature
Daniel
g an index that
the console query is. Try doing an 'explain' on the query from the
processlist and comparing it to an 'explain' from the console query to
see if they are using the same indexes.
Dan
--
signature
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North S
Campanella Danilo wrote:
Hi,
Look at what happened today :
mysql select curdate();
++
| curdate() |
++
| 2004-03-01 |
++
1 row in set (0.00 sec)
mysql select (curdate()-1);
+---+
| (curdate()-1) |
+---+
| 20040300 |
The benchmarks look good for opterons and mysql, i just scored a Sun Fire
V100, still havent benchmarked that yet though.
Not to start a flame war, but just a question/suggestion...
Do you specifically want a Mac (i.e. are you a Mac shop), or are you
looking for inexpensive 64 bit?
If the
MySQL Listers,
The ability to have utf-8 encoded data in my database is
important enough for me that I am considering upgrading to 4.1. I am a
beginner to MySQL, having only used it for not quite a year. My
question is whether or not MySQL 4.1 is stable enough for a beginner to
use. On
Do you have separate indexes on:
Table1.ID
Table2.ID
Table1.Field1
Table2.Field1
Table1.Field1
Table1.Field2
Select*
FROM Table1 as a
INNER JOIN Table2 as b ON (a.ID = b.ID or (a.Field1 = b.Field1 and
a.Field2 = b.Field2))
WHERE bla bla bla
We have
to go.
I'll try this, though.
Eric
At 10:36 AM 2/25/2004 -0800, Daniel Clark wrote:
Do you have separate indexes on:
Table1.ID
Table2.ID
Table1.Field1
Table2.Field1
Table1.Field1
Table1.Field2
Select*
FROM Table1 as a
INNER JOIN Table2 as b
Excuse if i'm not correct but this may be your problemo ?
MySQL 3.23.55 running on my webhost's Linux box
phpMyAdmin 2.1.0
I didnt think fulltext was in 3.23 wasnt this a Mysql 4 feature ??
Summary: When I run a fulltext search, it always returns no results. I
have added a fulltext index
Maybe i'm wrong here, someone correct me, if its just int's you are gonna
use set the field types to bigint it may search faster you are doing a
character search, to get there quicker in a text search scenerio i'd
suggest mysql4 and full text searching MATCH AGAINST
I've got a query that I
i think u have to compile it in as an option, it doesnt as default, i
wouldnt be suprised if Mysql 4 did a better job though, trying to convince
work to upgrade all machines to Mysql 4 hopefully 4.1 is a task in itself.
Hi, thanks for your reply, but it looks like:
As of Version 3.23.23,
Hi Don,
No, full-text search was added in MySQL 3.23.23, I believe (4.0.1 just
added boolean searches along with more speed overall). It doesn't need
to be compiled in or anything, it's there by default. Unless someone
compiled it and actually *removed* the full-text code or something. :-)
it, and then join it to your original query.
Dan
--
signature
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
Greetings:
Crack open the beer, PEAR DB 1.6.0 is here! (Hey, I'm a bit giddy
with excitement that my intense work during the past seven weeks
has come to fruition.)
For those unfamiliar with PEAR DB, it's a package of PHP classes
that provide an object oriented API with common methods of
It would be good as spaces between words are taking OR as the default, i
ave devised a system where the user selects the AND in the dropdown and if
they select that is will add a + to every word.
Hi!
On Feb 13, Heath, Brad wrote:
Is this a legitimate variable? It seems like it'd be useful,
.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Luiz Rafael Culik Guimaraes wrote:
Daniel
I searched all myql 4.0 what new page and did found any reference, is their
other page
Regards
Luiz
Press Release:
http://www.mysql.com/press/release_2002_11.html
Documentation:
http://www.mysql.com/doc/en/InnoDB_transaction_model.html
http
;safe" working under
SQL Server 2000.
Sorry is this is a newbie question, this is my first work mySQL.
Cheers,
http://www.eweek.com/article2/0,4149,293,00.asp
Click on the links for graphs.
--
signature
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific High
Hi,
When executing this query through the 'mysql' command line utility, the
result is returned from the database server immediately and the database
server does not create a temporary file.
(SELECT
domains.domain,accounts.owner,accounts.type,accounts.server,accounts.win
Hello
I would like to create a user that can create databases and do all the
necessary changes to it(select, insert, update, delete...), view all
database that he has been granted to see by other users except the
mysql.* I have created 1 user with the grant method but he can see all
the tables
Hi there i am designing a system where users can upload revised versions of
a file, so therefore newer versions of the file will need to be joined with
the older original file. I'd need to join the parent file id with the child
file id, would using a join table work ? I have tried something that
Hello
I am new to mysql. What I want to do is give a user a right to create
databases with all rights but I do not want them to see the mysql
database I have tried the following
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
DENTIFIED BY 'some_pass' WITH GRANT OPTION;
then tried to revoke
Brian L. Walter wrote:
Thanks for your reply.
Let me try again.
In access, you can create views. These are called 'queries' in Access. The
current version of MySQL does not support views, as I understand it.
Using DBManager, I import all my tables and data to MySQL from Access. One
of the
Mihalidis
Yes. I have tried.
MyODBC isn't up to the task yet.
Have a look at bug #2273 at
http://bugs.mysql.com/bug.php?id=2273
and PLEASE vote for the bug so it gets some priority.
--
signature
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW,
to the tree.
I can't see the error...
No-one actually posted a correction, just made comments that the
original code was wrong.
Anyone care to have a look and tell me what's up with the method of
adding a child ( on page 3 of the article )?
Thanks!
Dan
--
Daniel Kasak
IT Developer
NUS Consulting
Brian L. Walter wrote:
Greetings,
I'm in the process of migrating from Access to MySQL. I've imported access
queries into MySQL, and they do show up (using a third party db manager,
they show up under tools).
In Access, queries can be used like views. I.e. you can select from them.
Now, the
I got the following error on a perl script:
Duplicate entry '273' for key 1
I googled for it and found a thread telling me to DROP the table and re
CREATE it. So I did, and my script is working fine. My question: why
did this happen, why did dropping and recreating work, and what can I do
Paul DuBois wrote:
At 15:50 + 2/5/04, Daniel R. Anderson wrote:
I got the following error on a perl script:
Duplicate entry '273' for key 1
It means you tried to set the value of the column corresponding to key
one to 273, and there was already a record that had that value.
I googled
...
--
=
Daniel PowellA+ [EMAIL PROTECTED]
Networkgeek MCP http://networkgeek.org
=
And Trogdor smote the Kerrek, and all was laid to Burnination
1 root root 28 Jul 25 2003 libgcc_s.so.1 -
libgcc_s-3.2.2-20030225.so.1
On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote:
Have you looked in the hostname.err logs for the MySQL server?
Original Message
On 2/4/04, 2:00:53 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding
-- =
Daniel PowellA+ [EMAIL PROTECTED]
Networkgeek MCP http://networkgeek.org
=
And Trogdor smote the Kerrek, and all was laid to Burnination
to start MySQL with safe_mysqld?
Original Message
On 2/4/04, 3:04:54 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
nothing of the sort. no .err files on the machine nothing named
redstone.err or localhost.err.
Just baffling. something
your logs are being stored.
...
Also, what sort of logging are you currently performing? Are you logging
just errors , slow queries or everything?
...
Original Message
On 2/4/04, 3:27:55 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries
On 2/4/04, 3:48:46 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
its pretty default. I'd like to enable all logging if possible. What
specificly should I enable in my.cnf?
On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote:
If the server
not responding and such from applications.
I'll have to trace back several upgrades before I can pinpoint the exact
upgrade that caused the failure.
Thanks for everyone's input!
On Wed, 4 Feb 2004, Daniel Powell wrote:
I may have resolved the crashing issue...
I upgraded gcc and libgcc
places,
without brackets too.
Any help would be appreciated.
TIA
Mat
What problem are you having exactly? An error, or just not getting the
results you expected?
Maybe you need to format the date in mmdd format before giving it to
MySQL.
--
Daniel Kasak
IT Developer
NUS Consulting Group
of people using Perl from inside Excel. Check back
through the list archives - it wan't long ago. It may give you what you
need if you want to use Perl for this.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676
Jacque Scott wrote:
I have a fairly simple query where I feel it takes too long to run.
SELECT Products.NSIPartNumber,Products.Cost, Products.ModelNo,
Products.USPrice, Products.VendorPart, Products.Description ,
Products.ProductID, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products
LEFT JOIN
David Perron wrote:
Im looknig for the function that will allow me to export the database
structure into a static file, without the actual data.
I would like to create an ERD diagram with the output file.
David
mysqldump -d
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77
Hi there, i am trying to use a replace, when mysql throws an error
of Cannot delete or update a parent row: a foreign key constraint fails ,
is there any way to get more information like which key is having the
issue, is there more detailed information i can extract ?
--
MySQL General Mailing
Hi there, i am trying to use a replace, when mysql throws an error of
Cannot delete or update a parent row: a foreign key constraint fails
, is there any way to get more information like which key is having the
issue, is there more detailed information i can extract ?
--
It seems to work
Duke, Brian wrote:
Can someone explain a 1:n non identifying relation?
Brian Duke
Yes.
I'm Dan, and I'm unique; there's only one of me.
However if I like a store after an initial purchase from them, I may go
back and another purchase.
1:n
User:Purchase
Dan
--
MySQL General Mailing List
the above behaviour too, but probably not.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list
Ok, I've read the release notes, the manual, the threads on this
mailing list, installed/removed/re-installed about 5 times, tried
4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc
867MHz, 768MB RAM). When I run configure, it tells me everything is
hunky-dory and that I
So, can somebody please correct the following query (and explain the
syntax) so that it will work please? (I haven't tried putting an outer
join in it because I don't understand the syntax.)
Select
actr.name,
acto.name,
dvd.title
from
actresses actr,
actors
601 - 700 of 1312 matches
Mail list logo