Look at:
if ($tenureid=3)
You're not comparing $tenureid with 3, you're assigning 3 to
$ternureid... If you want to compare both values, you must use the
operator == (and not only =).
On Fri, 2003-10-10 at 05:43, Jordan Morgan wrote:
Hi,
I have the following statement:
echo $tenureidP;
Hi,
I have downloaded MySQL 4.0.15 from http://www.mysql.com
http://www.mysql.com and installed it on my Windows 98 (SE) OS .
I used this command to start the MySQL server,
C:\mysql\bin mysqld --standalone
When I run the mysqladmin command from the command prompt
C:\mysql\binmysqladmin
HI Owen
I am not sure about strcmp - I have never used it on numbers before..MySQL
2nd Ed by DuBois PLUG Which is well worth the money - makes me look
intelligent /PLUG says that strcmp sorts lexically...and to be quite
honest, I need to go look that up.. but I think it will work...
However,
Hi Toby
If Apache, PHP and MySQL are all sitting on the same box, try connecting to
the loopback address and see if the problem goes away.
Up until recently, I was running a similar setuo and I always used to
connect to 127.0.0.1 and had no hassles, so I am hoping that this might fix
the
Hi Taylor
To quote from MySQL (2nd ED) by Dubois (pg 725) - InnoDB and BDB tables can
be dumped using mysqldump, just like any other kind of tables.
So the answer is: nope nothing different.
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
There are 10 kinds of people in this
Yes my GRANTAS are ok, and it has also worked before.
The show table status from database_name tells me that they all are
MyISAM.
What to do next, how do I figure out whats wrong, and how do I solve it?
Best regards
Søren
-Original Message-
From: Thierno Cissé [mailto:[EMAIL PROTECTED]
I am not sure if this has any significance - but isn't 31 Dec 1969 the day
before the UNIX epoch (1 Jan 1970 - i think)?
Jordan, how are the dates stored in the database - as dates or unix
timestamps?
Also, the function fixDate isn't in the online PHP manual - is it a function
defined by you? -
We can use SUM(), AVG(), COUNT(), etc. in GROUP clause. These are all
numeric functions. Is it possible to use string functions as well? I
know MIN() MAX() can be asciibetical for string fields, but wouldn't
this be very handy/practical?
SELECT division,
G_CONCAT(, ,first_name) as nicks,
Apologies for any confusion - wrong list. Should have gone to PHP-DB
instead.TGIF.
- Original Message -
From: Rory McKinley [EMAIL PROTECTED]
To: O Franssen [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, October 10, 2003 9:14 AM
Subject: Re: Re[2]: [PHP-DB] MySQL Regular
Hi Caspar
Also try phpbuilder.com, and zend.com. Alternatively, try googling PHP
tutorials.
Regards
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
There are 10 kinds of people in this world,
those who understand binary and those who don't (Unknown)
- Original Message
I found a bugreport that i though might have a saying here (only an idea,
was not sure at all), and therefore I installed 4.1.0-alpha and started from
scratch again, and then when I did a LOAD DATA FROM MASTER; I now got this
(maybe this info helps you guys to help me, I sure hope so because Im
When end-user use MySQL with any non-GPL licensed program , he must buy
commercial MySQL license.
Or
If you want support from MySQL AB, you need commercial license.
It's very easy and elastic.
özgür
- Original Message -
From: Rob A. Brahier [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Here are some hard examples to help:
It is certainly usable on an old PC eg 200MHz Pentium 2 with linux and 32Mb
RAM. Obviously the performance will be proportional to the hardware, but
MySql is designed to be able to run on low level hardware. If you just want
to play around with the database,
Christopher L. Everett [EMAIL PROTECTED] wrote:
The online manual at http://www.mysql.com/doc/en/Replication_Options.html
says that these two variables:
max-relay-log-size=#
relay-log-purge=0|1
exist to control the size of the relay log. But when I try to start my
slave server
with:
When end-user use MySQL with any non-GPL licensed program , he must
buy
commercial MySQL license.
Nope. Only If you distribute Mysql with your non gpled commercial
application. Then you need to get commercial licenses for each copy you
sell.
You can use GPL Mysql with Non GPL program as far
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours
Shaun
Not a 100 % sure if this is what you're looking for or if somebody's already
suggested it also do not know how practical it is for your application
If a booking spans more than one day (e.g. two) split it into two days - and
write two records to the table one for each daythis
oh thanks! I guess that's why I'm a newbie.
Diana Soares wrote:
Look at:
if ($tenureid=3)
You're not comparing $tenureid with 3, you're assigning 3 to
$ternureid... If you want to compare both values, you must use the
operator == (and not only =).
On Fri, 2003-10-10 at 05:43, Jordan
The date is stored as dates instead of timestamps. Yes, that fixDate function is
defined by me and it worked great with other dates I have stored. I'm really
thinking my dropdown fields for the MM, DD, and on the data entry page has
somethng wrong with it.
do you think so?
ps: thanks for
I have been using ODBC v3.51 to select from MySQL DB's hosted by a RH v7.2 Linux VM
from within an application script. The DB's are normally imported in the early morning.
I now have a need to Insert into a table from an application script. The insert works
when submitted through phpMyAdmin.
Hi Paul
If all the tables have a primary key set, you can do an INSERT IGNORE from
the tables in System A to the tables in System B (either manually or write a
script).
Any rows form System A that already have a System B equivalent will be
silently dropped and only those that do not have an
Hi !!
Whenever i create a database user using GRANT command, mysql add a register inside the
user table in mysql database. I've noticed that if i use REVOKE to revoke all
privileges from that user, mysql does not delete the register from user table, but
denies every permission for that user.
Shane,
Maybe I can lend a hand.
When you first install MySQL, there is (basically) only one user root. The
root user exists without a password, which is why pretty much everyone
recommends that you assign root a password immediately. You're first
command:
mysqladmin -uroot password password
That's how I do it. Take the user out of both the user and db tables.
-Original Message-
From: Alejandro Javier Pomeraniec
[mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 6:33 AM
To: [EMAIL PROTECTED]
Subject: deleting mysql users
Hi !!
Whenever i create a database user using
I had an odd issue happen with one of our MySQL Servers last night
(4.0.15a-max), and I'm wondering if anyone might be able to shed some
light on the issue.
I noticed the issue as one of the clients that connects to the server
started receiving Too Many Connection and/or Could not create new
If you are looking at PHP, may I suggest the PEAR DB URL:
http://pear.php.net family of classes? It implements functionality that
I imagine is similar to perl's DBI interface.
?php
require_once('DB.php');
// Note that database backend can be specified.
$db =
Alejandro Javier Pomeraniec [EMAIL PROTECTED] wrote:
Whenever i create a database user using GRANT command, mysql add a register inside
the user table in mysql database. I've noticed that if i use REVOKE to revoke all
privileges from that user, mysql does not delete the register from user
Scott Brown [EMAIL PROTECTED] wrote:
DROP TABLE IF EXISTS t;
CREATE TABLE t (ts TIMESTAMP, i INT);
INSERT INTO t (i) VALUES(0);
SELECT * FROM t;
At this point, the timestamp field is un-interpretable. SELECT returns
-00-00 9:01 AM
UPDATE t SET i = i + 1;
SELECT * FROM t;
Thanks !!
Do you happen to know why mysql decided not to erase those users??
On Fri, 10 Oct 2003 17:07:12 +0300
Victoria Reznichenko [EMAIL PROTECTED] wrote:
Alejandro Javier Pomeraniec [EMAIL PROTECTED] wrote:
Whenever i create a database user using GRANT command, mysql add a
Steps:
Step 1: Download and install the MyODBC software from the MySQL website.
Step 2: Configure a DSN to connect to your MySQL server.
(This can be achieved by going to
Control Panel = Data Sources (Win98, ME) or
Control Panel = Administrative Tools =
If you are running version 4.1, you can use a sub-select.
INSERT INTO table2 SELECT table1
WHERE IDs IN (SELECT IDs FROM /* this may be the one with left joins */
table3)
Thanks
Emery
- Original Message -
From: Nobody [EMAIL PROTECTED]
To: PAUL MENARD [EMAIL PROTECTED]; [EMAIL PROTECTED]
David Garamond [EMAIL PROTECTED] wrote:
We can use SUM(), AVG(), COUNT(), etc. in GROUP clause. These are all
numeric functions. Is it possible to use string functions as well? I
know MIN() MAX() can be asciibetical for string fields, but wouldn't
this be very handy/practical?
SELECT
I have just installed latest version of MySQL on
RedHat 8 and am trying to get mysqladmin to run. I
have run the mysql_install_db and set the root and
host passwords. I am able to log in to regular mysql
ok and issue commands. But whenever I try to use
mysqladmin to check version status etc. I get
Alejandro Javier Pomeraniec [EMAIL PROTECTED] wrote:
Thanks !!
Do you happen to know why mysql decided not to erase those users??
It's how REVOKE works. REVOKE doesn't remove user entry from the table 'user'. From
version 4.1.1 you can use DROP USER command to delete user:
Hi Dora!
It depends what are you looking for. I can help you in Java via Netbeans
(TM), or look on the netbeans.org mailing list, where is a subject proposed
by me, and I have answers directly from sun.
Best regards
On Thu, 9 Oct 2003 18:40:25 -0400, Dora wrote
Thank you. I'd like to do it
I think it is because the REVOKE command is for stopping some user
PRIVILEGES and not removing the user from the system.
In fact we always tell MySQL to REVOKE some/all rights from some/all
databases.
We don't tell it to remove the user or change his/her PASSWORD.
Maybe MySQL should implement a
I am building a SELECT using a left join and I almost have what I want.
One of the fields that gets sucked in from the left join is either null
or has a value in it.
if it is null I only want to include the rows from the main table where
the field isdemo=1
if that field has a value in it I
Hi everyone,
I'm using an Access database and trying to use a macro to export to a text
file for mysql. It's no problem to export to a text file, but it's in a
format that mysql won't recognize. I know it just needs to be formatted on
export a little but the macro options aren't available for
Use myodbc
www.mysql.com/downloads/api-myodbc.html
Best regards
On Fri, 10 Oct 2003 12:34:48 -0400, Montagna, Dan wrote
Hi everyone,
I'm using an Access database and trying to use a macro to export to
a text file for mysql. It's no problem to export to a text file,
but it's in a
I have a simulation of moving objects that interact with each other. If
I store the object positions as coordinates, I think I will need at
least one database call for every object to determine intersections.
[for N objects there are N database calls]
I'm wondering if I could do the same thing
I have two columns in a table, both timestamp(14). The first one holds
a start date and the second one holds an end date. Is there any built
in mysql function to subtrack timestamp1 from timestamp2 and get the
elapsed time between?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives:
I am trying to create a script that will insert data. Right now I am just
using something simple to test this out, but I can't get it to work. Here is
what I have.
mysql --user=root --password= Database_Name;
INSERT INTO table_name (column_name) VALUES (value);
After I run the script, I
Put the full path to mysql in the script...
Jeff
-Original Message-
From: Mike Tuller [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 1:07 PM
To: [EMAIL PROTECTED]
Subject: Shell Script to Insert Data
I am trying to create a script that will insert data. Right
now
The first line starts mysql.
When mysql exits, the second line does nothing, as it is not a valid
shell command.
try :
echo 'INSERT INTO table_name (column_name) VALUES (value)' | mysql
--user=root --password= Database_Name
Or put the second line in a file, and cat the file through a
This is a bit vague.
How about showing what you have done, and how it is not what you wan't.
Colleen Dick wrote:
I am building a SELECT using a left join and I almost have what I want.
One of the fields that gets sucked in from the left join is either
null or has a value in it.
if it is null I
Mike Tuller wrote:
I am trying to create a script that will insert data. Right now I am just
using something simple to test this out, but I can't get it to work. Here is
what I have.
mysql --user=root --password= Database_Name;
INSERT INTO table_name (column_name) VALUES (value);
After I
--- Carol Andrejak [EMAIL PROTECTED] wrote:
Date: Fri, 10 Oct 2003 10:40:53 -0700 (PDT)
From: Carol Andrejak [EMAIL PROTECTED]
Subject: Re: Error trying to start mysqladmin
To: Carol Andrejak [EMAIL PROTECTED]
While I've been waiting, these are the other things
I
have tried:
I deleted
SELECT UNIX_TIMESTAMP(timestamp2)-UNIX_TIMESTAMP(timestamp1) as
difference from table;
gives you the time in seconds between the 2
SELECT
sec_to_time(UNIX_TIMESTAMP(timestamp2)-UNIX_TIMESTAMP(timestamp1)) as
difference from table;
gives you the time in Days+HH:MM type format
see
The way I usually do it is this..
I have a shell scipt called query
It contains:
/fullpath/mysql --user=root --password= Database_Name
I then make new scripts for the queries as such:
(query file name: Select_all.sql)
Select * from Table where blah=foo;
To run this I then execute
Hey
Just wanted to know...which are the most popular
English language ,agazines and journals read by MySQL
community?
Just curious...maybe i will subsribe to it.
Karam
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Hey
Just wanted to know...which are the most popular
English language magazines and journals read by MySQL
community?
Just curious...maybe i will subsribe to it.
Karam
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
from allpossibledates
left join daily_rate on allpossibledates.date=daily_rate.date
where date between 20030901 and 20031010
and daily_rate.date is null
The problem is I don't know how to generate allpossibledates easily on
the fly.
I am running 3.23.58 and can't upgrade to the latest
Hi Group,
I'm requesting feedback - should I use MyISAM or Innodb tables, or a
mix? My database (currently in Sybase) typically gets no larger than 50
gigs, but 99% of the data is in one table.
(The app is an cleanroom monitoring system, we collect 3-5,000 records a
minute from environmental
I was wondering if anyone had any tricks on the best way to handle
localizing time zones in MySql?
For example, all my datetime data is stored as GMT. I have written
tools to query the data based upon whatever local time zone you want
to use. So, for example if I query for 2003-10-1 to
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Holly Chamberlain [mailto:[EMAIL PROTECTED]
--Sent: Friday, October 10, 2003 11:01 AM
--To: [EMAIL PROTECTED]
--Subject: What do you
On 10 Oct 2003 at 14:12, Graeme B. Davis wrote:
BUT, I've run into a problem when you want to GROUP BY
DAYOFYEAR(datefield) for example, I want it to do the grouping by EDT
and not GMT -- is this possible?
You say you've already got the necessary time zone offsets, right?
So can you use
Dear list:
I`m trying to insert some values into my table but I received a error
message when I type::
INSERT INTO TABLE admin VALUES ('admin',ENCRYPT('system'),15,0);
The error said:
Error 1064: You have an error in SQL syntax.
Could someone help me to clarify the correct syntax for
First, don't use the word table in an insert into statement (e.g. `INSERT
INTO tbl_nm (col_1, col_2, col_3) VALUES ('a', 'b', 3)` where tbl_nm is the
name of a table in the database and col_1, col_2, etc. are names of columns
in the specified table). Second, ensure the number of columns your
I think your INSERT syntax is wrong. There is no TABLE in the syntax.
It has to be INSERT INTO admin VALUES .
- Shanta
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: ENCRYPT Syntax problem
Well, I have been playing around some, partly in the files, other times with
other ccommands see what happens. Well I decided to delete the entire
directory, and try again. As I was watching the configure to go through
it's thing, I got a interesting error at 21985 - unknown command and at
21988
Hi all,
I have been working on getting MySQL going all day.
Initially I had it working but had problems with
mysqladmin. Figured that one out shutdown the server
and tried to restart but I now have an error. This is
what I found in my errorlog. In looking at the
documentation I think I have to do
Are you using symlinks?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Carol Andrejak [mailto:[EMAIL PROTECTED]
--Sent: Friday, October 10, 2003 1:04 PM
--To: mysql
--Subject: Cannot
Can SQL statements evaluate expressions? I want to store thousands of
equations, and return a subset when I plug in a value.
For instance, if I stored the following two equations:
x = y + 5;
x = 100 / y;
I might want to query for all records whose x is less than 10 when y is
equal to 3. I'd
I don't know of any, although I never thought about it much. I'd be
interested.
On Friday, October 10, 2003, at 01:58 PM, Karam Chand wrote:
Hey
Just wanted to know...which are the most popular
English language magazines and journals read by MySQL
community?
Just curious...maybe i will
This may be a Linux/Redhat question instead of MySQL -- I just
installed MySQL 4.0.15 on my RedHat 9 box. Runs fine but there's only
6 Gigs free on the drive. So, I have a new 60 gig drive I can use. My
question is can I mount the drive temporarily some place, copy the
entire contents of
---Original Message-
--From: Randy Chrismon [mailto:[EMAIL PROTECTED]
--Sent: Friday, October 10, 2003 1:51 PM
--To: [EMAIL PROTECTED]
--Subject: Adding space to /var/lib/mysql
--
--This may be a Linux/Redhat question instead of MySQL -- I just
--installed MySQL 4.0.15 on my RedHat 9
from
select date,123.45
from allpossibledates
left join daily_rate on allpossibledates.date=daily_rate.date
where date between 20030901 and 20031010
and daily_rate.date is null
The problem is I don't know how to generate allpossibledates easily on
the fly.
I am running 3.23.58
Tried to do a load of data from a file in my home directory on Linux.
Got this message:
ERROR 13: Can't get stat of
'/home/rchrismon/mysql/ArchiveEC02-Invoices.txt' (Errcode: 13)
What does this mean and what can I do about it?
Thanks
Randy
--
MySQL General Mailing List
For list archives:
/usr/local/mysql/bin/perror 13
Error code 13: Permission denied
Check your file permissions.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Randy Chrismon [mailto:[EMAIL PROTECTED]
Thank you for the responses we've been spoiled by using sybase SQL
Anywhere in that the entire database is stored in one file. I'm worried
about having our service people, many of whom are in asia and for whom
english is a second language, suddenly having to deal with about 300
files for the
=daily_rate.date
where date between 20030901 and 20031010
and daily_rate.date is null
The problem is I don't know how to generate allpossibledates easily on
the fly.
I am running 3.23.58 and can't upgrade to the latest versions yet due
to incompatibilties with the timestamp formats that were
Okay, after reading the MySQL manual I figured out how to get what I
want. Can anyone advise me where to send such newbie questions in the
future so that I would get a response? I realize my question was a SQL
database question and not a MySQL-specific database question, but I
figured the
Updating on my progress on getting it to work. I did get the errors fixed,
there were 3 in the end that needed to be fixed. Pretty much I had to
remove a space in 2 spots, I think at 21985 and 21986 if I am correct, more
of there was a space on the lines assigning a value to a varable. The
On Thu, Oct 09, 2003 at 06:41:42PM -0400, Dora wrote:
I m open to suggestions. I use HTML and JavaScript regularly. If I
have some sample code I could hack it do what I need. My website is on
a UNIX CGI plant form.
I'd suggest PHP. Perl, PHP and to a lesser degree, C and Python, are the
74 matches
Mail list logo