storage of values in mysql

2003-10-21 Thread Uma Shankari T.
Hello, I need to store the charater value as well as some float value in the varchar defined field..is there any other way of decalaration of the field that i can store the character as well as float value ? Regards, Uma -- MySQL General Mailing List For list archives:

Abt mysqldatabase

2003-09-03 Thread Uma Shankari T.
Hello , I need to copy the database contents from one operating system to another operating system..if i copy the entire database folder it is coping only the table structure..contents is not getting copied..can anyone please tell me how do i go do this ?? Regards, Uma -- MySQL

Abt Mysqldump

2003-09-02 Thread Uma Shankari T.
Hello, I have dumped the database contents as one txt file by using this command mysqldump databasename -uusername -ppasswd textfilename. but while redumping back to mysql it is giving some errors in the textfile..is there any possibility to redump the contents without any error..

Removal of Primary Key in Mysql

2002-11-04 Thread Uma Shankari T.
Hello, I have set one of my field in the mysql table as primary key..no i want to remove that primary key setting in mysql..Can anyone please tell me how to do that ??? Regards, Uma - Before posting, please check:

Re: Insert dates with PHP

2002-05-15 Thread Uma Shankari T.
you have to enter ur date as in this format -MM-DD for example: 2002-04-04 Hope this will work Uma On Thu, 16 May 2002, Defryn, Guy wrote: DG DG DGI am working with PHP for the first time and I need a form DGTo insert some details and a date. DG DGWhen I check the mysql database the

Triggers

2002-04-24 Thread Uma Shankari T.
Hello All, Is Mysql supports sql triggers ...??.. Is anyone know this pls tell me.. Thanks in advance Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Sorting Data

2002-03-18 Thread Uma Shankari T.
Hello, To get German sorting order, you should start mysqld with --default-character-set=latin_de. This will give you the following characteristics. To get Tamil sorting order , i have started the mysqld with --default-character-set=latin1.But it is displaying the sorting order in a

Re: Sorting Data

2002-03-18 Thread Uma Shankari T.
On Mon, 18 Mar 2002, Victoria Reznichenko wrote: VRUma, VRMonday, March 18, 2002, 11:34:07 AM, you wrote: VR VRUSTTo get German sorting order, you should start mysqld with VRUST--default-character-set=latin_de. This will give you the following VRUSTcharacteristics. VR VRUST To get

Mysql dump

2002-03-18 Thread Uma Shankari T.
Hello, I am having all mysql database contents in one txt file.how i will dump all those contents to mysql database tablespls tell me how to do it -Uma - Before posting, please check:

Re: Creating tables in mysql

2002-03-15 Thread Uma Shankari T.
Hello, Now i am struck up with one problem...When i am trying to create a table in the mysql database it is giving this error...Can anyone plese help me how to rectify this problem.. ERROR 1: Can't create/write to file './dbase/rr.frm' (Errcode: 13) My mysql database name is dbase and my

Creating tables in mysql

2002-03-15 Thread Uma Shankari T.
Hello, Now i am struck up with one problem...When i am trying to create a table in the mysql database it is giving this error...Can anyone plese help me how to rectify this problem.. ERROR 1: Can't create/write to file './dbase/rr.frm' (Errcode: 13) My mysql database name is dbase and my

ISCII support for mysql

2002-03-11 Thread Uma Shankari T.
Hello, Can anyone tell to me which version of Mysql support ISCII.. Regards, Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Check 8 bit in mysql during sorting

2002-03-04 Thread Uma Shankari T.
Hello, I need one help.To enable 8 bit language in bash we are exporting like this # For 8 bit Language support export LC_CTYPE=iso_8859_1 # For less to support 8 bit chars export LESSCHARSET=latin1 I am using local language for inserting values in mysql.While sorting in mysql is

Re: need help debugging!

2002-03-01 Thread Uma Shankari T.
Hello Alex, If the mysql query returns 0 then it will display the message like this -Uma On Fri, 1 Mar 2002, Alex Behrens wrote: ABHey All, AB ABI am new to mysql and I need help debugging this peice of code for my site: AB AB?php AB$db = mysql_connect(db30.pair.com, net3dual,

Re: need help debugging!

2002-03-01 Thread Uma Shankari T.
Shankari T. [EMAIL PROTECTED] ABTo: Alex Behrens [EMAIL PROTECTED] ABCc: [EMAIL PROTECTED] ABSent: Friday, March 01, 2002 7:35 PM ABSubject: Re: need help debugging! AB AB AB AB Hello Alex, AB AB AB If the mysql query returns 0 then it will display the message like this AB AB AB -Uma AB AB AB On Fri, 1

Select 8 bit

2002-02-28 Thread Uma Shankari T.
Hello, I need one help.To enable 8 bit language in bash we are exporting like this # For 8 bit Language support export LC_CTYPE=iso_8859_1 # For less to support 8 bit chars export LESSCHARSET=latin1 I am using local language for inserting values in mysql.While sorting in mysql is

Enable iscii in mysql

2002-02-28 Thread Uma Shankari T.
Hello, For enabling the iscii in bash we will give export LC_CTYPE=iso_8859_1 For enabling the iscii in mysql is there any setting is there... Anyone came to know this please tell me... - Before posting,

Sorting

2002-02-27 Thread Uma Shankari T.
Hello, I am new to mysql.For the best reference of mysql which site i will look for. please tell me what is the query to sort field name in ascending order Cheers Umashankar - Before posting, please check:

no of bits

2002-02-27 Thread Uma Shankari T.
Hello, Can any one tell me in mysql for sorting how many bits it is check please tell me as soon as possible Cheers Umasankar - Before posting, please check: http://www.mysql.com/manual.php (the manual)