Hi,
I'm working on a faculty system and currently I'm building a search
which allows users to generate a list of faculty withint a department
based on their first name, last name, rank, and tenure status. I could
do it without the tenure status criteria however I can't get it work if
the tenure st
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
m
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 t
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 exis
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
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 r
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 t
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:http://lists.m
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]
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 mysq
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 ver
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
Ma
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 (2003-0
[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
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 l
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
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
Rodd
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
http://www.m
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 t
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 parent_datetime
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 [EMAI
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 successf
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
23 matches
Mail list logo
