>$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
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&#
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]
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
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 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 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 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
- 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
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
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
---
- 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
- 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: "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: "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
> 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: "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-
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)
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
-
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,
> 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
> > 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
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
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@
- 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
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
> ###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
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)
- 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 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
-
()
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
> 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
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
#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
34 matches
Mail list logo
