hello
I once red that using "truncate table xx" instead of "delete from xx"
should reset autoincrement , but it seem not to happend.
but when I try to insert data with "insert" or "load data in "
it remember the old autoincrement value.
from manual :
"Truncate operations drop and re-create th
Hi guys,
First of all let me warn you, i am very much a newbie to mysql, i am pretty
good with the basics like selecting,deleting,updateing etc but after that i
get a dazed look in my eyes with complex sql :-D
Now that you have been warned let me explain, on my local machine (win2k) i
have php and
Hi All MySQL experts. A while ago I asked how replace a bit of text in a field.
The answer someone gave worked very well and quickly too. The field is
ItemDescription with the properties set as mediumtext There is quite a bit of
Text in each field (nearly 40,000 records) and the text is the same
Hey,
Thanks for replying.
Nope, the whole reason for selecting the data is the count, i need to
display to the client how many records of each category he has...if there is
any other way to do that (me being a newbie to mysql) I would happy to know
of it.
Cheers,
-Ryan
> Without 'count' functio
Ryan,
As you probably found out, union is only available in version 4 of mysql.
As you're using PHP anyway, why don't you just break it up into 5 separate
selects and combine the results in PHP?
Andy
> -Original Message-
> From: Ryan A [mailto:[EMAIL PROTECTED]
> Sent: 15 September 2003
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 12 Sep 2003, Michael Stassen wrote:
> When I downloaded it on August 30, it was called
> "Dec2002gccUpdater.dmg," perhaps because it was an update to the Dec
> 2002 DevTools. That has disappeared and the August 2003 gcc Updater now
> sit
Ryan,
If this query worked, it would return you 5 rows, one for each separate
count.
If you execute 5 separate counts in PHP, you'll get 5 separate values with
the same numbers as above.
Not radically different?
Andy
> -Original Message-
> From: Ryan A [mailto:[EMAIL PROTECTED]
> Sent:
"Kim G. Pedersen" <[EMAIL PROTECTED]> wrote:
>
> I once red that using "truncate table xx" instead of "delete from xx"
> should reset autoincrement , but it seem not to happend.
>
> but when I try to insert data with "insert" or "load data in "
> it remember the old autoincrement value.
>
> fr
Randall Perry <[EMAIL PROTECTED]> wrote:
> Using the OS X binary dist of mysql 4.0.14.
>
> I put my.cnf in both the data dir and /etc, restarted the server, but it
> doesn't seem to be reading the config.
>
> I added these options to the my-large.cnf under [mysqld]:
>safe-show-database
>s
Lorenzo Sicilia <[EMAIL PROTECTED]> wrote:
>
> I am new member here.
>
> I have a question about REPLICATE_IGNORE_DB,
>
> I have two mysql server (4.0.15) with replication A->B->A
> All work fine
> Now, I want to ignore one database.
>
> I have try this command:
> CHANGE MASTER TO REPLICATE_I
Thank you all for replying.
Brent your code is nice but I'ts not what I want.
In "where" clause the equality is not true because its table has diferent cod fields
anyway.
Can you help me with that?
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To: <$B&-&)&*&/&2 (B $
Hi,
You need to use UNION, but it's not possible in version 3.23.*
So it's better to upgrade MySQL server first.
SELECT table1.cod
FROM table1
LEFT JOIN table4 ON table1.cod=table4.cod
WHERE table4.cod IS NULL
UNION
SELECT table2.cod
FROM table2
LEFT JOIN table4 ON table2.cod=table4.cod
WHERE t
Dwight Trumbower <[EMAIL PROTECTED]> wrote:
> I'm sure this has been discussed before, I just haven't found it.
>
> When creating numeric data types you have the option of putting a display
> attribute. After reading the docs, I'm not really sure why you would want
> to do this.
Display size do
hi,
why its mysql database over random record use?
hi,
why its mysql database over random record use?
You may also want to look at
http://www.php.net/manual/en/function.mysql-num-rows.php
Ryan A wrote:
Hey,
Thanks for replying.
Nope, the whole reason for selecting the data is the count, i need to
display to the client how many records of each category he has...if there is
any other way to do that (
Hey Andy,
True, but thats using 5 selects instead of just one, and since we are expecting quite
a bit of traffic to the site that can add up pretty fast, expecially since we cant
afford to have a dedicated server but are on a shared hosting package.
If we have no other alternative we will be go
Hi
I need to know how and where to tell mysql to look for mysql.sock.
I am using mysql version 3.23.55 and SUSE Linux 8.2.
My problem is that i have a mysql daemon working very well and using
/var/lib/mysql/mysql.sock as the correct socket. No problems.
My problems come when I try and inst
Ryan,
You might well find that the 5 separate counts are quicker than the join
approach. Mysql is pretty efficient at counts on indexed columns from a
single table. My instincts suggest that the four table join you are
proposing could be slower than the 5 separate counts, especially if the
table
I have an existing database with a lot of information, I need to create
a new database to record inventory information that pertains to records
in the first database. I'd like to keep these two database's separate.
Is it possible to relate a record in one database to a record in another
and do qu
39?
> -Original Message-
> From: tuncay bas [mailto:[EMAIL PROTECTED]
> Sent: 15 September 2003 13:32
> To: mysql
> Subject: random record
>
>
> hi,
>
> why its mysql database over random record use?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
pls unsubscribe me from this maillist. thanks.
- Original Message -
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Monday, September 15, 2003 8:54 PM
Subject: {Scanned} RE: random record
> 39?
>
> > -Original Message-
> > From: tuncay bas [ma
excuse me
have can I get from mysql database random 6 data item?
Jeff McKeon wrote:
I have an existing database with a lot of information, I need to create
a new database to record inventory information that pertains to records
in the first database. I'd like to keep these two database's separate.
Is it possible to relate a record in one database to a record in
Is the server running?
SWIT wrote:
badboy# ./mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (
2)
that file is not there.
should I touch it ?
argggh !
and ya say windows sucks. (ok the beer is talking n
Has anyone ever used a non-ODBC, 3rd party ADO connector to MySQL?
Any suggestions would be greatly appreciated. My client does not wish to use
ODBC.
/tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
I do it everyday, they are on the same machine and installation, but most of
my queries span 2 to 4 databases. I can't get it it work on ODBC queries
though, but PHP does it fine and so does the mysql command line.
But I would be interested to know if there is any problems or reason not to
do thi
In a message dated 9/15/03 9:50:22 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> Jeff McKeon wrote:
>
> > Is it possible to relate a record in one database to a record in another
> > and do queries that pull from both databases?
Programmatically yes. Using referential integrity (for
Petre Agenbag wrote:
How can one select unique rows based on a set of fields
select distinct state_ID from financial_master where category_id='1'
only returns rows based on the uniqueness of one field.
what if there is another field that COMBINED with state_ID forms a
unique row; how can one sear
That's what I thought. Thanks for the advise!! :o)
Jeff
> -Original Message-
> From: Joseph Bueno [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 15, 2003 9:26 AM
> To: Jeff McKeon
> Cc: [EMAIL PROTECTED]
> Subject: Re: Joining tables from two different databases
>
>
> Jeff McKeon
Are you trying to run mysqld or mysqld_safe (or safe_mysqld)? If you
are going to start mysql manually, you should be in the
/usr/local/mysql directory and then type the following:
sudo ./bin/mysqld_safe &
mysqld_safe is actually just a shell script that will launch and
monitor mysqld to make s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 15 Sep 2003, Brent Baisley wrote:
> Are you trying to run mysqld or mysqld_safe (or safe_mysqld)? If you are
> going to start mysql manually, you should be in the /usr/local/mysql
> directory and then type the following: sudo ./bin/mysqld
The MySQL documentation confuses me a bit. If I create a table with
property NOT NULL and default "", does that mean that a record with a
column so defined will have a zero-length string in that column if I
don't provide a value? I guess what I'm asking is whether there's a
difference between a fi
No, NULL is not the same as the empty string. NULL, for any class of field,
means that no data has ever been written there. Tests involving NULL other
than IS NULL and IS NOT NULL will return NULL. Thus "" < "a" returns 1
(true) whereas NULL < "a" returns NULL, which will always be regarded as a
"
Randy-
NULL means No Data
So in the case of a MySQL Column defined as Type String
NULL is equivalent to ""
Best Regards,
Marty Gainty
Randy Chrismon wrote:
what I'm asking is whether there's a
difference between a field with NULL in it and a field with a
zero-length ("") string in it.
Yes, there is. NULL is the absence of a value; an empty string is a
valid value. NULL by definition isn't equal to anything, even to
itself
I'm trying to create a table in my database with
CHARACTER SET utf8 COLLATE COLLATE utf8_general_ci
Answer is
ERROR 1115: Unknown character set: 'utf8_general_ci'
What am I doing wrong, if anything? Please find details on my server and
the table I'm trying to create below:
my
Null is a special value and cannot be tested in the same manner as a string
or other value. Yes, there is a difference. If the column is Null, a
comparison operation such as a.field == "" or a.field == "something" will
both return Null.
Maybe this document will help:
A.5.3 Problems with NULL V
I ran into the issue where data had been written, and then a Null was
written.
The presence of Null in a field may not in fact guarantee that data has
never been written.
-m-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 11:12
To:
This is sometime a tough concept to get through. For example, there is
more than two answers to a yes and no question. There is yes, no, "I
don't know" (the empty set) and the "No answer at all" (null).
It's almost useless to specify a property as NOT NULL and also set a
default value. The only
I don't seem to have a my.cnf file. Maybe I should create one.
Dan
>Can you send you're my.cnf options in /etc? You might have wait-timeout
>set.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message--
At 11:00 AM -0400 9/15/03, Randy Chrismon wrote:
The MySQL documentation confuses me a bit. If I create a table with
property NOT NULL and default "", does that mean that a record with a
column so defined will have a zero-length string in that column if I
don't provide a value? I guess what I'm ask
At 11:12 AM -0400 9/15/03, Martin Gainty wrote:
Randy-
NULL means No Data
So in the case of a MySQL Column defined as Type String
NULL is equivalent to ""
Actually, it's not.
"" isn't No Data, it's Data with a length of zero.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL
At 5:23 PM +0200 9/15/03, Sigfrid Lundberg - LUB NetLab wrote:
I'm trying to create a table in my database with
CHARACTER SET utf8 COLLATE COLLATE utf8_general_ci
Answer is
ERROR 1115: Unknown character set: 'utf8_general_ci'
Try it again when 4.1.1 comes out. There is a bunch of character
s
Hey everyone,
I have a question about the speed of selecting distinct values on an
indexed column. I have a table with a five column primary key and 3,215,540
records. I want to select all of the distinct values of the first column in
the primary key. This column only has 549 distinct valu
Dear Programmers,
At the end of this query,
I make a select * from the table product_order,
Which happens to be empty,
Why ?
Is something wrong with my insert statements please ?
I inserted something into the tables CUSTOMER and PRODUCT,
and I expected it to appear into the table PRODUCT_ORDE
Nathan Cassano wrote:
Hey everyone,
I have a question about the speed of selecting distinct values on an
indexed column. I have a table with a five column primary key and 3,215,540
records. I want to select all of the distinct values of the first column in
the primary key. This column only
Its a compound key, they are always slow. I would imagin you will need to
seriously redesign your database to speed that up. I'm not 100% sure how the
index is stored, but it would be some what pointless if it was individual
field values. Its like haveing "field1field2feild3field4field5" so that a
mysql> explain select distinct AccountLevelId from PostedZpdi;
++---+---+-+-+--+-+-
+
| table | type | possible_keys | key | key_len | ref | rows|
Extra |
++---+---+-+--
Ye, NULL = "Undefined" in every database I've ever used.
Null and "" are not equal, NULL and NULL are not equal eigther. Infact
absolutly nothing is ever equal to NULL.
Haydies.
Database/PHP Developer
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMA
On 15 Sep 2003 at 11:47, Brent Baisley wrote:
> It's almost useless to specify a property as NOT NULL and also set a
> default value. The only way it would ever be NULL is if you
> specifically set it to NULL.
I think you meant "NULL" rather than "NOT NULL" there.
--
Keith C. Ivey <[EMAIL PROTE
At 5:21 PM +0100 9/15/03, Haydies wrote:
Ye, NULL = "Undefined" in every database I've ever used.
Null and "" are not equal, NULL and NULL are not equal eigther. Infact
absolutly nothing is ever equal to NULL.
One slight exception is that for purposes of ORDER BY, GROUP BY, and
DISTINCT, NULL valu
Since your primary key is used, maybe you should consider adding an
index on PostedZpdi field only.
You may also check 'key_buffer_size' value (show variables like 'key%').
Since your primary key is more than 200 MB big, allocating a "big" key
buffer (> 256MB) may help.
Joseph Bueno
Nathan Cassano
> Null is a special value and cannot be tested in the same manner as a
> > string
> or other value. Yes, there is a difference. If the column is Null, a
> comparison operation such as a.field == "" or a.field ==
"something" > will
> both return Null.
> Maybe this document will help:
> A.5.3 Pr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 3.23.58, a new version of the popular Open Source/Free Software
Database, has been released. It is now available in source and binary form
for a number of platforms from our download pages at
http://www.mysql.com/downloads/ and mirror sites.
That sounds reasonable to me, but better let more experienced hands,
particularly in db design, chime in here...
There are some good reasons to allow Null, so perhaps it would be wise to
consider some other ideas before plunging forward. :)
Just my 0.02
-m-
-Original Message-
From: R
>
> From: Haydies [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 15, 2003 11:19 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Select distinct speed on an indexed column
>
>
> Its a compound key, they are always slow. I would imagin you will need to
> seriously redesign your database to speed t
Well, it's an InnoDb database and has some decent memory pools.
| innodb_additional_mem_pool_size | 33554432
| innodb_buffer_pool_size | 536870912
-Original Message-
From: Joseph Bueno [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 11:47 AM
To: Nathan Cassano
Cc: '[
"tuncay bas" <[EMAIL PROTECTED]> wrote:
>
> excuse me
>
> have can I get from mysql database random 6 data item?
Take a look at the RAND() function:
http://www.mysql.com/doc/en/Mathematical_functions.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Th
Wasn't there just an announcement that 4.0.something was released?
-Dan
On Mon, 2003-09-15 at 12:52, Lenz Grimmer wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi,
>
> MySQL 3.23.58, a new version of the popular Open Source/Free Software
> Database, has been released. It is now a
I am needing help with a mixed left and inner join.
I guess my point of confusion is that if I do a join like table_1 left
join table_2 inner join table_3 (assuming the clauses only reference
each of the 2 tables in the order written), i expect to get all of the
results from table_1 - where am
At 1:31 PM -0400 9/15/03, Dan Anderson wrote:
Wasn't there just an announcement that 4.0.something was released?
Yes, 4.0.15.
There are 3.23, 4.0, 4.1, and 5.0 development trees, each at different
stages of their lifetime.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, w
> There are 3.23, 4.0, 4.1, and 5.0 development trees, each at different
> stages of their lifetime.
Is there any reason not to use 4.0.15 and instead use 3.23 in a
production environment? I know MAX is unstable but I have 4.0.15
installed.
-Dan
--
MySQL General Mailing List
For list archives
I am doing a mysql_num_rows after a SELECT statement and am getting
the following warning message:
Warning: Supplied argument is not a valid MySQL result resource in {pathname to
program} on line 40
Line 40 - $result = mysql_num_rows($res);
The SELECT statement:
$res = mysql_query("SELECT * FRO
On Mon, Sep 15, 2003 at 01:48:36PM -0400, Dan Anderson wrote:
> > There are 3.23, 4.0, 4.1, and 5.0 development trees, each at different
> > stages of their lifetime.
>
> Is there any reason not to use 4.0.15 and instead use 3.23 in a
> production environment? I know MAX is unstable but I have 4.
At 11:06 AM -0700 9/15/03, Tom Sparks wrote:
I am doing a mysql_num_rows after a SELECT statement and am getting
the following warning message:
Warning: Supplied argument is not a valid MySQL result resource in
{pathname to program} on line 40
Line 40 - $result = mysql_num_rows($res);
The SELECT
Paul,
It is not an error for $category to be 'no' in all records. The warning
is just telling me that it didn't find any 'yes' records.
I need to read up and find out how to error check the SELECT statement,
I guess...
-tom
Paul,
It is not an error for $category to be 'no' in all records. The warning
is just telling me that it didn't find any 'yes' records.
Well, no, it is not. The error you showed was:
Warning: Supplied argument is not a valid MySQL result resource in
{pathname to program} on line 40
PHP is tel
didn't ignore, huh?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have an odd problem with mysqld_multi.
I am trying to set up several MySQL servers on my new development server,
for testing purposes.
I currenty have only one, 4.0.9, just want to get this one going first.
However, when I try to start mysqld_multi, it seems it does not recognise
the mysqld
Hey,
Does anyone have any suggestions? Is this the correct list to post MySQL
ssl questions? I didn't get any responses so far. Thanks.
Sherrill
On Wed, 10 Sep 2003, Sherrill (Pei-chih) Verbrugge wrote:
> Hey,
>
> I am trying to test mysql moniter ssl connection. I've compiled ssl
> sup
Yeah, I have a similar box like yours. I copied the first column to a new
table with an index. I ran select distinct and the query took 6 seconds to
execute. This must have to do with the record length, because when I indexed
the origional table's first column the query was 1 minute 30 seconds to
I am needing help with a mixed left and inner join SQL statement in
MySQL 4.0 (ie, can't use subselects yet like 4.1).
I guess my point of confusion is that if I do a join like table_1 left
join table_2 inner join table_3 (assuming the clauses only reference
each of the 2 tables in the order wr
I just checked...
83
On Mon, 15 Sep 2003 13:54:53 +0100, "Andy Eastham"
<[EMAIL PROTECTED]> wrote:
| 39?
|
| > -Original Message-
| > From: tuncay bas [mailto:[EMAIL PROTECTED]
| > Sent: 15 September 2003 13:32
| > To: mysql
| > Subject: random record
| >
| >
| > hi,
| >
| > why its
Hello List Meisters.
I have the MySQL Reference Manual (the brown book), 1st Edition,
and it is a mighty fine book.
On p256, I follow the examples, but for a user who's supposed
to have access to a single database ('cabs') with the following
privileges:
SELECT, REFERENCES, INDEX, ALTER
In a message dated 9/15/03 3:05:09 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> Hey,
>
> Does anyone have any suggestions? Is this the correct list to post MySQL
> ssl questions? I didn't get any responses so far. Thanks.
>
> Sherrill
Are you orunning the monitor from the sam
Yep, you're right Paul, it is a bad query, one thing I've been burnt on a lot
in the past, is using the variables inside those double quoted lines. I've
started expanding everything, mostly objects and arrays won't get interpreted
correctly, try building the query in a string, and then printing
Hello everyone,
Kind of an oddball question but I'll try to make it as clear as
possible.
We have a Solaris server, that we have root access to. It houses mysql
db's and information.
I was not the admin for the db's and frankly I'm not an MySQL buff to be
honest.
Our DB Admin is gone now, I ne
Hi!
InnoDB is a MySQL table type which provides transactions, foreign key
constraints, and a non-free hot backup tool.
InnoDB is included in MySQL-Max-3.23 downloads, and in all downloads of
MySQL-4.0 and MySQL-4.1.
Release 3.23.58 is a bugfix release of the 'old' stable 3.23 branch. For
product
Mikhail,
I am not absolutely sure of the answers below. We should ask Monty.
- Original Message -
From: ""Mikhail Entaltsev"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, September 15, 2003 9:30 AM
Subject: Does InnoDB use any of these variables?
> Hi,
>
> Doe
Has anyone every connected Lotus Notes/Script to MySQL?
Someone asked me about it and I can't seem to find any information on
Google... and I don't know much of MySQL...
Would I have to have built MySQL with ODBC support? I installed the
binary so wouldn;t this already be available...
--
MySQ
I've been trying this for a few hours now and I'm not sure what's going on.
mysqldump --host=localhost --user=root --password=mypass dbname >
dbname.dump
This works fine, it creates a text file with CREATE TABLE blocks and INSERT
statements for each table in the database. When I try to recreate
On Mon, 15 Sep 2003, Paul DuBois wrote:
> At 5:23 PM +0200 9/15/03, Sigfrid Lundberg - LUB NetLab wrote:
> >I'm trying to create a table in my database with
> >
> > CHARACTER SET utf8 COLLATE COLLATE utf8_general_ci
> >
> >Answer is
> >
> > ERROR 1115: Unknown character set: 'utf8_general
It is a good idea to stick with the MySQL branch that you currently use in
production. The only reasons I can see to do otherwise are 1) if you need a
feature introduced in one of the newer development trees or 2) if your
project is in its early stages and you want to avoid the hassle of upgrading
At 4:47 PM -0400 9/15/03, Peter Koutsoulias wrote:
I've been trying this for a few hours now and I'm not sure what's going on.
mysqldump --host=localhost --user=root --password=mypass dbname >
dbname.dump
This works fine, it creates a text file with CREATE TABLE blocks and INSERT
statements for ea
this link from the mysql docs should help
http://www.mysql.com/doc/en/Resetting_permissions.html
- hcir
Kind of an oddball question but I'll try to make it as clear as
possible.
We have a Solaris server, that we have root access to. It houses mysql
db's and information.
I was not the admin for th
Hello all,
I've tried searching through the lists but haven't been able to find an
answer to my problem. If any one can help I would be very grateful, Thanks
in advance. Anyway, on to the problem.
I have two tables each with field that contains a date in string format
'YYMMDDhhmmss' I want to g
> Has anyone every connected Lotus Notes/Script to MySQL?
I'm not sure what you mean. Just five minutes ago, I finished writing
a LotusScript agent that exports Notes data to a text file. I then
used LOAD to bring that data into a MySQL table. Both Lotus/Notes and
MySQL have obdc drivers but I hav
Jonathon
We are using odbc and jdbc to link up from notes to mysql.
David
> -Original Message-
> From: Jonathan Villa [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 15, 2003 1:43 PM
> To: [EMAIL PROTECTED]
> Subject: Lotus Notes/Script...
>
>
> Has anyone every connected Lotus Not
Hello,
I am currently creating a multi-user system which has approximately
15 tables. Each table has a primaryID as well as the userID of who
this record belongs to. Therefore, when I perform a SELECT I am
checking (potentially) both the primaryID column as well as the
userID. I'm using MyISAM ta
I've tried this several times:
mysql> source c:/mysql/import_cash.sql
with this error:
ERROR 2013: Lost connection to MySQL server during query
from the commandline, using:
C:\mysql -u myname -pmy_password my_database <
c:/mysql/import_cash.sql
I get the same error. This happens immediately, so
I have a query:-
SELECT recTran.TransactionID,tr.* FROM Transaction tr LEFT OUTER JOIN
ReconciledTransactions recTran ON recTran.TransactionID = tr.TransactionID
WHERE tr.ReconciliationID = '8' HAVING recTran.TransactionID IS NULL ORDER
BY 'tr.Amount' DESC;
The problem I have is that the Order By
"Martin Moss" <[EMAIL PROTECTED]> wrote:
> SELECT recTran.TransactionID,tr.* FROM Transaction tr LEFT OUTER JOIN
> ReconciledTransactions recTran ON recTran.TransactionID =
> tr.TransactionID WHERE tr.ReconciliationID = '8' HAVING
> recTran.TransactionID IS NULL ORDER BY 'tr.Amount' DESC;
You are
Hello,
I have problem with stability of MySQL. I got this messages:
030915 11:30:52 mysqld restarted
/usr/local/libexec/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is
sorry, I had some extraneous quotes in my perl code:-) zzz
- Original Message -
From: "Martin Moss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 15, 2003 11:17 PM
Subject: Order By question
> I have a query:-
> SELECT recTran.TransactionID,tr.* FROM Transa
In a message dated 9/15/03 4:53:18 PM Eastern Daylight
Time, [EMAIL PROTECTED] writes:
> Would I have to have built MySQL with ODBC support?
I installed the
> binary so wouldn;t this already be available...
Download and install the MyODBC driver for your client
application machine (surprisingly
Hi Randy,
See here: http://www.mysql.com/doc/en/Gone_away.html
Maybe one of the queries in import_cash.sql is longer than
max_allowed_packet?
- Original Message -
From: "Randy Chrismon"
Sent: Monday, September 15, 2003 4:50 PM
Subject: LOAD Fails on Lost Connection
I've tried this sev
On Mon, Sep 15, 2003 at 12:46:50PM -0400, Randy Chrismon wrote:
> an exort from a Lotus Notes database. At some point, the MySQL
> documentation says that a table with no nullable columns is
> better/faster than one with. The Lotus Notes database I'm migrating,
> however, has many fields with no va
I believe that your ON UPDATE CASCADE clause should be in the definition for the
PRODUCT and
CUSTOMER table rather than the PRODUCT_ORDER table.
However, I don't think that it will work how you expect.
ON UPDATE CASCADE means that everytime you update a row in this table then all rows in
other
Bob Hall wrote:
The meaning of NULL is defined in the SQL specification; it means
"not known" or "not applicable".
Which is just about as useful as not defining it, actually. The
vagueness is the cause of a great many program bugs when database
designers don't specify what NULL means for a g
1 - 100 of 111 matches
Mail list logo
