Re: Linux vs. Windows?

2005-08-12 Thread Dan Tappin
I can't resist... neither Mac OS X! lol Dan T On Aug 12, 2005, at 8:46 AM, Brian Dunning wrote: Same machine, any performance difference? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database equivalent to NorthWind for M$ SQL

2005-08-12 Thread Jeremy Cole
Hi Scott, Is there any database file similiar to M$'s Northwind that I can use to play with? It would be nice if there is one inside MySQL by default for newbies to start out with. Microsoft's document often used Northwind as an example to teach functions. How about FlightStats: http://d

Re: Child-Parent Relationships with 2 Parents

2005-08-12 Thread David Blomstrom
I just thought of a possible solution. Instead of listing all the phyla, orders, classes, families, genera and species in one big table, create separate tables for each taxonomic level. Each taxon would then have two parents. the genus Sus' (pigs) parents would be both the subfamily Suinae and fam

Child-Parent Relationships with 2 Parents

2005-08-12 Thread David Blomstrom
Suppose I want to create an animal kingdom database that gives me the option of displaying the following taxonomic hierarchies: 1) A bread crumbs navigation string, including ALL taxons; e.g. Animalia (kingdom) > Chordata (phylum) > Vertebrata (a SUBphylum) > Mammalia (class) > Eutheria (a SUBclas

Re: Linux vs. Windows?

2005-08-12 Thread Jeremiah Gowdy
MySQL is written with UNIX-like operating systems in mind. MySQL for Windows does not currently take advantage of many of the powerful scalability features of Windows NT based operating systems (2000, XP, 2003), as stated in the documentation. I happen to be one of the people working to make

Re: Complex query. (It's killing me)

2005-08-12 Thread Scott Noyes
> mysql Ver 12.22 Distrib 4.0.20, for mandrake-linux-gnu (i586) With 4.1, it might have been a little easier using some subqueries. But with 4.0, I don't think we can get the results you're looking for in a single query, without some really nasty setup. Part of the issue is that we need to join

spatial extensions - SRID

2005-08-12 Thread douglass_davis
To the powers that be: Can we get a MySql GIS/spatial list?? This is going to be a very popular area (actually it is already). I am trying to use the Spatial extensions to MySql. To be honest PostGIS has many more features, but MySql is my favorite, and on top of that, the applications I

Index - max key length is 1024 bytes

2005-08-12 Thread javabuddy
Thanks Devananda.. it helped. - javabuddy. People are conversing... without posting their email or filling up their mail box. ~~1123878070408~~ roomity.com http://roomity.com/launch.jsp No sign

Re: Index - max key length is 1024 bytes

2005-08-12 Thread Keith Ivey
javabuddy wrote: But still I can't get the part where my column size totals to 560, but MySql complaining that I have exceeded 1024. Did I went anywhere wrong??? Are you sure you've thought your index through correctly and considered how MySQL will use it? What sort of query would such an in

Re: Index - max key length is 1024 bytes

2005-08-12 Thread Devananda
javabuddy wrote: Thanks But still I can't get the part where my column size totals to 560, but MySql complaining that I have exceeded 1024. Did I went anywhere wrong??? - Gana. People are con

Index - max key length is 1024 bytes

2005-08-12 Thread javabuddy
Thanks But still I can't get the part where my column size totals to 560, but MySql complaining that I have exceeded 1024. Did I went anywhere wrong??? - Gana. People are conversing... without

RE: Index - max key length is 1024 bytes

2005-08-12 Thread Gordon Bruce
If you are on a version prior to 4.1.2 the max index size is 500 bytes {not sure why the error mentions 1024} >From section 14.1 of documention The maximum key length is 1000 bytes (500 before MySQL 4.1.2). This can be changed by recompiling. For the case of a key longer than 250 bytes, a larger

RE: Linux vs. Windows?

2005-08-12 Thread Patrick Fowler
Folks, Go with what you know best. If you are a good Windows admin etc go with windows. If you are a good Linux/Unix admin go with Linux. What little performance gain from one or the other will be lost if you do not run a tight ship all around. Performance and stability goes way beyond what OS

Re: upgrade 3.23 to 4.12 slowness

2005-08-12 Thread Jeff Lacki
lack of a primary key was the problem. I am surprised the problem didnt show up in 3.23 but did in 4.12 Thanks for the suggestions! Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Index - max key length is 1024 bytes

2005-08-12 Thread javabuddy
I am trying to create an index with multiple fields. The sixe of each of the column is listed and thier sum is 560bytes. But when I try to create an index with the colums, it complains on the size exceeded 1024 bytes. Below is the query and the size of each.. create index selectTechnologyClubs

Re: BLOB FILES ERRORS

2005-08-12 Thread jose nuno neto
Hi, I've made it work with DUMPFILE but its a BIG workaround for my php aplication: To insert I have to read the file received from the browser $_FILES[tmp_name] placed it in a directory for MySQL to read it, and them insert it into MySQL table with LOAD_FILE To extract I have to use DUMPFILE a

MySQL 5.0.11-beta has been released

2005-08-12 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 5.0.11-beta, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/d

RE: Linux vs. Windows?

2005-08-12 Thread Per Jessen
Pat Adams wrote: > Even though Linux more or less acts like its big UNIX cousins, the nitty > gritty > details of system administration, security, and patching are much difference. Ah, not really. In the *nix world, I first encountered Linux, then HPUX, then AIX, then Linux again, then Solaris

RE: Complex query. (It's killing me)

2005-08-12 Thread James M. Gonzalez
The original sql query returned nothing. 0 rows. The second (with a left join) returned a record for every date avaiable, but a 0 in all others fields. (0 shipments, 0 undelivered, 0 returned, 0 open, etc) Im not sure if we can solve this with a join, since each colum does have a different set of

Re: Complex query. (It's killing me)

2005-08-12 Thread James M. Gonzalez
-Original Message- From: James M. Gonzalez Sent: 12 August 2005 16:58 To: 'Scott Noyes' Subject: RE: Complex query. (It's killing me) Sorry, I will explain myself more clearly: Everyday, we ship packages, and we also receive some packages. The one we receive, has been shipped by us s

Re: Linux vs. Windows?

2005-08-12 Thread Curtis Maurand
Please note that this answer is not meant to support one OS or another, but the information on that page is not useful. The information is seriously out of date. The comparison is on Windows NT not Server 2K3 or XP. The hardware is Pentium Pro 400 or AMD K6II-350 with old versions of softw

Re: Query Help

2005-08-12 Thread Jason Chan
Thanks Scott! "Scott Noyes" <[EMAIL PROTECTED]> ??? news:[EMAIL PROTECTED] ???... > SELECT s.StudentID, StudentName > FROM Student s > JOIN StudentGrade sg1 USING (StudentID) > JOIN StudentGrade sg2 USING (StudentID) > WHERE > sg1.Subject = 'Maths' AND sg1.Grade = 'A' > AND sg2.Subject = 'C

Re: Linux vs. Windows?

2005-08-12 Thread Tim Johnson
* Jay Blanchard <[EMAIL PROTECTED]> [050812 07:32]: > [snip] > On Fri, 2005-08-12 at 09:55 -0500, Jay Blanchard wrote: > > [snip] > > Same machine, any performance difference? > > [/snip] > > > > Yes. Linux will consistently outperform Windows in many areas. > > Except for those areas that it doe

Re: Locking Issue

2005-08-12 Thread Kishore Jalleda
The first thing I would do is to upgrade the Kernel, as per you r mail u said u were running 2.4.20-8, get the latest one for RH9 that is 2.4.20-31.9 SMP, and you might see a huge difference, if it doesn't work, then make sure you have properly indexed the colums, mytop is a great tool for diagnos

RE: Linux vs. Windows?

2005-08-12 Thread Pat Adams
On Fri, 2005-08-12 at 09:30 -0600, Duke, Brian wrote: > Like crashing, auto-rebooting, memory leaking, program cost, etc... > > -Original Message- > From: Pat Adams [mailto:[EMAIL PROTECTED] > Sent: Friday, August 12, 2005 9:21 AM > To: mysql@lists.mysql.com > Subject: RE: Linux vs. Win

Re: Complex query. (It's killing me)

2005-08-12 Thread Alec . Cawley
Sorry - I think you need a LEFT JOIN or it won't count shipments which are not returned. Alec [EMAIL PROTECTED] 12/08/2005 16:38 To [EMAIL PROTECTED] cc mysql@lists.mysql.com Subject Re: Complex query. (It's killing me) Just in the spirit of refining my own skills, here is how I w

Re: Complex query. (It's killing me)

2005-08-12 Thread Alec . Cawley
Just in the spirit of refining my own skills, here is how I would tackle the problem. It parses, but I haven't populated the tables so I don't know if it works: SELECT s.dateshipped, COUNT(r.type="undelivered"), COUNT(r.type = "customer"), COUNT(r.status="open") FROM shipments s JOIN returns r

Re: Complex query. (It's killing me)

2005-08-12 Thread Scott Noyes
> Shipped Undelivered Returned Open > 12/8/2005 143 3 3 Does this mean of the 14 shipped on 12/8/2005, 3 were returned at some later date, or does it mean that you shipped 14 on 12/8/2005, and on that same day 3 unrelated shipments came back, each of which co

Re: Query Help

2005-08-12 Thread Michael Stassen
Jason Chan wrote: > I have a student Table and a SubjectGrade table > > Create Table Student( > StudentID INT NOT NULL, > StudentName VARCHAR(30) > ) > > Create Table SubjectGrade( > StudentID INT NOT NULL, > Subject VARCHAR(30) NOT NULL, > Grade CHAR(1) > ) > > let's say have following record in

RE: Linux vs. Windows?

2005-08-12 Thread Duke, Brian
Like crashing, auto-rebooting, memory leaking, program cost, etc... :) Brian Duke Level(3) Communication ==-=-=-=-=--==--==¬ -Original Message- From: Pat Adams [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 9:21 AM To: mysql@lists.mysql.com Subject: RE: Linux vs. Windows

Re: Query Help

2005-08-12 Thread Scott Noyes
> SELECT s.StudentID, StudentName > FROM Student s > JOIN StudentGrade sg1 USING (StudentID) > JOIN StudentGrade sg2 USING (StudentID) > WHERE > sg1.Subject = 'Maths' AND sg1.Grade = 'A' > AND sg2.Subject = 'Chem' AND sg2.Grade = 'A' > So i have to write 3 join if I have 3 conditions and s

Re: Linux vs. Windows?

2005-08-12 Thread Raz
[snip] > "creakcreakcreak" > - the sound of a rusty old can of worms being opened...;) [/snip] Except when it's already open. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Linux vs. Windows?

2005-08-12 Thread Scott Hamm
On 8/12/05, Jay Blanchard <[EMAIL PROTECTED]> wrote: > > [snip] > I am willing to bet you I can write a more scalable higher performing > socket > server using NT I/O Completion Ports than you can write using Linux's > epoll. > > It you're running a 32 cpu system, Windows will consistently outper

RE: Linux vs. Windows?

2005-08-12 Thread Jay Blanchard
[snip] I am willing to bet you I can write a more scalable higher performing socket server using NT I/O Completion Ports than you can write using Linux's epoll. It you're running a 32 cpu system, Windows will consistently outperform Linux in many areas. My point is, blanket statements like this

RE: Linux vs. Windows?

2005-08-12 Thread Jay Blanchard
[snip] On Fri, 2005-08-12 at 09:55 -0500, Jay Blanchard wrote: > [snip] > Same machine, any performance difference? > [/snip] > > Yes. Linux will consistently outperform Windows in many areas. Except for those areas that it doesn't. [/snip] True. -- MySQL General Mailing List For list archives:

RE: Linux vs. Windows?

2005-08-12 Thread Pat Adams
On Fri, 2005-08-12 at 09:55 -0500, Jay Blanchard wrote: > [snip] > Same machine, any performance difference? > [/snip] > > Yes. Linux will consistently outperform Windows in many areas. Except for those areas that it doesn't. -- Pat Adams Applications Programmer SYSCO Food Services of Dallas s

Re: Query Help

2005-08-12 Thread Jason Chan
So i have to write 3 join if I have 3 conditions and so on, right? "Scott Noyes" <[EMAIL PROTECTED]> ??? news:[EMAIL PROTECTED] ???... > Select s.StudentID, s.StudentName from Student s, SubjectGrade sg where > s.StudentID = sg.StudentID and sg.Subject = 'Maths' and sg.Subject = 'Chem' > and sg.Gr

Complex query. (It's killing me)

2005-08-12 Thread James M. Gonzalez
Hello list, I got a sql query that's is just beating me (5-0). Have have read here and there, and MySQL Query Browser is just fed up with all the tries I have made it do. It is just not working. First, the tables (simplified version, if need more info just tell me): [shipments] ID int DateShippe

Re: Linux vs. Windows?

2005-08-12 Thread Jeremiah Gowdy
I am willing to bet you I can write a more scalable higher performing socket server using NT I/O Completion Ports than you can write using Linux's epoll. It you're running a 32 cpu system, Windows will consistently outperform Linux in many areas. My point is, blanket statements like this aren

Re: Query Help

2005-08-12 Thread Jason Chan
I havn't write my schema clearly , (StudentID, Subject) is the key of SubjectGrade "Philippe Poelvoorde" <[EMAIL PROTECTED]> ??? news:[EMAIL PROTECTED] ???... > Alternatively, use an IN list for the subject, then use a HAVING clause > to limit the results to students with 2 matching rows, like th

Re: Linux vs. Windows?

2005-08-12 Thread dixie
Il giorno 12/ago/05, alle ore 16:46, Brian Dunning ha scritto: Same machine, any performance difference? go to http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/information/ benchmark-results/result-mysql-platform-relative.html anyway the difference isn't only in performance what

Re: Query Help

2005-08-12 Thread Michael Stassen
Arno Coetzee wrote: Jason Chan wrote: I have a student Table and a SubjectGrade table I want to find out students who have got A in both Maths and Chem How the SQL look like? select s.StudentID , s.StudentName from Student as s , SubjectGrade as sj where s.studentID = sj.studentID and s

Re: Query Help

2005-08-12 Thread Jason Chan
Jason Chan wrote: >I have a student Table and a SubjectGrade table > >Create Table Student( >StudentID INT NOT NULL, >StudentName VARCHAR(30) >) > >Create Table SubjectGrade( >StudentID INT NOT NULL, >Subject VARCHAR(30) NOT NULL, >Grade CHAR(1) >) > >let's say have following record in SubjectGrad

RE: Linux vs. Windows?

2005-08-12 Thread Jason Pyeron
On Fri, 12 Aug 2005, Jay Blanchard wrote: Yes. Linux will consistently outperform Windows in many areas. Except Dilbert's boss's approval queue. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Py

RE: Linux vs. Windows?

2005-08-12 Thread Jay Blanchard
[snip] Same machine, any performance difference? [/snip] Yes. Linux will consistently outperform Windows in many areas. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Help

2005-08-12 Thread Philippe Poelvoorde
Alternatively, use an IN list for the subject, then use a HAVING clause to limit the results to students with 2 matching rows, like this: SELECT StudentID, StudentName FROM Student s JOIN SubjectGrade sg ON s.StudentID = sg.StudentID WHERE sg.Subject IN ('Maths', 'Chem') AND sg.Gra

Re: Linux vs. Windows?

2005-08-12 Thread Raz
> Same machine, any performance difference? "creakcreakcreak" - the sound of a rusty old can of worms being opened...;) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Linux vs. Windows?

2005-08-12 Thread Brian Dunning
Same machine, any performance difference? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Help

2005-08-12 Thread gerald_clark
Jason Chan wrote: I am using mysql 4.0.25 with no subquery support : ( "Jason Chan" <[EMAIL PROTECTED]> ¦b¶l¥ó news:[EMAIL PROTECTED] ¤¤¼¶¼g... I have a student Table and a SubjectGrade table Create Table Student( StudentID INT NOT NULL, StudentName VARCHAR(30) ) Create Table SubjectGrade( St

Re: Query Help

2005-08-12 Thread Arno Coetzee
Jason Chan wrote: I have a student Table and a SubjectGrade table Create Table Student( StudentID INT NOT NULL, StudentName VARCHAR(30) ) Create Table SubjectGrade( StudentID INT NOT NULL, Subject VARCHAR(30) NOT NULL, Grade CHAR(1) ) let's say have following record in SubjectGrade 1Math

Re: Query Help

2005-08-12 Thread Scott Noyes
> Select s.StudentID, s.StudentName from Student s, SubjectGrade sg where > s.StudentID = sg.StudentID and sg.Subject = 'Maths' and sg.Subject = 'Chem' > and sg.Grade = 'A' Take a close look at the WHERE clause: "sg.Subject = 'Maths' and sg.Subject = 'Chem'" will never return a result - how could

Re: Query Help

2005-08-12 Thread Michael Stassen
Jason Chan wrote: I have a student Table and a SubjectGrade table Create Table Student( StudentID INT NOT NULL, StudentName VARCHAR(30) ) Create Table SubjectGrade( StudentID INT NOT NULL, Subject VARCHAR(30) NOT NULL, Grade CHAR(1) ) let's say have following record in SubjectGrade 1Maths

Re: Query Help

2005-08-12 Thread Dan Julson
Select s.StudentID, s.StudentName from Student s, SubjectGrade sg where s.StudentID = sg.StudentID and sg.Subject = 'Maths' and sg.Subject = 'Chem' and sg.Grade = 'A' The key here is using the aliases for the tables. The linking of the tables comes in the s.StudentID = sg.StudentID statement.

Re: Query Help

2005-08-12 Thread Jason Chan
I am using mysql 4.0.25 with no subquery support : ( "Jason Chan" <[EMAIL PROTECTED]> ¦b¶l¥ó news:[EMAIL PROTECTED] ¤¤¼¶¼g... I have a student Table and a SubjectGrade table Create Table Student( StudentID INT NOT NULL, StudentName VARCHAR(30) ) Create Table SubjectGrade( StudentID INT NOT NULL,

Query Help

2005-08-12 Thread Jason Chan
I have a student Table and a SubjectGrade table Create Table Student( StudentID INT NOT NULL, StudentName VARCHAR(30) ) Create Table SubjectGrade( StudentID INT NOT NULL, Subject VARCHAR(30) NOT NULL, Grade CHAR(1) ) let's say have following record in SubjectGrade 1MathsA 1PhysB

Minimial settings on Windows XP AND Linux for MySQL server

2005-08-12 Thread Scott Hamm
I would like to install MySQL 5.0.x beta into two computers and test them. They will run Windows XP Home Edition (of course with massive updates and whatsnot) and Linux (SlackWare 10.0 vanilla). I am familiar with Registry Editor and bash shell scripting for /etc start up directory in technical

Re: a question in SERIALIZABLE transaction isolation level

2005-08-12 Thread Gleb Paharenko
Hello. SERIALIZABLE is like REPEATABLE READ, but all plain SELECT statements are implicitly converted to SELECT ... LOCK IN SHARE MODE. In REPEATABLE READ statements like SELECT ... LOCK IN SHARE MODE that use a unique index with a unique search condition lock only the index record found, no

Re: GRANT EXECUTE in MySQL 4.1

2005-08-12 Thread Gleb Paharenko
Hello. EXECUTE is not operational until MySQL 5.0.3. Don't use in 4.1. See: http://dev.mysql.com/doc/mysql/en/grant.html "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > Hi there, > > For some reason, GRANT EXECUTE is possible on the global level, > but not on the database level: >

Re: Locking Issue

2005-08-12 Thread Gleb Paharenko
Hello. Use SHOW PROCESSLIST and slow-query log to catch the query which locks tables for a long time. Upgrade to 4.1.13. If you use MyISAM, think about moving towards InnoDB. Aaron <[EMAIL PROTECTED]> wrote: > Hi all , > > I have been experiencing intermittent locking issues with MY

Re: how to change ft_max_word_len value beyond 254

2005-08-12 Thread SGreen
Bendick Mahleko <[EMAIL PROTECTED]> wrote on 08/12/2005 07:48:27 AM: > Hello Mark, > > I am indexing scientific data, where each word is potentially more than > 255 in length. So the point is, there doesn't seem to be a way to change > the maximum word length (via 'ft_max_word_len' - the para

Re: help with slow query

2005-08-12 Thread SGreen
I know it's bad form to reply to yourself but I just found a major mental mistake in my response. See embedded: [EMAIL PROTECTED] wrote on 08/12/2005 12:18:21 AM: > Sebastian <[EMAIL PROTECTED]> wrote on 08/11/2005 01:19:30 PM: > > > well i managed to solve the problem myself, and im no sql ge

Re: Best practices for deleting and restoring records - moving vs flagging

2005-08-12 Thread Arno Coetzee
Bastian Balthazar Bux wrote: We need to track the modification to the records too so the route has been to keep them all in a different, specular databases. If the "real" table look like this: CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `ts` timestamp NOT NULL default

Re: how to change ft_max_word_len value beyond 254

2005-08-12 Thread Bendick Mahleko
Hello Mark, I am indexing scientific data, where each word is potentially more than 255 in length. So the point is, there doesn't seem to be a way to change the maximum word length (via 'ft_max_word_len' - the parameter defining the maximum length of any word as you pointed out) beyond 255. Wh

Re: Best practices for deleting and restoring records - moving vs flagging

2005-08-12 Thread Bastian Balthazar Bux
Saqib Ali wrote: > Hello All, > > What are best practices for deleting records in a DB. We need the > ability to restore the records. > > Two obvious choices are: > > 1) Flag them deleted or undeleted > 2) Move the deleted records to seperate table for deleted records. > > We have a complex sc

RE: how to change ft_max_word_len value beyond 254

2005-08-12 Thread Mark Leith
> -Original Message- > From: Bendick Mahleko [mailto:[EMAIL PROTECTED] > Sent: 12 August 2005 12:22 > To: mysql@lists.mysql.com > Subject: how to change ft_max_word_len value beyond 254 > > Hello, > I want to index a table using a TEXT value, with length > > 255. I tried changing ft_max_

how to change ft_max_word_len value beyond 254

2005-08-12 Thread Bendick Mahleko
Hello, I want to index a table using a TEXT value, with length > 255. I tried changing ft_max_word_len but each time I check the status of variables, I notice the changes are not taken. It defaults to 254. I am able to change this value to anything below 254. Is there any other way to enforce

Character Set Question

2005-08-12 Thread James Sherwood
Hello, We have installed the newest version of MySql and cannot get it to play nice with French characters. Our older version worked fine. The problem may (or may not) be that when we put the dump into the new database(yes its default charset is Utf8) the default character set for the table is U

FYI: Background info on "visibility of command line arguments"

2005-08-12 Thread Joerg Bruehe
Hi! Some days ago, there was a debate on this list about the visibility of passwords using "ps" if they were given on the command line. I have just come across this text. While it talks about the process name, the info still applies to command line arguments as well: | 1.13 How do I change

Re: GRANT EXECUTE in MySQL 4.1

2005-08-12 Thread Martijn Tonies
> > For some reason, GRANT EXECUTE is possible on the global > > level, but not on the database level: > > "Incorrect usage of DB GRANT and GLOBAL PRIVILEGES" > > > > Has anyone got any idea what EXECUTE should do on a global > > level in MySQL 4.1? > > Martin, > > EXECUTE is specifically for stor

RE: "mysql" database characterset

2005-08-12 Thread Mark Leith
> -Original Message- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: 12 August 2005 10:43 > To: mysql@lists.mysql.com > Subject: "mysql" database characterset > > Hi there, > > Is the "mysql" database always in UTF8 characterset for MySQL > 4.1 and up? > > With regards, > > M

RE: GRANT EXECUTE in MySQL 4.1

2005-08-12 Thread Mark Leith
> -Original Message- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: 12 August 2005 09:40 > To: mysql@lists.mysql.com > Subject: GRANT EXECUTE in MySQL 4.1 > > Hi there, > > For some reason, GRANT EXECUTE is possible on the global > level, but not on the database level: > "Inco

"mysql" database characterset

2005-08-12 Thread Martijn Tonies
Hi there, Is the "mysql" database always in UTF8 characterset for MySQL 4.1 and up? With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www

GRANT EXECUTE in MySQL 4.1

2005-08-12 Thread Martijn Tonies
Hi there, For some reason, GRANT EXECUTE is possible on the global level, but not on the database level: "Incorrect usage of DB GRANT and GLOBAL PRIVILEGES" Has anyone got any idea what EXECUTE should do on a global level in MySQL 4.1? With regards, Martijn Tonies Database Workbench - tool for