Installing from SOURCE or from RPM: your recommendation

Hi group? What do you recommend someone who wants to install MySQL on RedHat? Using RPMs or installing from SOURCE? What are the main differences and/or benefits? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone:

4.1.1 not an update or upgrade of 4.1.0

Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1 When the SUB-SELECT contains more than one field, it does not work (this works very well with 4.1.0 ) For example: SELECT field1 FROM Table1 WHERE (field2,field3) IN (SELECT field2,field3 FROM Table2) The above quer

Re: Problem with LPAD() function

CTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 12, 2004 12:36 Subject: Re: Problem with LPAD() function > "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: > > > I think there is a bug in LPAD() function. > > > > Just try to run this quer

Re: New grant tables

Check the User `table` of the `mysql` database If the Password column is 45 characters long, it has changed it. Hope I remember it correctly. Thanks Emery - Original Message - From: "Scott Haneda" <[EMAIL PROTECTED]> To: "MySql" <[EMAIL PROTECTED]> Sent: Sunday, January 04, 2004 03:37 S

Problem with LPAD() function

I think there is a bug in LPAD() function. Just try to run this query: SELECT LPAD(12, 3, '0'); This will correctly return 012 as expected. But when I run SELECT LPAD(512, 3, '0'); It doesn't return 512, instead it returns special characters. With that situation I

Re: odbc

ODBC does not need to be installed on the server machine. It is only needed on the client. So, it is possible to use Access to connect to the MySQL server even though the ODBC is not installed on the server. Just install MyODBC on the client machine and tell Access to connect through ODBC. You may

Re: Knowing the real size of a column

Yes, I am using ADO. But, I wanted to know the size so that the application may decide to download the content. I wanted to download the content if its size is below 1MB. ADO will know the size after downloading it; is it right? I might be wrong!!! Thanks Emery - Original Message - From:

Re: Knowing the real size of a column

ent: Thursday, January 08, 2004 18:06 Subject: Re: Knowing the real size of a column > "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: > > Does anyone know of a simple way of knowing the real size of a column. > > Currently I am interested in knowing the s

Knowing the real size of a column

Hi group, Does anyone know of a simple way of knowing the real size of a column. Currently I am interested in knowing the size of data stored in a BLOB column. I have tried BIT_LENGTH() but this one does not seem to return the real size. Thanks, __ NZEYIMANA Emery

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

Loosing one table [one data file] is less affecting than 10. My view is that MySQL is good because it uses different data files. If one data file gets corrupt, you will loose less information since it is only one table [meaning one data file] that is affected. I am not an expert though!! J

Re: What is code and what's not?

your password should replace Your hostname should replace `hostname` Hope this helps Thanks Emery - Original Message - From: "Lost Idols" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 06, 2003 00:06 Subject: What is code and what's not? > I found a script on this

Happy new year

Just to wish you a prosperous new Year. My wishes go to the special guys of the MySQL and related software development team[s]. May the coming year bring you happiness and more innovative and productive ideas. May your families be the happiest on this earth! May this year protect you against homo

Re: problem trying to connect to MySQL server

Maybe port 3309 is not open on the firewall or there is no rule set for it or it is blocked. I am not a network expert though!!! Thanks Emery - Original Message - From: "Jon Miller" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, December 29, 2003 13:44 Subject: pro

Re: Not able to connect to mysql by mysql_connect()

