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: http://lists.mysql.co

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 Genera

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.. R

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: http://w

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> DG>I am working with PHP for the first time and I need a form DG>To insert some details and a date. DG> DG>When I check the mysql database

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/

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: http://www.mysql.com/manual.php

Re: Sorting Data

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

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 wr

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 t

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 ta

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 lis

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 che

Re: need help debugging!

2002-03-01 Thread Uma Shankari T.
Send News: AB>[EMAIL PROTECTED] AB>- Original Message - AB>From: "Uma Shankari T." <[EMAIL PROTECTED]> AB>To: "Alex Behrens" <[EMAIL PROTECTED]> AB>Cc: <[EMAIL PROTECTED]> AB>Sent: Friday, March 01, 2002 7:35 PM AB>Subject: Re: need help deb

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: AB>Hey All, AB> AB>I am new to mysql and I need help debugging this peice of code for my site: AB> AB>$db = mysql_connect("db30.pair.com", "net3dual", "rosevil

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, pleas

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 che

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) htt

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: http://w