RE: Changing data types in mysql!

> -Original Message- > From: Lenin Lakshminarayanan [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 22, 2008 6:54 PM > To: mysql@lists.mysql.com > Subject: Changing data types in mysql! > > Hello, > > I was pulling data from one datasource [ oracle ] earlie

Re: Changing data types in mysql!

Lenin Lakshminarayanan schrieb: Hello, I was pulling data from one datasource [ oracle ] earlier which had a couple of fields as integer. Now i am moving to a newer data source and the same fields are now varchar's in the newer oracle database. I am planning to change the data types of those fi

Changing data types in mysql!

Hello, I was pulling data from one datasource [ oracle ] earlier which had a couple of fields as integer. Now i am moving to a newer data source and the same fields are now varchar's in the newer oracle database. I am planning to change the data types of those fields from integer to varchar's as

RE: changing data dir

[snip] Do I have to reinstall mysql in order to change the default data dir from /var/lib/mysql? Can I do this: mv /var/lib/mysql /newdir/mysql cd /var/lib ln -s /newdir/mysql mysql [/snip] This should work. You could also change the datadir variable in your my.cnf file instead of creating the

changing data dir

Do I have to reinstall mysql in order to change the default data dir from /var/lib/mysql? Can I do this: mv /var/lib/mysql /newdir/mysql cd /var/lib ln -s /newdir/mysql mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

RE: Changing Data Directory

er 12, 2003 8:26 AM > To: [EMAIL PROTECTED] > Subject: RE: Changing Data Directory > > > in my.cnf: > [mysqld] > datadir=/var/lib/mysql > > > -Original Message- > From: Daniel Kiss [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 12, 2003 3

RE: Changing Data Directory

in my.cnf: [mysqld] datadir=/var/lib/mysql -Original Message- From: Daniel Kiss [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:21 PM To: [EMAIL PROTECTED] Subject: Changing Data Directory Hi all, How can I change the directory of the databases? I have

Changing Data Directory

Hi all, How can I change the directory of the databases? I have tries the basedir switch in the my.cnf [mysqld] section, but it did not work. How should I do it? Thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMA

RE: Changing data

X'),' y', ' Y'), ' z', ' Z'); This will handle any number of words in name as well as any number of successive spaces. I am sorry if it seems too ugly. Anvar. At 08:03 PM 03/12/2001 -0800, you wrote: >Okay, so if it won't work with more than o

RE: Changing data

[EMAIL PROTECTED]' Subject: RE: Changing data Try the following 2 queries. UPDATE table SET name=concat(ucase(left(name,1)), lcase(SUBSTRING(name,2))); UPDATE table SET name=concat(left(name, INSTR(name, ' ')), ucase(mid(name,INSTR(name, ' ')+1,1)), substring(name FROM INST

RE: Changing data

#x27;t work. But you can find those records that have more than one space in them by running THIS query: SELECT * FROM table WHERE name REGEXP ".* .* .*" - Jonathan -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 10:45 AM To: '

RE: Changing data

tml - Jonathan -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 3:23 AM To: '[EMAIL PROTECTED]' Subject: Changing data how would I change in all rows data that is; 00 to 000-000- or (000) 000- Can this even b

Re: Changing data

- From: "Gill, Vern" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 03, 2001 7:22 PM Subject: Changing data > how would I change in all rows data that is; > 00 > > to > > 000-000- > > or (000) 000- > > Can th

Re: Changing data

Hi, > how would I change in all rows data that is; > 00 It goes something like this: > to 000-000- update my_table set my_field = concat(left(my_field, 3), '-', mid(my_field,4,3), '-', right(my_field,4)); > or (000) 000- update my_table set my_field = concat('(', left(my_field

Changing data

how would I change in all rows data that is; 00 to 000-000- or (000) 000- Can this even be done with mysql? Thank you in advance... Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org

RE: changing data paths

: [EMAIL PROTECTED] Subject: changing data paths Hi I have just started to look at mysql as a database for use with kylix, using Linux Mandrake 8.0. One thing I would like to be able to do is store data in a directory of my choice, but their seems to be no infomation on this. The only infomation

changing data paths

Hi I have just started to look at mysql as a database for use with kylix, using Linux Mandrake 8.0. One thing I would like to be able to do is store data in a directory of my choice, but their seems to be no infomation on this. The only infomation is on a procedure in windows, but the comm

Re: Changing Data Fields through GUI?

Peter Kovari writes: > > Could someone tell us, how to change individual data fields with > MYSQLGUI, or when is this feature going to be available? > Does anyone know about any other tool that enables you to change > individual data fields in tables? > > Thanks, > > -Peter > HI! For the mo

Re: Changing Data Fields through GUI?

You can change data with ksql but to use it, you will have to install some old Qt1.44 and old KDE stuff, asl well as an old libstc++ library, if you don't already have them installed. j- k- On Monday 14 May 2001 14:40, Peter Kovari wrote: > Could someone t

Changing Data Fields through GUI?

Could someone tell us, how to change individual data fields with MYSQLGUI, or when is this feature going to be available? Does anyone know about any other tool that enables you to change individual data fields in tables? Thanks, -Peter -

Re: changing "data" directory

"Marc S. Bragg" wrote: > How does one redirect mysql to a data directory location different than > the default. . . . and if possible, only for a particular database. > > You can find the 'official' notes on how to relocate tables or entire databases at: http://www.mysql.com/doc/S/y/Symboli

changing "data" directory

How does one redirect mysql to a data directory location different than the default. . . . and if possible, only for a particular database. -- Marc S. Bragg [EMAIL PROTECTED] Bialecki & Bragg, PC p: 610-444-7508 f: 610-444-7548 http://www.chescolawyers.com/BB "Chester County Legal Services" - "F