If you are the one controlling the MySQL server, do one of the following: 1. Shorten the Password Column of the mysql.User table 2. Change your password to use the old passwords (you may use SET password=OLD_PASSWORD('your_password'); 3. Put the option --OLD-PASSWORDS in your options file 4. Update

Re: newbie question about calculations

Why do you want to store the results of a calculation? Don't store the results of a calculation, instead do the calculation when you are retreiving data. For example "SELECT field1, field2, field1 + field2 AS sum_of_the_two_fields FROM your_table" Also, it is a good idea to give good names to your

Re: Forms & Reports like I use in MS Access

Me I use VB for the front end development and MySQL for the database. I use ADO to connect to the database through MyODBC. When you use VB to connect to a MySQL database, there are two things that will change: * the connection string * the cursor location will be set to adUseClient. Read the MyOD

Re: Column name: CHECK

Have tried to use back sticks? Like `check` Thanks Emery - Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 24, 2003 16:41 Subject: Re: Column name: CHECK > > > I use the column name CHECK (smallint), but when I insert into

MySQL 4.1.1 is released

For those who are interested like me: MySQL 4.1.1 is released. Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nef

Re: Client does not support authentication protocol requested by server

You will need to start MySQL with --OLD-PASSWORDS option. Or simply put OLD-PASSWORD in [mysqld] section of your options file. Or when creating your passwords, make sure you update the password column using OLD_PASSWORD() function. For example, UPDATE mysql.user SET password=OLD_PASSWORD("your_p

Non-conditional LEFT JOIN

Hi group, I want to do a LEFT JOIN that takes no condition. For example I have the following tables: table_1table_2 --- - 1A 2

Re: MyODBC and MySQL 4.1

I have found the issue. It is talked about at the URL http://www.mysql.com/doc/en/Password_hashing.html The question now is When Will MyODBC support that new hashing? Thanks Emery - Original Message - From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> To: "abai

MySQL separate downloads

Hi group, This is not a problem as such but a limitation. I have a problem with downloading MySQL due to its download size. Can someone tell me where I can get MySQL in separate files? For example I am interested in only the standard MySQL binary for WinNT (mysqld-nt.exe) But, I cannot find where

Re: MyODBC and MySQL 4.1

l.exe will login without any problem. I think it's a compatibility issue. Thanks Emery - Original Message - From: abaid al-mutairy To: Director General: NEFACOMP Sent: Saturday, November 29, 2003 08:30 Subject: Re: MyODBC and MySQL 4.1 To create a new user use

Re: MySQL users.

hing in DB table and restart. Hope this helps. Thanks Emery - Original Message - From: "m i l e s" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Sent: Saturday, November 29, 2003 02:26 Subject: Re: MySQL users. > Emeyr >

Re: MySQL users.

Use GRANT ___your_permissions on database[s] to 'username'@'%' IDENTIFIED BY 'his/her password' % will be used if you don't want to restrict that user on a given host or network Otherwise, use 'username'@'host_name_or_ip_address' like 'emery'@'192.168.0.50' if you omit the @ part, MySQL will

MySQL 4.1 binaries

Hi group, I have a problem that I think is not very serious. All the MySQL 4.1 binaries I downloaded from the MySQL website appear to be max versions!!! Ok, their names are mysqld-nt, mysqld, ... but when I do SELECT version() I always get something containing a MAX thing. I remember

MyODBC and MySQL 4.1

Hi groups, does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new passwords? When I create a password using PASSWORD( ), I can only login using the MySQL client (the one that comes with MySQL). But if I create the password using OLD_PASSWORD( ), I can login from both my

Re: mysql_fix_privilege_tables script

The Manual does not talk about that problem. For example I have been forced to no longer use GRANT because it creates a password with * thing at the beginning. Instead, when I access the user table directly and use OLD_PASSWORD instead of using PASSWORD, my clients login with no problem. It seems

Re: Adapting a Select statement to MySQL

Have you tried WHERE ytd_sales >= 4095 AND ytd_sales <=12000; Also, you may try adding ( ). They sometimes help. Thanks Emery - Original Message - From: "Nitin" <[EMAIL PROTECTED]> To: "Jim Bartram" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, November 04, 2003 08:30 Subj

Re: System time vs MySQL time

I think one of OS or MySQL uses GMT. Just check it out. I have had a similar problem with a VoIP Router. What is your time difference with GMT? Are you at GMT-12 or +12? I am not an expert though Thanks Emery - Original Message - From: "Gordon" <[EMAIL PROTECTED]> To: <[EMAIL

Re: Deleting from multiple tables

What version of MySQL are you using? Ver 4.1 supports sub-queries. So, you may issue: DELETE FROM table2 WHERE msg_id IN( SELECT msg_id FROM table1 WHERE ((TO_DAYS(NOW()) - TO_DAYS(date_column)) > 45) ) Thanks Emery - Original Message - From: "Luis Lebron" <[EM

Re: making specific query for big data

I don't understand well. Are you looking for the MAX value of a column? Or its data size? Thanks Emery - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 23, 2003 12:21 Subject: making specific query for big data > Hello all.. > > so > Is it p

Re: MySQL 4.1 subqueries!

It does, I executed the following and it worked: SELECT * FROM table1 WHERE (field1, field2) IN (SELECT field1, field2 FROM table2) I think your problem is that you used constants (1,2,3) instead of using fields. Also I don't know if the fields don't need to be of the same type. I just need to ch

Re: Update Syntax

Note that REPLACE deletes before inserting!! Very dangerous. If you cannot use UPDATE ON DULICATE KEY UPDATE ... then do the following: You will need o send two queries to the server: INSERT IGNORE INTO tbl ..; UPDATE tbl SET ..; Explanation: - the first query will try to insert the r

Need a Tutorial on RAID with MySQL

Hi group, Does anyone know of a good tutorial on RAID? When used with MySQL. Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED]

Re: type data

If you want to save your BMP picture in the database and save the extension as well you will need separate fields. One for the picture content (BLOB) and another one for the extension (CHAR or VARCHAR as Egor said) Thanks Emery - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]>

Re: SELECT 9 BETWEEN 1 AND 0

I am sorry to say that your question is not clear. Why don't you send us a simple Table with few data and what you want to achieve in simple terms? I mean a more clear question!!! Have tried using IN(). In your subject, you said 9 BETWEEN 1AND 0? I am confused. Thanks Emery - Original Mes

Re: Starting the mySQL Server

an installer? Or you just unzipped the files? Both methods should work on Windows. Try to reinstall and see if the problem will be solved Thanks Emery - Original Message - From: "Larry Wasserman" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[E

Re: Starting the mySQL Server

That is one of the tables in MySQL database (for privileges and other server stuffs). It is located in MySQL DATA --->mysql ---> MySQL data is the directory containing all data. On windows systems that is normally c:\mysql\data So the table file should be in c:\mysql\data\mysql Thanks Emery

Re: Getting remote connected machine as value in a select.

list may help on this issue. Also as I told you, I don't know the difference between USER() and SESSION_USER() Thanks Emery - Original Message - From: "Chris Faust" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PRO

Re: Error 1045

Add the -p option to tell mySQL to ask for a password. For example c:\mysql\bin\mysql -u root -p Or if you want to give the password without a prompt c:\mysql\bin\mysql -u root -p YourPassWord Or if you are connecting on another Server c:\mysql\bin\mysql -u root -h RemoteServerAddress -p Hope

Re: Getting remote connected machine as value in a select.

I don't know I well understand your problem. There is a function SESSION_USER() in MySQL that returns the currently connected user. The user string also returns the host from which he connected in the form [EMAIL PROTECTED] So, by issuing the query: SELECT SESSION_USER(), Table.* from Table yo

Re: select in inverse order

The best method will be to adda TIMESTAMP. But if you are sure that no record gets DELETEd you may use the following procedure. CREATE a temporary Table to store the records you want to use. That temp table needs to have a key or ID. SELECT from that temp table and order using that ID. But I will

Java related

Hi group, I wanted to start learning programming in JAVA. What do you think is the right discussion group or mailing list for starters? I have never touched JAVA. Can someone advise on what software I should install? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computi

Re: Check for data before inserting

REPLACE replaces the row (as in English). That means it first DELETEs the row before inserting!!! Very dangerous. Use INSERT ... ON DUPLICATE KEY UPDATE ... Thanks Emery - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Simon Green" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECT

Re: Hotmail

Je ne vous comprends pas - Original Message - From: "André Thibault" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 15:01 Subject: Hotmail IMPOSSIBLE DE RECEVOIR MON COURRIER SUR HOTMAIL DEPUIS AU MOINS UNE SEMAINE...?? [EMAIL PROTECTED] MERCI

Re: error message

Normally it's a good habit to explicitly name the columns. But it also works whithout naming them in the INSERT instruction when you are inserting exactly in all the columns. Thanks Emery - Original Message - From: "Gregory Norman" <[EMAIL PROTECTED]> To: "

Re: error message

That error means that the number of columns in the table is differnt from the number of columns you are sending for insert. For my system (4.1.0) I have got 14 fields. For your query, you are trying to insert 12 fields. Normally this should work even if the the number of fields is different and the

Re: network interfaces

What if you want it to listen to two or three interfaces (I mean not all interfaces but on more than one interface). Can one separate the addresses by Commas? Each on a new line???/ Thanks Emery - Original Message - From: "Matt W" <[EMAIL PROTECTED]> To: "Dan Jones" <[EMAIL PROTECTED]>; <

Re: from char to Date routine

Me, I will say that such a function should be added as a feature request since it doesn't exist. MySQL 4.1.1 introduces MAKE_DATE() The following can be read from http://www.mysql.com/doc/en/Date_and_time_functions.html MAKEDATE(year,dayofyear) Returns a date, given year and day-of-year values. da

Someone asked it some time back

Hi group, Someone asked a question about how he could change a column name and have his old application continue using the same table while he is updating the client. This means: He has a table with columns: ColA, ColB and he is forced to change the columns names into ColX, ColB and possibly the

Re: Challenging query....

I think it is: SET @a:=0; /* SELECT would return the value. Of course it would work but */ SELECT @a:[EMAIL PROTECTED], blah, blew from table where blah > 1; Thanks Emery - Original Message - From: "Diana Soares" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 16

Re: Check for data before inserting

The REPLACE statement is very dangerous since it first DELETEs the row if found. Instead you should use : INSERT . ON DUPLICATE KEY UPDATE Check the manual for clearer syntax But this one will work if the INSERT would create a Duplicate Key entry (I mean, would violate the index or p

Re: LIMITS

I think you should use something like LIMIT 50, 15 Check the manual for the correct syntax. (http://www.mysql.com/doc/en/SELECT.html explains it better than me) Thanks Emery - Original Message - From: "Cummings, Shawn (GNAPs)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, O

Re: Temporary table question

Also, sometimes one needs to copy the content of a table in itself but earlier versions of MySQL don't support something like INSERT INTO some_table SELECT * FROM some_table /* the select table and insert tables are not different */ So, you may create a temporary table, fill it with the info you

Re: PASSWORD() function problem

Hi, If I remember, ENCODE() is reversible using DECODE() or something similar. I might be wrong, just check the manual!!! Thanks Emery - Original Message - From: "Nitin" <[EMAIL PROTECTED]> To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 16:

Re: PASSWORD() function problem

PASSWORD() is a one-way function (I was confirming just). Though, it has worked for you, please consider the advice of Paul in his previous Email when he recommended you read about PASSWORD() at the URL: http://www.mysql.com/doc/en/Miscellaneous_functions.html Thanks Emery - Original Message

Re: MySQL 5.0 and Stored Procedures

Can you please provide me with the direct link to those PDFs? I have worked with Stored Procedures on MS SQL but have not yet played with them on MySQL. I first want to read about them even before I download the supporting version. Thanks Emery - Original Message - From: "Bob Brands" <[EM

Re: not found driver 3.51 not found

Maybe installing MyODBC 3.51.06 will solve the problem. I am not sure. Thanks Emery - Original Message - From: "miguel solorzano" <[EMAIL PROTECTED]> To: ".eric" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 05:16 Subject: Re: not found driver 3.51 not found

Very interesting MySQL usage Article on ComputerWorld website

Hi group, I just read the first news item on the MySQL website and thought some of you might need to read about it as it is very interesting for those who use MySQL for hi end transactions. This gave me more powers in choosing MySQL as my favorite DBMS. Just go to http://www.mysql.com or http:

Re: connexion avec un pocket pc

Also check the [EMAIL PROTECTED] list. It is very helpful Thanks Emery - Original Message - From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> To: "scr informatiques" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 14, 2003 11:07

Re: creating a new table from a SELECT

In the docs, search for CREATE TABLE syntax. There is something like CREATE TABLE tbl_name SELECT some_fields FROM some_table WHERE where_condition I don't remember exactly but you should find useful information in the docs of the MySQL website. Thanks Emery - Original Message -

Re: deleting rows which table1.row=table2.row

I think the question is not very clear. Do you want to delete from all the tables or you just want to delete from one of the tables? Does your MySQL version support sub-queries? (Is it Ver 4.1.x ?) I saw some replies to your question, did they solve your problem? I am asking this because a DELETE

Re: connexion avec un pocket pc

Des articles de Mike Hillyer peuvent t'aider. Son site est http://www.vbmysql.com Vous aurez besoin d'un Connecteur ODBC pour utiliser Visual Basic. MyODBC est tres simple a utiliser. Il peut se telecharger depuis le site de MySQL (http://www.mysql.com) Mais le site est en Anglais. I can ask and

Re: User Grouping and Priveleges in MySQL

hts are to change, we will only change the GROUP rights instead of manually changing for every user. If I am not clear, I will rephrase the question again! Thanks Emery - Original Message - From: <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>

User Grouping and Priveleges in MySQL

Hi Group, I am wondering whether MySQL is planning to implement Group based privileges. To make my question clear, consider a database where some users are not allowed to update data and other are allowed to update. Will it be possible to create a group that has got some privileges and whenever

Re: Adding space to /var/lib/mysql

I read in the manual that SymLinks should be avoided when not really needed. I might be wrong! Thanks Emery - Original Message - From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]> To: "'Randy Chrismon'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, October 10, 2003 23:01 S

Re: deleting mysql users

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 R

Re: [MYSQL] Combine tables from two different systems

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 PR

Re: printing reports

ful (if this helps you, please let me know) Thanks Emery - Original Message - From: "Wang Feng" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 08, 2003 1

Re: BLOB images in Crystal Reports

- Original Message - From: "Danny Haworth" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 14:41 Subject: Re: BLOB images in Crystal Reports > I've had no problems with MySQL, crystal reports

Re: Ideas on Compression Protocol

Thank you for the ideas. Very helpful. Thanks Emery - Original Message - From: "Danny Haworth" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 12:01 Subject: Re: Ideas on Compression Protocol &g

Ideas on Compression Protocol

Hi group, I recently asked about Compression and security and got nice answers. Now I have got a different question: What are the disadvantage of using that client/server Compression protocol? Does it increase speed? Does it decrease speed? Does it overload the server? The client? Any ideas

Re: Exponentiation operator

I think exp(number, number) will do the job. Check the manual for the correct syntax. Thanks Emery - Original Message - From: "Bob Brands" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 08, 2003 11:16 Subject: Exponentiation operator > What is the correct syntax f

Re: printing reports

ool in that client. Are you familiar with MS Access? If yes, you can use Access to work with MySQL data. If you have Access installed, just let me know and I will send you Step by Step Instructions. Thanks Emery - Original Message - From: "Wang Feng" <[EMAIL PROTECTED]> To

Re: error messages in different languages

I use 4.0.14 and 4.1.0-Alpha Thanks Emery - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 16:45 Subject: Re: error messages in different languages > "Director General: NEFAC

Re: printing reports

To get data from/into MySQL, you will always need a client software. So, the reporting thing should be implemented in your client software. Hope to be right!!! Thanks Emery - Original Message - From: "Wang Feng" <[EMAIL PROTECTED]> To: "Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>

Re: error messages in different languages

To: <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 11:21 Subject: Re: error messages in different languages > "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: > > > > I have two questions about error messages in MySQL. > > > > 1.

Compression: Security or Zipping?

Hi group, I have read in the MySQL manual that the client/Server Compression protocol adds some security to the application. Does anyone have more information on this? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office

Re: COUNT(*) faster?

I think this is OK. But if you want to get a recordset with data and know how much records you have with only ONE query, you may use: $date=2003-02-16; SELECT col1, col2, coln FROM `games` WHERE `date`='$date' $num_rows=0; $num_rows=mysql_num_rows($rs_resource_identifier); I don't remember exact

Re: Row-level privileges in mysql

I think this is not implemented. But Logically, I also think it is not easy to implement since rows get added dynamically. So, it is not easy to predict what will be in the table. Since I needed such a feature in my application, I created an ACL (access control list) table that allows me to contr

UNION syntax (Request for feature)

Hi Group, I want to use a UNION in order to SELECT columns from several tables but I wish MySQL could use the following syntax: SELECT {several fields} FROM (Table1 UNION Table2 UNION Table3 . ) WHERE condition Currently I think MySQL only supports the following: (SELECT {several fields} F

error messages in different languages

Hi group, I have two questions about error messages in MySQL. 1. Section 4.6.2 talks about Non-English error messages. It says that for recompiling the errmsg.sys file, one will issue a comp_err command at the SHELL prompt. Does such a utility exist for Windows? I mean can someone tell me when t

Re: How can i make mysql to print date and time automatically?

I am sorry, the instruction I sent doesn't work in MySQL: You should use: INSERT INTO your_table (field1, field2, field3) VALUES(CURDATE(), "value2", CURTIME()) Note the CUR (I think it stands for CURrent) Thanks Emery - Original Message - From: "Director Genera

Re: How can i make mysql to print date and time automatically?

INSERT INTO your_table (field1, field2, field3) VALUES(DATE(), "value2", TIME()) But check the manual for very simple things. Thanks Emery - Original Message - From: "Emilio Ruben Estevez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 2003 17:09 Subject: How ca

Re: 'IF NOT EXISTS' ignored?

From: "Antony Dovgal" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 15:23 Subject: Re: 'IF NOT EXISTS' ignored? > On Mon, 29 Sep 2003 15:16:57 +0200 > "

Re: 'IF NOT EXISTS' ignored?

From: "Antony Dovgal" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 13:28 Subject: Re: 'IF NOT EXISTS' ignored? > On Mon, 29 Sep 2003 12:30:28 +0200 > "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: > > &g

Re: 'IF NOT EXISTS' ignored?

It seems Victoria didn't understand the real problem: I think that query should be stopped as soon as the table exists. But if it doesn't exist, the query should create it and insert some records. The problem is: WHY is MySQL trying to insert records while the table exists? It should only insert r

Re: Authentication

While connected to MySQL, issue the following instruction: GRANT ALL PRIVILEGES to 'YourChoosesUsername'@'%' ON `database` I don't remember exactly the syntax, but I think this should work. It means, you giving all the permissions to the user YourChoosenUsername and you are allowing him/her to

Re: insert into x select * from x doesn't work

Read the docs at: http://www.mysql.com/doc/en/INSERT_SELECT.html They said that with 4.0.14 and up, that should work!!! Thanks Emery - Original Message - From: "David Precious" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 10:09 Subject: Re: insert into x

Re: mysqldump error (mysql 4.0.14)

`TableNamesOr FieldNames` - Original Message - From: "Kelley Lingerfelt" <[EMAIL PROTECTED]> To: "Rusty Wright" <[EMAIL PROTECTED]>; "Mysql List" <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 09:10 Subject: Re: mysqldump error (mysql 4.0.14) > Try putting the name inside of backti

UNDOing query operations

Hi group? Suppose I run a query by mistake that for example deletes my records. Is there a way to go back to a previous state? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 1

Re: insert into x select * from x doesn't work

I think this should be reported as a BUG for version 4.1 Below is a small text retreived from the URL http://www.mysql.com/doc/en/INSERT_SELECT.html --- Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. This li

Re: mysqlclient.lib

Go to the end of the page http://www.mysql.com/downloads/mysql-4.0.html You will find the source downloads. I said the end of the page. Thanks Emery - Original Message - From: "Luiz Rafael Culik Guimaraes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 28, 2003 17:49

Re: newbie Q: create a table in a database

commandPrompt> USE DataBaseName; Thanks Emery - Original Message - From: "Wang Feng" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 28, 2003 10:55 Subject: newbie Q: create a table in a database > Hi, folks. > > I use Windows XP Pro, MySQL v.1.4 > > The following i

Re: php and mysql

You need to install a package. Unless you install PHP from source and include MySQL at Compile time. If you install PHP from a RPM package, you will need to install a package called php-mysql-.rpm Thanks Emery - Original Message - From: "Adam Clauss" <[EMAIL PROTECTED]> To: "'gam

Re: php and mysql

Go to http://www.rpmfind.com and search for php-mysql It should give you a list of packages. So, to use PHP with MySQL you need to install a package with a name like php-mysql-**.rpm Hope this helps Thanks Emery - Original Message - From: "gamalt tant" <[EMAIL PROTECTED]> To: <[EM

Re: newbie Q: what are the benefits of having several databases?

If you have different projects, I think it is better to have different databases. Also permissions can be set per database basis. I am not an expert ;) Thanks Emery - Original Message - From: "Wang Feng" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 28, 2003 15:19 Su

Re: Excluding Results from a database

Using the Query of the players already selected build a list like : $player_list="player1, player2, player3, ..."; and then use that list to not return selected ones SELECT player_id FROM playerTable WHERE player_id NOT IN($player_list); I don't know exactly how your tables are

Re: Ideas on creating connections

The problem is not when sending FLOTs to the server, but it when RECEIVING floats FROM the server. Thanks Emery - Original Message - From: "Mike R. Duncan" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]&g

  1   2   >