[kapper.net #16695] Re: Another Replication Problem
Hallo User, diese eMail wurde automatisch als Antwort auf Deine Nachricht generiert und bestaetigt Dir die Uebernahme in unser Bearbeitungssystem. Wir werden schnellstmoeglich antworten. Bitte ein wenig Geduld, wir vergessen niemanden. Solltest Du Information sofort benoetigen, rufe uns bitte an. Bitte behalte diese Ticket-ID im Betreff der eMail bei: [kapper.net #16695] nur so ist unsere Korrespondenz eindeutig für alle beteiligten nachvollziehbar. Danke für Dein Interesse, die kapper.net::verwaltung ;-) [EMAIL PROTECTED] - Hi User, this email is an automatically generated reply that confirms the receipt of your mesage and tells you we're already working on your request now. We will respond ASAP, please give us a little time. If you need your information right now, please call us and let us know. Please do also keep this messages Ticket-ID in the subject for further emails: [kapper.net #16695] only this makes sure our communication is as accurate as possible. Thank you for talking to us, the kapper.net::administration ;-) [EMAIL PROTECTED] [...deutsche version am beginn...] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help!!! The error message "SELECT in a stored procedure must have INTO"
Hi everyone,
This is my first project in MySql database. I use VB.Net and OleDb to connect
to MySql(5.0.1 alpha-max). When I call the stored produce, I get the error
message:
ERROR [42000][MySQL][ODBC 3.51 Driver][mysqld-5.0.1-alpha-max]You have an error
in your SQL syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to use near 'usp_CountryAll' at line 1
When I call the same stored procedure in the MySql console, it is fine. But
when I call it at the MySql Query Broswer, I get "SELECT in a stored procedure
must have INTO" error message. I have checked it on the internet and I saw many
messages about "SELECT in a stored procedure must have INTO" error message. But
I didn't find the direct answer in my case. I am very appreciated, if anyone
can point out how to change my source code in follows.
Here is my stored procedure and VB.Net code:
CREATE PROCEDURE `testdb`.`usp_CountryAll`()
SELECT CountryId, ShortName, FullName FROM Country ORDER BY ShortName
Try
Dim oOdbcDA As OdbcDataAdapter = New OdbcDataAdapter
Dim oOdbcCmd As OdbcCommand
Dim oDS As DataSet = New DataSet
Dim oRow As DataRow
Dim oMySqlConn As OdbcConnection = New OdbcConnection
oMySqlConn.ConnectionString = "DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=testdb;USER=root;PASSWORD=;OPTION=3"
oMySqlConn.Open()
oOdbcCmd = New OdbcCommand("usp_CountryAll", oMySqlConn)
oOdbcCmd.CommandType = CommandType.StoredProcedure
oOdbcDA.SelectCommand = oOdbcCmd
oOdbcDA.Fill(oDS)
For Each oRow In oDS.Tables(0).Rows
lstResult.Items.Add(oRow("FullName"))
Next
Catch ex As Exception
MsgBox(ex.Message)
End Try
Thanks!
Owen Ni
-
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com
Odd Results on Mysql LIMIT and ORDER BY
Hi Guys, Firstly, this is the only time I have ever encountered this problem and searching archives or google shed no luck since yesterday so here I am . I have a table described below: mysql> describe containers; +++--+-+-++ | Field | Type | Null | Key | Default | Extra | +++--+-+-++ | internal_id| mediumint(20) unsigned | NO | PRI | NULL| auto_increment | | category_id| smallint(20) unsigned | YES | MUL | NULL || | user_id| mediumint(20) unsigned | YES | MUL | NULL || | parts_amount | int(2) | NO | | 0 || | file_name | varchar(64)| NO | MUL | || | file_format| varchar(5) | NO | MUL | || | file_info | text | NO | | NULL || | file_description | text | YES | | NULL || | admin_comments | text | YES | | NULL || | is_approved| tinyint(1) | YES | MUL | 0 || | is_shared | tinyint(1) | YES | MUL | 1 || | is_deleted | tinyint(1) | YES | | 0 || | upload_date| bigint(10) | NO | MUL | 0 || | downloads | int(11)| YES | MUL | 0 || | last_download_date | bigint(10) | NO | MUL | 0 || | rating | decimal(3,1) | YES | MUL | 0.0 || | ftp_site | smallint(6)| NO | MUL | 0 || | total_votes| int(11)| NO | MUL | NULL || | total_dnloads | int(11)| NO | | NULL || | total_votes_ave| float | NO | | 0 || | total_votes_sum| int(11)| NO | | NULL || | file_img | varchar(120) | NO | | NULL || | file_extended_info | text | NO | | NULL || | file_exist | tinyint(4) | NO | MUL | 0 || | post_options | varchar(20)| NO | | NULL || +++--+-+-++ 25 rows in set (0.00 sec) mysql> select count(*) from containers; +--+ | count(*) | +--+ | 9504 | +--+ 1 row in set (0.00 sec) mysql> select count(*) from containers where upload_date < 1209208414 and category_id = 120; +--+ | count(*) | +--+ | 795 | +--+ 1 row in set (0.01 sec) And I have queries like these: select * from containers where upload_date < 1209208414 and category_id = 120 order by upload_date desc limit 0,25 and select * from containers where upload_date < 1209208414 and category_id = 120 order by upload_date desc limit 175,25 These queries are dynamically generated and is is being paged for browser display so the second query means I am on the 8th page for 25 items each page. The problem is, offsets 0...150 (LIMIT [0...150],25) will not return any results while 175 onwards will. This happens only when I am filtering category_id 120, all other categories does not yield this odd result. I have no clue whatsoever what is going on, executing the query directly from the server yields the same results. Now, if I omit either the order by or limit clauses I get results all through out. Hope someone can shed some light. Jervin
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 that new authentication is not compatible with MyODBC. It only works with the client program given by MySQL. Thanks Emery - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Fernando Gomes Bernardino" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, November 21, 2003 19:42 Subject: Re: mysql_fix_privilege_tables script > At 10:18 -0200 11/21/03, Fernando Gomes Bernardino wrote: > > > At 10:00 -0200 11/19/03, Fernando Gomes Bernardino wrote: > >> >Hi eveybody, > >> > > >> >The mysql_fix_privilege tables can be undone? I have already > >> >re-install mysql server and nothing > >> > >> Why do you want to undo it? > >> > >> You can undo it by restoring the grant tables from your most recent > >> backup. But without knowing why you'd want to or what problems you're > >> encountering, it's difficult to say whether or not that's something > >> you should consider. > >> > >Hi Paul! The problem is that some aplications couldn't connect to mysql, the > >returned message is: > >"Consider upgrade your MySQL Client". Thanks a lot. > > I would guess then that you have upgraded to 4.1. The problem you are > seeing is a result of changes to the authentication mechanism for passwords > in 4.1. There is information about this in the MySQL Reference Manual: > > http://www.mysql.com/doc/en/Upgrading-from-4.0.html > http://www.mysql.com/doc/en/Upgrading-grant-tables.html > http://www.mysql.com/doc/en/Password_hashing.html > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 applications and the MySQL client!!! Curious!! The server says: ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. I received this error when I used - MySQL Front 2.5 - MySQL Control Center 0.9.2 - My Application developped in VB using MyODBC 3.51 to connect I have not yet tried PHP. I searched the archives but found only one people who faced the same problem but I didn't see any message saying that he got a solution. Or simply, is it possible to tell MySQL daemon to use OLD_PASSWORD when encrypting passwords? Any advice? 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.nefacomp.net/
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 to have read that thos -max are packed with many features that I think I don't need for the time being. Normally mysqld-opt.exe or mysqld-nt.exe had worked for me well. So, I don't see why I should need --max versions. Any idea of why it appears like that? 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.nefacomp.net/
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 add 'locahost' for you. Like 'emery'@'localhost' Hope this helps. Thanks Emeyr - Original Message - From: "m i l e s" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 28, 2003 20:12 Subject: MySQL users. > Hi > > Im a more than a lil confused about how to set up multiple > users for EXTERNAL access to MySQL. > > Ive granted permissions to the Local user, but how to I grant permissions > to external users ? > > Sincerely, > > -- > M i l e s > > President & Toolbox Architect > MagicMiles Software > (413) 374 - 5161 > PO Box 414, Northampton, MA 01060 > > http://www.servicetoolbox.com/ > http://www.workshoptoolbox.com/ > http://www.healingartstoolbox.com/ > http://www.artshoptoolbox.com/ > > We create content management systems for > the rest of us, starting at $25.00 a month, > includes domain registration, web hosting, > email and webmail. Great for Yoga Teachers, > Massage Therapists, Lawyers, Doctors, > and any professional! > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL users.
Check also the other tables in the `mysql` database such as db and host to make sure that there are no entries of that user with 'locahost' as host. If you created the entries earlier, there is a chance that the entries are still there with the localhost entry. Or simply delete everything 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 > > miles'%' or > miles% or > [EMAIL PROTECTED] or > miles@'%' > > all FAIL to authenticate. > > and that's in the USER table in the USER field. > > do I need to change any other tables and fields ? > > Sincerely, > > -- > M i l e s > > President & Toolbox Architect > MagicMiles Software > (413) 374 - 5161 > PO Box 414, Northampton, MA 01060 > > http://www.servicetoolbox.com/ > http://www.workshoptoolbox.com/ > http://www.healingartstoolbox.com/ > http://www.artshoptoolbox.com/ > > We create content management systems for > the rest of us, starting at $25.00 a month, > includes domain registration, web hosting, > email and webmail. Great for Yoga Teachers, > Massage Therapists, Lawyers, Doctors, > and any professional! > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC and MySQL 4.1
I know how to grant privileges but the problem is with the password type of mysql 4.1.0 After granting privileges using GRANT (in 4.1.0), I can only login using the mysql client. But I can't use the same username and password for logging in. Nor MyODBC will succeed. But c:\mysql\bin\mysql.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 the "Grant" command from the "mysql" command prompt: Mysql> GRANT ALL PRIVILEGES ON *.* TO user1@'%' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTIONGRANT ALL PRIVILEGES this will allow the "user1" with the "some_pass" to access the database "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: 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 applications and the MySQL client!!! Curious!! The server says: ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. I received this error when I used - MySQL Front 2.5 - MySQL Control Center 0.9.2 - My Application developped in VB using MyODBC 3.51 to connect I have not yet tried PHP. I searched the archives but found only one people who faced the same problem but I didn't see any message saying that he got a solution. Or simply, is it possible to tell MySQL daemon to use OLD_PASSWORD when encrypting passwords? Any advice? 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.nefacomp.net/ -- Do you Yahoo!? Free Pop-Up Blocker - Get it now
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 to download it alone since the package contains everything (the clients that I never use, the ---max version that I think I don't need, ...) and this makes the size of the package something > 20MB which is very big for DialUp connection!!! Also, I sometimes need an updated documentation but I cannot get it alone without downloading everything I hope the packaging team will do something for us disabled people. 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.nefacomp.net/
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: "abaid al-mutairy" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, November 29, 2003 13:43 Subject: Re: MyODBC and MySQL 4.1 I know how to grant privileges but the problem is with the password type of mysql 4.1.0 After granting privileges using GRANT (in 4.1.0), I can only login using the mysql client. But I can't use the same username and password for logging in. Nor MyODBC will succeed. But c:\mysql\bin\mysql.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 the "Grant" command from the "mysql" command prompt: Mysql> GRANT ALL PRIVILEGES ON *.* TO user1@'%' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTIONGRANT ALL PRIVILEGES this will allow the "user1" with the "some_pass" to access the database "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: 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 applications and the MySQL client!!! Curious!! The server says: ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. I received this error when I used - MySQL Front 2.5 - MySQL Control Center 0.9.2 - My Application developped in VB using MyODBC 3.51 to connect I have not yet tried PHP. I searched the archives but found only one people who faced the same problem but I didn't see any message saying that he got a solution. Or simply, is it possible to tell MySQL daemon to use OLD_PASSWORD when encrypting passwords? Any advice? 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.nefacomp.net/ ---- -- Do you Yahoo!? Free Pop-Up Blocker - Get it now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 2B 3C 4D 5E And I want my result to be: table_result --- 1A 2B 3C 4D 5E The result table has got two fields!! By doing SELECT field_1, field_2 FROM table_1, table_2 I get several records because it does a full join. I want MySQL to just pick a record from table_1 and picks another one from table_2 without a specified condition. Which type of JOIN should I use? 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.nefacomp.net/
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_password") WHERE
Host="your_host" AND User="your_username"
You also asked what might be wrong: that is due to that your PHP doesn't
support the new passwords used by MySQL 4.1
Also, using empty passwords does the trick.
Hope this helps.
Thanks
- Original Message -
From: "Fernando Gomes Bernardino" <[EMAIL PROTECTED]>
To: "MySQL - Lista Internacional" <[EMAIL PROTECTED]>
Sent: Wednesday, December 03, 2003 12:33
Subject: Re: Client does not support authentication protocol requested by
server
>
> > Warning: mysql_pconnect(): Client does not support authentication
> protocol
> > requested by server. Consider upgrading MySQL client
>
> #1249 - Client does not support authentication protocol requested by
> server.
> Consider upgrading MySQL client ??
>
> I have MySQL 4.1 on Linux. The "mysql_fix _privilege_tables" is the
> problem, I think. What can I do??
>
> Fernando Gomes Bernardino
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.nefacomp.net/
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 the table I > > get an error : Check the manual for: Check) values ( etc.etc. > > > > When I try to change the column name (alter table tablename change check > > blabla smallint) I get an error too, check your manual.. > > > > Does anybody know what's happening? > > Reserved word? > > With regards, > > Martijn Tonies > Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL > Server. > Upscene Productions > http://www.upscene.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 MyODBC manual and you will get enough information about how you can use VB with MySQL. Also, consider joining the MyODBC mailing list. Thanks Emery - Original Message - From: "Ed Leafe" <[EMAIL PROTECTED]> To: "Adam Jones" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 28, 2003 16:07 Subject: Re: Forms & Reports like I use in MS Access > On Dec 28, 2003, at 4:49 AM, Adam Jones wrote: > > > When building Access DBs, I write VB code, SQL, develop DBs using 3rd > > N.F. and build lovely forms for data entry, print outs, reports etc, > > etc. > > > > After examing MySQL's material, I don't see any forms like I use in > > Access. So what GUI should I use and how do I link the SQL to things > > like command buttons, check boxes, drop-down list etc? > > You could use Access. ;-) > > MySQL is a database; Access is a database with a form and report > designer. With MySQL you can use any front end you like that can 'talk' > to the database engine. > > In my case, I used Visual FoxPro for many years, because of its pure > object-oriented design tools, but I got tired of being limited by the > file-based data access of products like VFP and Access and the limited > security of those products. I now use VFP as the front end and MySQL as > the back end exclusively, and my apps are better than they ever were. I > have a powerful object-oriented design tool that allows me to create > not only the GUI for my apps, but also has the power to create a strong > middle tier of business objects that contain the logic that governs the > data. > > I'd recommend VFP, but if you are already fluent in Access, you would > probably be better off using that for your GUI. You connect to the data > via ODBC or OleDB, and then use the data normally. And if you ever > move away from the world of Windows development, there are several > choices on Linux and OS X that I'm sure others will chime in with. > > > ___/ > / > __/ >/ > / > Ed Leafe > > Linux Love: > unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 fields. Not Field1, Field2, Your names are very confusing. It is like giving birth to three boys and you name them Boy1, Boy2, Boy3 Would you do that? The last question will be why you defined the fields as VARCHAR while it seems they will be holding numeric values. If the will be holding INTEGERs or FLOATs, define them accordingly. The manual will easily teach you about the data and field types. Hope this will help you Thanks Emery - Original Message - From: "daryl hansen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 27, 2003 10:59 Subject: newbie question about calculations > Please excuse me if I do not use the correct terminology for what I am > trying to descibe. I am new to mySQL and am using FileMaker and Lass to > export Filemaker data for use with mySQL. How do you make a field that > is the sum of two other fields in the same record? I have riffled > through the mySQL manual, but I still have no clue on how to make > calculation fields. Right now I have FileMaker talking to mySQL 4.0.15 > using the JDBC driver and a SQL plug-in for Filemaker. And it is > working very well, for static data, But Anyway, this is a sample > of my current code to create my Table called, "cart": > > CREATE TABLE Cart ( > ID bigint(20) NOT NULL auto_increment , > Field1 varchar (5) , > Field2 varchar (5) , > Field3 varchar (5) , > KEY `ID` (`ID`) > ) > > And code to input data into the table: > > INSERT INTO cart ( > Field1, > Field2, > Field3 ) > VALUES ( '1', '1', '2') > > > How do I make "Field3" a calculation, which equals 2 if fields 1 & 2 > where values set to "1"? Any pointers in the right direction would be > sincerely appreciated. > > Aloha, > > Daryl Hansen > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 the User table using the OLD_PASSWORD() function [for example
UPDATE mysql.User SET password=OLD_PASSWORD('your_password') WHERE
User='your_username' AND Host='your_host']
Just do one of the above and your problem will be solved until PHP releases
a version that supports the new authentication protocol used by 4.1
Also, reading the manual will give you more hints.
Thanks
Emery
- Original Message -
From: "ads mysql" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 29, 2003 15:42
Subject: Not able to connect to mysql by mysql_connect()
> Hi,
> I am trying to connect mysql through .php script.
>
> Following is the php code.
>
> ###
> MYSQL_CONNECT("localhost", "x", "xxx" ) OR DIE("Unable to connect
to database");
> @mysql_select_db("xxx") or die("Unable to select database");
> ###
>
> I get following warning :
>
>
> Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in
/usr/local/apache2/htdocs/Display_squiddata.php on line 99
> Unable to connect to database.
>
> I then tried mysql_real_connec() as per documentation as follows :
>
> ##
>
> MYSQL
mysql;mysql_init(&mysql);mysql_options(&mysql,MYSQL_OPT_COMPRESS,0);mysql_op
tions(&mysql,MYSQL_READ_DEFAULT_GROUP,"odbc");if
(!mysql_real_connect(&mysql,"host","user","passwd","database",0,NULL,0)){
fprintf(stderr, "Failed to connect to database: Error: %s\n",
mysql_error(&mysql));}
>
> The above requests the client to use the
>
> ##
>
>
>
> 1) I want to use mysql_connect() to connect to database whcih I am using
all these days.
>
> 2) If there is any problem due to new version of mysql. Please guide how
to use function mysql_real_connect(). Please guide me to URL which will give
values for using mysql_real_function.
>
>
>
> I am have installed mysql as follows :
>
> MySQL-client-4.1.1-0.i386.rpm
> MySQL-server-4.1.1-1.i386.rpm
>
> Help appreciated.
>
>
>
>
>
>
>
>
> I don't know what should be values
>
>
>
>
>
>
>
>
>
>
>
>
>
> -
> Do you Yahoo!?
> Yahoo! Photos - Get your photo on the big screen in Times Square
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: problem trying to connect to MySQL server > I'm having a problem with one of our MySQL servers. > Setup > VPN with Firewall at main office (iptables), > remote office currently has 2 MySQL servers and their port numbers are > 3306 (server1) and 3309 (server2) > Programmer accesses server1 okay from his location, but cannot access > server2. He will be moving data from server1 to the new server2. > Error msg: error no. Can't conect to mysql server at '192.168.0.15' > (10061). > > > Thanks > -- > Jon Miller <[EMAIL PROTECTED]> > MMT Networks Pty Ltd > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 homosexuality! 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.nefacomp.net/
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 help page, that should be used when > giving the root user a password, but I really don't understand > what of this is words and what is just an example. > > /usr/local/mysql/bin/mysqladmin -u root password > /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password > > Where in this script am I supposed to write my password and where is the > word supposed > to acctually be written as the word password? > And what about hostname? Is that a command or should I write the host name > of my computer? > Since I'm a newbie it's hard to understand. > Can someone please mark this for me? > > Is this the right way? > > /usr/local/mysql/bin/mysqladmin -u root password > /usr/local/mysql/bin/mysqladmin -u root -h `this_is_me` password > > Weird question maybe... but I guess I'm not the only one here. > It would've been easier with underscored or different colours here... I > guess ;-) > > _____ > Hitta rätt köpare på MSN Köp & Sälj http://www.msn.se/koposalj > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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!! Just an Idea. Thanks Emery - Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 10:07 Subject: Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ? > > > Looking at the facts, the number of files used to store your data is of > > very little consequence at the end of the day. Looking > > at the following: > > > > * MS SQL Server stores database data in a single file and logs in another. > > * Oracle and FoxPro both have a pretty large number of files, for very > > different reasons > > * MySQL stores MyISAM each table in a few files: FRM for the schema, > > MYD for data and MYI for the index > > * FileMaker Pro stores each table along with a bunch of interface stuff > > in a single file > > * SQLBase (popular in the contract / "closed market" segment) has a > > single file unless you tell it to partition the database. This > > single file stores tables, stored procedures, views, triggers, indexes > > and all transaction logs > > * MySQL requires 3 types of file for InnoDB storage in 3.23.x and 4.x - > > ibdata*, ib_arch_log_* and iblogfile*, in 4.1.1 and higher > > you can go to 4 files with individual table spaces > > > > The last point is particularly worthy of note. The new option in 4.1.1 > > and higher has implications for performance - you can have your > > InnoDB data dictionary (ibdata*), logs and individual table/index spaces > > on physically seperate devices. Backing things up becomes > > more complicated though. > > > > To be honest, the vast majority of database installations experience > > problems in performance caused by poor query and schema design, > > bad application logic or grossly underspecified hardware. A change in > > the number of files used to store the data is extremely unlikely > > to resolve these problems given all other variables in the environment > > remain fixed. > > > > What does everyone else think? > > I fully agree with the part about performance and the number of > files. :-) > > With regards, > > Martijn Tonies > Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL > Server. > Upscene Productions > http://www.upscene.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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.nefacomp.net/
Re: Knowing the real size of a column
I have tried it but it failed to give me that size. It only works when the content is a CHAR or VARCHAR. It just returns the number of characters, not the disk size. Thanks Emery - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 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 size of data stored in a BLOB column. > > I have tried BIT_LENGTH() but this one does not seem to return the real size. > > Would you want to use LENGTH() function? > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: "robert_rowe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 08, 2004 19:29 Subject: Re: Knowing the real size of a column > > If you are using ADO then the field object has an actualsize property that should give you your value. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 need to create a DSN that connects to the server. Thanks Emery - Original Message - From: "Matthew McNicol" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 09, 2004 03:34 Subject: odbc I have a PHP/MySQL database application running on linux hosted webspace (via webfusion.co.uk). I'd like to make the information accessible from a MS Access database which sits on my clients office server (microsoft os), either by using odbc, or an alternative. This is because the client would like to be able to use MS Access for reporting purposes. I don't think odbc is available via the hosted webspace so I may have to export the data periodically to the MS Access database using cron/scheduling. Any recommendations? Matthew McNicol - yellowmarker.co.uk [information technology] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 tried the following
SELECT LPAD('512', 3, '0');
And it worked as required.
So, my conclusion will be that the type conversion will only take place when the
number of characters to PAD is bigger than the length of the original string.
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.nefacomp.net/
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 Subject: New grant tables > I just updated from 3.x to 4.x. I moved my data files from one server to > another. Srated mysql, and ran the permissions fixer script, which seemed > to have worked just fine. However, I am not sure what it changed, how can I > be sure that it did in fact update the tables? > -- > - > Scott HanedaTel: 415.898.2602 > http://www.newgeo.com Fax: 313.557.5052 > [EMAIL PROTECTED] Novato, CA U.S.A. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with LPAD() function
I am using 4.1.0 and 4.1.1 on Windows
On WinXP, it even crashes the server when I add extra date fields.
On Win2k AS, it doesn't crash the MySQL server but it returns unexpected
results.
Thanks
Emery
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
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 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 tried the following
> > SELECT LPAD('512', 3, '0');
> > And it worked as required.
> >
> > So, my conclusion will be that the type conversion will only take place
when the number of characters to PAD is bigger than the length of the
original string.
>
> What version do you use?
> Works like a charm for me:
>
> mysql> SELECT LPAD(12, 3, '0');
> +--+
> | LPAD(12, 3, '0') |
> +--+
> | 012 |
> +--+
> 1 row in set (0.00 sec)
>
> mysql> SELECT LPAD(512, 3, '0');
> +---+
> | LPAD(512, 3, '0') |
> +---+
> | 512 |
> +---+
> 1 row in set (0.00 sec)
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Victoria Reznichenko
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
><___/ www.mysql.com
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 query works as expected with mysqld-nt.exe 4.1.0 (on WinXP) but it does not work with mysqld-nt.exe 4.1.1 (on WinXP). This problem causes unexpected results as the recordset comes empty (on 4.1.1) while it comes with rows with 4.1.0 and no error is returned!!! Maybe it is a known bug! 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.nefacomp.net/
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: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/
User variables not working
Hi group, Is there anything I need to set in MySQL in order to use USER variables? 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.nefacomp.net/
Difference between FLOAT and DECIMAL numbers
Will someone tell me the real difference between FLOAT numbers and DECIMAL numbers? What are the implications when I use either of those types? 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.nefacomp.net/
Re: Using SQL variables
Can you run this query and tell me if it works on your machine? SELECT (@var := @var + 1) AS Number, * FROM any_table_with_records; As per the manual, this should give something like: +-- NumberFieldOne 1Value 2Value 3Value ... But when I run it the error is :You have an error in your SQL syntax near 'NULL @var + 1) AS Number BLAH BLAH BLAH I have read everything about Using Variables (in the manual) and I apply what it says but it can't run. Even the simple example given by MySQL This is the example MySQL has given in the manual: SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; When I run this query, the error message is: You have an error in your SQL syntax near '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 Where do you think these NULL stuffs are coming from? Do I have to change the character set? Thanks Emery - Original Message - From: "Petr Vileta" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 01:45 Subject: Re: Using SQL variables > > Can someone tell me what's wrong with my query? > > My Query was: > >SELECT (@num := @num + 1) as RecNum, AnotherField FROM tbl WHERE > condition. > > > > When I change the := into =, the query returns results with a non changing > RecNum. > Because > "=" mean "some IS EQUIAL to another" > but > ":=" mean "SET MYSQL VARIABLE to some value" > > Consult your MySQL manual and look for "Using variables" :-) > > Petr Vileta, Czech republic > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: nested select alternative??
Upgrade to MySQL 4.1 and your nested query will run with no problem. But remember to change TOP 50 into LIMIT 50 Thanks Emery - Original Message - From: "Wajih-ur-Rehman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 12:40 Subject: nested select alternative?? > I have this statement that works perfectly fine in Access and MSSQL: (In > words, i first get the top 50 id values according to the where clause and > then i get the maximum of those id values) > > "SELECT Max(id) FROM (select top 50 id from myTable where infoId in > ( 3 ) AND id > 100 order by id ASC) AS t1 " > > (Note that id > 100 changes in every iteration of the loop in my code) > > I want to run a similar query in MYSQLIs there *any* way to accomplish > it ? I have tried the following query without any luck > > "SELECT Max(id) FROM (select id from myTable where infoId in > ( 3 ) AND id > 100 order by id ASC LIMIT 50) AS t1 " > > > Thanx in advance > > Best Regards > Wajih > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using SQL variables
I tried on MySQL 4.0.12, 4.0.14 and 4.1 and I am getting the same error. Whether these servers were on Windows or on Linux, it does not help. I also initialized the variables but the same error came. I even tried to run the example given in the MySQL documentation with the same results. MySQL thinks ``:='' is a NULL character. Maybe it's a problem with the character set. Thanks Emery - Original Message - From: "Pete Harlan" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Cc: "Petr Vileta" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 18:49 Subject: Re: Using SQL variables > You have to initialize @var to something first, or it's just null. So > try "set @var := 0;" before your query. > > Also, you don't say which version of MySQL you're using, but I'm using > 4.0.14 and I can't say "... as number, * from ...", but have to say > "... as number, tableName.* from ...". > > HTH, > > --Pete > > > On Tue, Sep 23, 2003 at 04:54:03PM +0300, Director General: NEFACOMP wrote: > > Can you run this query and tell me if it works on your machine? > > SELECT (@var := @var + 1) AS Number, * FROM any_table_with_records; > > As per the manual, this should give something like: > > +-- > > NumberFieldOne > > 1Value > > 2Value > > 3Value > > ... > > But when I run it the error is :You have an error in your SQL syntax near > > 'NULL @var + 1) AS Number BLAH BLAH BLAH > > > > I have read everything about Using Variables (in the manual) and I apply > > what it says but it can't run. > > Even the simple example given by MySQL > > This is the example MySQL has given in the manual: > > SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; > > > > When I run this query, the error message is: You have an error in your SQL > > syntax near '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 > > Where do you think these NULL stuffs are coming from? > > Do I have to change the character set? > > > > > > Thanks > > Emery > > - Original Message - > > From: "Petr Vileta" <[EMAIL PROTECTED]> > > To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> > > Sent: Tuesday, September 23, 2003 01:45 > > Subject: Re: Using SQL variables > > > > > > > > Can someone tell me what's wrong with my query? > > > > My Query was: > > > >SELECT (@num := @num + 1) as RecNum, AnotherField FROM tbl WHERE > > > condition. > > > > > > > > When I change the := into =, the query returns results with a non > > changing > > > RecNum. > > > Because > > > "=" mean "some IS EQUIAL to another" > > > but > > > ":=" mean "SET MYSQL VARIABLE to some value" > > > > > > Consult your MySQL manual and look for "Using variables" :-) > > > > > > Petr Vileta, Czech republic > > > > > > > > > > > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using SQL variables
Yes you are right. I run the query in SQLyog and it came very nicely. Thanks for your time and help. Another question is: How do I send multiple queries at the same time the server? I mean, two instructions in the same query. Like SET @var = 0; SELECT (@var := @var + 1) AS Number, AnotherField FROM any_table_with_records; Thanks Emery - Original Message - From: "Petr Vileta" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 18:55 Subject: Re: Using SQL variables > > Can you run this query and tell me if it works on your machine? > > SELECT (@var := @var + 1) AS Number, * FROM any_table_with_records; > > As per the manual, this should give something like: > > +-- > > NumberFieldOne > > 1Value > > 2Value > > 3Value > > ... > > But when I run it the error is :You have an error in your SQL syntax near > > 'NULL @var + 1) AS Number BLAH BLAH BLAH > > Yeah :-) You are using MySQL-Front, is it right? I get the same error in > mysql-front but the syntax is right, test it using mysql.exe - a native > mysql client in DOS mode. If you will use this syntax in some program in > VisualBasic, PHP, Perl or other the command still work ok. > If you preffer GUI interface for work you can test SQLyog on www.webyog.com > > Petr Vileta, Czech republic > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Reading a table without knowing column names
I think by issuing a SELECT * FROM tblTableName will execute your query without knowing the column names. But you can also issue a SHOW FIELDS FROM tblTableName to get a list of the table columns. Hope this helps, Thanks Emery - Original Message - From: "Philippe MAIRE" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 19:33 Subject: Reading a table without knowing column names > Hi > I would like to execute a select on a table for which i don't know the > column names. > IE I would like a command like > select column(1) from table where ... > > Sure, if I ask, it is because I cannot use the desc command. > > I have another solution which causes again a problem : > if I could execute a function on the result of "desc table" > I explain myself : > > I access a mysql base through a fixed php script (which i can't modif), > which takes for input a request in an html form, executes it and gives me > back the numeric value of the first row, first column > So when i know the field name and to retreive what I want, i can do > select ascii(mid(col1,1,1)) from table where ... > so doing this char by char I get the entire string. > But the problem is that I haven't found the way to execute that > ascii(mid(...)) function on the result of "desc table" or "show tables" etc > > Anyone sees something ? > > Philippe > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using SQL variables
Thank you for your support. In fact the problem was in MySQL Front. I tried using SQLyog and it passed very well. The problem is that SQLyog will not facilitate me in buying since I have no credit card!!! I am in Africa and the best payment method I have access to is by Western Union (http://www.westernunion.com) Thanks Emery - Original Message - From: "Petr Vileta" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 03:47 Subject: Re: Using SQL variables In mysql.exe type query and Enter and other query and Enter ... In MySQL-Front type more query on more rows and press F9. Every query runs in sequece from top to bottom as is typed on rows. See MySQL-Front help for using F9, Shift+F9 and Ctrl+F9 function. Other way is using some programming language as a Perl, Visual Basic, PHP and his appropriate libraries/packages. I preffer Perl, because it is very powerfull language, is free and exist for Windows and Linux too. Applications programed in Perl are portabled to Windows and Linux without any changes ;-) Petr Vileta http://www.practisoft.cz Ostatne soudím, ze letní cas musí být zrusen ! - Original Message - From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> To: "Petr Vileta" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 10:01 AM Subject: Re: Using SQL variables > Yes you are right. > I run the query in SQLyog and it came very nicely. > > Thanks for your time and help. > > Another question is: How do I send multiple queries at the same time the > server? > > I mean, two instructions in the same query. > > Like > SET @var = 0; > SELECT (@var := @var + 1) AS Number, AnotherField FROM > any_table_with_records; > > > Thanks > Emery > - Original Message - > From: "Petr Vileta" <[EMAIL PROTECTED]> > To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> > Sent: Tuesday, September 23, 2003 18:55 > Subject: Re: Using SQL variables > > > > > Can you run this query and tell me if it works on your machine? > > > SELECT (@var := @var + 1) AS Number, * FROM any_table_with_records; > > > As per the manual, this should give something like: > > > +-- > > > NumberFieldOne > > > 1Value > > > 2Value > > > 3Value > > > ... > > > But when I run it the error is :You have an error in your SQL syntax > near > > > 'NULL @var + 1) AS Number BLAH BLAH BLAH > > > > Yeah :-) You are using MySQL-Front, is it right? I get the same error in > > mysql-front but the syntax is right, test it using mysql.exe - a native > > mysql client in DOS mode. If you will use this syntax in some program in > > VisualBasic, PHP, Perl or other the command still work ok. > > If you preffer GUI interface for work you can test SQLyog on > www.webyog.com > > > > Petr Vileta, Czech republic > > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ideas on creating connections
Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following methods for connecting to the server: 1. At logon, I create a connection to the server and maintain it throught the application life. By the application life I mean that the connection stays open as long as the application is loaded in the memory. So, for a user who is online for 3 hours, the connection is on for those three hours, even if the user goes out for a coffee. 2. I create a connection only when a query is about to be sent to the server. That means, I create a connection when I want to create an ADO recordset and run a query against the server. After running my query, I distroy the connection. Currently I am using the first option since I don't exactly what it is required (time and resources) to make a connection to the server. Will you please tell me how fast is to connect to the server. If you advise me that this method is the best, I will add functions to reconnect a dead connection. Any ideas and advices are highly welcomed 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.nefacomp.net/
Re: Ideas on creating connections
What is connection pooling? How big should my memory be if 200 connections may be required? Is there any limit of how many connections I can use in MySQL? I know one can set the max connections in MySQL. Does MySQL impose the limit I can tell it? I mean, may I set that number to let's say 1? Thanks Emery - Original Message - From: "Dan Greene" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 18:17 Subject: RE: Ideas on creating connections The general rule of thumb is that connection creation/destruction is the most costly part of approach #2. However, it is unlikely that each connection needs a dedicated connection, and therefore memory resources on the server for the entirity of the client's lifespan... if your clients are firing off many queries back-to-back, buy a lot of memory for your server, and go w/ your option #1. if it's a typical app, where the user queries data, looks through it for a bit, then queries more, yadda, yadda, yadda, then what you're probably going to want to do is #2. Without a central 'app server' as such, you can't really take advantage of connection pooling. The closest you can do is write into your app that if the connection is idle for x amount of time, then it closes the connection, and reestablishes it upon next data request. Hope this helps... Dan Greene > -Original Message- > From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 25, 2003 11:57 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Ideas on creating connections > > > Hi groups, > > I need some experienced users to guide me on this issue. > I am developping an Application that will be accessing a > MySQL database through MyODBC. > The application is developped using Visual Basic. > > Since my application will be used simultaneously by more than > 200 users, I want to know the implication of using one of the > following methods for connecting to the server: > > 1. At logon, I create a connection to the server and maintain > it throught the application life. By the application life I > mean that the connection stays open as long as the > application is loaded in the memory. So, for a user who is > online for 3 hours, the connection is on for those three > hours, even if the user goes out for a coffee. > > 2. I create a connection only when a query is about to be > sent to the server. That means, I create a connection when I > want to create an ADO recordset and run a query against the > server. After running my query, I distroy the connection. > > > Currently I am using the first option since I don't exactly > what it is required (time and resources) to make a connection > to the server. Will you please tell me how fast is to connect > to the server. If you advise me that this method is the best, > I will add functions to reconnect a dead connection. > > > Any ideas and advices are highly welcomed > > > 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.nefacomp.net/ > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ideas on creating connections
I never use DAO. Is there any benefit over ADO? Thanks Emery - Original Message - From: "Roger Davis" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 18:14 Subject: RE: Ideas on creating connections > My experience is this. I use DAO through MyODBC, and I also use the > libmysql.dll with a custom recordset. Connection times through both options > are extremely fast. Fast enough in my situation that it can basically can be > ignored. There are times when I open several connections to the server at > once and have yet to run into any problems. If you strictly want to use ADO > though, I would suggest that you open one connection to the server and > process your queries through that connection. Leave it open for the life of > the program. While the program is open, the connection to the server will > stay open and the thread for MySQL will be a "sleep". > > Just my $0.02. > > Roger > > -Original Message- > > From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 25, 2003 11:57 AM > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: Ideas on creating connections > > > > > > Hi groups, > > > > I need some experienced users to guide me on this issue. > > I am developping an Application that will be accessing a MySQL > > database through MyODBC. > > The application is developped using Visual Basic. > > > > Since my application will be used simultaneously by more than 200 > > users, I want to know the implication of using one of the > > following methods for connecting to the server: > > > > 1. At logon, I create a connection to the server and maintain it > > throught the application life. By the application life I mean > > that the connection stays open as long as the application is > > loaded in the memory. So, for a user who is online for 3 hours, > > the connection is on for those three hours, even if the user goes > > out for a coffee. > > > > 2. I create a connection only when a query is about to be sent to > > the server. That means, I create a connection when I want to > > create an ADO recordset and run a query against the server. After > > running my query, I distroy the connection. > > > > > > Currently I am using the first option since I don't exactly what > > it is required (time and resources) to make a connection to the > > server. Will you please tell me how fast is to connect to the > > server. If you advise me that this method is the best, I will add > > functions to reconnect a dead connection. > > > > > > Any ideas and advices are highly welcomed > > > > > > 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.nefacomp.net/ > > > > --- > > Incoming mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 > > > -- > MySQL ODBC Mailing List > For list archives: http://lists.mysql.com/myodbc > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL powered MailServer
Just wanted to know if anyone knows the status of the MySQL powered Mailserver found at http://www.mysql.com/portal/software/item-239.html 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.nefacomp.net/
Re: Ideas on creating connections
Thank you for your time. I don't want to be too much demanding. I currently have a problem with MyODBC 3.51. When my client machine is set to use French numbers (with a COMMA instead of a PERIOD or DOT for floats), MyODBC does not let the decimal part to pass. Venu told me he will try to look into this before the next release. It seems I am impatient!!! You said you are trying to move from DAO to using the MySQL DLL (libmysql.dll). Can we share some code using VB and the DLL? Just send me a piece of code doing the following: = - Creating a connection to the MySQL server, - Running a DELETE query on the server (or any other query that doesn't need to return values) - Running a SELECT query against the MySQL server and - Populating data of the RecordSet creating into a Flex grid - Closing and Distroying the RecordSet - Closing and Distroying the Connection = One time I saw such a code on http://www.vbmysql.com but it seems to have dissappeared. Thanks Emery - Original Message - From: "Roger Davis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 19:08 Subject: RE: Ideas on creating connections > DAO is, I guess you would say, the predessor to ADO. I am currently in the > process of getting rid of all the DAO code in the application and moving to > a custom recordset using the libmysql.dll. Some of this is done in VB and > it is still extremely fast for a VB based recordset. Although there are > numerous ways to do this, it is really difficult to tell what would be the > best in your situation. As has been mentioned before, if you are doing > queries one after another in your application, then by all means connect > once and pass all the queries through that connection. If you a making very > few queries and you have limited resources on the server, then it would be > best to connect only when you need to and drop the connection when you are > done. These are of course only my opinions based on what I have experienced > in the past. Your experience may vary. Void where prohibited. > > Roger > > > -Original Message- > > From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 25, 2003 12:48 PM > > To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: Re: Ideas on creating connections > > > > > > I never use DAO. > > > > Is there any benefit over ADO? > > > > > > Thanks > > Emery > > - Original Message - > > From: "Roger Davis" <[EMAIL PROTECTED]> > > To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Thursday, September 25, 2003 18:14 > > Subject: RE: Ideas on creating connections > > > > > > > My experience is this. I use DAO through MyODBC, and I also use the > > > libmysql.dll with a custom recordset. Connection times through both > > options > > > are extremely fast. Fast enough in my situation that it can > > basically can > > be > > > ignored. There are times when I open several connections to > > the server at > > > once and have yet to run into any problems. If you strictly want to use > > ADO > > > though, I would suggest that you open one connection to the server and > > > process your queries through that connection. Leave it open > > for the life > > of > > > the program. While the program is open, the connection to the > > server will > > > stay open and the thread for MySQL will be a "sleep". > > > > > > Just my $0.02. > > > > > > Roger > > > > -Original Message- > > > > From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] > > > > Sent: Thursday, September 25, 2003 11:57 AM > > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > > > Subject: Ideas on creating connections > > > > > > > > > > > > Hi groups, > > > > > > > > I need some experienced users to guide me on this issue. > > > > I am developping an Application that will be accessing a MySQL > > > > database through MyODBC. > > > > The application is developped using Visual Basic. > > > > > > > > Since my application will be used simultaneously by more than 200 > > > > users, I want to know the implication of using one of the > > > > following methods for connecting to the server: > > > > > > > > 1. At logon, I create a connection to the server and maintain it > > >
Re: Connect to 4.1 using MyOBDC
I use MyODBC 3.51.06 to connect my VB applications to MySQL and it works. Thanks Emery - Original Message - From: "Randy Chrismon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 19:20 Subject: Connect to 4.1 using MyOBDC Please tell me it ain't so! My test user is using MyOBDC to connect to our 4.1.0 alpha server. She will be creating some Crystal Reports from the data. Her test DSN fails on an incompatible protocol error with a message that she should upgrade to the newest client. Do I have to download bitkeeper, a C compiler, and learn how to use them to get an OBCD driver that will work with our server? Thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: No valid command found
Is everyone on the list receiving the message below? It is coming to me every time I send a message to the mysql list Thanks Emery - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 20:04 Subject: No valid command found > Your message does not contain a valid command for this mail server > to process. No action has been taken. > > Message-Id: <[EMAIL PROTECTED]> > From: [EMAIL PROTECTED] > Time-Stamp: Thu, 25 Sep 2003 19:40:58 +0200 > > : Message contains [1] file attachments > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL powered MailServer
It seems the developpers are no longer doing any work on this server. Their website is empty: http://www.halvar.com/ Thanks Emery - Original Message - From: "Luc Foisy" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 19:51 Subject: RE: MySQL powered MailServer Try here http://www.lencom.com/desc/indexN16185.html -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:18 PM To: [EMAIL PROTECTED] Subject: MySQL powered MailServer Just wanted to know if anyone knows the status of the MySQL powered Mailserver found at http://www.mysql.com/portal/software/item-239.html 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.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't execute code in VB 6.0
I think you can't. Even MySQLcc runs one after one. In fact it takes one statement and runs it. After that, it runs the following statement. The thing is not sent on the server at once. I might be wrong! (not an expert) Thanks Emery - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 26, 2003 05:52 Subject: Can't execute code in VB 6.0 > I'm trying to execute a code with multiple SQL statement over VB 6.0. The > code includes the creation of temporary tables, multiple inserts and one > final select... > It looks like i can only excecut one single SQL statement... does any one > know how to fix that? > > I can run the code with out problems using MySQL Control Center. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL powered MailServer [dbmail.org]
Thank you very much. Emery - Original Message - From: "Brent Baisley" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 21:28 Subject: Re: MySQL powered MailServer > I don't know about the hMailServer, but you may look at dbMail too > (dbmail.org). You can use MySQL or PostgresSQL as the backend. Although > I think it's only for Unix/Linux systems. I've been meaning to try > setting it up on OSX, but haven' gotten around to it yet. > > On Thursday, September 25, 2003, at 01:17 PM, Director General: > NEFACOMP wrote: > > > Just wanted to know if anyone knows the status of the MySQL powered > > Mailserver found at http://www.mysql.com/portal/software/item-239.html > > > -- > Brent Baisley > Systems Architect > Landover Associates, Inc. > Search & Advisory Services for Advanced Technology Environments > p: 212.759.6400/800.759.0577 > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Noob Question: Error 1046
Do you have a database you want to create that table in? You can use the test database if you are just testing. In that case you do: mysql> USE test If you want to create your own database: mysql> CREATE DATABASE database_name mysql> USE database_name And then continue your queries. This means, you need to tell MySQL the database your queris should run on. Hope this helps Thanks Emery - Original Message - From: "Charlie Brewer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 21:12 Subject: Noob Question: Error 1046 Evenin', Sorry to send noob questions, I know how annoying they can be, but we need help too ;) Anyways, Im using a self teach book to teach myself PHP, MySQL and Apache. The book is getting into MySQL and basic commands. Anyways, they gave an example, and I typed it in as shown in the book, but I get an error. I took a screenshot (I thought that would be easier) and posted it here: http://hostultra.org/brewer/mysql.jpg Any help would be very much so appreciated, thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]>; <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 23:55 Subject: RE: Ideas on creating connections try adding a '\' before the comma like a \n in c++ -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:41 AM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections Thank you for your time. I don't want to be too much demanding. I currently have a problem with MyODBC 3.51. When my client machine is set to use French numbers (with a COMMA instead of a PERIOD or DOT for floats), MyODBC does not let the decimal part to pass. Venu told me he will try to look into this before the next release. It seems I am impatient!!! You said you are trying to move from DAO to using the MySQL DLL (libmysql.dll). Can we share some code using VB and the DLL? Just send me a piece of code doing the following: = - Creating a connection to the MySQL server, - Running a DELETE query on the server (or any other query that doesn't need to return values) - Running a SELECT query against the MySQL server and - Populating data of the RecordSet creating into a Flex grid - Closing and Distroying the RecordSet - Closing and Distroying the Connection = One time I saw such a code on http://www.vbmysql.com but it seems to have dissappeared. Thanks Emery - Original Message - From: "Roger Davis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 19:08 Subject: RE: Ideas on creating connections > DAO is, I guess you would say, the predessor to ADO. I am currently in the > process of getting rid of all the DAO code in the application and moving to > a custom recordset using the libmysql.dll. Some of this is done in VB and > it is still extremely fast for a VB based recordset. Although there are > numerous ways to do this, it is really difficult to tell what would be the > best in your situation. As has been mentioned before, if you are doing > queries one after another in your application, then by all means connect > once and pass all the queries through that connection. If you a making very > few queries and you have limited resources on the server, then it would be > best to connect only when you need to and drop the connection when you are > done. These are of course only my opinions based on what I have experienced > in the past. Your experience may vary. Void where prohibited. > > Roger > > > -Original Message- > > From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 25, 2003 12:48 PM > > To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: Re: Ideas on creating connections > > > > > > I never use DAO. > > > > Is there any benefit over ADO? > > > > > > Thanks > > Emery > > - Original Message - > > From: "Roger Davis" <[EMAIL PROTECTED]> > > To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Thursday, September 25, 2003 18:14 > > Subject: RE: Ideas on creating connections > > > > > > > My experience is this. I use DAO through MyODBC, and I also use the > > > libmysql.dll with a custom recordset. Connection times through both > > options > > > are extremely fast. Fast enough in my situation that it can > > basically can > > be > > > ignored. There are times when I open several connections to > > the server at > > > once and have yet to run into any problems. If you strictly want to use > > ADO > > > though, I would suggest that you open one connection to the server and > > > process your queries through that connection. Leave it open > > for the life > > of > > > the program. While the program is open, the connection to the > > server will > > > stay open and the thread for MySQL will be a "sleep". > > > > > > Just my $0.02. > > > > > > Roger > > > > -Original Message- > > > > From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] > > > > Sent: Thursday, September 25, 2003 11:57 AM > > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > > > Subject: Ideas on creating connections > > > > > > > >
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, but I hope the above idea will be OK. Thanks Emery - Original Message - From: "Matt MacLeod" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 26, 2003 11:51 Subject: Excluding Results from a database > Hi, > > I asked for some help about a week ago and thanks to everybody who got > me a little closer to the solution. > > I am developing an online fantasy rugby game. Visitors buy and sell > players and earn points depending on those players' performances in real > matches. > > The only problem I have is that when visitors go to the 'Purchase > Players' screen, I cannot exclude players that they already own. For > example, if they already have Jonny Wilkinson in their team, Wilkinson > is still available to purchase again (anybody familiar with rugby will > appreciate the issue with a visitor fielding a team of 15 Jonny Wilkinsons). > > I am using two queries. The first query selects the players that are > available to buy: > > $teamqry = "SELECT * FROM players, countries WHERE players.position = > '$pos' AND players.country = countries.countryid AND players.price <= > '$availablebudget' ORDER BY players.price DESC"; > > The second brings up the squad that a visitor has currently selected: > > $squadqry = "SELECT * FROM transactions, players, positions, countries > WHERE transactions.managerid = '$userid' AND transactions.playerid = > players.playerid AND players.position = positions.positionid AND > players.country = countries.countryid AND datein < '$now' AND dateout > > '$now' ORDER BY positionid ASC"; > > Basically I need to be able to produce a list of all the players that > appear in the first query ($teamqry) EXCEPT those that appear in the > second ($squadqry). > > Help!?!?!??! > > Thanks very much, > Matt > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Subject: newbie Q: what are the benefits of having several databases? > Hi, folks. > > What are the benefits of having several databases rather than just one? The > hosting companies usually charge more bucks if customers asked for more > databases. I'm so curious why people need more databases while they can > create as many tables as they need in 1 database? > > > cheers, > > feng > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: <[EMAIL PROTECTED]> Sent: Sunday, September 28, 2003 03:48 Subject: php and mysql > hi > i want to use php with mysql. However, i do not know > if i should install another package from mysql that > incluse shared library between php and mysql?. i > already installed mysql client and server package. if > there more package i should install,can you please > tell the name and where can i find it? > >redhat8.0 >mysql 4.0.15 > thanks > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: "'gamalt tant'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, September 28, 2003 04:49 Subject: RE: php and mysql > There shouldn't be anything else required (besides PHP). PHP has built in > functions to access MySQL. > See: > http://www.php.net/manual/en/ref.mysql.php > > Adam Clauss > [EMAIL PROTECTED] > > > -Original Message- > > From: gamalt tant [mailto:[EMAIL PROTECTED] > > Sent: Saturday, September 27, 2003 8:48 PM > > To: [EMAIL PROTECTED] > > Subject: php and mysql > > > > > > hi > > i want to use php with mysql. However, i do not know > > if i should install another package from mysql that > > incluse shared library between php and mysql?. i > > already installed mysql client and server package. if > > there more package i should install,can you please > > tell the name and where can i find it? > > > >redhat8.0 > >mysql 4.0.15 > > thanks > > > > __ > > Do you Yahoo!? > > The New Yahoo! Shopping - with improved product search > > http://shopping.yahoo.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 is how I access to MySQL and create a database and a table in > that database: > > >c:\mysql\bin\mysql line 1 > mysql>create database DB1line 2 > mysql>quit line 3 > >c:\mysql\bin\mysql DB1line 4 > mysql>create table TB1(id char(3)); ---line 5 > > It works fine. But I'm not happy with that since everytime I have to quit > the MySQL after creating a database (e.g. line 3) and then login again using > the command 'mysql database_name' to access that database (e.g. line 4) and > then create the tables in the database, Otherwise, I'll get the message: "No > Database Selected". So, I'm wondering what commands I should use to create > the tables in a database without having to exit just like what I did above? > > Thanks for your time. > > > > cheers, > > feng > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Subject: mysqlclient.lib > Dear Friends > > Where i can get the source for mysql 4.0.14 > I´ve like to contribute with an mysqlclient.lib compiled with Borland C++ > compilers as existe an version of this lib for 3.23.36 > > Regards and thanks in advance > Luiz > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/03 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 limitation is lifted in 4.0.14. --- This should apply to 4.1.0 because it is not prior to 4.0.14 ! Thanks Emery - Original Message - From: "Tedman Leung" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 08:08 Subject: insert into x select * from x doesn't work > In mysql 4.1 (and since mysql 4.0.14 or something like that) I believe > it's documented that an insert into X select * from X should work. > > It's not working for me on MySQL 4.1.0 alpha, anyone else have this > problem? is it a bug? I haven't found any other reports of this not > working for anyone else. > > Bellow is a pasted copy of what I get. > > --- > > [1006:[EMAIL PROTECTED]:~]more /proc/version > Linux version 2.4.18-26.8.0 ([EMAIL PROTECTED]) (gcc version > 3.2 20020903 (Red Hat Linux 8.0 3.2-7)) #1 Mon Feb 24 10:21:42 EST 2003 > [1007:[EMAIL PROTECTED]:~]mysql --version > mysql Ver 13.5 Distrib 4.1.0-alpha, for pc-linux (i686) > [1008:[EMAIL PROTECTED]:~]mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 3 to server version: 4.1.0-alpha > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> create database foo; > Query OK, 1 row affected (0.00 sec) > > mysql> create table foo.bar (id int); > Query OK, 0 rows affected (0.08 sec) > > mysql> insert into foo.bar select id from foo.bar; > ERROR 1066: Not unique table/alias: 'bar' > mysql> > > -- >Being normal is vastly over rated : Ted Leung > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/
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 backticks; > > >From the Manual: > 6.1.2 Database, Table, Index, Column, and Alias Names > --- > Note that if the identifier is a restricted word or contains special characters you must always > quote it with a ` (backtick) when you use it: > mysql> SELECT * FROM `select` WHERE `select`.id > 100; > See Section 6.1.7 [Reserved words], page 437. > > KL > > Rusty Wright wrote: > > > I have a user who unfortunately named one of his tables "order". He also > > has table names with a dash in them. mysqldump is unable to dump the > > "order" table and I'm unable to use the ALTER command on it and the tables > > with the dashes in their names to rename them. Is there any way to quote > > the table names so it doesn't treat them as sql commands? > > > > /local_a/servers/mysql/bin/mysqldump: Got error: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order READ /*!32311 LOCAL */,order_pricing READ /*!32311 LOCAL when using LOCK TABLES > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 select * from x doesn't work > > Hi > > > In mysql 4.1 (and since mysql 4.0.14 or something like that) I > > believe it's documented that an insert into X select * from X should > > work. > > IIRC, the table you're INSERTing into cannot be the same table you > SELECT from - you're trying to take records from the table 'foo' and > insert them into the same table. > > > mysql> insert into foo.bar select id from foo.bar; > > ERROR 1066: Not unique table/alias: 'bar' > > mysql> > > This error seems to support that idea - although its not a particularly > friendly way of saying it. Try creating another table, and do the > select from that. > > Hope this helps! > > David P > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 connect from any computer (even the Internet if applicable) on just the database `database` Thanks Emery - Original Message - From: "ketvin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 11:42 Subject: Authentication > Access denied for user: '@localhost' to database 'database' > > > I have a database named 'database' and i got this problem while trying to > get it run. I am connecting that database to localhost without user and > password, it works just fine on my previous windows box, but since lately > when i move it onto my linux box, it starts showing me that error message. > > It works when i connecting the database with user "root" , my problem is > that how can i get it to work without using user "root" , just like the old > days on windows box. > > Or is there anyway to add user/password for that particular database so that > only that single user can access to that db ? > > > Thanks > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 records after creating the table (and table will be created only when t doesn't exist already). So, in that query, will the IF condition apply for table creation only? Thanks Emery - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 11:37 Subject: Re: 'IF NOT EXISTS' ignored? > Hassan Schroeder <[EMAIL PROTECTED]> wrote: > > Is there a problem with 'IF NOT EXISTS' in the following scenario? > > > > This statement creates the table as expected ... > > > > CREATE TEMPORARY TABLE IF NOT EXISTS > >showcase ( > > PRIMARY KEY (product) > > ) > > SELECT product FROM productList > > > > .. but re-running it (from the console or via page reload) results > > in "ERROR 1062: Duplicate entry 'foo' for key 1" > > > > I expected it to simply exit silently when it finds that the table > > *does* already exist. So what am I missing? :-) > > "Duplicate entry" means that you already have value 'foo' in the column 'product' which is defined as primary key. > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 'IF NOT EXISTS' ignored?
When I replied I was not meaning the aim of this query but the aim of Mr. Hassan who first asked that question on September 28, 2003. I just rephrased his question!!! Below is a text he wrote. Please note where he said: . I expected it to simply exit silently when it finds that the table *does* already exist. === Is there a problem with 'IF NOT EXISTS' in the following scenario? This statement creates the table as expected ... CREATE TEMPORARY TABLE IF NOT EXISTS showcase ( PRIMARY KEY (product) ) SELECT product FROM productList .. but re-running it (from the console or via page reload) results in "ERROR 1062: Duplicate entry 'foo' for key 1" I expected it to simply exit silently when it finds that the table *does* already exist. So what am I missing? :-) === Now, do you think I was right in my rephrasing? To me, I think that is a bug and should be reported to MySQL. When the IF condition is false, it should break the rest of the statement. What is your view on this? Thanks Emery - Original Message - 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: > > > 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 records after creating the table (and table > > will be created only when t doesn't exist already). > > I don't think you're right. > The main aim of this query is to INSERT data into table. > And before this it checks if the table already exists and creates it if not. > So, there is no problem imho. > > > So, in that query, will the IF condition apply for table creation only? > Yes. > > --- > WBR, > Antony Dovgal aka tony2001 > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 'IF NOT EXISTS' ignored?
It is good that we both understand his problem. Do you have a solution for his problem? For me, I think he may use two statements: 1. Create the table if it does not exist. 2. Insert data if that will not create duplicates. /* This is the first instruction for creating the table */ CREATE TEMPORARY TABLE IF NOT EXISTS showcase ( PRIMARY KEY (product) ); /* This is the second instruction for dumping records */ INSERT IGNORE INTO showcase SELECT product FROM productList; Another alternative is to first DROP that table and recreate it. But I think the above 2 steps procedure will work. Unfortunately, I don't see a way to send these queries at once to the server for execution. Is this helpful? Thanks Emery - Original Message - 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 > "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: > > > Now, do you think I was right in my rephrasing? > > To me, I think that is a bug and should be reported to MySQL. When the IF > > condition is false, it should break the rest of the statement. > > What is your view on this? > > For me this is not a bug, just poorly documented feature. > So, Hassan can't do it using this statement, he needs to check if table exists and then INSERT, cause the statement he's trying to use is not intended for conditional INSERT, but for conditional CREATE. > > --- > WBR, > Antony Dovgal aka tony2001 > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 can i make mysql to print date and time automatically? > Hi, im develping an application, and was wondering how can i make mysql get > time and date from pc and print it automatically in the time field and date > field so the user dont have to worry about entering the coorect time and > date. Is this posible, ive created a databse with fields hour(time) and > Date(date) like type but i dont know how to do the mysql to get time and > date and print it! > > Any hints? > > Thaks in advance. > Emilio. > > _ > Add MSN 8 Internet Software to your existing Internet access and enjoy > patented spam protection and more. Sign up now! > http://join.msn.com/?page=dept/byoa > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 General: NEFACOMP" <[EMAIL PROTECTED]> To: "Emilio Ruben Estevez" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 02, 2003 22:16 Subject: 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 can i make mysql to print date and time automatically? > > > > Hi, im develping an application, and was wondering how can i make mysql > get > > time and date from pc and print it automatically in the time field and > date > > field so the user dont have to worry about entering the coorect time and > > date. Is this posible, ive created a databse with fields hour(time) and > > Date(date) like type but i dont know how to do the mysql to get time and > > date and print it! > > > > Any hints? > > > > Thaks in advance. > > Emilio. > > > > _____ > > Add MSN 8 Internet Software to your existing Internet access and enjoy > > patented spam protection and more. Sign up now! > > http://join.msn.com/?page=dept/byoa > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 to find the 'comp_err.exe' in the MySQL Windows distribution? 2. One can change the error message file used by MySQL to instruct it to to send error messages in a given language. My question is that my application will be used by both English and French speakers. So, you understand that I don't need to use this or that error file; I need to use both at the same time. Is there anyway to instruct MySQL to use both error files and send messages based on client request? So that whenever the connected client will get personalized error messages as MySQL accepts different character SETs to be used based on Client request? 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.nefacomp.net/
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} FROM Table1 WHERE condition) UNION
(SELECT {several fields} FROM Table2 WHERE condition) UNION
(SELECT {several fields} FROM Table3 WHERE condition) UNION
(SELECT {several fields} FROM Table4 WHERE condition)
If the string {several fields} contains like 50 columns and the tables are for
instance 100, you understand how long the query sent to the server will be (of course
it works but )
For those who did Mathematics, you may be remembering that it is easier to write 10 *
(20 + 30 + 40 + 50 + 60 + 70 )
than writing 10 * 20 + 10 * 30 + 10 * 40 + 10 * 50 + 10 * 60 + 10 * 70
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.nefacomp.net/
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 control who can UPDATE which rows in other tables. Of course this is only possible when a user accesses the DB through my application. In case a user connects to the database using other Clients, he will bypass my ACL. Hope this helps Thanks Emery - Original Message - From: "Madhavi Kutty" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 06, 2003 18:12 Subject: Row-level privileges in mysql > Hi, > Does MySQL support row-level access privileges? > > Regards, > Madhavi > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 exactly Try it. Thanks Emery - Original Message - From: "Steve Buehler" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Monday, October 06, 2003 18:40 Subject: COUNT(*) faster? > I am using PHP & MySQL for a program that I am writing. I have a table in > my database that has a column withut dates in it in the form > -mm-dd. Sometimes there is nothing in the table with the search date > that I am using. Other times there might be 1000's of rows with that in > the date column. I am trying to find out if there are any rows with the > date that I am searching for in the 'date' column. Would the fastest way > be to use > $date=2003-02-16; > SELECT COUNT(*) FROM `games` WHERE `date`='$date' > or is there a faster way? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/
Re: error messages in different languages
> > Yup, there is a comp-err.exe in the bin directory. I am sorry but I asked this after not finding it. Will you please give me an URL on the MySQL website where I can download it from ? Thanks Emery - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> 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. 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 to find the 'comp_err.exe' in the MySQL Windows distribution? > > Yup, there is a comp-err.exe in the bin directory. > > > 2. One can change the error message file used by MySQL to instruct it to to send error messages in a given language. My question is that my application will be used by both English and French speakers. So, you understand that I don't need to use this or that error file; I need to use both at the same time. Is there anyway to instruct MySQL to use both error files and send messages based on client request? So that whenever the connected client will get personalized error messages as MySQL accepts different character SETs to be used based on Client request? > > You can't. > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]> Sent: Tuesday, October 07, 2003 12:22 Subject: Re: printing reports > > In MySQL, how can I create and print reports without the help of neither a > > scripting language(e.g. php) nor a thrid party software tool? > > bad grammar :-( but you guys understand what i'm saying, right? :-) > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: NEFACOMP" <[EMAIL PROTECTED]> wrote: > >> > >> Yup, there is a comp-err.exe in the bin directory. > > > > I am sorry but I asked this after not finding it. Will you please give me an > > URL on the MySQL website where I can download it from ? > > What version of MySQL do you use? I don't exactly remember in which version comp-err.exe was added into windows distribution, seems it was 3.23.50. > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: printing reports
Some are free, others are commercial. But, note that most of these are mainly for administration purposes. For example phpMyAdmin is a free PHP based client. Do you know some programming language? Like Visual Basic, C, C++, Java, PHP, ... You said that you are able to run queries, ... How do you run those queries? I suspect you use SHELL>mysql -u UserName -h HostNameOrIP -p Is that right? If it is, then I will tell you that mysql is a client developped by the MySQL team to ease your administration of the database. Unfortunately, they have not implemented a reporting tool 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: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 22:38 Subject: Re: printing reports > Hi, Emery > > What do you mean client software? I just downloaded the MySQL server and I > can insert data to the database and select the data from database and do > some queries. In Oracle server, there're some commands which can be used to > edit and print reports. What about MySQL? > > Also, as you said, I need a client software, what client software are you > using? Are they free? Please give me some advice. > > > > cheers, > > feng > > > - Original Message - > From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> > To: "Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, October 08, 2003 12:49 AM > Subject: 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]> > > Sent: Tuesday, October 07, 2003 12:22 > > Subject: Re: printing reports > > > > > > > > In MySQL, how can I create and print reports without the help of > neither > > a > > > > scripting language(e.g. php) nor a thrid party software tool? > > > > > > bad grammar :-( but you guys understand what i'm saying, right? :-) > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 for using a Exponentiation operator in MySQL? > > BTW is this even posible? > > bye, Bob > > > > > > > > http://www.beheervisie.nl/disclaimer. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 and/or thoughts are welcome. 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.nefacomp.net/
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 > We used compression on a project with about 90 simultaneous users. > Overall it sped things up (especially since most users were on modem > dialups). Load on the client wasn't noticeable, neither was load on the > server, > > The server did have two 2Ghz processors in though so compression of 90 > simultaneous streams shouldn't have been a problem =) > > On a standard 100mb switched lan, compression didn't make much of a > difference, but there weren't any noticeable speed decreases either. > > HTH > > danny > > On Thu, 2003-10-09 at 09:39, Director General: NEFACOMP wrote: > > 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 and/or thoughts are welcome. > > > > > > 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.nefacomp.net/ > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: BLOB images in Crystal Reports
I want to ask you one thing: Is your Crystal Report accessing the database through the Mascon Utility or it uses MyODBC? I think the main problem to me is how Crystal Report is accessing the database. I will try to access the database using ADO and see if there is any change. Thanks Emery - 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 and blob images. Main > differences here are the following: > > Crystal Reports 8.5 (not 7) > Myodbc 2.x (haven't tried 3.x yet with images) > > Images were also inserted into the MySQL database using a third party > utility called Mascon (http://www.scibit.com/). They do a free, > unlimited, version (annoying nag screens but still) if you want to try > that out? If that works, you can see the differences between the way > mascon stores them, and the way you are storing them.. > > I'm assuming if crystal is reading happily from mssql then that cant be > at fault. > > hth > > danny > > On Thu, 2003-10-09 at 13:08, Director General: NEFACOMP wrote: > > It was a good idea but it is not feasible for my case since I will be > > displaying many images coming in a recordset with many records. If it was > > only one record, then I would follow your advice. > > > > When I get the images from a MS SQL 2000, Crystal Reports displays them > > without problems. But when I switch to MySQL, I fail. > > > > > > Thanks > > Emery > > - Original Message - > > From: "DenBaguse MasRodjie" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]>; "Director General: NEFACOMP" <[EMAIL PROTECTED]> > > Sent: Thursday, October 09, 2003 12:44 > > Subject: Re: BLOB images in Crystal Reports > > > > > > > You can manually get that BLOB binaries from MySQL and copied to local > > file. > > > And from CR get that file. > > > > > > > > > Rgds, > > > > > > > > > Roji > > > > > > - Original Message - > > > From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Cc: "Mike Hillyer" <[EMAIL PROTECTED]> > > > Sent: Thursday, October 09, 2003 4:23 PM > > > Subject: BLOB images in Crystal Reports > > > > > > > > > Hi group, > > > > > > has anyone tried to display BLOB pictures from MySQL through MyODBC in > > > Crystal Reports? > > > I have tried everything but I failed. > > > > > > > > > Any ideas on how to achieve this is highly appreciated. > > > I am using: > > > MySQL 4.1.0 or MySQL 4.0.14 > > > MyODBC 3.51.06 > > > Crystal Reports Ver 7 (7.0.1.192) > > > > > > > > > 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.nefacomp.net/ > > > > > > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: printing reports
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 => Data Sources (Win2000, XP or like)) Step 3: Go to MS Access and do the following: File > Get External Data >> Link Tables Under files of Type . Choose ODBC and a window will be opened to ask you which ODBC you want to use. Choose the one you created in Step 2. At this time, a list of available tables will be shown, choose the tables you want to work with. You almost done now and you may start creating reports in your Access as if the tables were in Access. In fact a link is created for each table you choose. Hope to be helpful (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 10:16 Subject: Re: printing reports > > > Unfortunately, they have not implemented a reporting tool in that client. > > that's the problem, as I was trying to find some sql commands to edit the > report, such as report titles. > > > >Do you know some programming language? Like Visual Basic, C, C++, Java, > PHP, > > i know them, but as I mentioned earlier, I was trying to find some sql > commnds to achieve that. and i don't wanna print the report with the help of > a programming language since i think if we can solve problems using SQL > itself then it costs less. > > > > 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. > > yes, please send me the Step by Step Instructions. i do want to give it a > try with Access although it's not free. > > > > cheers, > > feng > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 PROTECTED]> Sent: Friday, October 10, 2003 14:40 Subject: Re: [MYSQL] Combine tables from two different systems > 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 equivalent will be > written. > > e.g. INSERT IGNORE INTO system_b.table_n (columns) > SELECT columns FROM system_a.table_n > > HTH > Rory McKinley > Nebula Solutions > 082 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 - > From: "PAUL MENARD" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, October 09, 2003 5:21 PM > Subject: [MYSQL] Combine tables from two different systems > > > > Hello All, > > > > I have two system, we shall call then system A (OLD) and system B (NEW), > running MySQL that I want to combine their tables. The system B is the newer > and most accurate. The table structure is the exact same. Some of the rows > in system B (NEW) tables are also in system A (OLD). For those rows I want > to leave the system B data unchanged. > > > > I have a select statement with a left join that will tell me the rows that > are in system A but not in system B (the target). Question is how to I write > a SQL statement to also insert these rows? > > > > System information. > > > > Windows NT4 (System A), Windows server 2003 (System B). > > MySQL 3.23.42-nt running on both systems. > > > > Paul > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 REMOVEUSER command. Thanks Emery - Original Message - From: "Alejandro Javier Pomeraniec" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 10, 2003 13:22 Subject: Re: deleting mysql users > 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 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. What if i want to delete a user from user table? Should i delete it manually? is that safe? > > > > > > > Yes, you should delete user manually. Don't forget about FLUSH PRIVILEGES. > > > > > > -- > > For technical support contracts, goto https://order.mysql.com/?ref=ensita > > This email is sponsored by Ensita.net http://www.ensita.net/ > >__ ___ ___ __ > > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > ><___/ www.mysql.com > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Subject: RE: Adding space to /var/lib/mysql > > > > -->-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 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 /var/lib/mysql to it then permanently mount it as > -->/var/lib/mysql? > > This sounds fine mount the 60 gig drive by hand and then when the copy > is done put the mount options in your fstab. Remount (reboot to make > sure it comes up mounted properly). > > > -OR- > you can change your datadir indicated in you're /etc/my.cnf file to let > mysql know where your new data is on the new drive. > > -OR- > you can use a simple symlink > > > > - Dathan Vance Pattishall > - Sr. Programmer and mySQL DBA for FriendFinder Inc. > - http://friendfinder.com/go/p40688--> > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[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 a new user is put into that category gets all the rights of that group? Like the Unix system does. If a Windows user is a member of the Administrators group, he can perform administrative tasks. I think you get my point!! 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.nefacomp.net/
Re: User Grouping and Priveleges in MySQL
Thank you for the answer but it seems you didn't understand my question. I was not asking about windows users. I may reformulate my question as follows: 1. suppose you have a database that will be accessed by both students and their teachers for different works 2. you understand that students have got some rights in common. 3. you understand that teachers have got some rights in common. 4. if you have got 500 students and 50 teachers you will need to create 550 users for you software (if it is web-based you may not need all these users at the MySQL level) 5. if you have several tables, you need to give SELECT, INSERT, ... on those tables accordingly. so, if there 50 different rights for each student, you will need to add more than 25000 entries in the different privileges tables of the mysql database (such as user, host, table_privileg, column, ...) 6. if we are together up to now, I will ask WHY CAN"T WE CREATE just a group called STUDENT and give it all the student required rights and then when creating a student user TELL MYSQL that he/she BELONGS to the student group? As Linux, MS SQL, WINDOWS, ... does? 7. and when creating a user who is a teacher, why do we need to redefine his/her rights while there another user who has the same rights as him/her? You may tell me that we may copy those rights and reassign them. But if there is a group called TEACHERS, we will simply tell MySQL that this new user belongs to that group and we are done. Also, when rights 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]> Sent: Monday, October 13, 2003 15:24 Subject: Re: User Grouping and Priveleges in MySQL > The simple answer is no. MySQL is first and foremost a Linux/UNIX and the > MySQL Management do not care to much about Windows. I should know I used to > work for MySQL AB > > Regards > Minky > > > - Original Message - > From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, October 13, 2003 2:18 PM > Subject: 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 a new user is > put into that category gets all the rights of that group? > Like the Unix system does. If a Windows user is a member of the > Administrators group, he can perform administrative tasks. > > I think you get my point!! > > > 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.nefacomp.net/ > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 answer in French and/or English but I don't know if it's allowed on this list. Thanks Emery - Original Message - From: scr informatiques To: [EMAIL PROTECTED] Sent: Monday, October 13, 2003 17:57 Subject: connexion avec un pocket pc bonjour, nous souhaitons que des utilisateurs munient de pocket pc puissent accéder à une base de donnée mysql stocké sur un serveur en nos locaux. Pour cela nous souhaitons envoyé une commande à partir de Visual Basic (embedded). Existe-t-il des commandes adapter pour cela ? Merci Frédéric NUNGE. IncrediMail - La messagerie électronique a enfin évolué - Cliquer ici
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 command is one of the most risky operations on data. Thanks Emery - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 17:25 Subject: deleting rows which table1.row=table2.row > how to delete rows which table1.field=table2.field > > thanks > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 14, 2003 11:19 Subject: creating a new table from a SELECT > how can i create a new table from a SELECT...WHERE... ? > > thanks > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Subject: 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 answer in French and/or English but I don't know if it's allowed on this list. Thanks Emery - Original Message - From: scr informatiques To: [EMAIL PROTECTED] Sent: Monday, October 13, 2003 17:57 Subject: connexion avec un pocket pc bonjour, nous souhaitons que des utilisateurs munient de pocket pc puissent accéder à une base de donnée mysql stocké sur un serveur en nos locaux. Pour cela nous souhaitons envoyé une commande à partir de Visual Basic (embedded). Existe-t-il des commandes adapter pour cela ? Merci Frédéric NUNGE. IncrediMail - La messagerie électronique a enfin évolué - Cliquer ici -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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://www.computerworld.com/databasetopics/data/software/story/0,10801,85900,00.html?SKC=software-85900 to read the ComputerWorld article. It also compares prices at the end of the article. 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.nefacomp.net/
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 At 20:03 15/10/2003 -0500, .eric wrote: Hi, >okay this is strange. every time i try to start mysql via WinMySQLadmin, i >get the error message in the MyODBC box containing the following error: >Not Found The above should be for drive MyODBC 2.50 >Driver 3.51 Not Found Well on my machine the above has showed the path and API level information. Anyway you need to verify with your ODBC Manager if the MyODBC driver is listed (that is the most important) and if you find it then disregard the WinMySQLAdmin message. >ive uninstalled completly and reinstalled mysql twice and i cant seem to >get mysql running again. i even uninstalled the service, and reinstalled >it, but nothing happens. im not sure whats wrong but for the record i have >the following: >windows xp >mysql 2.5.4 >WinMySQLadmin 1.4 > >if anyone can help me with this problem, i would greatly appreciate it. >thanks in advance! > > >--- >eric smith >http:/m00q.tk - [EMAIL PROTECTED] -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano <[EMAIL PROTECTED]> São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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" <[EMAIL PROTECTED]> To: "Jim Winstead" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 09:26 Subject: Re: MySQL 5.0 and Stored Procedures > Hi, > > > > I'm working with version 5.0 as well, like you I find it hard to find > documentation on MySQL-5.0 and not much support for MySQL-5.0 on the mysql > list, probably because not many people work with 5.0. I'm studding MySQL5.0 > to see how far I can come to create a tool to convert a Oracle Database to a > MySQL-5.0 database. > > > > I have learned a lot from the "internal" mail archive, and I found 2 pdf > documents, "stored-procedures.pdf", "Moving-Towards-MySQL-5.0.pdf". As well > there is documentation as mentioned in the docs directory. > > > > gr. Bob > > > > > - Original Message - > From: "Jim Winstead" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, October 15, 2003 7:10 PM > Subject: Re: MySQL 5.0 and Stored Procedures > > > > On Wed, Oct 15, 2003 at 11:57:02AM -0500, woody at nfri dot com wrote: > > > On Wed, 2003-10-15 at 10:55, Josh Wilson wrote: > > > > I have just recently compiled Mysql 5.0 onto my redhat linux box, and > > > > have been trying to set up some store procedures, but have yet to be > > > > able to figure out how. Can anyone help me on this on how to go about > > > > creating a stored proc in Mysql 5.0?? > > > > > > > > Any help or suggestions would be great. > > > > > > When you install development test releases (pre-alpha) you are pretty > > > much on your own... Unless any documentation was included with the > > > download, the only other thing around is the blurb on mysql.com > > > > In the MySQL 5.0 tree, the file Docs/sp-implemented.txt details the > > current state of the stored procedures implementation. > > > > Examples of the syntax can be found in mysql-test/t/sp.test > > > > Jim Winstead > > MySQL AB > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > http://www.beheervisie.nl/disclaimer. > > > > > > > > > > > > > > > http://www.beheervisie.nl/disclaimer. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 -
From: "Manisha Sathe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 15:16
Subject: Re: PASSWORD() function problem
> thanks all, it works (i just increase it to 20)
> but one more thing, now if i want to get this password (e.g for option
> forget password), can we retrieve, i believe we can not- just want to
> confirm
>
> manisha
>
> - Original Message -
> From: "Paul DuBois" <[EMAIL PROTECTED]>
> To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, October 15, 2003 11:05 PM
> Subject: Re: PASSWORD() function problem
>
>
> > At 17:26 +0800 10/15/03, Manisha Sathe wrote:
> > >Hi,
> > >
> > >I inserted one record thr PHPMyAdmin - mem_pass field of member
> > >table set to xyz using function 'PASSWORD'
> > >
> > >Then trying to select the same - select * from member where mem_pass
> > >= PASSWORD('xyz') - then it is not getting selected
> > >
> > >I do not know why I am not getting the result. please help me.
> > >what's going wrong ?
> > >
> > >Thanks in advance
> > >Manisha
> >
> > Please consider using something other than PASSWORD(), as noted in the
> > description for that function at:
> >
> > http://www.mysql.com/doc/en/Miscellaneous_functions.html
> >
> > PASSWORD() should not be used for your own applications.
> >
> > --
> > Paul DuBois, Senior Technical Writer
> > Madison, Wisconsin, USA
> > MySQL AB, www.mysql.com
> >
> > Are you MySQL certified? http://www.mysql.com/certification/
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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:13
Subject: Re: PASSWORD() function problem
> all encryption functions are one way only
>
> Nitin
>
> - Original Message -
> From: "Manisha Sathe" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, October 16, 2003 6:46 PM
> Subject: Re: PASSWORD() function problem
>
>
> > thanks all, it works (i just increase it to 20)
> > but one more thing, now if i want to get this password (e.g for option
> > forget password), can we retrieve, i believe we can not- just want to
> > confirm
> >
> > manisha
> >
> > - Original Message -
> > From: "Paul DuBois" <[EMAIL PROTECTED]>
> > To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Wednesday, October 15, 2003 11:05 PM
> > Subject: Re: PASSWORD() function problem
> >
> >
> > > At 17:26 +0800 10/15/03, Manisha Sathe wrote:
> > > >Hi,
> > > >
> > > >I inserted one record thr PHPMyAdmin - mem_pass field of member
> > > >table set to xyz using function 'PASSWORD'
> > > >
> > > >Then trying to select the same - select * from member where mem_pass
> > > >= PASSWORD('xyz') - then it is not getting selected
> > > >
> > > >I do not know why I am not getting the result. please help me.
> > > >what's going wrong ?
> > > >
> > > >Thanks in advance
> > > >Manisha
> > >
> > > Please consider using something other than PASSWORD(), as noted in the
> > > description for that function at:
> > >
> > > http://www.mysql.com/doc/en/Miscellaneous_functions.html
> > >
> > > PASSWORD() should not be used for your own applications.
> > >
> > > --
> > > Paul DuBois, Senior Technical Writer
> > > Madison, Wisconsin, USA
> > > MySQL AB, www.mysql.com
> > >
> > > Are you MySQL certified? http://www.mysql.com/certification/
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 want to copy, copy the contents of the temporary table into the original table and distroy the temporary table. Also, I sometimes work with complex joins. Instead of using those lengthy SQL instructions, I create temp tables and work with them. Thanks Emery - Original Message - From: "Nitin" <[EMAIL PROTECTED]> To: "Susan Ator" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 16:39 Subject: Re: Temporary table question > basically used to make queries easier running from within scripts. it could > be a good workaround for views, as you can create a temporary table to be > used as a view, but it gets destroyed as the connection to your database > closes. You can also use it as a good workaround for union, for older mysql > version, which doesn't support union and for other functions you want to > perform on some rows selected from multiple tables. > > Enjoy > Nitin > > - Original Message - > From: "Susan Ator" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, October 16, 2003 7:39 PM > Subject: Temporary table question > > > > I would like to know the circumstances in which a temporary table would be > > used. What is the rationale behind temporary tables? I have searched the > > manual and the 'net but only find out information about creating or > > manipulating them. > > > > Thanks, > > > > Susan > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, October 16, 2003 17:49 Subject: LIMITS > > when I do a query is there a way to IGNORE the first X number of returned > records??? > > For instance I want to see 15 records after the first 50. > > > > > Shawn Cummings > Engineering Project Manager > Global NAPs > 10 Merrymount Rd > Quincy, MA 02169 > Desk 617-507-5150 > VoIP 617-507-3550 > [EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 primary key) Thanks Emery - Original Message - From: "Mike Knox" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 09:44 Subject: RE: Check for data before inserting > Traditionally, I'd take the following approach > > 1) Update - assume it's there > 2) If update fails (0 rows) do an insert > > Thats assuming that the update case is more prevalent. If the row is > unlikely to be there - insert and do the update if you get a duplicate key. > > > Rgds > > Mike > > > > -Original Message- > From: Brent Baisley [mailto:[EMAIL PROTECTED] > Sent: 16 October 2003 19:29 > To: Mike Tuller > Cc: MySql List > Subject: Re: Check for data before inserting > > > It sound like you want to use REPLACE instead of the SELECT and > INSERT/UPDATE combo. Replace will insert if the record doesn't exist > and update if it does. > > > On Thursday, October 16, 2003, at 01:27 PM, Mike Tuller wrote: > > > I have a shell script that I have data entered into a database, and > > instead > > of just entering in the data blindly, I want it to check to see if the > > item > > it is entering exists already, and if it does, update the information > > rather > > than inserting it. So I want to run a select statement, and if results > > come > > back, have the data updated, and if not have it inserted. > > > > I know how to do this in PHP with $query_total_rows. Is there some way > > in > > SQL to do this, or do I need to figure out a way to do it in the shell > > script? > > > > Thanks, > > Mike > > > -- > Brent Baisley > Systems Architect > Landover Associates, Inc. > Search & Advisory Services for Advanced Technology Environments > p: 212.759.6400/800.759.0577 > > > -- > Live Life in Broadband > www.telewest.co.uk > > > The information transmitted is intended only for the person or entity to which > it is addressed and may contain confidential and/or privileged material. > Statements and opinions expressed in this e-mail may not represent those of > the company. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or entities > other than the intended recipient is prohibited. If you received this in > error, please contact the sender immediately and delete the material from any > computer. > > == > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, 2003 19:41 Subject: RE: Challenging query > On Thu, 2003-10-16 at 17:42, Jeff McKeon wrote: > > Is there a way to generate a "line number" for a query return within the > > returned rows?? > > > > For instance, if I return 5 rows from a query, is there a command or > > function I can put in a query to add a column that contains the row > > number returned? > > > > Select some_command(),blah, blew from table where blah > 1; > > > > +---+---+---+ > > | row | blah | blew | > > +---+---+---+ > > | 1 | blah | blew | > > | 2 | blah | blew | > > | 3 | blah | blew | > > | 4 | blah | blew | > > +---+---+---+ > > You can do: > > SELECT @a:=0; > SELECT @a:[EMAIL PROTECTED], blah, blew from table where blah > 1; > > > -- > Diana Soares > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 table name. So, he was asking how he could do that change and continue using his application that still uses the old table and columns. I think I have found a solution: using MERGE tables. It that user is still in need of this I will be happy to send it over. Unfortunaly, I am unable to find his post as I have a lot of mails to search in!!! 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.nefacomp.net/
