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 chec
Yeah, just have your backend script parse the info it needs and just call
two queries to make that happen.
On Fri, 16 Feb 2001, Chris Toth wrote:
> I have a form on a webpage for a simple trouble ticket system. When
> requesting a computer be fixed, software be installed, etc...a faculty
> memb
you probaly don't have your code setup correctly. put some of the perl
code that does the statement to let us help you more.
On Thu, 15 Feb 2001, Laszlo G. Szijarto wrote:
> Hi, everyone,
> I've recently run into a strange phenomenon.
>
> I try to tun the statement "update accounts set loggedi
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 Wilder-Goodw
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:
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 usin
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
SQL is a language used in most database servers. Each database server
however may have a tiny little different syntax, but for the most part
everything is the same. Some databases also include database specific
code which is not portable to other database servers.
PHP, Perl, C, etc. are just lan
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
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;
>
>
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 probl
your selects
> and for this select to
> come up with some solution.
> Here we are having databases with over 20 tables where 5 of them have more
> than 30 records
> and we are getting LEFT JOIN and GROUP BY select for all 30 records in
> less than 20 seconds.
>
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 Preview.CASEID
Put your limit at the end
On 17 Jan 2001 11:26:04 +1100, MacBane wrote:
> The variables are set using php and are all set correctly.
> how do I do the where and order by statement
>
> SELECT * FROM $table_name LIMIT $indst,$inded where sec_id = $sec order by PG_date
>DESC
>
>
What's your subquery and we can help you convert it to a join.
On 16 Jan 2001 15:59:48 -0500, Mark Marshall wrote:
> Hi all,
>
> Is there any kind of schedule that says when the next MySQL version will be
>available? I'd like to utilize MySQL here, but I can't really start to seriously
>work
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 exter
16 matches
Mail list logo
