On Wednesday 11 June 2003 08:47 pm, JJ wrote:
> I have to add group functionality to an existing database. The
> functionality required will be something like /etc/group in linux.
How about 3 tables. Groups, Members, and Relationships.
Table Group
id int auto_increment
name char
Table Memb
On Friday 13 June 2003 09:29 pm, Mark Stringham wrote:
> I'm querying a table of approximately 42 records based on 3 criteria. The
> results are then displayed in a pop-up window. When the query is executed
> the first time - the window opens and stalls for about 3 seconds before
> the results ar
On Sunday 15 June 2003 08:44 am, wrote:
> Greetings-
>
> I request your help constructing a query to return a list of active members
> based on the following:
select distinct members.members_number, members.name, status.status from
members,status where status.status='Active' and status.date
On Tuesday 17 June 2003 03:35 am, George Chelidze wrote:
> Hello,
>
> I have two RH boxes with mysql on them and replication is enabled from
> box 1 to box 2 and from box 2 to box 1. The amount of data on each of
> them is round 400-500MB. Now I have to replace one of them with new box.
> As both b
the problem is grouping
incorrectly, but it doesn't jump out at me. It's still early here
this morning.
Ryan Fox
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
up',Hemisphere='$Hemisphere',ID1='$ID1'
> WHERE CCode=$CCode";
Should be changed to
>$sql = "UPDATE Continents SET
> CCode='$CCode',Name1='$Name1',Type1='$Type1',Group='$Group',Hemisphere='$Hemisphere&#
>$sql = "UPDATE Continents SET
> CCode='$CCode',Name1='$Name1',Type1='$Type1',Group='$Group',Hemisphere='$Hemisphere',ID1='$ID1'
Also, this has a pretty severe logic flaw. If someone changes the
CCode field, this sq
> Can you explain this procedure to me a little better or point me to
> something I can read? I still have to convince the person who manages the
> Oracle box to open up an NFS share.
The point of using NFS to transfer the files from the oracle box to the
mysql box is to avoid copying the data twi
- Original Message -
From: "Trask" <[EMAIL PROTECTED]>
> I'm trying to configure MySQL and PHP so that PHP can access MySQL for
> function calls and database access. It's my understanding that I need to
> use the command - "mysql_connect(, , );"
>
> I tried that and got a syntax error, I
- Original Message -
From: "Michelle de Beer" <[EMAIL PROTECTED]>
> I believe this question is solved by a join, but I
> haven't really got a hang of it.
>
> My table:
> --
> | uid | rootid | parentid | name |
> -
- Original Message -
From: "Qunfeng Dong" <[EMAIL PROTECTED]>
>
> We are trying to develop a simple biology database to
> maintain some DNA Sequence information. My problem is
> coming from the following two tables:
Making indexes smaller will help. Does it need to be varchar(50)?
Also,
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
> mysql> create table aaa(id int not null unsigned, name text);
> Can you tell me why doesn't it work?
You want:
create table aaa(id int unsigned not null, name text);
Your way doesn't work as 'unsigned' is a modification
tatement like that
above, how about:
SELECT * FROM Students WHERE LastName='Smith' and FirstName LIKE 'J%';
or worse,
SELECT * FROM Students WHERE concat(LastName, ", ", FirstName) LIKE 'Smith,
J%';
Ryan Fox
sql, query, sausage
---
Taking a blind stab, how about..
SELECT a.name, minimum(0,COUNT(b.id)) as votes FROM poll_options as a LEFT
JOIN poll_votes as b on a.id=b.oid
WHERE b.pid='' GROUP BY b.oid
Ryan Fox
- Original Message -
From: "Blaster" <[EMAIL PROTECTED]>
> However! Here
- Original Message -
From: "yeong Tze En" <[EMAIL PROTECTED]>
> I am trying to develop an ERP system(Enterprise Resources Planning)..
> I am wondering wheater if MYSQL suitable for this system..? Any opinion or
suggestion from you all?
> Maybe Oracle or SQL server are more suitable.. at lea
On Wednesday 19 March 2003 12:31 pm, Tab Alleman wrote:
> I am using the following command, following the only example I could
> find in the documentation ("mysql>" prompt shown for clarity):
>
> mysql> mysql < u:/db backup 20030318/cm_central.sql;
Run this from a command line, not the mysql clien
> So I do:
> SELECT * FROM table1 WHERE datum BETWEEN ('-00-00' + INTERVAL 1 DAY)
AND '2002-03-10';
> MySQL returns an empty result set, but it shouldn't (the table contains
dates year 2000 and up.
MySQL refers to the date -00-00 as null. Null+1 is null. Why don't you
rewrite the query
lect least(count(*),30) from ct;
++
| least(count(*),30) |
++
| 30 |
++
1 row in set (0.00 sec)
mysql> select count(*) from ct;
+--+
| count(*) |
+--+
| 43 |
+--+
1 row in set (0.00 sec)
Cheers,
t set will force you to do a query that returns
all of the rows, while using count(*) will (much more efficiently) use the
index to return the number of rows.
Cheers,
Ryan Fox, Geek email: [EMAIL PROTECTED]
BackWatcher, Inc. web: http://backwatcher.com
-
tibution does.
Hope this helps,
Ryan Fox
[EMAIL PROTECTED]
On Thu, 2002-07-18 at 11:44, Richard Fox wrote:
> The mysqld.log file says:
>
> 020717 13:05:05 mysqld started
> 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
#x27;1' takes far less space to store than the string 'Foo
Company'), ensure data integrity (make sure you don't have entries such as
'Foo Company' and 'foo company'), and to speed queries (matching integers
can be performed by the sql se
ory. Try
cat lefeber.txt | /apache/mysql/bin/mysql -u MyUserName -pMyPassword lefeber
or just
cat lefeber.txt | mysql -u MyUserName -pMyPassword lefeber
if the command line client is in your path.
Cheers,
Ryan Fox
-
Befor
> How do tamporary tables die? Is there a time limit, og do I have to drop
> them manually?
They are dropped when the client connection that created them disconnects.
They can also be dropped manually.
Ryan
-
Before posting, p
()
function dependant on what user is authenticated in to your web server. If
you need to restrict clients on a per-IP basis, you can do this at the php
level by checking the $REMOTE_ADDR variable and acting accordingly.
Hope this helps,
Ryan Fox
- Original Message -
From: "Wee Chua&quo
e TRUNCATE() or
FLOOR() instead.
ROUND(X,D)
Returns the argument X, rounded to a number with D decimals. If D is 0, the
result will have no decimal point or fractional part:
Also, From the mailing list:
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Ryan Fox
-
- Original Message -
From: "Colin Hill" <[EMAIL PROTECTED]>
> So, is there a way to retrieve the version information directly from the
> server using some pseudo SQL query?
show variables lik
e ability to migrate to or support
other databases than MySQL easily.
Hope this helps,
Ryan Fox
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
> ###query the last time where ip='172.017.011.253'
> mysql> select max(THE_TIME) from COLL_DATA where
IP_ADDR='172.017.011.253';
> +-+
> | max(THE_TIME) |
> +-+
> | 2001-11-26 14:35:18 |
> +-+
> 1 row in set (6.77 sec)
> It's too
t does not have a
decryption function. Regardless, a better solution is to change the user's
password to a random string, then e-mail the user their new password.
Hope this helps,
Ryan Fox
-
Before posting, please check:
htt
- Original Message -
From: "Andrew Aragi" <[EMAIL PROTECTED]>
Sent: Friday, January 11, 2002 8:30 AM
Subject: Re: Installation of mySQL on a Win2000 Pro machine
> So pardon my ignorance but what is the difference
> between besides the ">" symbol? What does the
> ">" do. When I use the la
I'm running ok on my Dual PII machine, if this helps anyone.
Redhat 7.1, 2.4.2-SGI_XFS kernel, MySQL 3.23.43.
[root@willyjr /root]# uptime
1:07pm up 95 days, 4:08, 1 user, load average: 0.08, 0.04, 0.01
[root@willyjr /root]# cat /etc/redhat-release
Red Hat Linux release 7.1 (Seawolf)
[root@
Check out select into outfile.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL
ECT
Ryan
- Original Message -
From: "Cindy Yu" <[EMAIL PROTECTED]>
I am new to mysql. I know, in Oracle, when you spool file, then spool off,
this will create a file on your ser
> > Doesn't matter: "If you assign a value to a CHAR or VARCHAR column that
> > exceeds the column's maximum length, the value is truncated to fit."
>
> ok, so it isn't depending on "fixed length" as you first said, and the
> reason for it is just the simple design of sql, right?
As I see it, the
- Original Message -
From: "Damien Buttler" <[EMAIL PROTECTED]>
> I hope someone can help. I have written a PHP script which adds a row to
a
> MySQL table. The columns are all of type 'char'. The script works fine
> when only numerical values are passed, but when I try to pass values a-
34 matches
Mail list logo
