Re: Problem accessing phpmyadmin using IP from remote machine

Can you ping ip 192.168.1.9 from other machines? On Dec 11, 2012 11:21 AM, Girish Talluru girish.dev1...@gmail.com wrote: Hi Guys, I have environment as specified below. Main server: Windows Server 2008 Virtual Box: Oracle VM VM OS: Ubuntu Inside Ubuntu I downloaded and configured

RE: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

Hi, Or if you are interested in limiting the number of rows add a limit clause, so that entire resultset of entire table is not returned , I am not sure how will that be done , but i have seen some GUIs doing that, would look for a solution from group. Thanks Abhishek -Original

Which Database when lot of insert / update queries to execute

, -- Thanks and kind Regards, Abhishek jain

RE: One table gets locked by itself

Hi Thanks, Where can i find query log for previous one,or i have to do some config in my.ini file, please let me know, Thanks Abhi -Original Message- From: Darryle [mailto:dstepli...@gmail.com] Sent: 08 May 2012 19:42 To: abhishek jain Cc: mysql@lists.mysql.com Subject: Re: One table

Deleting the duplicate values in a column

, Abhishek jain

reset auto increment to a lesser value

Hello friends, I need to reset auto increment to a lesser value, is there a metod to do so in any version of mysql. Pl. help me. Thanks abhi

Re: reset auto increment to a lesser value

On Sat, Aug 2, 2008 at 10:49 PM, Nacho Garcia [EMAIL PROTECTED] wrote: http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html mysql *ALTER TABLE tbl AUTO_INCREMENT = 100;* On Sat, Aug 2, 2008 at 5:28 PM, abhishek jain [EMAIL PROTECTED] wrote: Hello friends, I need to reset

Fwd: Calendar event query

(*) event_type 235 7 237 8 246 6 254 6 26 10 6 27 15 . Pl. help me Thanks, Abhishek jain Hi , eventum will not solve my purpose. Pl. reply

Calendar event query

4 6 26 10 6 27 15 . Pl. help me Thanks, Abhishek jain

Urgent: mysql_history on windows ?

Hi, I need to track the mysql commands executed on mine system , I am running windows with mysql 5.x I know there is a file .mysql_history and hopes there must be a similar file on windows too. Pl. help me urgently, Thanks, -- Regards, Abhishek Jain

Query needed for this sol.

wanted to know how to do so, Pl. help Thanks, Abhishek jain

Re: Google like search string to be implemented

So is there any other alternative. Thanks, Abhishek jain On 3/10/07, Michael Dykman [EMAIL PROTECTED] wrote: LIKE and NOT LIKE can be a dangerous path.. it is very easy to put yourself in a situation where your logic design requires full table scans for every query.. - michael dykman On 3

Re: Google like search string to be implemented

On 3/8/07, abhishek jain [EMAIL PROTECTED] wrote: On 3/6/07, abhishek jain [EMAIL PROTECTED] wrote: On 3/6/07, Nils Meyer [EMAIL PROTECTED] wrote: Hi, abhishek jain wrote: I am having a database with varchar(255) columns named title, extra_info1,extra_info2,extra_info3

Re: Google like search string to be implemented

On 3/6/07, abhishek jain [EMAIL PROTECTED] wrote: On 3/6/07, Nils Meyer [EMAIL PROTECTED] wrote: Hi, abhishek jain wrote: I am having a database with varchar(255) columns named title, extra_info1,extra_info2,extra_info3 . I want to search all these columns with a search string given

Re: Google like search string to be implemented

On 3/6/07, Nils Meyer [EMAIL PROTECTED] wrote: Hi, abhishek jain wrote: I am having a database with varchar(255) columns named title, extra_info1,extra_info2,extra_info3 . I want to search all these columns with a search string given to me via a form ,I am using PERL, the string

Re: Does casing of Table names matter on Linux

On 3/5/07, abhishek jain [EMAIL PROTECTED] wrote: On 3/1/07, abhishek jain [EMAIL PROTECTED] wrote: On 2/28/07, Ow Mun Heng [EMAIL PROTECTED] wrote: On Wed, 2007-02-28 at 15:05 +0530, abhishek jain wrote: Hi Friends, I have been developing one application over Windows and now i

Google like search string to be implemented

Hi Friends, I am having a database with varchar(255) columns named title, extra_info1,extra_info2,extra_info3 . I want to search all these columns with a search string given to me via a form ,I am using PERL, the string will be like +abhishek jain -abcd this should be exact As you can see

Does casing of Table names matter on Linux

that this is not a problem on windows but it is on linux, i want a sol. for that a i can not change all the table names as in some places it is in small case and in other places it is in capital case. Pl. help me, Thanks, Abhishek jain

Re: Does casing of Table names matter on Linux

On 2/28/07, Ow Mun Heng [EMAIL PROTECTED] wrote: On Wed, 2007-02-28 at 15:05 +0530, abhishek jain wrote: Hi Friends, I have been developing one application over Windows and now i want to move/port that into linux, i want to know will the casing of the table name matter on linux ie if i have

Data back up for innodb tables - Copy paste

