Yeah, it's in the manual.
On Fri, 2 Mar 2001, Progetto 2000 wrote:
Hi,
It's possible to create a database in a differents directories ? And how to
make it ?
Thanks
Carlo Carlini
-
Before posting, please check:
SELECT
t1.id
FROM
table1 t1,
table2 t2a,
table2 t2b
WHERE
t1.StopTime = 0 AND
(t2a.Group != 'Dedicated' AND t2a.UserName != t2b.Username) AND
t2a.UserName = t1.UserName
Not sure if you need those () though.
On 2 Feb 2001, Drew
In the manual.
www.mysql.com
On 01 Feb 2001 17:29:02 -0200, Jader Wallauer wrote:
Where can i get an exemple of connection using c with mysql!
for gcc with freebsd OS.
tkz!
[]'s Jader
-
Before posting, please check:
Just because you send a message doesn't mean it's gonna get answered!!
Have you successfully installed a non alpha version of the db?
On 31 Jan 2001 11:09:33 -0500, Sanam Azeem wrote:
I sent this email two days ago and haven't heard from anyone
Date: Mon, 29 Jan 2001 14:51:30 -0500
A database server can contain multiple databases.
On 31 Jan 2001 19:01:02 +, SED wrote:
Hi,
Can I have two (or more) different SQL-databases running at the same time on
the same server (or same computer)? Does it varies between the systems?
And if I can, are they all available to
Yeah, you should really change the way the database is setup but you
could also do something like this. Have perl return an array and just do
a foreach on the array and that will give you all the values of each
column on the row, without you knowing how many rows there are.
Even if your not
If you do a
DESC tblNAME;
you can go through row by row and check if the Default is NULL
On Tue, 30 Jan 2001, Shawn Cummings wrote:
I want to query out the field names where the "Default" is NULL ... so I
can populate an HTML page for input...
SHOW FIELDS FROM tblNAME;
This
Try this one:
SELECT STRAIGHT_JOIN ArgumentCalendar.Docket
, ArgumentCalendar.Date
, DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date
, CaseID.CASEID
, CONCAT(Party1, ' v. ', Party2) AS name
, Blurb
FROM ArgumentCalendar
, CaseID
, Parties
LEFT JOIN Preview ON
Send the results of the EXPLAIN
On 25 Jan 2001 15:15:35 -0500, Brian Hughes wrote:
Hi. Thanks, I like that syntax, I didn't know I could put STRAIGHT_JOIN
there after the SELECT.
But it doesn't get me anything. EXPLAIN still says I am examining all
19,701 rows in CaseID: same problem
Go look at an example in the documentation on how to create an index and
create one on the ID column.
On 15 Jan 2001 20:57:55 +0100, Tobias Talltorp wrote:
I have a table with 2 fields which I, every fifteen minutes, load new data
into. The data is not formatted by me. It comes from an
10 matches
Mail list logo