, 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]
= UPDATE Continents SET
CCode='$CCode',Name1='$Name1',Type1='$Type1',Group='$Group',Hemisphere='$Hemisphere',ID1='$ID1'
WHERE CCode='$CCode';
Repeat everywhere you're using CCode without quotes.
Ryan Fox
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
$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 sql statement won't function as desired. :)
Ryan Fox
--
MySQL General Mailing
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 boxes
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 are
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
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 client.
Ryan
- 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 least the
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='poll_id' GROUP BY b.oid
Ryan Fox
- Original Message -
From: Blaster [EMAIL PROTECTED]
However! Here comes the problem, if no vote
* FROM Students WHERE concat(LastName, , , FirstName) LIKE 'Smith,
J%';
Ryan Fox
sql, query, sausage
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
- 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 of
- 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:
snip
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 |
--
| 1 |
- 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(address, username, password);
I tried that and got a
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
- 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-z
A-Z
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)
020717 13:05:05 mysqld ended
But I do see
;
++
| 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,
Ryan Fox, Geek email: [EMAIL PROTECTED
efficiently) use the
index to return the number of rows.
Cheers,
Ryan Fox, Geek email: [EMAIL PROTECTED]
BackWatcher, Inc. web: http://backwatcher.com
-
Before posting, please check:
http://www.mysql.com/manual.php
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 as
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 question
- 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 latter it say
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)
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
, 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:
http://www.mysql.com/manual.php (the manual)
http
###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 slowly
- 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 like 'version';
Ryan Fox
-
Before
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)
To request this thread, e-mail [EMAIL PROTECTED
.
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
()
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 [EMAIL
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,
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 server MUCH qiucker than matching strings).
Hope this helps,
Ryan Fox
32 matches
Mail list logo