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 ] earlier which had a > couple > of fie

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

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

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 tr

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

them ("PRO SPORTS TEAM"), this won'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]] Se

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

Try this query: UPDATE table SET phone = concat("(",left(phone,3),") ",mid(phone,3,3),"-",mid(phone,6,4)); It should convert 00 to (000) 000-. Take a look at this page if you want details on how it works: http://www.mysql.com/doc/S/t/String_functions.html - Jonathan -Original Me

Re: Changing data

lets says the column your_column holds hte data to be changed. then: update your_table set your column=concat(substring(your_column,1,4),-,substring(your_column,5,8),-,subs tring(your_column,8,12)); this should work, if i am wrong please someone correct me cheers ) - Original Message - Fro

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

RE: changing data paths

Unsure on the Paths, but I know someone else will help there, but Kylix doe not support the current version of MySQL with the libmysql.10 only version .6 or the 3.23.32 version. Cheers -Original Message- From: simon [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 02, 2001 3:41 PM To: [E

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

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