Re: Table and indexes
A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT NULL. If they are not explicitly declared as NOT NULL, MySQL will declare them so implicitly (and silently). A table can have only one PRIMARY KEY. If you don't have a PRIMARY KEY and an application asks for the PRIMARY KEY in your tables, MySQL returns the first UNIQUE index that has no NULL columns as the PRIMARY KEY. (MySQL Manual | 14.2.6 CREATE TABLE Syntax) http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html --- Cemal Dalar [EMAIL PROTECTED] wrote: Is this normal to have a index like below.. As I know there is no need to have KEY and UNIQUE for a PRIMARY KEY PRIMARY KEY (`urun_id`), UNIQUE KEY `UC_urun_id` (`urun_id`), KEY `IDX_urun_urun_id` (`urun_id`), KEY `ktgr` (`ktgr`) ) TYPE=MyISAM Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.dalar.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
confused about character sets in mysql 4.1.3b
Hello list, I have already installed mysql 4.1.3 beta to my windows xp. I set default-caharacter-set to latin5 and default-collation to latin5_turkish_ci in my.ini configuration file. Because I want latin5 my default character set. Then I restarted mysql service and looked up character set and collation variables. And get cofused. - In WinMySQLAdmin1.4 variables tab I see the following results: character_set_client = latin1 character_set_connection = latin1 character_set_database = latin5 character_set_results = latin1 character_set_server = latin5 character_set_system = utf8 collation_connection = latin1_swedish_ci collation_database = latin5_turkish_ci collation_server = latin5_turkish_ci - When i execute show variables like '%character%' and show variables like '%collation%' queries from the command line i get the same results. - When i execute the same queries from phpMyAdmin 2.5.7-pl1 i get different result set. character set client = latin5 character set connection = latin5 character set database = latin5 character set results = latin5 character set server = latin5 character set system = utf8 collation connection = latin5_turkish_ci collation database = latin5_turkish_ci collation server = latin5_turkish_ci First off all I could not understand why the results are different. And second, does not all my variables have to be latin5 and latin5_turkish_ci because of the configuration I have done in my.ini file? Thanks in advace. Harun __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
formatted text
Hello list, What is the best way to store and search formatted text? Thanks in advance. __ New! Unlimited Netscape Internet Service. Only $9.95 a month -- Sign up today at http://isp.netscape.com/register Act now to get a personalized email address! Netscape. Just the Net You Need. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
off-topic but need help : [FWD: ezmlm warning]
Hello, Today i have received the attached message from mysql-ezmlm. But I could not understand what is going on. Is there anyone who will be able to explain what the ezmlm tries to tell me and what I have to do? Thanks in advance. __ New! Unlimited Netscape Internet Service. Only $9.95 a month -- Sign up today at http://isp.netscape.com/register Act now to get a personalized email address! Netscape. Just the Net You Need. ---BeginMessage--- Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. I'm working for my owner, who can be reached at [EMAIL PROTECTED] Messages to you from the mysql mailing list seem to have been bouncing. I've attached a copy of the first bounce message I received. If this message bounces too, I will send you a probe. If the probe bounces, I will remove your address from the mysql mailing list, without further notice. I've kept a list of which messages from the mysql mailing list have bounced from your address. Copies of these messages may be in the archive. To retrieve a set of messages 123-145 (a maximum of 100 per request), send an empty message to: [EMAIL PROTECTED] To receive a subject and author list for the last 100 or so messages, send an empty message to: [EMAIL PROTECTED] Here are the message numbers: 157680 --- Enclosed is a copy of the bounce message I received. Return-Path: Received: (qmail 4069 invoked from network); 15 Jan 2004 10:25:25 - Received-SPF: unknown Received: from omr-m07.mx.aol.com (HELO omr-m07.mx.aol.com) (64.12.138.19) by lists.mysql.com (qpsmtpd/0.27-dev) with ESMTP; Thu, 15 Jan 2004 11:25:25 +0100 Received: from rly-nc01.mx.aol.com (rly-nc01.mail.aol.com [172.18.151.198]) by omr-m07.mx.aol.com (v97.10) with ESMTP id RELAYIN5-640066a893e; Thu, 15 Jan 2004 05:25:13 -0500 Received: from localhost (localhost) by rly-nc01.mx.aol.com (8.8.8/8.8.8/AOL-5.0.0) with internal id FAC23082; Thu, 15 Jan 2004 05:25:13 -0500 (EST) Date: Thu, 15 Jan 2004 05:25:13 -0500 (EST) From: Mail Delivery Subsystem [EMAIL PROTECTED] Message-Id: [EMAIL PROTECTED] To: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: multipart/report; report-type=delivery-status; boundary=FAC23082.1074162313/rly-nc01.mx.aol.com Subject: Returned mail: Host unknown (Error 275) Auto-Submitted: auto-generated (failure) X-AOL-IP: 172.18.151.198 This is a MIME-encapsulated message --FAC23082.1074162313/rly-nc01.mx.aol.com The original message was received at Thu, 15 Jan 2004 05:24:56 -0500 (EST) from lists2.mysql.com [213.136.52.31] *** ATTENTION *** Your e-mail is being returned to you because there was a problem with its delivery. The address which was undeliverable is listed in the section labeled: - The following addresses had permanent fatal errors -. The reason your mail is being returned to you is listed in the section labeled: - Transcript of Session Follows -. The line beginning with describes the specific reason your e-mail could not be delivered. The next line contains a second error message which is a general translation for other e-mail servers. Please direct further questions regarding this message to your e-mail administrator. --AOL Postmaster - The following addresses had permanent fatal errors - [EMAIL PROTECTED] - Transcript of session follows - 550 [EMAIL PROTECTED]... Host unknown (Error 275) --FAC23082.1074162313/rly-nc01.mx.aol.com Content-Type: message/delivery-status Reporting-MTA: dns; rly-nc01.mx.aol.com Arrival-Date: Thu, 15 Jan 2004 05:24:56 -0500 (EST) Final-Recipient: RFC822; [EMAIL PROTECTED] Action: failed Status: 5.1.2 Remote-MTA: DNS; air-nc02.mail.aol.com Last-Attempt-Date: Thu, 15 Jan 2004 05:25:13 -0500 (EST) --FAC23082.1074162313/rly-nc01.mx.aol.com Content-Type: text/rfc822-headers Received: from lists.mysql.com (lists2.mysql.com [213.136.52.31]) by rly-nc01.mx.aol.com (v97.10) with ESMTP id MAILRELAYINNC19-66740066a741ab; Thu, 15 Jan 2004 05:24:52 -0500 Received: (qmail 308 invoked by uid 109); 15 Jan 2004 10:23:24 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 32756 invoked from network); 15 Jan 2004 10:23:24 - Received-SPF: unknown (domain of sender [EMAIL PROTECTED] does not designate mailers: NXDOMAIN) Message-ID: [EMAIL PROTECTED] Date: Thu, 15 Jan 2004 02:23:19 -0800 (PST) From: Aron Bereket [EMAIL PROTECTED] Subject: Mysql problem + Problem in loading data SOLVED To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-AOL-IP: 213.136.52.31 X-AOL-SCOLL-SCORE: 0:XXX:XX X-AOL-SCOLL-URL_COUNT: 0 X-AOL-INRLY: lists2.mysql.com
select distinct from two columns
Hello, The two columns of my table are name and city. I am trying to do a list which contains only the different names. This can be done this by distinct keyword. But all the same names which have different cities also have to be included in my list. So I can not do this with a distinct keyword. Any ideas? Thanks in advance. __ New! Unlimited Access from the Netscape Internet Service. Beta test the new Netscape Internet Service for only $1.00 per month until 3/1/04. Sign up today at http://isp.netscape.com/register Act now to get a personalized email address! Netscape. Just the Net You Need. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: select distinct from two columns - solved
:) I have solved the problem. Thanks. [EMAIL PROTECTED] (Veysel Harun Sahin) wrote: Hello, The two columns of my table are name and city. I am trying to do a list which contains only the different names. This can be done this by distinct keyword. But all the same names which have different cities also have to be included in my list. So I can not do this with a distinct keyword. Any ideas? Thanks in advance. __ New! Unlimited Access from the Netscape Internet Service. Beta test the new Netscape Internet Service for only $1.00 per month until 3/1/04. Sign up today at http://isp.netscape.com/register Act now to get a personalized email address! Netscape. Just the Net You Need. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ New! Unlimited Access from the Netscape Internet Service. Beta test the new Netscape Internet Service for only $1.00 per month until 3/1/04. Sign up today at http://isp.netscape.com/register Act now to get a personalized email address! Netscape. Just the Net You Need. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fw: Server-Client
I could not understand what you try to do. But generally mysql runs on a server machine and the clients connect to it. Every client program you write can connect to mysql server seperately. If you want and need you can also write a server program too. But you have to be more clear about your problems and purpose to get a good answer. [EMAIL PROTECTED] wrote: Hi all, I think that I should ask the question like that. I want to run MySQL on 14 client. What am I do. I try but There is a problem that i can't find... Please help me. Hseyin DEMRA stikbal Furniture Int. - Original Message - From: Mike Hillyer [EMAIL PROTECTED] To: Hseyin DEMIRAG [EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 6:03 PM Subject: RE: Server-Client Can you be more specific? A client application written on a test machine that also houses the server will just need a different IP address in it's DSN/Connection String and a copy of MyODBC on the new client machine. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Hseyin DEMIRAG [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 8:54 AM To: 1MySql - MySql Subject: Server-Client Hello, I coded a program by using VB 6.0 I will use this program on network(nearly 12 user). is it necessary to code two different program for both of server and client. Or, Can I solve this problem by MYSQL Control Center. Hseyin DEMRA stikbal Furniture nt. -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: joining two columns from two different tables in a query - solved
Thanks Michale. The problem is solved.:) Michael Satterwhite [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 20 July 2003 14:18, Veysel Harun Sahin wrote: Hello, I have to join two columns from different tables in a query. Assume that I have two tables: staff idcompany_Id name 11FirstName 21SecondName 32ThirdName company company_Id owner 1MyOwnerName 2SecondOwnerName Here I need to join the columns staff.name and company.owner from two tables with the name joined_column so I can do order by on them. For example when I query two tables with the company_id = 1 I want to get a resultset like this: joined_column FirstName MyOwnerName SecondName Any comments? This is a UNION query. For example: Select name as Joined_column from Staff where company_id = 1 UNION Select owner as Joined_column from company where company_id = 1; -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQE/Gv6YjeziQOokQnARAmoLAKCf6NSmFaLG5foQYZtbHpeGuUZJOgCgrINR Q1SFb1eu7DUXAIV/44savs8= =4h+/ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
joining two columns from two different tables in a query
Hello, I have to join two columns from different tables in a query. Assume that I have two tables: staff idcompany_Id name 11FirstName 21SecondName 32ThirdName company company_Id owner 1MyOwnerName 2SecondOwnerName Here I need to join the columns staff.name and company.owner from two tables with the name joined_column so I can do order by on them. For example when I query two tables with the company_id = 1 I want to get a resultset like this: joined_column FirstName MyOwnerName SecondName Any comments? Thanks in advance. [sql, query, mysql] -- Veysel Harun Sahin [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 -- user accounts
Did you try to select a database before querying the table? You can do this with use command. mysqluse mysql; Then your command; mysqlselect * from user; [EMAIL PROTECTED] wrote: I setup MySQL 4.0.13 Win32. I also setup PHP 4.3.2. I am trying to learn MySQL and PHP. I am using PHP MySQL for dummies. I am having a problem. Look: mysql SELECT * FROM user - ; ERROR 1046: No Database Selected mysql Ok so the book says This message means your account is not allowed to slect the mysql database Well... MySQL/Apache/PHP are installed on this local box. How can I setup a username and password that have admin rights to the mysql database? Or how can I login to Root? It has admin rights automaticly right? I would like to choose my own username/password and give that account admin rights Thank you For Your Protection This Email Was Scanned by Apollo Systems MailServer. For More Services Please Visit http://www.apollosystems.net -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question: using Visual Studio.NET
You can access a mysql database within VS.Net through odbc. To do this you have install myodbc. You can get this from mysql website. After installing myodbc you have to create a new datasource. Then you can connect to mysql with the help of adodb object in vs.net. I have never tried to connect mysql within access. But I think so you can do this too through odbc. If you need I can send you samples codes too. [EMAIL PROTECTED] wrote: Hi Everybody, 1- I am trying to upsize an access database to my MySQL server on my website. I tried to get connected within access and failed. Please advise. I am using Win XP as the operating system and MS Office XP Pro. 2- How to connect a Visual Studio.NET project to a MySQL data base located on a MySQL server on a web. I tried to establish a connection with the server from within VS.NET project using th normal procedure, but failed. I could connect to a local SQL server. however I need to use MySQL server on my website. I have the IP address, User ID and Password of the server. Please advise. I am using VS.NET 2003. Many thanks. T. Rady _ No masks required! Use MSN Messenger to chat with friends and family. http://go.msnserver.com/HK/25382.asp -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Managing big tables
http://www.mysql.com/doc/en/Data_size.html [EMAIL PROTECTED] wrote: Hello, i've got a little problem, we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on HD), the other contains nearly 200.000.000 (130 Gb on HD). Now we want to delete some rows from these tables to free diskspace. It seems that MySQL frees the harddisk-space which was used by these rows only after optimization, which lasts very long on these tables. Both tables are dynamic in terms of row-format what seems to extend the time needed for optimization. I tried to convert the smaller one to fixed-row-format, which increased the disk-space of its data-file from 30 Gb to 60 Gb. This would not be the problem, but some SQLs which are run daily on this table now run 4 times slower than with dynamic structure. So, my questions are: 1) Did i something wrong while converting to fixed row-format ? (i found no indication) 2) Is the fixed structure really faster on optimization ? 3) Can anybody confirm the slow-down on big tables when converted from dynamic to fixed ? (on small tables fixed were faster) I'm running SuSE Linux, Kernel 2.4.20, the above behaviour could be reproduced with our productive server (MySQL 3.23) and with a test server (MySQL 4.0.12). thanks in advance, alex -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Managing big tables
Sorry rudy, but I can not understand what you try to say! I can only say that if you follow the link below and read the explanations on that page and also follow the related links you can find answers to Alex's problems. [EMAIL PROTECTED] wrote: Always take care what you want to achieve! And consider the circumstances. Yes, adding a lot of indexes makes queries faster. But makes inserts/deletes/updates slower. Alex's problem is NOT that his/her queries takes too long, the problem is that optimize takes too long. Which is something completely different. Cheers /rudy -Original Message- From: Veysel Harun Sahin [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 15:22 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Managing big tables http://www.mysql.com/doc/en/Data_size.html [EMAIL PROTECTED] wrote: Hello, i've got a little problem, we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on HD), the other contains nearly 200.000.000 (130 Gb on HD). Now we want to delete some rows from these tables to free diskspace. It seems that MySQL frees the harddisk-space which was used by these rows only after optimization, which lasts very long on these tables. Both tables are dynamic in terms of row-format what seems to extend the time needed for optimization. I tried to convert the smaller one to fixed-row-format, which increased the disk-space of its data-file from 30 Gb to 60 Gb. This would not be the problem, but some SQLs which are run daily on this table now run 4 times slower than with dynamic structure. So, my questions are: 1) Did i something wrong while converting to fixed row-format ? (i found no indication) 2) Is the fixed structure really faster on optimization ? 3) Can anybody confirm the slow-down on big tables when converted from dynamic to fixed ? (on small tables fixed were faster) I'm running SuSE Linux, Kernel 2.4.20, the above behaviour could be reproduced with our productive server (MySQL 3.23) and with a test server (MySQL 4.0.12). thanks in advance, alex -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied, simple task
An idea; Did you try to set user name with ip address of the computer you are running instead of localhost? I think it is worth to try and hope it helps. grant all on myFineDb.* to [EMAIL PROTECTED] identified by abcpass; [EMAIL PROTECTED] wrote: What works for me with mysql 3.23.49 of Debian GNU/Linux (Woody), does not any more with mysql 3.23.56 of fink (current-stable, for fink cf. fink.sf.net) - I am not sure, if this problem is caused by the mysql version (some security changes between .49 and .56) or by the fink configuration - I might ask at the fink-users list later. I am trying to create a database and a mysql user with privileges to use it - a rather simple thing to do (my knowledge is mostly from Paul Du Bois' books: MySQL and MySQL Recipes) I start creating the database as the mysql root user $ mysqladmin -u root -p*** create myFineDb Next, I create the user and give him privileges to use myFineDb (again as the mysql root user) $ mysql -u root -p*** mysql grant all on myFineDb.* to [EMAIL PROTECTED] identified by abcpass; mysql ^D (to leave mysql) (So far no problems, now comes the thing:) $ mysql -u abc -pabcpass myFineDb Works fine in Debian (.49) but not in fink (.56): [mac:~] reuleaux% mysql -u abc -pabcpass myFineDb ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb' [mac:~] reuleaux% If I look closer at the problem I see that I can at least log in but not use the database: [mac:~] reuleaux% mysql -u abc -pabcpass Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 24 to server version: 3.23.56 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use myFineDb; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb' mysql I have tried variations of the upper grant command with no succes either: ...to 'abc'@'localhost' ... Any help is appreciated. Andreas -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: the number of Rows (records)
SELECT COUNT(*) FROM table_name; [EMAIL PROTECTED] wrote: Hi, Is there any command or function in MySQL to find out how many records a table has? phpMyAdmin shows the number of records ( Rows ) when shows the structure of a table plus Row Length more information. How can we find these table information? Thanks -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select by weekly SUM
SELECT week, sum(tips) FROM mytable GROUP BY week; [EMAIL PROTECTED] wrote: I have a table of daily information (tips, # of deliveries, etc.). Does anyone know of an easy way using SQL to extract all weekly sums of a field? Like: week 1: sum of tips for that week week 2: sum of tips for that week week 3: sum of tips for that week week 4: sum of tips for that week week 5: sum of tips for that week I can do them one week per query (obviously) but would like one query that will spit them all out, one after the other. -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: query: if exists UPDATE else INSERT?
Try this: set @w = 0; select @w := value from table where id = 20030713; delete from table where id = 20030713; insert into table values (20030713, @w + 20); [EMAIL PROTECTED] wrote: Hello, I'm looking for a solution to write a sql query that inserts a set of data if the data id is not present and otherwise update the set. I have a table with id (char(8)) and value (int(8)) To make my problem clear: There is no set with id = 20030713 insert into table values (20030713,10); The next set is (20030713,20) but as a set with 20030713 is already available I like to have update table set value = value + 20 where id = 20030713 I tried the replace command but I fail to get the value = value + 20 working. The problem is that the query is called from within a programm that only can call a query but not get some data back. Also a solution in form of mysql $w = select value from table where id = 20030713; delete from table where id = 20030713; insert into table values (20030713,$w + 20); mysql would be fine but I think that $w = part isn't working with mysql ;-) Its no solution to simply make the table accept duplicate entries for id and make a sum(value) group by id because I think it will be a performace problem if I have thousends of datasets a day - If I'm wrong let me know. Any hints how to manage this?? Alexander Newald -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select by weekly SUM
Then you can use the week function of mysql in group by clause like this: SELECT sum(tips) FROM mytable GROUP BY WEEK(date); This will group your records week by week then will sum each week's tips. Also you can look at http://www.mysql.com/doc/en/Date_and_time_functions.html for the date and time functions in mysql. [EMAIL PROTECTED] wrote: On Sun, 13 Jul 2003 11:03:21 +0300, Veysel Harun Sahin wrote: SELECT week, sum(tips) FROM mytable GROUP BY week; Sorry, I wasn't clear. I have ONLY daily data, not weekly, but I want to output weekly data. These are the fields I have: date DATE NOT NULL, hours_worked DECIMAL(5,2), no_of_deliveries TINYINT(1) UNSIGNED, total_tips DECIMAL(5,2), gas_used TINYINT(1) UNSIGNED, notes TEXT There is no week field. So, I have to compute 'week by adding together sum(tips) for 7 consecutive days. Any suggestions how I can extract many consecutive weekly sums? -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problems with farsi sorting!!
You can change your charset by adding a line in your mysql configuration file like this. default-character-set = cp1256 Here cp1256 means that mysql will use Windows Arabic character set. I don't know the difference between farsi and arabic charsets. And also I don't know if mysql has a farsi charset support. But if you are able to use arabic charset you can set your charset to cp1256 like above. You can also take a look at http://www.mysql.com/doc/en/Charset-charsets.html page. Here you can get info about mysql charsets. [EMAIL PROTECTED] wrote: I use unicode to store farsi data in mysql database but I have problems sorting it using ORDERBY command...(ORDER BY does'nt work properly) I don't know what to do . 1---)pleases help me if there is any solution for me to define a charset in the order that I want . 2---) how can I replace the default charset of mysql (latin1) with this new charset. 3---) please help me if there is any other solution like writing a functioin (how should I write a functioin). thanx for your helps... - Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HAI SIR
Did you set max_allowed_packet variable? If not set it in your configuration file like this: set variable = max_allowed_packet = thesizeyouneedM [EMAIL PROTECTED] wrote: Dear Sir , this is bhanuprakash m from smartifacts , india , ap , hyderabad please can you provide me a solution tomy problem , my problem is , while loding large amount oF data FILE ( more then 16MB ) to LONGBLOB i am getting exception , i am using Mysql with INNODB , please can you provide solution bhanuprakash www.smartifacts.com -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock problem - solved
Problem solved. Thanks victoria.:) [EMAIL PROTECTED] wrote: Veysel Harun Sahin [EMAIL PROTECTED] wrote: I am using mysql 3.23.49 on openbsd3.2 with php4.2.3. Formerly I was connecting to mysql with php without any problem but now (I don't know what I have changed) when I try to connect to mysql with php it gives the following errors: Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /htdocs/index.php on line 3 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /htdocs/index.php on line 3 I have controlled mysql.sock file and its path is true. Also mysql server is up and running. Check permission on the socket file. -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql.sock problem
Hello, I am using mysql 3.23.49 on openbsd3.2 with php4.2.3. Formerly I was connecting to mysql with php without any problem but now (I don't know what I have changed) when I try to connect to mysql with php it gives the following errors: Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /htdocs/index.php on line 3 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /htdocs/index.php on line 3 I have controlled mysql.sock file and its path is true. Also mysql server is up and running. Any comments? Thanks in advance. [sql, query] -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Delphi 7 and MySQL 4.1.0 alpha
Did you try to put this dll into your application directory? The common way to use this dll is to hold it together with executable. [EMAIL PROTECTED] wrote: Hello, I'm trying to get connection on MySQL 4.1.0 alpha edition by using the SQLCOnnection (dbExpress) object. I am having the error 'Unable to load libmysql.dll'. I placed this file into the winnt\system32 folder... still didn't work. I put the whole path into the VendorLib... still didn't work. Any ideas? I have to use this version of MySQL as it succefully supports the SubSelects. Thanks George Christoforakis. -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Maximum table size
If your os permits, mysql can handle file sizes up to terabytes. You don't need to spawn your tables. But you have to be careful when creating your myisam tables. If you don't specify your table size limit with the max_rows option when creating table mysql will create a table with 4G file size limit. If you use innodb you can setup auto extend feature, so you don't need to control your table size, if it reach its maximum innodb will automatically extend its file size. [EMAIL PROTECTED] wrote: Hello As i understand it mysql maintains a file for every table created. Does it mean that the filesystem restricts the maximum size of a given table or do i have the option to make table data spawn more than on file like in oracle? Thanks in advance Mark Vollmann Mit freundlichen Grüßen, Mark Vollmann accelsis technologies GmbH www.accelsis.de Boschetsrieder Str. 20 D - 81379 München Tel. +49 (0)89 1893599-0 Fax. +49 (0)89 1893599-99 [EMAIL PROTECTED] -- Die Information in dieser E-Mail ist vertraulich und kann dem Berufsgeheimnis unterliegen. Sie ist ausschließlich für den Adressaten bestimmt. Jeglicher Zugriff auf diese E-Mail durch andere Personen als den Adressaten ist untersagt. Sollten Sie nicht der für diese E-Mail bestimmte Adressat sein, ist Ihnen jede Veröffentlichung, Vervielfältigung oder Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im Vertrauen auf erlangte Information untersagt. In dieser E-Mail enthaltene Meinungen oder Empfehlungen unterliegen den Bedingungen des jeweiligen Mandatsverhältnisses mit dem Adressaten. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing accelsis technologies client -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OpenBSD
Did you try to use packages instead of ports? It is simpler then compiling from source. Try it if you have not reasonable causes to use ports. [EMAIL PROTECTED] wrote: I hope I can get some help here, I'm installing mySQL on OpenBSD and i cannot find the mysql_install_db file, all the documentation that I've read is saying its the first step after doing make and make install from the ports tree. FYI: Its not in /usr/local/bin, and there was no /usr/local/mysql dir, and of course no /usr/local/share/doc/mysql dir either so far this has been a small nightmare for me. Has others had this problem with OpenBSD? And if so can you point me in the right direction to get it running! Thanks! Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Veysel Harun Sahin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [help] with browsing table?
Is your table empty? [EMAIL PROTECTED] wrote: why am i not able to select the browse link on mysql phpmyadmin to view my table ultimatefootballleague.com/index.php [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Veysel Harun Sahin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using 3.23 and Delphi 6
Try zeos lib at http://zeoslib.sourceforge.net/ [EMAIL PROTECTED] wrote: Hi I am currently trying to use mysql 3.23 for a database project and connect to it using a Delphi 6 front end. Can anyone tell me how the connect to a MySQL database and any other tips they might have on using Delphi 6 with MySQL. I have never used MySql before and so the information needs to be pretty specific. Hope someone can help Thanks Clive Glasgow --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.456 / Virus Database: 256 - Release Date: 18/02/2003 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Veysel Harun Sahin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sql select from question
Hello list, I want to select all the columns in a table except one column. Can I do this without writing all the column names to the query? For example assume that I have table with the name table1 and there are 50 columns in table1 with the names col1, col2, col3.col50. To be able to select all the columns except col35 I have to write a query like SELECT col1, col2, , col34, col36, col50 FROM table1. Is there a simpler way to do this for example using not operator with the column name col35? Thanks. sql, query, select vb. -- Veysel Harun Sahin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql select from question
Thanks dread. Yes it can be done programmatically. But i try to do only with sql. I don't want to hardcode it. [EMAIL PROTECTED] wrote: On 24-Feb-2003 Veysel Harun Sahin wrote: Hello list, I want to select all the columns in a table except one column. Can I do this without writing all the column names to the query? For example assume that I have table with the name table1 and there are 50 columns in table1 with the names col1, col2, col3.col50. To be able to select all the columns except col35 I have to write a query like SELECT col1, col2, , col34, col36, col50 FROM table1. Is there a simpler way to do this for example using not operator with the column name col35? Not that I know of. Depending on the application language it might be easier to post-process: $result = mysql_query('SELECT * FROM mytable'); while ($row = mysql_fetch_array($result, MYSQL_NUM)) { unset($row[34]); echo 'The values :', implode(', ', $row), 'br'; } Regards, -- Veysel Harun Sahin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on Mandrake 9 with EXT3 File system... Max Size?
You can see your max table size at the row Max datafile length: 4294967294. This means that your UsedData table's max size is 4G. If you want to change it you have to use alter table command with the option max_rows. For example ALTER TABLE UsedData MAX_ROWS = 100. [EMAIL PROTECTED] wrote: Hi, this is my first post here, I hope it's easily answered I've got Mandrake Linux 9, with the ext3 file system What is the absolute maximum table size I can have? And what do I need to change to achive that? I've spent half the night googling, and couldn't find a real answer so now I throw my helpless soul onto those who use it more then I do (c: Below is information about the table. MyISAM file: UsedData Record format: Packed Character set: latin1 (8) File-version:1 Creation time: 2003-02-17 14:09:19 Recover time:2003-02-20 0:28:44 Status: checked Data records:17530 Deleted blocks: 0 Datafile parts: 17530 Deleted data: 0 Datafile pointer (bytes):4 Keyfile pointer (bytes):3 Datafile length: 1267264 Keyfile length: 1024 Max datafile length:4294967294 Max keyfile length: 17179868159 Recordlength: 73 Any help would be greatly appreciated. Thanks Shannon To bypass the anti spam filters: sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Veysel Harun Sahin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need Help With MySQL Query
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber; [EMAIL PROTECTED] wrote: hello, I've performed searches on this site and php.net to try and figure out why this is occuring. I can't find any instance in my searches that helped me. So, I'm posting my very first question to this list Here's my table ($usertableDaily): vanNumber|grossPay - | 1000 | 500 |100 |100 Here's my query: SELECT SUM(grossPay) FROM $usertableDaily WHERE vanNumber = $vanList[$count] The query appears inside a loop hence the $vanList[$count] variable. I have a txt file that contains the van numbers. I read that file and then run through the loop and for each van number I execute the above statement. Yes, I've trimmed off any extra blank spaces before and after the 'read' van numbers... I want to SUM the grossPay for each van number. Here's what it should be: $1500 $200 But when I execute I get this: Resource id#3 Resource id#4 Anyone got any idea why this is happening? Thanks in advance, Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Veysel Harun Sahin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: NEWBIE to mysql
mysql CREATE TABLE info - ( - name varchar(50), - message varchar(255) - ) - ; [EMAIL PROTECTED] wrote: Can anyone tell me why I keep getting an ERROR 1064 with this command ? I just would like to create a table with two fields, name and messages for a Simple guestbook but I want to store the data in a mysql database. mysql CREATE TABLE info - ( - name varchar(50) - message varchar(255) - ) - ; thanks, -wiley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sort problem
Store town numbers in another column. [EMAIL PROTECTED] wrote: Hi, How can I fix an order by using numbers and letters ? Id Town 56 Paris 1 60 Paris 10 7 Paris 11 262 Paris 12 8 Paris 13 16 Paris 14 22 Paris 15 6 Paris 3 57 Paris 4 51 Paris 6 5 Paris 7 61 Paris 8 59 Paris 9 I'd like to get : 56 Paris 1 6 Paris 3 57 Paris 4 51 Paris 6 5 Paris 7 61 Paris 8 59 Paris 9 60 Paris 10 7 Paris 11 262 Paris 12 8 Paris 13 16 Paris 14 22 Paris 15 A this time I'm doing this sql syntax : SELECT * FROM town ORDER BY town ASC How can I do it ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Not sure my other email got through!
select table1.name, table2.id2+table2.col1+table2.col2+table2.col3 as mysumresult from table1 left join reference using (id1) left join table2 using (id2); [EMAIL PROTECTED] wrote: Not sure my other email got through, so here it is again, with an updated description of the problem. Hi, I have a database with 3 names in it. In each of these names is 5 categories that have numbers in them. I want to be able to do a select and total these numbers for each name, and then sort them in descending order. I have tried for over 6 hours tonight and no matter what I do, there is one minor glitch. I am not supplying any code as I would like to know from you people first what the best way to go about this would be - as what I have done is obviously not working. TIA i.e This is what is in the database. Table 1 ID1 NAME 1 Bill 2 John 3 Fred Table 2 ID2 Col1 Col2 Col3 Col4 1 1456 2 3286 3 4922 Database 3 is a reference file that ties them together - so I would have to use a join in the select statement. ID1 ID2 11 22 33 This is what I want to be able to show: John 21 Fred 20 Bill 16 sql, query, queries, smallint - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: converting MS SQL to MySQL
Take look at http://www.mysql.com/doc/en/CREATE_TABLE.html [EMAIL PROTECTED] wrote: Hi, I am new to SQL. I am attempting to create a database that was created in MS SQL to MySQL. The below SQL statements works with MS SQL. I am executing the following: CREATE TABLE 'Accounting'( 'Username' VARCHAR(254) NULL, 'CallerID' VARCHAR(128) NULL, 'Addr' VARCHAR(128) NULL, 'NAS' VARCHAR(128) NULL, 'Port' VARCHAR(128) NULL, 'Start' DATETIME NULL, 'Stop' DATETIME NULL, 'SessionTime' INTEGER DEFAULT 0, 'ExtraTime' INTEGER DEFAULT 0, 'TimeLeft' INTEGER DEFAULT 0, 'KBytesIn' INTEGER DEFAULT 0, 'KBytesOut' INTEGER DEFAULT 0, 'SessionKB' INTEGER DEFAULT 0, 'ExtraKB' INTEGER DEFAULT 0, 'KBytesLeft' INTEGER DEFAULT 0, ) GO CREATE INDEX IX_Username ON Accounting(Username) MySQL will not take this command GO CREATE TABLE 'ActiveUsers'( 'UserID' VARCHAR(254) PRIMARY KEY, 'NAS' VARCHAR(128) NULL, 'Port' VARCHAR(128) NULL, 'Username' VARCHAR(254) NULL, 'CallerID' VARCHAR(128) NULL, 'Address' VARCHAR(128) NULL, 'LoginTime' DATETIME NULL, ) GO CREATE TABLE 'TAC_GRP'( 'TAC_ID' VARCHAR(254) NOT NULL, 'TAC_Attr' VARCHAR(64) NOT NULL, 'TAC_Val' TEXT NULL ) GO CREATE UNIQUE INDEX IX_TAC_ID ON TAC_GRP(TAC_ID, TAC_Attr) MySQL will not take this command GO CREATE TABLE 'TAC_USR'( 'TAC_ID' VARCHAR(254) NOT NULL, 'TAC_Attr' VARCHAR(64) NOT NULL, 'TAC_Val' TEXT NULL ) GO CREATE UNIQUE INDEX IX_TAC_ID ON TAC_USR(TAC_ID, TAC_Attr) MySQL will not take this command GO Thanks in advance. --- [This E-mail scanned for viruses by Friend.ly.net.] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: encrypted password
Try this: insert into tablename values ('myusername', password('mypassword')); [EMAIL PROTECTED] wrote: On Tue, Feb 04, 2003 at 02:58:28PM -0500, Jianping Zhu wrote: I have mysql in a redhat machine. I need to use mysql do user authentication to a website. I have a table like following. +--+--+ | username | passwd | +--+--+ | jianping | jian1830 | | chichi | jian1830 | +--+--+ I want the passwd field not to be plain text but encrypted. how can i do that? Not for sure on the exact syntax becuse I've always used myPhpAdmin's md5 utility but it would be something like MD5(jian1830) this would do an MD5 hash -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.55-nt on Windows 2000: Trying to Create InnoDB Tables
Take a look at http://www.mysql.com/doc/en/NT_start.html. And about innodb tables you can read http://www.innodb.com/ibman.html. [EMAIL PROTECTED] wrote: I've got a beginner's question: I've installed SQL Server, and begun building tables; when I create a new table, the table type is defaulting to MyISAM. I wanted to change it to InnoDB, but everytime I save it, it reverts back to MyISAM. Is this feature not available in Windows? It appears that max version of SQL Server is only available for Linux. Let me know. Thank you! Dana - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4G file limit
Hello, I am using mysql3.23.49 on openbsd3.2. I have a myisam table with 4G file size and now I can no longer insert records into table. My mysql data partition is not full (%24 used). I have read that mysql 3.23 supports up to 2 terabytes table size. Not so sure but I know openbsd's file size limit is bigger than 4G. Here is my error log. Failed on my_net_write, writing to stderr instead: Found block with too small length at 4294914928; Skipped Failed on my_net_write, writing to stderr instead: Found block that points outside data file at 4294915080 Any comments? Thanks. mysql, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4G file limit - solved
Yes, setting up MAX_ROWS parameter is the right solution i think. I have tried it with alter table command and it seems to work. Thanks all. [EMAIL PROTECTED] wrote: Hi, Even if you have large file support you must tell mysql to use long pointers when creating the table. The way to accomplih this is to add the MAX_ROWS table option when creating the table, just make it a really large number like 50. You can verify this effect by BEFORE makeing the change, use SHOW TABLE STATUS LIKE 'MYTABLE' . Then look at the max_data_length column. Before you change it will be this 4294967295 (4.0G), after your change it will be something like 1099511627775. Yes, the error message does not make sense. I have not had time to build a test case to get to MySQL so they can give us a better error message. See this manual page for info on create table. http://www.mysql.com/doc/C/R/CREATE_TABLE.html You can just alter the table with this option. Hope this helps, - Original Message - From: Veysel Harun Sahin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 03, 2003 4:49 AM Subject: 4G file limit Hello, I am using mysql3.23.49 on openbsd3.2. I have a myisam table with 4G file size and now I can no longer insert records into table. My mysql data partition is not full (%24 used). I have read that mysql 3.23 supports up to 2 terabytes table size. Not so sure but I know openbsd's file size limit is bigger than 4G. Here is my error log. Failed on my_net_write, writing to stderr instead: Found block with too small length at 4294914928; Skipped Failed on my_net_write, writing to stderr instead: Found block that points outside data file at 4294915080 Any comments? Thanks. mysql, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql_install_db doesn't install grant tables
have look at http://www.mysql.com/doc/en/mysql_install_db.html [EMAIL PROTECTED] wrote: Description: When I tried to start MySQL server with shell/usr/bin/safe_mysqld it gave me the error: - Starting mysqld daemon with databases from /var/lib/mysql 030128 08:56:42 mysqld ended - The log file /var/lib/mysql/stvme2.log has only following: /usr/libexec/mysqld, Version: 3.23.52-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument The log file /var/log/mysqld.log has the followings: -- 030128 08:56:42 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 030128 8:56:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errn o: 13) 030128 08:56:42 mysqld ended -- I did put the line innodb_data_file_path = ibdata1:10M:autoextend on the mentioned place now it gaves the same error with log: -- 030128 09:56:44 mysqld started 030128 9:56:44 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get better performance if you configure a bigger InnoDB: value in the MySQL my.cnf file for InnoDB: innodb_additional_mem_pool_size. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 030128 9:56:44 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 030128 9:56:45 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 030128 9:56:45 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 030128 9:56:46 InnoDB: Started 030128 9:56:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030128 09:56:46 mysqld ended It would be great if one could help me on this. Thanks in advance, Ozlem How-To-Repeat: Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: Ozlem Celik Originator:development Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.52 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux stvme2.astro.ucla.edu 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-sh\ ared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa\ _atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LA\ RGEFILE_SOURCE' CXX='g++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_ \LIBC: lrwxrwxrwx1 root root 14 Jan 10 07:06 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x2 root root 1235468 Sep 5 16:12 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 15:59 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 15:50 /usr/lib/libc.so Configure command: ./configure
RE: Mysql and Openbsd 3.2
I have never tried to compile sources on openbsd. So I don't know if it is possible or not. Generally I prefer the standart openbsd packages. You can download and use mysql-server3.23.49 package from openbsd: http://www.openbsd.org/3.2_packages/ Also if you have problems installing openbsd packages you can read this manual: http://www.openbsd.org/cgi-bin/man.cgi?query=packagessektion=7format=html [EMAIL PROTECTED] wrote: I am trying to install Mysql server 3.23.54a on openbsd 3.2 and I downloaded the source.tar.gz and did tar zxvf filename and I get and unexpected end of file error.. I have downloaded this 4 times now and all 2 times from different sources. Any ideas what is wrong? I have been working on finding a solution to this for 5 days now. Finding docs for openbsd is the worse thing I have ever had to deal with on the Inet. All I want to do is install Snort/Acid/Mysql. Any help on why this error is occurring would be great. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: sql delete question
Hello Adolfo, Yes I have tried it too but it did not work. Anyway i have done it programatically in my app. Thanks. Adolfo Bello [EMAIL PROTECTED] wrote: I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id int not null auto_increment table1id int not null data varchar(30) These two tables are connected to each other with the table1id column. I need to delete rows in table1 which have no corresponding table1id values in table2 and also i need to delete rows in table2 which have no corresponding table1id values in table1. Any comments? Can you try a multi table DELETE? I haven't done it but I would be a shot at something like (adapted from MySQL Manual) DELETE t1 FROM t1,t2 WHERE t1.id=t2.id AND t2.id IS NULL Adolfo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sql delete question
Hello, I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id int not null auto_increment table1id int not null data varchar(30) These two tables are connected to each other with the table1id column. I need to delete rows in table1 which have no corresponding table1id values in table2 and also i need to delete rows in table2 which have no corresponding table1id values in table1. Any comments? Thanks. sql,query __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql delete question - solved
Hello Paul, I have tried the code you have written, before posting to list and it did not work. When I have seen the sentence This requires that you have MySQL 4.x at your mail I realized the problem. I am using mySQL 3.23.49. :( Thanks for your help. Paul DuBois [EMAIL PROTECTED] wrote: At 7:27 -0500 1/8/03, Veysel Harun Sahin wrote: Hello, I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id int not null auto_increment table1id int not null data varchar(30) These two tables are connected to each other with the table1id column. I need to delete rows in table1 which have no corresponding table1id values in table2 and also i need to delete rows in table2 which have no corresponding table1id values in table1. Any comments? Thanks. sql,query This sounds like a delete parentless children and childless parents question. Turning to my handy copy of MySQL Cookbook which I just happen to have nearby :-) I see the following under Identifying and Removing Unattached Records (pp668-669), where the _head and _item are the parent and child tables that correspond to your table1 and table2: --- To use a multiple-table DELETE statement for removing unmatched records, just take the SELECT statement that you use to identify those records and replace the stuff leading up to the FROM keyword with DELETE tbl_name. For example, the SELECT that identifies childless parents looks like this: SELECT swdist_head.dist_id AS 'unmatched swdist_head IDs' FROM swdist_head LEFT JOIN swdist_item ON swdist_head.dist_id = swdist_item.dist_id WHERE swdist_item.dist_id IS NULL; The corresponding DELETE looks like this: DELETE swdist_head FROM swdist_head LEFT JOIN swdist_item ON swdist_head.dist_id = swdist_item.dist_id WHERE swdist_item.dist_id IS NULL; Conversely, the query to identify parentless children is as follows: SELECT swdist_item.dist_id AS 'unmatched swdist_item IDs' FROM swdist_item LEFT JOIN swdist_head ON swdist_item.dist_id = swdist_head.dist_id WHERE swdist_head.dist_id IS NULL; And the corresponding DELETE statement removes them: DELETE swdist_item FROM swdist_item LEFT JOIN swdist_head ON swdist_item.dist_id = swdist_head.dist_id WHERE swdist_head.dist_id IS NULL; --- This requires that you have MySQL 4.x, because 3.x doesn't support multiple-table DELETE. For 3.x, you must write a program that identifies the unattached records and generates the appropriate statements to delete them. (The code for this is in the Cookbook, too; you can get it at the book's web site.) __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Using files stored as blob
If you can give more info about your development environment and explain a little what you want to do, some of us may help. Tim Best [EMAIL PROTECTED] wrote: OK I got files to upload to my MySQL server but now how do I retreive them for distribution by email for instance. When I do a query the filename looks something like: /var/tmp//phptkYxkV I'm not sure where that is but I need to retrieve that file and distribute it... Any suggestions would be greatly appreciated... /T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No my.cnf - why?
http://www.mysql.com/doc/en/Option_files.html http://www.mysql.com/doc/en/Automatic_start.html If you have not my.cnf file you can create a new one with a text editor. Just write your options and then save it to the required place with the name my.cnf. If you enter a password for user root try /usr/bin/mysqladmin -u root -p then hit return. It will ask you the password. Type your password and it is ok. Vidiot wrote: I installed the Linux RPMs for the latest version of MySQL. But, no my.cnf. How do I create one? I can't find anything in the 800+ page manual on how to create said file. I can't get any of the programs to work either. The mysql daemon starts, the firewall has a hole cut in it for my IP to get through port 3306, but it doesn't help: mrvideo.ZROOT 6 /usr/bin/mysqlshow /usr/bin/mysqlshow: Access denied for user: 'root@localhost' (Using password: NO) mrvideo.ZROOT 3 /usr/bin/mysqladmin -u root -h localhost password xxx /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' mrvideo.ZROOT 7 /usr/bin/mysqladmin -u root -h mrvideo password vidiot90210 /usr/bin/mysqladmin: connect to server at 'mrvideo' failed error: 'Host 'mrvideo.vidiot.com' is not allowed to connect to this MySQL server' I previously posted the following query, which hasn't resulted in any responses, so I'll try again... Date: Sun, 1 Dec 2002 02:31:59 -0600 (CST) I found the following RPMs: perl-DBD-MySQL-1.2215-1.i386.rpm perl-DBI-1.14-10.i386.rpm But they aren't good enough: rpm -ivh MySQL*3.23.53a-1.i386.rpm perl-DBD-MySQL-1.2215-1.i386.rpm perl-DBI-1. 14-10.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.53a-1 Just what the hell is the person looking for that packaged the bench RPM? It would be nice if the MySQL page that has the Linux RPMs would list the dependencies and where to get the RPMs that it needs. But, nope, nada. Until I can find that particular RPM, the bench RPM will be left off the list. I'm attempting to install the following Linux RPMs: MySQL-3.23.53a-1.i386.rpmMySQL-client-3.23.53a-1.i386.rpm MySQL-Max-3.23.53a-1.i386.rpmMySQL-devel-3.23.53a-1.i386.rpm MySQL-bench-3.23.53a-1.i386.rpm MySQL-shared-3.23.53a-1.i386.rpm When I do so I get the following error: rpm -ivh MySQL*3.23.53a-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.53a-1 The only Perl DBI module on the MySQL website is the DBI-1.18.tar.gz tarball. Where is said RPM located? Thanks for any pointers to the location. MB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
order by clause with latin5 character set on binary fields
Hello, I use mySQL 3.23.49 with latin5 character set. At some of my tables I use binary fields. At normal fields order by clause returns true sorting but at binary fields I get wrong results. Is there any way to correct this problem or have to I use normal fields instead of binary and use BINARY operator at comparisions? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Delphi 6
I think the standart tsqlconnection in delphi6 have some problems. Instead you can use ado or tmysqlconnection from http://www.productivity.org/projects/mysql/;. Hope it helps. Patricio Díaz G. wrote: Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL server in a Linux box. I am having trouble connecting to the server with the CLX/dbExpress TSQLConnection component. Please, if somebody can help me, let me know and I'll explain the whole situation. Regards, Patricio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select from multiple tables - solved
Thanks Joseph and Kelly. I think merge tables will be a good solution for me. Veysel Harun Sahin wrote: Hello, I have a problem with select statetement. I need to query and select records from multiple tables which have the same column types. I have done this with left join but my query became so complex. Because i have written left join between all of my tables and also if i need to query something i have to write tablename.columnname syntax for each table. Now i am looking for a more basic query to be able to do this. For example i have 3 tables with the names of table1, table2 and table3. All of my tables have 2 columns cola and colb. I have to select records whose cola = something from all of my tables with one query. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select from multiple tables
Hello, I have a problem with select statetement. I need to query and select records from multiple tables which have the same column types. I have done this with left join but my query became so complex. Because i have written left join between all of my tables and also if i need to query something i have to write tablename.columnname syntax for each table. Now i am looking for a more basic query to be able to do this. For example i have 3 tables with the names of table1, table2 and table3. All of my tables have 2 columns cola and colb. I have to select records whose cola = something from all of my tables with one query. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query question
Hello list, I am using mysql 3.23.52. I have to query one of my tables which has two columns with the type of date and time. For example i have to get the records whose date are 2002-10-12 and time is bigger than 11:30:00 and also the records whose date are 2002-10-13 and time is smaller than 05:00:00. In other words i have to get a timeline between the 2002-10-12/11:30:00 and 2002-10-13/05:00:00. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: query question - solved
Thank you Egor. These queries meet my needs. Egor Egorov wrote: Veysel, Monday, October 14, 2002, 12:48:58 PM, you wrote: VHS I am using mysql 3.23.52. I have to query one of my tables which has two VHS columns with the type of date and time. For example i have to get VHS the records whose date are 2002-10-12 and time is bigger than 11:30:00 VHS and also the records whose date are 2002-10-13 and time is smaller than VHS 05:00:00. In other words i have to get a timeline between the VHS 2002-10-12/11:30:00 and 2002-10-13/05:00:00. SELECT * FROM table_name WHERE CONCAT(date,' ',time)'2002-10-12 11:30:00' AND CONCAT(date,' ',time)'2002-10-13 05:00:00'; SELECT * FROM table_name WHERE (date 2002-10-12 AND date 2002-10-13) AND (time 11:30:00 AND time 05:00:00); -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Network access?
look at the grant syntax in the manual. Steve Dickey wrote: I am a MySQL newbie and can not seem to find the documentation that explains how to allow network or remote access to a running MySQL server. It does not seem to be in the my.cnf file or in the manual??? I am sure this is a simple thing but it is really holding me up right now. Thanks for any help. scd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CREATE FUNCTION
http://www.mysql.com/doc/P/r/Privileges.html Sameh Attia wrote: Hi, Can anybody help me figuring how to control granting users permissions to created functions in MySQL like we do for SELECT, INSERT, ...etc or it is not possible and every one logged in to MySQL could simply use them like any other native function? Regards -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CREATE FUNCTION
ahh sorry for misunderstand. the truth is that i have no idea about the solution of your problem but i would like to hear from you if you find a solution. Sameh Attia wrote: Veysel Harun Sahin wrote: http://www.mysql.com/doc/P/r/Privileges.html Sameh Attia wrote: Hi, Can anybody help me figuring how to control granting users permissions to created functions in MySQL like we do for SELECT, INSERT, ...etc or it is not possible and every one logged in to MySQL could simply use them like any other native function? Regards Thanx Veysel for your concern; but unfortunately this did not help me. Creating functions is independent of tables or databases privileges. Is there a solution one can authorize using created functions? Regards -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unions
Take a look at http://www.mysql.com/doc/;. If you search the keyword union you can get an answer. Arul wrote: Hi Can i use Unions in MySQL. If not could anyone comeout with some alternates.. Regards, -Arul sql, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1030: Got error 127 from table handler
It seems that your table has been crashed. Try to check and repair your table. tl wrote: Hello MySQL, I do select: select SUM(IF((@a:=(( ( ((@data:= DATE_FORMAT(data,'%Y-%m-%d')) IN ('2001-11-10','2001-12-22','2001-12-29')) OR (WEEKDAY(data) IN ('0','1','2','3','4')) ) AND (HOUR(data) '19' AND HOUR(data) ='8') ) AND !(@data IN ('2001-07-06','2001-08-15','2001-11-01','2001-11-02','2001-12-24','2001-12-25','2001-12-26','2001-12-31','2002-01-01','2002-03-11','2002-04-01','2002-05-01','2002-08-15','2002-11-01','2002-12-25','2002-12-26')) )),in_s,'0')) as ipm, SUM(IF(@a, ot_s,'0')) as opm, SUM(IF(!@a, in_s,'0')) as inm, SUM(IF(!@a, ot_s,'0')) as onm FROM _stat_._stat_10_4_1_10 where DATE_FORMAT(data,'%Y-%m') = '2002-05' AND DATE_FORMAT(data,'%Y-%m-%d') BETWEEN '-00-00' AND '-00-00' ; got error: ERROR 1030: Got error 127 from table handler Please, HELP ME! Thank very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database modelling tool
Hello, Is there any database modelling tool for mysql? -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php