Hi All,
I want to know how do I use computations on dates in php or mysql like for
example, today is September 13, 2003 (2003-09-13) and I want to get the date
output if I add 5 days from the given date so that my output would be
September 18, 2003 (2003-09-18). And if any given day falls on a
Does the installation of the PKG itself finish successful?
No problems installing the files, the PKG works fine and everything is as it should be
in /usr/local/
It's essential to start up mysqld before you continue with using
mysqladmin.
When i try to startup the mysqld it works but then I
I have created a user grant all privileges on *.* to user@%
=identified by ' pword' with grant option;
and grant all privileges on *.* to [EMAIL PROTECTED]
=identified by ' pword' with
Hi,
It could be a permission problem on /tmp and/or mysql data directory.
OR You have not mysql internal tables (host, user, etc) in data/mysql.
Try to open a file named (yourhost).err in data directory and see why
mysql ended.
Santino
Does the installation of the PKG itself finish
Robert,
On Sat, Sep 13, 2003 at 08:08:48PM +1200, Robert Morgan wrote:
I have created a user grant all privileges on *.* to user@%
=identified by ' pword' with grant option;
and grant all privileges on *.* to [EMAIL
I have two tables, each with a column of type datetime,
tbl_parent.parent_datetime, tbl_child.child_datetime. Then I want to
count how many children a parent entry have and retrieve the latest
parent entry OR the parent entry with the latest child entry. Therefore
I need to ORDER BY
Our programmer is designing a large scale database and I have some questions.
1) can I create groups, add users and assign privileges to the group?
2) since this system is going over a VPN the data should be encrypt using 3DES. If a
authorized user needs access to the data who is not in the VPN
As far as I know, MySQL Access Privilege system does not allow you to
create groups of users. You can have only users.
Communication between MySQL Server and MySQL client is, normally, NOT
encrypted. You can do that using SSL connections to your server (Mysql4
feature). Check
on 13/9/03 9:57 am, Peter Nguyen at [EMAIL PROTECTED] wrote:
Cause ORDER BY
tbl_parent.parent_datetime AND tbl_child.child_datetime doesn't seem to
work. Any help would be appreciated, thanks.
The AND should be a , thus:
ORDER BY tbl_parent.parent_datetime, tbl_child.child_datetime
Roddie
In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
1) can I create groups, add users and assign privileges to the group?
Yup.
2) since this system is going over a VPN the data should be encrypt using
3DES. If a authorized user needs access to the data
Andy Callan wrote:
When i try to startup the mysqld it works but then I get msqld ended
immediately afterwards, I tried to follow the two posts about that
with the online documentation with no luck. If you need anymore info
just let me know, thanks a lot for your response.
Find the error log
[EMAIL PROTECTED] wrote:
From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like mysqldump --tab or mysql -e
SELECT ... outfile to generate the file
On Sat, 2003-09-13 at 02:50, delz wrote:
I want to know how do I use computations on dates in php or mysql like for
example, today is September 13, 2003 (2003-09-13) and I want to get the date
output if I add 5 days from the given date so that my output would be
September 18, 2003
At 10:21 AM -0400 9/13/03, [EMAIL PROTECTED] wrote:
In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
1) can I create groups, add users and assign privileges to the group?
Yup.
???
How do you create a group in MySQL?
--
Paul DuBois, Senior Technical Writer
At 5:24 PM +0200 9/13/03, karim bernardet wrote:
[EMAIL PROTECTED] wrote:
From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like mysqldump --tab or
At 8:08 PM +1200 9/13/03, Robert Morgan wrote:
I have created a user grant all privileges on *.* to user@%
=identified by ' pword' with
grant option;
and grant all privileges on *.* to
[EMAIL PROTECTED]
please,remove my email from your database
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
We are pleased to announce the new release 2.2.0 of the DBManager
Professional. It is a major bug fix bringing stability and performance to
the application. Also it adds support to SQLite databases and Xbase Tables
which you can manage using the same way you do for MySQL and PostgreSQL. In
next
What I'd like to do is create a textfile and then import the whole thing
into a table. So, naturally, I've a few questions.
Do I need to include the column heads as a line in my textfile, or can I
simply go straight to the data?
Assuming, no column heads are necessary--because they're already
Hi all;
I was given a query today of the following:
SELECT record_id, record_title,artist_name,label_name,record_catalog
FROM record_profile
LEFT JOIN artist_profile,label_profile
ON record_profile.artist_id = artist_profile.artist_id OR
record_profile.label_id = label_profile.label_id
GROUP BY
I'm confused... The 4.1 alpha features says that MySQL now has help files
installed with the server. I did a clean install (Win2K), following all
directions to the best of my ability, and find no help files. I did
discover a SQL file that purported to fill the help files:
fill_help_tables.sql.
At 10:46 PM -0400 9/13/03, Randy_Chrismon/[EMAIL PROTECTED] wrote:
Also, I did a clean install using RPMs on a Redhat 9.0 machine. A straight
install (rpm -Uvh) failed on a bunch of dependencies -- including the fact
that apparently MySQL 3.2.? was installed with Redhat. I did an rpm -e on
the
After installing MySQL 4.1 on a Win2K machine, I tried to run the
mysql_fix_privilege_tables.sql script. I got the duplicate column name
errors which the documentation says I can safely ignore. However, I also
got this error:
ERROR 1064 at line 67: You have an error in your SQL syntax. Check
After installing MySQL 4.1 on a Win2K machine, I tried to run the
mysql_fix_privilege_tables.sql script. I got the duplicate column name
errors which the documentation says I can safely ignore. However, I also
got this error:
ERROR 1064 at line 67: You have an error in your SQL syntax. Check the
24 matches
Mail list logo