Hi, I want to copy paste the data files of Innodb database, is it possible, i mean can i just copy the data files like that we do for myisam tables, Thanks, Abhishek jain

Re: max_allowed_packet in my.ini

On 2/3/07, abhishek jain [EMAIL PROTECTED] wrote: Hi friends, I am using mysql 5.0.23-nt on windows, i have to store large binary data in database, i have used setting like max_allowed_packet=16M in mysqld section of my.ini . Now i have a poblem that i want to create a setup so that the entry

max_allowed_packet in my.ini

need to create many setups on diff. machine and i do not want to search the mysqld section and write the line and restart mysql . I can however would like to do via mysqladmin or so if it is possible as i can invoke that via mine .net program Would appreciate your comments on this, Thanks . Abhishek

How to keep myqsl backup server

server and restore it by a script on the backup server, but i need to know how will i switch between servers and if i use domain names instead of ips how will i make immediate switch. I know some part of the question is not appropriate for this mailing list but pl help. Regards, Abhishek jain

Re: Urgent: How to decode base64 via mysql V 5.0.x

module gives in a different line after some same no of characters. Pl. someone give me a sol. to it. I coould have attached the files but the mailing list wont support that. Also pl. forgive mine top posting. -- Regards, Abhishek jain On 10/17/06, Ady Wicaksono [EMAIL PROTECTED] wrote: http

Urgent: How to decode base64 via mysql V 5.0.x

Hi, I want to decode base 64 string via mysql . Also i am using aspx .net . Pl. help me. Urgent reply will be appreciated -- Regards, Abhishek jain

Re: Urgent: How to decode base64 via mysql V 5.0.x

Hi, Yes that solved the problem and was fast. I would like to know now that is there anyother way for the same in earlier versions of mysql. Thanks again, -- Regards, Abhishek jain On 10/17/06, Ady Wicaksono [EMAIL PROTECTED] wrote: http://firestuff.org/wordpress/wp-content/uploads/2006/03

How to get the size of a row

Hi, I wanted to know the size of the data stored in a row of a table. I mean is there something like select size from table where x... -- Regards Abhishek Jain

A tricky Query

added date. Pl. help me. I shall be very grateful. -- Regards, Abhishek jain

How to find the top most member in a hierarchy of subcategories

not know how many sublevels are there, Thanks, Abhishek jain

which is better long rows in table or two short row tables

Dear Friends, I was to create a site with quite some heavy mySQL database. I wanted to know which is better longer rows in a table or two short rows tables. When compared in terms of speed etc. Pl. help me , with this question and any other tip you may find can be useful to me. Thanks, Abhishek

What is the best coding ethics related to mysql

. point me to good advanced tutorial of mysql. Also is there any certification of mysql, php etc. Thanks, Abhishek Jain

On what factors does speed of mysql depends

the approximate size of a table ideal for mysql, Any other factors you want mine attention to be foccused on. Thanks, Abhishek Jain

Re: Output to a file

://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] select * into outfile '/tmp/new.txt' from tablename where condition = '1'; looks to me a good option. Best Regards, Abhishek Jain

How to synchronize two databases

anyone help. Regards, Abhishek Jain

Re: How to Find Most Recent Autoincrement Index Assigned???

the table and i do not get the exact value. Thanks, Abhishek Jain On 4/22/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: From 'Section 13.5.3 SET Syntax' of the 5.0.18 ref manual: IDENTITY = value The variable is a synonym for the LAST_INSERT_ID variable. It exists for compatibility

Why does this query takes a lot of time

. Pl. help me it is important to me. Thanks, Abhishek Jain

Fwd: Fetch and updation in single step/query

No i do not want an autoincrement key , as i want to be only one row in the table and it value gets incremented / updated and i to know whats its current value. -- Regards Abhishek Jain On 4/19/06, Michael Kruckenberg [EMAIL PROTECTED] wrote: Seems like what you need is an auto-increment key

How to initiate a prog. via mysql

Dear Friends, I need to start a prog. as soon as a particular field in the mySQL 4.x is changed. ie. when in Flag table if_flag is set to '1' i need to start a script. The script will be in PHP. Pl. tell me how to do so on mySQL 4.x. I shall be very grateful. -- Regards, Abhishek Jain

Fetch and updation in single step/query

me in either: 1)telling me a single query which will fetch and incr. in the same query. so the problem of simultaneously queries are solved. 2)A system by which delaying the other queries are done, I use PHP . Expecting a quick reply. Thanks, Abhishek Jain

How to remove muiltiple queries to a table at the same time

me in either: 1)telling me a single query which will fetch and incr. in the same query. so the problem of simultaneously queries are solved. 2)A system by which delaying the other queries are done, I use PHP . Expecting a quick reply. Thanks, Abhishek Jain

How to take dump of a query instead of table / database

Dear Friends, I need to take the backup of a query, is it possible. If yes how. -- Regards Abhishek jain www.smsengine.co.uk

Mysql Finding the country name from country prefix

Hi Friends, I have a ticky mysql problem. I need to find the country name from the country prefix so eg. i have a mysql table with prefix and name as the coumns and with datas like : Prefix, Name 1 USA 11XYZ 44UK 91India 92Pakistan 123 ZXF and i