On Wed, Sep 03, 2003 at 03:46:45PM -0700, James Kelty wrote:
> I was wondering of there is a way to kill multiple processes in MySQL
> rather than one at a time?
mytop has a currently undocumented super kill feature. By using the
'K' key, you can kill all connections owned by a given user. I hav
This might be a good solution.
I work on it in a diferent way. I create a temporary table, insert all cod
from t1, t2, t3 tables and left join it with t4 table.
Not so eficient way I could say...
Anyway thanx all
Nikos
- Original Message -
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
To
On Mon, Sep 15, 2003 at 07:29:38PM -0700, Jon Frisby wrote:
> That's an ugly way to make the distinction between A-mark and I-mark.
> In most situations, I'd move the relevant column(s) to a separate table,
> with a NULL-allowed column in that table and a FK reference back to the
> original table.
Why do I get a permission denied when I try to execute the following SQL statement via
ODBC 3.51?
UPDATE mysql.user SET Password = Password('Blank') WHERE user = 'sdaf'
I can execute the statement from a tool such as SQLYog (logged in as 'myAdmin').
The error I get is:
DIAG [S1000] [MySQ
On Mon, Sep 15, 2003 at 10:33:27PM -0400, Bruce Feist wrote:
> if you stick to the natural meaning, that doesn't happen; integer and
> other values have precise and obvious natural meanings. NULL does not.
Integers and NULL are exactly alike it this regard. Neither has
a natural meaning; their
On Mon, Sep 15, 2003 at 09:24:50PM -0500, Dan Nelson wrote:
> In the last episode (Sep 15), Bruce Feist said:
> Your example has nothing to do with the vagueness of NULL though.
> Replace NULL with "0" and you get the same result.
Bad move. "0" has a universally known meaning, and it isn't
"not
On Mon, Sep 15, 2003 at 09:53:11PM -0400, Bruce Feist wrote:
> 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
That's not true. Having a univerally
Jon Frisby wrote:
The application is payroll/personnel. A programmer is tasked with
creating forms for data entry on new employees, including
supervisor.
If the user doesn't enter a new employee's supervisor, the
application
accepts it, figuring that it is not yet known, and stores
NULL fo
Dan Nelson wrote:
In the last episode (Sep 15), Bruce Feist said:
The application is payroll/personnel. A programmer is tasked with
creating forms for data entry on new employees, including supervisor.
If the user doesn't enter a new employee's supervisor, the
application accepts it, figuring
> The application is payroll/personnel. A programmer is tasked with
> creating forms for data entry on new employees, including
> supervisor.
> If the user doesn't enter a new employee's supervisor, the
> application
> accepts it, figuring that it is not yet known, and stores
> NULL for the
In the last episode (Sep 15), Bruce Feist said:
> 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
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
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
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
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
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
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
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
"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
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
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
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
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
> 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
didn't ignore, huh?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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
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
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.
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
> 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
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
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
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
"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
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: '[
>
> 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
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
-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.
> 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
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
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
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
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
mysql> explain select distinct AccountLevelId from PostedZpdi;
++---+---+-+-+--+-+-
+
| table | type | possible_keys | key | key_len | ref | rows|
Extra |
++---+---+-+--
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
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
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
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
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
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 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
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--
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 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:
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'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
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
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
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
"
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
-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
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
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
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
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
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
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
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
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
excuse me
have can I get from mysql database random 6 data item?
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
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
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
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
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
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
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 (
hi,
why its mysql database over random record use?
hi,
why its mysql database over random record use?
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,
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
1 - 100 of 111 matches
Mail list logo