Tunning Process
Hi , I am working on Performance Management in MySQL. I got the information of table and the type of data is. Now the problem is that how can I work on performance. For Example :- As we know that mysql support 4GB Data per table and we also knows that mediumtext can support 4GB data per column. Now the condition arise on what percentage I have to take backup of my database. with mediumtext or without mediumtext. Thax In Advance Manish Mehta - 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
Export
Hi, I am working on Mysql . I wants to take backup (export) of my database from dos prompt . Is their any way. Please Tell. Thx in advance Manish Mehta - 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
Encrpt/Decrypt
Hi I can Encrypt password in mysql using password() command. what is the way to decrypt the password. Manish - 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
Begin work
Hi Any body tells me what the use of Begin work in SQL . Manish Mehta - 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
between
Hi In mysql I found a problem with between query. For example select * from bugdetail where dbugcreate_date between from_days(to_days('2002-03-01')) and from_days(to_days('2002-03-04')) this query shows only those records up to '2002-03-03' instead of '2002-03-04' pl. help Manish - 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
max function
Hi I got a problem with max function select a.cemp_firstname,sum(nsalary_value),max(nsalary_status),max(dstatus_date) from employeemaster as a,empsal as s where a.nemp_id = s.nemp_id group by dstatus_date This query shows me two records . But my requriment is according to the max - salary status and max - salary status date according to the employee id. My requriment is show only single for particular employee. how can it is possible. pl. help, Manish - 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
encrypt password
Hi , I am working in mysql . with the help of password() function I insert the data in some table . for example :- insert into a values (password('name')); when I fire select query . It shows me this - 23e6065b74 I wants to decrypt the data again in same format as I insert with Select query. please tells me the process . Thx in advance Manish Mehta - 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
Export database
Hi i have 3.23.32 version of mysql. i wants to export the database from \mysql\bin\ please tell. thanks in advance Manish Mehta CORE Solucomm Limited 423 B, Hamilton Court, DLF City, Phase IV, Gurgaon, India - 122 001. Tel: +91-124-6392896 / 897 / 035 Fax:+91-124-6392036 E-mail: [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
Test Case (Urgent)
Hi, I am new to test case design in Database. I wants to know Basically how to calculate the Maximum Database. When we have to take backup.? What are steps to be flow please tell me. Thanks in advance. Manish Mehta E-mail: [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
Database Size Limit
Hi, As we know that MySql support maximum of 4 GB data per table. Now the question arise that what is the maximum limit of Database in MySQL. Manish Mehta E-mail: [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
Database in MySQL
Hi, As we know that MySql support maximum of 4 GB data per table. Now the question arise that what is the maximum limit of Database in MySQL. Manish Mehta E-mail: [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
auto_increment
Hi Is it possible auto_increment start 100 instead of 1 . for example create table a ( a int(10) primary key auto_increment 100); Manish Mehta E-mail: [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
Error List
Hello Everyone , Some error mostly comes in MySQL; Code Description 1 Operation not permitted 2 No such file or directory 3 No such process 4 Interrupted function call 5 Input/output error 6 No such device or address 7 Arg list too long 8 Exec format error 9 Bad file descriptor 10 No child processes 11 Resource temporarily unavailable 12 Not enough space 13 Permission denied 14 Bad address 16 Resource device 17 File exists 18 Improper link 19 No such device 20 Not a directory 21 Is a directory 22 Invalid argument 23 Too many open files in system 24 Too many open files 25 Inappropriate I/O control operation 27 File too large 28 No space left on device 29 Invalid seek 30 Read-only file system 31 Too many links 32 Broken pipe 33 Domain error 34 Result too large 36 Resource deadlock avoided 38 Filename too long 39 No locks available 40 Function not implemented 120 Didn't find key on read or update 121 Duplicate key on write or update 123 Someone has changed the row since it was read; Update with is recoverable 124 Wrong index given to function 126 Index file is crashed / Wrong file format 127 Record-file is crashed 131 Command not supported by database 132 Old database file 133 No record read before update 134 Record was already deleted (or record file crashed) 135 No more room in record file 136 No more room in index file 137 No more records (read after end of file) 138 Unsupported extension used for table 139 Too big row (= 16 M) 140 Wrong create options 141 Duplicate unique key or constraint on write or update 142 Unknown character set used 143 Conflicting table definition between MERGE and mapped table 144 Table is crashed and last repair failed 145 Table was marked as crashed and should be repaired Enjoy . Manish Mehta E-mail: [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 Problem
Hello Everyone, I wants to find the max. date and Login status of employee for Attendance table. The qurey runs fine but it shows me the wrong status. select max(a.dAtt_Date),a.nLog_Status from tbl_attendance a,tbl_attendance b where a.nEmp_id = 1 and a.nLog_Status = b.nLog_Status group by b.nEmp_id for example :- the data is dAtt_Date nLog_Status - --- 2001-11-20 2 2001-11-22 1 2001-11-23 1 2001-11-24 1 2001-11-24 2 Result is max(a.dAtt_Date) nLog_Status - 2001-11-24 2 2001-11-20 2 Thanks Manish Mehta E-mail: [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
Procedure and Funcion
Hello, I am facing a big problem related to some queries. Is i use store procedure or function in My SQL. If yes , Please tells me the syntax. Thanks Manish Mehta E-mail: [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
problem in SQL
Hello, I have a problem related SQL Query SELECT a.cAction_Name,a.nAction_ID FROM tbl_actionmaster a LEFT JOIN tbl_roleactionrelation b ON a.nAction_ID != b.nAction_ID WHERE b.nRole_ID = 3 group by a.cAction_Name In this query i wants to find Action name and Action Id from the Action Master table. As comparing with RoleActionReation table (field - nAction_ID , nRole_ID ) I need those Action Name which are not mapped with the Role Name . This Query shows me those field also which are already mapped. Thanks Manish Mehta E-mail: [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
Error List
hello I wants to Know of web site where's i found the list of errors mysql have. thanks Manish Mehta E-mail: [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
Problem related to not equal to function
Hello , I have a problem related to not or != (not equal to function) . The SQL Query is select a.cBook_Name from tbl_bookmaster as a , tbl_empbookrelation as b where a.nbook_id != b.nbook_id It shows me wrong result. It shows me those rows also which are already present in other table. Manish Mehta E-mail: [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
Urgent : - Select Query
Hello , Please help me (Urgent) i have two tables 1. tbl_employeeinfo 2. tbl_networkpartloc In these table i have common field called cCompany_ID. 1. select count(tbl_employeeinfo.cCompany_ID) from tbl_employeeinfo,tbl_networkpartloc where tbl_employeeinfo.cCompany_ID = tbl_networkpartloc.cCompany_ID and tbl_networkpartloc.iuPC 50 /* In this query i am counting those companies have less than 50 PC */ I got the result count(tbl_employeeinfo.cCompany_ID) --- 6 Now I fire 2. select cCompany_Name,cEmployee_Name,CPhone_Mode, sum(tbl_networkpartloc.iuPC) from tbl_employeeinfo,tbl_networkpartloc where tbl_employeeinfo.cCompany_ID = tbl_networkpartloc.cCompany_ID and tbl_networkpartloc.iuPC 50 group by cCompany_Name,cEmployee_Name,CPhone_Mode, tbl_employeeinfo.cCompany_ID I got the result cCompany_Name cEmployee_Name CPhone_Mode sum(tbl_networkpartloc.iuPC) - -- --- Case Atul Kulkarni Phone 14 Core Atul Kulkarni Phone 90 G-Tech NULL NULL 86 Oracle NULL NULL 15 Now the problem is that into out table(tbl_networkpartloc) i am storing multiple record with the same ID suppose the count of three rows i got the result (10+30+50 = 90) for same ID . It treate as a different record. What can i do I got the right result when the sum of my PC is more the 50 (In my first and second Query ) Data tbl_employeeinfo cCompany_ID cCompany_Name --- - 999 Core 111 ABC 112 DEF 113 GHI 114 ABC1 115 DEF1 116 GHI1 345 Case 346 CBIT 232 ABCD 456 Oracle 678 EON Tech 890 TCS 367 SSI 123 G-Tech tbl_networkpartloc cCompany_ID iuPC --- 232 700 116 590 115580 114 570 113 90 112 80 111 70 123 43 36750 123 43 999 45 890 435 346 56 345 14 456 15 999 45 678 234 Please Help me. Manish Mehta E-mail: [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
Windows Threads Support
Hello, Windows support 2000 threads by default (with the help of thread library). Then what a mean of max_connection = 100 because MySQL One each connection on differente thread. Is i able to increase the max_connection limit. Manish Mehta E-mail: [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
Is MySQL Support Procedure?
Does MySQL Support Procedure.If yes, Whats a real syntax? Manish Mehta - 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
Max Database
Hello Everyone, We are using MySQL as backend. What is Maximum size of MySQL Database? Manish Mehta E-mail: [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
Encryption
hello, Is MySQL Support Encryption ? Manish Mehta E-mail: [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
mysqladmin Vs WinMySQLAdmin
Hello What a difference between mysqladmin Vs WinMySQLAdmin Because i thing both were works as same. but those thing i set through --set-variable command not reflect on WinMySQLAdmin. Why? Manish Mehta E-mail: [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
Support related to tables
Hello, I have some queries related to MySQL a.. The Default table_cache = 64 . what its mean? If i increase the table_cache to 600 whats happened with my mysqladmin processlist (related to speed) and what is max_tmp_tables. b.. If in our database we have 20 tables. how many tables open when a user connect to my database? c.. Does this thing is true that in mysql one thread one for each connection if yes ,then what's a mean of thread_stack? d.. Does MySQL Support Distributed Database .If not, then what's the way out ? e.. What is max_user_connection? f.. Is their any Load Tester in MySQL? Manish Mehta - 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
Support
Hello, Does MySQL Support Distributed Database .If not, then what's the way out ? Manish Mehta - 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