-do you have any index covering this query?
-this is not a good practice to have function call(s) in the where
clause, since mysql will make the fucntion call for every rows scanned.
select count(*) as c
from users_table
where user_regdate > "2002-06-01 00:00:00"
-furthermore, in the where clause,
Hi there,
I would like to count the users out of a mysql db who registered after a
certain date.
The column I have in the db is a char and I do not want to change this
anymore.
This is how a typical entry looks like: May 29, 2002
This is how I tryed it:
// while '10...' is unix timestamp june
On Wednesday, June 5, 2002, at 10:03 PM, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to t
On Wed, Jun 05, 2002 at 10:28:15PM -, Jay Liew wrote:
> Hello everyone,
>
> I am new to database operations, and I was wondering if there were any
> advantages or using MS Access to MySQL. Don't get me wrong, but I would
> prefer Open Source over proprietary, but this is a mission-critic
Hi,
Is this mysqld.log file created automatically or we need to do some
settings in my.cnf to enable this logging of mysqld?
Thanx in advance..
Ritu
On Wed, 5 Jun 2002, Eivind A. Sivertsen wrote:
> You can also tail -f the logfile of mysqld...
>
> >> tail -f /var/log/mysqld.log
>
> ...or so
On Wed, Jun 05, 2002 at 07:39:47PM -0500, Cal Evans wrote:
>
> If he build using 2.9x would it be stable? (I'm assuming that they
> are using gcc 3.x from your post)
Right on both counts.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408)
Hrm. Closest I can think of is
EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access';
I think this is what you mean.
Adam Hooper
[EMAIL PROTECTED]
On Fri, 31 May 2002 08:44:49 -0700
marc malacarme <[EMAIL PROTECTED]> wrote:
> I can¹t seem to make any of the describe or show queries work wh
I am having a problem installing version 3.23.50
on AIX 4.3.3. When I execute mysql_install_db or
try to start mysqld I get errors like
0509-036 Cannot load program
./bin/my_print_defaults because of the following
errors:
0509-130 Symbol resolution failed for
my_print_defaults because:
0509-136
Hello everyone,
I´m writing a VC++ 6.0 App that among many other things manages a simple
mySQL database, using myODBC v3.51. Righ now I´m trying to send a "test"
simple statement to the database, using SQLPrepare:
retcode = SQLPrepare(hstmt,"INSERT INTO ger(manuf,model,location)
VALUES(?,?,?)", SQ
I've installed MySQL as a service using
mysqld-nt --install
on W2K. No problem there, says "service successfully installed". BUT, when I
try to log off the admin account and on to the regular "power user" account
MySQL will not start automagically and cannot be started manually. Pop back
At 05:18 PM 6/5/2002 -0700, you wrote:
>On Wed, Jun 05, 2002 at 04:52:39PM -0700, j.random.programmer wrote:
> > > We're running a custom-compiled 3.23.51 (or .52-pre,
> > > [..]
> > > Why not build your own?
> >
> > Hmm. The latest source on the pre-release page is 3.23.50 and it's
> > not clear
If he build using 2.9x would it be stable? (I'm assuming that they are using
gcc 3.x from your post)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 7:1
On Wed, Jun 05, 2002 at 04:52:39PM -0700, j.random.programmer wrote:
> > We're running a custom-compiled 3.23.51 (or .52-pre,
> > [..]
> > Why not build your own?
>
> Hmm. The latest source on the pre-release page is 3.23.50 and it's
> not clear whether the "stability" issue is a bug in the code,
> We're running a custom-compiled 3.23.51 (or .52-pre,
> [..]
> Why not build your own?
Hmm. The latest source on the pre-release page is
3.23.50 and it's not clear whether the "stability"
issue is a bug in the code, the compiler or
the runtime libs.
> I can send you a binary that works for us.
Ok, without ridiculing you in public (because that's not my purpose) I've
got to question your use of mission critical and MS Access in the same
statement.
Access is a desktop database and for that it does ok, ass long as you don't
want it to get in a hurry to do anything. (The JET engine is horr
Sorry, I think I confused you.
A batch file, calling mysqlhotcopy with the proper parameters is the way I
would go. If I had to use Win2k, I'd use the Task Scheduler to run the
batch file.
As to the parameters for myslqhotcopy, I don't know. I would suggest you
read the help file or type mysql
On Wednesday 05 June 2002 4:54 pm, Jeremy P. McKay wrote:
> I do not really think MS Access is for Mission-Critical databases...but I
> guess that depends on ther definition of mission critical. Most MCP will
> agree that MS Access does not scale well and offers little advantages for
> Mission-Cr
>IMHO, The Right Thing to do this, is to create the additional data in
>your application (as you said you won't change the table).
(...)
thank you!
>If you want this with SQL for sure, using user-defined variables will
>work:
cool. sorry, but I'm still learning, since I'm into MySQL from a fe
>It's not clear from your description whether the numbers are
>associated with the records in the table or with the records returned
I'm trying to choose a subset only of the select result...
(without having any informations about the db/data structure)
>should be handling in whatever you're
MS Access
MS Office Based.
It is has more graphic tools.
Possibly more people will be able to manipulate the database since Access
has very little security, this is not usually an advantage.
Lastly only a few people will be able to use you application before MS
Access fails... Therefore limiting a
On Wednesday 05 June 2002 4:28 pm, Jay Liew wrote:
> Hello everyone,
>
> I am new to database operations, and I was wondering if there were any
> advantages or using MS Access to MySQL. Don't get me wrong, but I would
> prefer Open Source over proprietary, but this is a mission-critical
> com
Hello everyone,
I am new to database operations, and I was wondering if there were any
advantages or using MS Access to MySQL. Don't get me wrong, but I would
prefer Open Source over proprietary, but this is a mission-critical
commercial purpose database. Any comments, would be much apprecia
On Wed, Jun 05, 2002 at 03:58:57PM -0600, Jayce^ wrote:
>
> I know my company is having a similar problem, the reason we're not
> building our own anymore, and the same reason we're having trouble
> with the rpms is the gcc on RH which is causing us serious stability
> problems. Might have the s
Hi.
On Wed 2002-06-05 at 22:03:59 +0200, [EMAIL PROTECTED] wrote:
> Hi.
>
> I need to have a cardinal number near each data, when I submit a query:
>
> for example, if my table is:
>
> +-+
> | example |
> +-+
> | cat |
> | dog |
> | horse |
> .
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I know my company is having a similar problem, the reason we're not building
our own anymore, and the same reason we're having trouble with the rpms is
the gcc on RH which is causing us serious stability problems. Might have the
same problem we're
Hi.
On Wed 2002-06-05 at 14:21:03 -0500, [EMAIL PROTECTED] wrote:
> In the last episode (Jun 05), Pooja Daryani said:
>
> > > I need to know how many rows are supported in mysql db.
>
> If there is a limit, it's probably 4294967296 rows. But you'll
> never get that many in a table anyway.
:-)
Hi.
On Wed 2002-06-05 at 13:37:22 -0500, [EMAIL PROTECTED] wrote:
[...]
> It selects a list of all members from the database referred by a certain
> member. However, the query needs to be modified to also select the
> number of people that person has referred. I planned to just send
> another que
On 5 Jun 2002, at 22:03, Marco Stagno wrote:
> and if I delete the 'dog' record...
>
> +-+---+
> | example | pos |
> +-+---+
> | cat | 1 |
> | horse | 2 |
> ...
>
> IMPORTANT NOTE: I can't add a (permanent) column with
Hi.
On Wed 2002-06-05 at 14:25:30 -0400, [EMAIL PROTECTED] wrote:
> Hi all,
>
> Does anyone have any numbers on the speed of MySql replication? I am
> concerned
> with the transfer of up to 10 gigabytes to a master db... what state are
> the slaves in during the replication catch up time? Is
What would you suggest?
Mark
At Wednesday, 5 June 2002, "Cal Evans" <[EMAIL PROTECTED]> wrote:
>No, a batch file and the task scheduler are the best way to do it.
As to
>the syntax I've not used mysqlhotcopy but most of the mysql programs
will
>display help if you enter no parameters to inval
On Wed, Jun 05, 2002 at 11:31:56AM -0700, j.random.programmer wrote:
> If any folks from MySQL AB are reading this:
>
> I need to go into production *today* with 3.23.5x. I am using InnoDB
> heavily (and need the newer fixes).
>
> 3.23.50 hasn't even been released yet (the pre-release version is
Description:
I have problem with a Cyrillic when I use clauses "ORDER BY"
and "LIKE".
They didn't work correctly.
Synopsis:
Submitter-Id:
Originator: Anelia Taneva
Organization:
MySQL support: email support
Severity:serious
Priority: high
Category
Hello.
On Wed 2002-06-05 at 08:08:32 -0600, [EMAIL PROTECTED] wrote:
> Hello,
>
> IS it possible to export a query from mysql in a specific format.
> I created a query- SELECT id,title,class,grade FROM semester1; \T
> semester1
> but it exported the query in a table form.
>
> Can anyone te
set yourself up a login from either that specific machine or from any
machine (host=%). Then try it.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Jetaime [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 3:46 PM
T
> As a potential MySQL customer, I am trying to find the answer to the
> question "Can I connect to a MySQL Database on a unix platform from a PC
> through TCP/IP network? If the answer is yes, what other additional
> supporting software will be needed on the Unix platform and on the PC? Any
> poi
how can i setup a mysql server on a machine that is on the network to accept
connections from my machine. I downloaded the client and there is currently
a server running on a nother machine on the LAN. I inputed it's ip address
and username:root password: password for root and it says can't coonne
In the last episode (Jun 05), Liqiang Feng said:
> As a potential MySQL customer, I am trying to find the answer to the
> question "Can I connect to a MySQL Database on a unix platform from a PC
> through TCP/IP network? If the answer is yes, what other additional
> supporting software will be
As a potential MySQL customer, I am trying to find the answer to the
question "Can I connect to a MySQL Database on a unix platform from a PC
through TCP/IP network? If the answer is yes, what other additional
supporting software will be needed on the Unix platform and on the PC? Any
pointers,
Hi.
I need to have a cardinal number near each data, when I submit a query:
for example, if my table is:
+-+
| example |
+-+
| cat |
| dog |
| horse |
I'd like to have, with a "select" statement..
+-+---+
| example |
On 5 Jun 2002, at 14:30, Ian M. Evans wrote:
> As per previous suggestions, I use sort_title so that film titles like
> "The Godfather" get sorted as "Godfather". In the above select I was
> trying to narrow the search down so I could grab all the films that
> started with 'G' but still using the
Hi Dan,
Close to what I want But no cigar just yet. Thanks for the help, but I
think you mis-understood some parts of it. First things first, on creating
the list of servers which is in a group - thanks, that works beautifully and
I got it working. The query looks as follows:
SELECT monit
I'd correct my post to recommend:
SELECT i.interest_id, COUNT(mi.interest_id) AS count, i.name
FROM interests AS i left join member_interests AS mi
on i.interest_id = mi.interest_id
GROUP BY i.interest_id, i.name
ORDER BY i.name
My original group-by was wrong, as I was referring
In the last episode (Jun 05), Pooja Daryani said:
>
>
> > Hi All,
> >
> > I need to know how many rows are supported in mysql db.
If there is a limit, it's probably 4294967296 rows. But you'll never
get that many in a table anyway.
--
Dan Nelson
[EMAIL PROTECTED]
--
thanks for all the replies!! but it is not working.
here is the loop:
if($result == EMPTY SET){
$Scheduled = NULL;
}
else{
$Tech = mysql_result($result, 0, "tech");
$SNumber = mysql_result($result, 0, "snumber");
$Scheduled = mysql_result($result, 0, "scheduled");
[snip]
SELECT posterdata.*, IF (aptitle LIKE 'The %',SUBSTRING(aptitle,5),IF
(aptitle LIKE 'A %',SUBSTRING(aptitle,3),IF (aptitle LIKE 'An
%',SUBSTRING(aptitle,4),aptitle))) AS sort_title FROM posterdata WHERE
ap_type='Original Movie Poster' AND sort_title LIKE 'G%' ORDER BY sort_title
ASC
As per
You could be correct, but I don't think so. The question was count the
members and give me the description. Just by reading it, I don't think your
query will answer that question.
I would however drop the distinct because the group by will do that for you.
> SELECT mi.interest_id, COUNT(*) AS c
No, a batch file and the task scheduler are the best way to do it. As to
the syntax I've not used mysqlhotcopy but most of the mysql programs will
display help if you enter no parameters to invalid parameters. (or the
parameter --help)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* h
I probably did not provide enough info the first time. The members table
is setup as follows:
Id (primary key)
Referer (relates to the primary key of the table)
I am given a member ID, say 4. I need to display all members who have
been referred by member 4 (obviously no problem). However, for ea
- Original Message -
From: "Chris Hohimer" <[EMAIL PROTECTED]>
To: "Anil Garg" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 2:26 PM
Subject: Re: help with empty set
> yeah that kinda works...
>
> what i have is
>
> $result = mysql($database "select x, y,
> Hi All,
>
> I need to know how many rows are supported in mysql db.
>
> Thanks,
> Pooja.
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
First off, I would like to thank everyone on this lists who helps people
like myself!
I'm having trouble with the following query:
SELECT username, first_name, email, DATE_FORMAT(signup_date, '%b %e,
%Y') AS signup_date FROM members WHERE referer = (id)
It selects a list of all members from the
If any folks from MySQL AB are reading this:
I need to go into production *today* with 3.23.5x. I
am
using InnoDB heavily (and need the newer fixes).
3.23.50 hasn't even been released yet (the pre-release
version is not "stable") and based on posts on this
list, we know that there are several bu
Hi all,
Does anyone have any numbers on the speed of MySql replication? I am
concerned
with the transfer of up to 10 gigabytes to a master db... what state are
the slaves in during the replication catch up time? Is the delay primarily
related to the network bandwidth? I am assuming that all t
yeah that kinda works...
what i have is
$result = mysql($database "select x, y, z from $table where a and b and
c;", $link);
if ($result == empty set){
$z = NULL;
}
else
$x = mysql_result($result, 0, "x");
$y= mysql_result($result, 0, "y");
$z = mysql_result($res
Ah, after I write my SQL SELECT query I discover that you can't use WHERE
with an alias.
Here's what I'm trying to do:
SELECT posterdata.*, IF (aptitle LIKE 'The %',SUBSTRING(aptitle,5), IF
(aptitle LIKE 'A %',SUBSTRING(aptitle,3),IF (aptitle LIKE 'An
%',SUBSTRING(aptitle,4),aptitle))) AS sort_t
have u tried with \0 ??
- Original Message -
From: "Chris Hohimer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 1:54 PM
Subject: help with empty set
> using PHP what is the value for a returned result from MySQL of "empty
> set"
> ex:
>
> if($result != NULL)
I looked at the same message you got and at the bottom it says to try
this address:
[EMAIL PROTECTED]
So perhaps eliminating the "digest" part in your address will work.
Also, you have to do it from the same email account that you signed up
with but you probably did that.
>>> Bob Purvy <[EMAIL
Have you tried the link at the bottom of every message from the list?
Chuck
At 10:22 AM 6/5/2002 -0700, Bob Purvy wrote:
>I'm really sorry to send this to the whole list, but I've tried every
>conceivable thing I can think of, over the last week, and none of it
>works. I promise this will b
* Arthur Fuller
> > I have searched the manual without success. I want to know the maximum
> > number of tables MySQL permits to be JOINed in a single SELECT
> > statement.
* Roger Baklund
> According to crashme, it is 32 in 3.22.39 and 63 in 3.23.39.
>
> http://www.mysql.com/information/crash-me
Hi,
I had an odd thing happen yesterday. I had replication running, the master
being on a server farm, the slave being in our office. I tested it early in
the morning by creating a table on the master, it showed up on the slave
right away.
Of course as soon(a few hours later) as I went to sho
using PHP what is the value for a returned result from MySQL of "empty
set"
ex:
if($result != NULL){
do this
}
else{
do that
}
but NULL is not right. what should I replace NULL with?
-
Before posting, please
In the last episode (Jun 05), Sabine Richter said:
> "Weaver, Walt" wrote:
> > From: Roger Baklund [mailto:[EMAIL PROTECTED]]
> > * Arthur Fuller
> > > I have searched the manual without success. I want to know the
> > > maximum number of tables MySQL permits to be JOINed in a single
> > > SELECT
In the last episode (Jun 05), Chris Knipe said:
> Does anyone have and ideas of wisdom on how to compare arrays (mysql
> result sets) and group items based on if they exist in two or more
> arrays?
>
> Now, I want to compare group1 against the server list, and do something like
> the following:
>
Does anyone know whether this binary distribution was compiled with
pthreads or not?
mysql-3_22_30-sun-sunos4_1_4-sparc_tar.gz
Or: does anyone know how one can find out?
Thanks
Peter Lloyd
--- mysqlbug form ---
From: Peter Lloyd <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Error 2003: m
Problem: mysql & mysqld cannot communicate (error 2003)
Synopsis:
(a) I installed mysql on a Unix SunOS system, but the post-installation died silently
in mysql_install_db. There
were no diagnostic messages. Trial-and-error indicated that mysql_install-db has a bug
(a missing '&'). When
this
> Isn't 'key' a reserved word?
Yeah... *slaps forhead*
That's why I "always" use 'id' as my key column name and "always" quote my
column names.
Thanks for the quick response!
nik
( sql query )
-
Before posting, please che
You can use in_array or array_search.
> hey everyone,
>
> Does anyone have and ideas of wisdom on how to compare arrays (mysql result
> sets) and group items based on if they exist in two or more arrays?
>
> For example:
>
> I have a table, with a list of servers:
> server1
> server2
> server3
> s
And how long does it take to compile a 32-tables-statement?
With the gupta server a 14-tables-statement took 2 hours.
Sabine
"Weaver, Walt" wrote:
>
> Hmmm... we're running 3.23.47 here and have run into a 32 table join
> limit...
>
> --Walt
>
> -Original Message-
> From: Roger Baklun
hey everyone,
Does anyone have and ideas of wisdom on how to compare arrays (mysql result
sets) and group items based on if they exist in two or more arrays?
For example:
I have a table, with a list of servers:
server1
server2
server3
server4
server5
...
serverX
I have a table that specifies w
I'm really sorry to send this to the whole list, but I've tried every
conceivable thing I can think of, over the last week, and none of it
works. I promise this will be my only broadcast message, regardless of
what happens next (so you don't need to flame about it!)
specifically, I've tried:
I am running MySQL 3.23 on WIN 2k server and would like to create a daily
scheduled task that will utilize mysqlhotcopy (or other back up method) to
back up my db. I understand that I need to create a .BAT file that contains
the command to run hotcopy but I'm a bit confused as to the syntax. What
Hello all,
I have a table that has a column named foo. It is enumerated with values
("Excellent","Good","Fair","Poor") and is indexed. The table has a few
million records in it. I recently did a select query where I mistakenly
typed "where foo='Goo'" instead of 'Good'. This query took quite
[snip]
tbl
keyint, primary key, auto increment
valint
I've inserted several dummy values so that my table looks like this:
key val
150
2100
3150
4200
I can successfully run this query:
UPDATE tbl SET val = val + 1
but THIS query fails:
UPDATE tbl SET val = val
Thanks Egor (and the others who responded). I don't normally install
unfamiliar software without first at least skimming the doc. Once
I ran the install it unpacked the doc directory.
See, first dumb question. 8-)
--Gary
Egor Egorov wrote:
>
> Gary,
> Wednesday, June 05, 2002, 6:05:08 PM, you
Hello, I'm new to the mailing list.
I have a simple table:
tbl
keyint, primary key, auto increment
valint
I've inserted several dummy values so that my table looks like this:
key val
150
2100
3150
4200
I can successfully run this query:
UPDATE tbl SET val = va
Chris,
Wednesday, June 05, 2002, 6:51:16 PM, you wrote:
CH> I am new to MySQL and SQL in general.
CH> I was wondering how to narrow down a
CH> search. I wanted to do something
CH> like
CH> select * from table where x, y, z;
You can use AND and OR in WHERE clause, f.e.
SELECT * FROM table WHE
Gary,
Wednesday, June 05, 2002, 6:05:08 PM, you wrote:
GD> Is there an archive of the MySQL doc? The doc at mysql.com is
GD> for v 4.0 alpha and I'd like to get the doc for v 2.23.49
GD> which I just downloaded. (As a new user I'd like to be able
GD> to RTFM before bugging the list with dumb ques
I believe the docs for whatever version you downloaded are included
in the full source distribution; they are at the top level of the
source tree:
manual_toc.html
manual.html
manual.txt
But yes, it would be nice for the docs in various formats for
previous - or at leas
Here's a design question similar to the current threads on normalization
issues.
Suppose I have three types of contact information I want to keep track of:
Postal address, phone, and email. The design is that any given entity
that has contacts info associated may have zero or more of each.
I al
Hmmm... we're running 3.23.47 here and have run into a 32 table join
limit...
--Walt
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 10:19 AM
To: mysql mailing list
Cc: Arthur Fuller
Subject: Re: Maximum JOINED tables
* Arthur Fuller
> I
As far as I can tell it works from root (Linux, BSD) but may not be the case
for all distros. Do a quick test and you will be able to find out.
HTH!
Jay
mysql, query, sql
Always reply to the list, so that others may participate in the discussion.
---
[snip]
I am new to MySQL and SQL in general.
I was wondering how to narrow down a
search. I wanted to do something
like
select * from table where x, y, z;
but this doesn't work. Can someone help me?
[/snip]
select *
from table
where x
and y
and z
HTH!
Jay
"It's hip to snip!"
---
[snip]
Is there a way to designate which folder on the server the OUTFILE ends
up in? Will it accept a full path in the file name?
[/snip]
yep, even something like "/somefolder/someotherfolder/somefile.foo"
HTH!
Jay
mysql, sql, query
"It's hip to snip!"
-
* Arthur Fuller
> I have searched the manual without success. I want to know the maximum
> number of tables MySQL permits to be JOINed in a single SELECT statement.
According to crashme, it is 32 in 3.22.39 and 63 in 3.23.39.
http://www.mysql.com/information/crash-me.php >
--
Roger
--
I have a reply for both Cal and Javier,
Cal,
I have a hunch the JOIN is backward for you.
> SELECT DISTINCT(mi.interest_id), COUNT(*) AS count,
>i.name
> FROM member_interests AS mi left join outer interests AS i on
> mi.interest_id = i.id
> GROUP BY mi.interest_id
> ORDER BY i.name
Yup, it'd be the answer to everything. :>)
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 10:00 AM
To: Weaver, Walt; 'Arthur Fuller'; 'mysql mailing list'
Subject: RE: Maximum JOINED tables
Would have been a little spooky if were '42'!
adelpfe wrote:
> I am using mysql++1.7.9.
> i have installed and configured mysql++
> but , i don't succeed even to compile the examples given with the api.
> please , try to help me.
> How can i find dependicies.
> how can I link
> ..
> thaks all
>
---
Would have been a little spooky if were '42'! :)
Andrew Hazen
-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 11:51 AM
To: 'Arthur Fuller'; mysql mailing list
Subject: RE: Maximum JOINED tables
32.
-Original Message-
From: Arthur
I am new to MySQL and SQL in general.
I was wondering how to narrow down a
search. I wanted to do something
like
select * from table where x, y, z;
but this doesn't work. Can someone help me?
-
Before posting, please check:
32.
-Original Message-
From: Arthur Fuller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 9:48 AM
To: mysql mailing list
Subject: Maximum JOINED tables
I have searched the manual without success. I want to know the maximum
number of tables MySQL permits to be JOINed in a sing
I have searched the manual without success. I want to know the maximum
number of tables MySQL permits to be JOINed in a single SELECT statement.
TIA,
Arthur
-
Before posting, please check:
http://www.mysql.com/manual.php (
- Original Message -
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 8:48 PM
Subject: RE: Is it possible to have MySQL perform an action at a
specific time?
> Sounds like you need to run a CRON job (you will have to know if your
> specific im
I am using mysql++1.7.9.
i have installed and configured mysql++
but , i don't succeed even to compile the examples given with the api.
please , try to help me.
How can i find dependicies.
how can I link
..
thaks all
-
B
Hi,
Is there a way to designate which folder on the server the OUTFILE ends
up in? Will it accept a full path in the file name?
Mysql;mysql;mysql;
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL programming.
- Original Message -
From: "Chris Stefanick" <[EMAIL PROTECTED]>
To: "MySQL Support" <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 2:55 PM
Subject: setting up two instances of mySQL
> I have one product already using a mySQL database. We just inherited a
> new
> product (via an acqui
Is there an archive of the MySQL doc? The doc at mysql.com is
for v 4.0 alpha and I'd like to get the doc for v 2.23.49
which I just downloaded. (As a new user I'd like to be able
to RTFM before bugging the list with dumb questions. I'll
still probably ask dumb questions, but at least I'll have
ma
[snip]
IS it possible to export a query from mysql in a specific format.
I created a query- SELECT id,title,class,grade FROM semester1; \T
semester1
but it exported the query in a table form.
Can anyone tell me if you can export the query in another formatTab
delimited,cvs etc.
[/snip]
f
In the last episode (Jun 05), Pabst Simon said:
> Description:
>
> When using mysqlhotcopy 1.15 for database backups with --regexp='.*' and
> having 640 or more Databases produces the following error:
>
> DBD::mysql::db do failed: File '/lvol1/mysql/data/mydatabase/mytable640.MYD' not
>found (
Hello,
IS it possible to export a query from mysql in a specific format.
I created a query- SELECT id,title,class,grade FROM semester1; \T
semester1
but it exported the query in a table form.
Can anyone tell me if you can export the query in another formatTab
delimited,cvs etc.
Any hel
Description:
When using mysqlhotcopy 1.15 for database backups with --regexp='.*' and
having 640 or more Databases produces the following error:
DBD::mysql::db do failed: File '/lvol1/mysql/data/mydatabase/mytable640.MYD' not found
(Errcode: 24) at ./bin/mysqlhotcopy line 432.
The file exists
1 - 100 of 140 matches
Mail list logo
