Re: Convert SQL Server Compact data to MySQL
>>>> 2012/04/05 02:15 -0700, sam >>>> I have data file written in SQL Server Compact.I need to Convert it to MySQL. Does anyone know how to do that? <<<<<<<< If it stores in CSV files, you can use that for the data, although to make MySQL read it
Re: Convert SQL Server Compact data to MySQL
Unfortunately they don't have MySQL Migration Toolkit for Ubuntu --- On Thu, 4/5/12, Pothanaboyina Trimurthy wrote: From: Pothanaboyina Trimurthy Subject: Re: Convert SQL Server Compact data to MySQL To: "sam" Date: Thursday, April 5, 2012, 4:56 AM hello sam you can convert
Convert SQL Server Compact data to MySQL
Hello, I have data file written in SQL Server Compact.I need to Convert it to MySQL. Does anyone know how to do that? Thank you, Sam
Re: Convert unix time to 12:00 AM of that same day
Hi Bryan, all! Bryan Cantwell wrote: > That's closer: > SELECT > UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400); > Gives me 6:00 PM today... The Unix timestamp is UTC-based (old name: GMT). You don't write which timezone you are using, but your notation "6:00 PM" makes me assume you are
Re: Convert unix time to 12:00 AM of that same day
That's closer: SELECT UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400); Gives me 6:00 PM today... On 03/01/2011 12:32 PM, Singer X.J. Wang wrote: SELECT unix_timestamp() + 86400 - (unix_timestamp() % 86400); -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/m
Re: Convert unix time to 12:00 AM of that same day
On Mar 1, 2011 6:17 PM, "Bryan Cantwell" mailto:bcantw...@firescope.com> <mailto:bcantw...@firescope.com <mailto:bcantw...@firescope.com>>> wrote: > I'd asked before how to convert a unix timestamp to the
Re: Convert unix time to 12:00 AM of that same day
io Nanni wrote: > >> >> You can start by using 60*60*24=86400 >> ;) >> >> On Mar 1, 2011 6:17 PM, "Bryan Cantwell" > bcantw...@firescope.com>> wrote: >> > I'd asked before how to convert a unix timestamp to the hour that it is >&
Re: Convert unix time to 12:00 AM of that same day
It was of course a typo, and even with the correct number isn't the answer On 03/01/2011 11:47 AM, Claudio Nanni wrote: You can start by using 60*60*24=86400 ;) On Mar 1, 2011 6:17 PM, "Bryan Cantwell" <mailto:bcantw...@firescope.com>> wrote: > I'd as
Re: Convert unix time to 12:00 AM of that same day
You can start by using 60*60*24=86400 ;) On Mar 1, 2011 6:17 PM, "Bryan Cantwell" wrote: > I'd asked before how to convert a unix timestamp to the hour that it is > in (and got the perfect answer) : > 1298999201 = 3/1/2011 11:06:41 AM > (1298999201 - (1298999201 % 36
Convert unix time to 12:00 AM of that same day
I'd asked before how to convert a unix timestamp to the hour that it is in (and got the perfect answer) : 1298999201 = 3/1/2011 11:06:41 AM (1298999201 - (1298999201 % 3600)) = 3/1/2011 11:00:00 AM Now getting the timestamp converted to midnight of that same day isn't as simple as:
Re: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
At 04:52 PM 7/16/2009, Todd Lyons wrote: On Wed, Jul 15, 2009 at 11:58 AM, mos wrote: >> I have backup all the database files(innodb engine). >> Now I want to recover it as myisam engine offline. >> Any suggestions? > > Why can't you copy the InnoDb files to another machine and open the database
Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
On Wed, Jul 15, 2009 at 11:58 AM, mos wrote: >> I have backup all the database files(innodb engine). >> Now I want to recover it as myisam engine offline. >> Any suggestions? > > Why can't you copy the InnoDb files to another machine and open the database > with another MySQL server? (You could do
RE: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
Re: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline At 07:53 AM 7/15/2009, you wrote: >hi all, > >I have backup all the database files(innodb engine). >Now I want to recover it as myisam engine offline. > >Any suggestions? Why can't you copy t
Re: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
At 07:53 AM 7/15/2009, you wrote: hi all, I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions? Why can't you copy the InnoDb files to another machine and open the database with another MySQL server? (You could do it on your
Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
hi all, I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Best way to convert character set from "latin1 to utf8" for existing database?
convert character set from "latin1 to utf8" for existing database? Uma, I apologize in advance if this is redundant ,because I did not click on any of Ewen's link. Nonetheless, this is the approach I would take. start your mysql server with different --character
Re: Best way to convert character set from "latin1 to utf8" for existing database?
. >> > But suggestions from you guys who have ACTUALLY worked on such a scenario >> > would help me out the best. >> > >> > >> > Current Database has: >> > DEFAULT CHARACTER SET - latin1 >> > DEFAULT COLLATION : latin1_swedish_ci >> > >> &
Re: Best way to convert character set from "latin1 to utf8" for existing database?
lp me out the best. > > > > > > Current Database has: > > DEFAULT CHARACTER SET - latin1 > > DEFAULT COLLATION : latin1_swedish_ci > > > > We need to convert this to > > DEFAULT CHARACTER SET - utf8 > > DEFAULT COLLATION : utf8_general_ci > > >
Re: Best way to convert character set from "latin1 to utf8" for existing database?
AULT CHARACTER SET - latin1 > DEFAULT COLLATION : latin1_swedish_ci > > We need to convert this to > DEFAULT CHARACTER SET - utf8 > DEFAULT COLLATION : utf8_general_ci > > > Note that this has to be done on a database that has *existing data* in it . > > Hence just by doing
Best way to convert character set from "latin1 to utf8" for existing database?
Hi All, I have read many blogs suggesting some examples for this. But suggestions from you guys who have ACTUALLY worked on such a scenario would help me out the best. Current Database has: DEFAULT CHARACTER SET - latin1 DEFAULT COLLATION : latin1_swedish_ci We need to convert this to DEFAULT
Re: Is it possible to convert column data into rows
I have a column which contains a list of IDs separated by commas. How can I take the content of this column, and insert it into a temporary table so that each ID is on a separate row? Can this be done using SQL? Can be done in a stored procedure, or (more easily) in an application language.
Is it possible to convert column data into rows
I have a column which contains a list of IDs separated by commas. How can I take the content of this column, and insert it into a temporary table so that each ID is on a separate row? Can this be done using SQL? Thanks! Khai -- MySQL General Mailing List For list archives: http://lists.mysql.
Re: How to convert Acess 2007 ACCDB file to MySQL?
At 11:12 PM 12/29/2008, you wrote: In the last episode (Dec 29), mos said: > Someone has given me an Access 2007 file *.ACCDB and I don't have Access > 2007. Is there a (preferably free) way to convert it to CSV or MySQL? Try the ODBC driver downloadable at "2007 Office Sys
RE: How to convert Access 2007 ACCDB file to MySQL?
>-Original Message- >From: mos [mailto:mo...@fastmail.fm] >Sent: Monday, December 29, 2008 11:52 PM >To: mysql@lists.mysql.com >Subject: How to convert Acess 2007 ACCDB file to MySQL? > >Someone has given me an Access 2007 file *.ACCDB and I don't have Access >
RE: How to convert Access 2007 ACCDB file to MySQL?
>-Original Message- >From: mos [mailto:mo...@fastmail.fm] >Sent: Monday, December 29, 2008 11:52 PM >To: mysql@lists.mysql.com >Subject: How to convert Acess 2007 ACCDB file to MySQL? > >Someone has given me an Access 2007 file *.ACCDB and I don't have Access >
Re: How to convert Acess 2007 ACCDB file to MySQL?
ly free) way to convert it to CSV or MySQL? Try the ODBC driver downloadable at "2007 Office System Driver: Data Connectivity Components" http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891 You should then be able to connect to the data
Re: How to convert Acess 2007 ACCDB file to MySQL?
In the last episode (Dec 29), mos said: > Someone has given me an Access 2007 file *.ACCDB and I don't have Access > 2007. Is there a (preferably free) way to convert it to CSV or MySQL? Try the ODBC driver downloadable at "2007 Office System Driver: Data Connectivity
How to convert Acess 2007 ACCDB file to MySQL?
Someone has given me an Access 2007 file *.ACCDB and I don't have Access 2007. Is there a (preferably free) way to convert it to CSV or MySQL? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub
Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?
Le Tue, 23 Dec 2008 15:33:34 +, KLEIN Stéphane a écrit : > Le Tue, 23 Dec 2008 14:42:40 +, KLEIN Stéphane a écrit : > >> Hi, >> >> This my script to convert latin1 database to utf8 : >> >> $ mysqldump --user=root --password=password --host=mybox my
Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?
Le Tue, 23 Dec 2008 14:42:40 +, KLEIN Stéphane a écrit : > Hi, > > This my script to convert latin1 database to utf8 : > > $ mysqldump --user=root --password=password --host=mybox mydatabase -- > default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- &
Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?
I've break line misteak in my previous message, this is the fix : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1 > mydata
If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?
Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=lat
Flexible way to convert?
Greetings, Please see following sample code and result. Note that x is cast properly but y isn't. (FYI 0x913386aa3cbbab5a == 10462854425033288538) Is there a way in MySQL to convert strings to numbers such that it recognizes decimal, hex, and optionally other bases? I'm thinking of
Re: convert week of the year into a date string
I did something similar to this recently. I ended up using the following select date_sub(curdate(), interval(dayofweek(curdate()) + (($week - week) * 7) - 1) DAY) as mydate. This was in php and ahead of time I set $week as select week(curdate()). It could easily be extended with year. Phil On
Re: convert week of the year into a date string
Pintér Tibor wrote: Ananda Kumar írta: Hi All, I think i worked on this and found the results. I did the below. 1. Multiplied the week_of_the_year with 7 (7 days per week), to get the total number of days from begning of the year. 2. used mysql function makedate makedate(year,number of d
Re: convert week of the year into a date string
Ananda Kumar írta: Hi All, I think i worked on this and found the results. I did the below. 1. Multiplied the week_of_the_year with 7 (7 days per week), to get the total number of days from begning of the year. 2. used mysql function makedate makedate(year,number of days from the start of
Re: convert week of the year into a date string
mar <[EMAIL PROTECTED]> wrote: > >> HI All, >> I have table which stores week_of_the_year and year. >> For example >> >> week_of_yearYEAR >> 32 2008 >> >> I want to convert this into the date. That is , i need
convert week of the year into a date string
HI All, I have table which stores week_of_the_year and year. For example week_of_yearYEAR 32 2008 I want to convert this into the date. That is , i need to get the date of first day of the week 32. some thing like 03-AUG-2008. Regards anandkl
Re: Convert Dbase file to mysql and enter data
Andrew, I have a dbase3 database that I would like to convert to mysql. A dBASE III "database" isn't a database but rather a single ASCII fixed-field-length data table with a binary header describing data layout. I think these are your main choices: (i) if you have an xbase
Convert Dbase file to mysql and enter data
Hello I have a dbase3 database that I would like to convert to mysql. After I download mysql (need a link to a stable version), what do I need to do to create a mysql database with the dbase fields and then import the data. In addition is there some sort of gui tool that will allow me to enter
RE: a function to convert a uk date to and from mysql date
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 22 May 2007 15:47 > To: mysql@lists.mysql.com > Subject: a function to convert a uk date to and from mysql date > > > Hi, > > My UK dates are this format DD/MM/ I w
Re: a function to convert a uk date to and from mysql date
My UK dates are this format DD/MM/ I want it reversed and then the seperator changed so it becomes -MM-DD I use this PHP at the moment $available_from = implode('/', array_reverse(explode('-', $available_from))); An even better solution would be: $UKDate = '22/05/2007' $USDate = date(
a function to convert a uk date to and from mysql date
Hi, My UK dates are this format DD/MM/ I want it reversed and then the seperator changed so it becomes -MM-DD I use this PHP at the moment $available_from = implode('/', array_reverse(explode('-', $available_from))); Ta, R.
Re: convert duration(mediumint) to hours and minutes
me, persons.name from events, persons, clients where events.personid= persons.personid and events.clientid= clients.clientid group by clients.name, events.personid, theyear; this does, off course not give me the wanted result. How can I convert these numerical entries to hh:mm in my query? (days
convert duration(mediumint) to hours and minutes
theyear, (sum(events.duration)/60),clients.name, persons.name from events, persons, clients where events.personid= persons.personid and events.clientid= clients.clientid group by clients.name, events.personid, theyear; this does, off course not give me the wanted result. How can I convert these
RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP
l.com Subject: RE: Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP This is because with version 4.1 and higher the format of timestamp changes to -00-00 00:00:00. We had this problem, so we had to add a few lines in the scripts that take this field and work with it -
RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP
This is because with version 4.1 and higher the format of timestamp changes to -00-00 00:00:00. We had this problem, so we had to add a few lines in the scripts that take this field and work with it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:
RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP
I'm simply executing a SELECT query that used to work before, same database, everything the same except a higher version of the MySQL server. In that case you are probably facing some uncompatible issue between the versions you used. Maybe someone else is able to help you more that I :( Sorr
RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP
t: Re: Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP > The second major problem I am running into after the upgrade is the > following error, which did not occur on Development. > > Error Executing Database Query. Cannot convert value '-00-00
Re: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP
The second major problem I am running into after the upgrade is the following error, which did not occur on Development. Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP. The error occurred on line 8. MySQL version is: 5.0.27
Is there C API function to convert the MYSQL_ROW items from string to Language specified type?
Hi all: Is there a C API function to convert the MYSQL_ROW items from string to Language specified type? I thought there should be one, but I can't find it. Could you give me some advice? Appreciate your help! -- David
Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP
The second major problem I am running into after the upgrade is the following error, which did not occur on Development. Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP. The error occurred on line 8. MySQL version is: 5.0.27
How to convert the the string row[i] to its real type.
Hi all: I use mysql C API , and I want generate JSON object from mysql recordset, the filed value of JSON should be real type , e.g. int, float, ect. but the value I got using mysql_fetch_row() is strings, I can get its type using field->type, and then convert the values. but it is
Re: Convert hex to decimal?
On 11/6/06, Dušan Pavlica <[EMAIL PROTECTED]> wrote: > How would I convert > > 13 ("false decimal") to 0x13 (Hex) and from there to 19 (decimal)? > conv('column_name', 16, 10) Thanks, that works! Fred -- MySQL General Mailing List For list arc
Re: Convert hex to decimal?
Frederic Wenzel napsal(a): Hey, I have a table with a SMALLINT column that -- trough a mistake -- contains values like 57, 13 etc. which in fact are 0x57 and 0x13 (i.e. HEX numbers). How would I convert 13 ("false decimal") to 0x13 (Hex) and from there to 19 (decimal)? I tried my
Re: Convert hex to decimal?
> I have a table with a SMALLINT column that -- trough a mistake -- > contains values like 57, 13 etc. which in fact are 0x57 and 0x13 (i.e. > HEX numbers). > > How would I convert > > 13 ("false decimal") to 0x13 (Hex) and from there to 19 (decimal)? > > I tr
Convert hex to decimal?
Hey, I have a table with a SMALLINT column that -- trough a mistake -- contains values like 57, 13 etc. which in fact are 0x57 and 0x13 (i.e. HEX numbers). How would I convert 13 ("false decimal") to 0x13 (Hex) and from there to 19 (decimal)? I tried my luck with UNHEX and CAST but
Re: Query needed to convert varchar to int ....sorry previous posting was incomplete
VenuGopal Papasani wrote: Dear all, I have a table with the following structure. ield Type CollationNullKey Default Extra Privileges Comment --- -- -- --- -
Query needed to convert varchar to int ....sorry previous posting was incomplete
Dear all, I have a table with the following structure. ield Type CollationNullKey Default Extra Privileges Comment --- -- -- --- --
Query to convert a varchar into int
Dear all, I have a table with the following structure. ield Type CollationNullKey Default Extra Privileges Comment --- -- -- --- --
Character Set convert?
Hey all, got a simple question: Is there a quick way to convert all the data in my database to a specific character set? I want to convert all the text to UTF-8. -Charlie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com
Re: How to convert strings to 'proper case' ?
quot;. The reason for my question was to avoid using MS Access. I will certainly take a closer look at your suggestions ! Regards, Cor - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "C.R.Vegelin" <[EMAIL PROTECTED]>; Sent: Tuesday, May 09, 2
Re: How to convert strings to 'proper case' ?
My God! Rhino, that was a very long and very good answer!! Impressive!! /Johan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to convert strings to 'proper case' ?
e existing value, create a revised value using string manipulation techniques, then update the current value with the revised value. Creating the revised value would likely be the only tricky part and even that might not be very hard if it really were only necessary to convert the first letter
Re: How to convert strings to 'proper case' ?
2006 1:16am An example of how to make the first letter in a string uppercase - analogous to UCFIRST SELECT CONCAT(UPPER(SUBSTRING(firstName, 1, 1)), LOWER(SUBSTRING(firstName FROM 2))) AS properFirstName /Johan C.R.Vegelin wrote: Hi List, I want to convert strings to proper-case, where on
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
> I believe the answer is that there isn't a way to fix the syntax for 3.23, > because 3.23 simply doesn't support multi-table deletes. An alternative > solution is needed. > > One option would be to do this programmatically. Collect the sectionids > with a SELECT, then delete them with a sepa
How to convert strings to 'proper case' ?
Hi List, I want to convert strings to proper-case, where only the 1st char of each word is uppercase, such as: "This Is An Example." Any idea how to do this with MySQL 5.0.15 ? Thanks, Cor
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
The Nice Spider wrote: > Hi, > > This query running fine on 4.0.25 but when trying on > 3.23 an error occurs. > can one help me to find correct command for 3.23? > > DELETE FROM A > USING A > RIGHT JOIN B ON B.id = A.sectionid > WHERE B.id is null > > This task is deleted any row in A that have no
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
You are not being honest with us on the list. Firstly, the error you got: You have an error in your SQL syntax near 'USING USING A RIGHT JOIN B ON B.id = A.sectionid' at line 1 SQL=DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null indicates that you used the USIN
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
>> This query running fine on 4.0.25 but when trying on >> 3.23 an error occurs. >> can one help me to find correct command for 3.23? > Probably if you post the error message you get. > DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null error message on 3.23 is: You have
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
2006-05-02
Thread
Adam i Agnieszka Gąsiorowski FNORD aka ALinkA ak a symbol '( { .A. } )'' ||~> { A.A }
On 2006-05-02, at 08:51, The Nice Spider wrote: Wow, impressive pseudonym...Are you strong enough to be my man? ;-} DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null ...AND the_reader IS a_fool. Hell and damnation! SQL POETRY! :-} This task is
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
The Nice Spider schrieb: Hi, This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? Probably if you post the error message you get. -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL G
How to convert this DELETE command from MySQL 4.0.25 to 3.23?
Hi, This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null This task is deleted any row in A that have no items on B.
Re: UDF help, convert BLOB to BIGINT
ata is type BLOB. It is raw data collected. The substr will get >> the specific bytes I'm interested in. What I need to do, is if the data >> is <= 8bytes, convert it to a BIGINT, so I can do some masking on the >> data. >> >> So I am writing a UDF to do the job
Re: UDF help, convert BLOB to BIGINT
ytes I'm interested in. What I need to do, is if the data > is <= 8bytes, convert it to a BIGINT, so I can do some masking on the > data. > > So I am writing a UDF to do the job, but I am apparently unfamiliar with > the Mysql data types and how I can convert them. >
UDF help, convert BLOB to BIGINT
f the data is <= 8bytes, convert it to a BIGINT, so I can do some masking on the data. So I am writing a UDF to do the job, but I am apparently unfamiliar with the Mysql data types and how I can convert them. In a procedure. DECLARE fdata_bigint BIGINT UNSIGNED; SELECT BlobToInt(binary
Re: can we convert shape files
yes. on linux it is possible to convert shp files you have to use libmygis avaliable at http://jcole.us/software/libmygis/ shann ___ Halloween Humour: Why did Dracula divorce his wife after 800 years? postmaster.co.uk http
can we convert shape files
Hi all, Is there any possibility to convert and store a shape file into the mysql database like postgis feature in postgres.If there any please give me the steps how to convert or the link that consists of this documentation. Thanks in advance, Regards, venu.
How to convert InnoDB to MyISAM in 5.0?
hi guys, it's a simple thing (I think), but I can't find the docu on this from the mysql site. Thanks in advance for the help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: convert help
Hello. > ERROR 1314 (0A000): PREPARE is not allowed in stored procedures PREPARE in the stored procedures should work in the latest release (5.0.18). David Godsey wrote: > Thank you. I tried this outside of the procedure and it works. However In > MYSQL 5 I get: > ERROR 1314 (0A000): PREPARE
Re: convert help
#x27;insert into ta set a=(',@a,'+0)'); > select @s; > prepare st1 from @s; > execute st1 ; > deallocate prepare st1; > select @b:=a from ta; > select @b into tmp_int; >
Re: convert help
prepare st1 from @s; execute st1 ; deallocate prepare st1; select @b:=a from ta; select @b into tmp_int; drop temporary table ta; --SELECT CONVERT(fdata,BIGINT) INTO tmp_int; SE
convert varchar/char to integer
Hi Gents Is it possible to sort char/varchars that only contains integers as integers and not as characters. I can't use integer because the standard says it may contain characters aswell. Currently I do this outside mysql in a perl-procedure. Whatever I try I get this order: | 2000651
Re: convert varchar/char to integer
morten bjoernsvik <[EMAIL PROTECTED]> skrev: Hi Gents Is it possible to sort char/varchars that only contains integers as integers and not as characters. I can't use integer because the standard says it may contain characters aswell. Currently I do this outside mysql in a perl-procedure.
Re: [SPAM] - convert help - Bayesian Filter detected spam
pull out the data I'm interested in, however to do the masking and bit shifting it appears I need it to be an integer of some kind. So I am taking blob data and trying to convert it to an integer type (unsigned) so I can do those bitwise operations. So I am putting the data into a variable li
Re: [SPAM] - convert help - Bayesian Filter detected spam
Gordon, >... >SELECT CONVERT(fdata,BIGINT) INTO tmp_int; >SELECT HEX(tmp_int); ... Are you looking for... SELECT CAST(0xABCDEF0123456789 AS UNSIGNED); +--+ | CAST(0xABCDEF0123456789 AS
RE: [SPAM] - convert help - Bayesian Filter detected spam
David Godsey [mailto:[EMAIL PROTECTED] Sent: Thursday, January 19, 2006 3:33 PM To: mysql@lists.mysql.com Subject: [SPAM] - convert help - Bayesian Filter detected spam I am trying to convert binary data to a bigint so I can do bitwise operations on the data, and I'm having trouble doing it.
convert help
I am trying to convert binary data to a bigint so I can do bitwise operations on the data, and I'm having trouble doing it. I noticed that if I have binary data and I: select data>>1; I get 0 (not what I'm expecting). Here is a test procedure I wrote: create procedure te
Re: Convert Subquery - need to find max of a set
[EMAIL PROTECTED] wrote: "Kristen G. Thorson" <[EMAIL PROTECTED]> wrote on 10/14/2005 09:15:21 AM: I need to convert this query into one without a subquery: SELECT r.selector_forms_results_max_points AS points, r.selector_forms_results_description AS d
Re: Convert Subquery - need to find max of a set
"Kristen G. Thorson" <[EMAIL PROTECTED]> wrote on 10/14/2005 09:15:21 AM: > I need to convert this query into one without a subquery: > > SELECT > r.selector_forms_results_max_points AS points, > r.selector_forms_results_description AS description, >
Convert Subquery - need to find max of a set
I need to convert this query into one without a subquery: SELECT r.selector_forms_results_max_points AS points, r.selector_forms_results_description AS description, FROM selector_forms_results AS r WHERE r.selector_forms_id = 1 AND r.selector_forms_results_max_points = ( SELECT
Re: convert varchar to char
Pooly wrote: Damnit ! Thanks for pointing it, I forgot these things. But it's a bit more subtle : If any column in a table has a variable length, the entire row becomes variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR colu
Re: convert varchar to char
Yeah, for example the last statement ALTER, ..., ... is the only way sometimes to make things working. anyway, it's worth knowing it. 2005/8/13, Chris Elsworth <[EMAIL PROTECTED]>: > On Sat, Aug 13, 2005 at 05:37:56PM +0100, Pooly wrote: > > Damnit ! > > Thanks for pointing it, I forgot these
Re: convert varchar to char
On Sat, Aug 13, 2005 at 05:37:56PM +0100, Pooly wrote: > Damnit ! > Thanks for pointing it, I forgot these things. > But it's a bit more subtle : [snip] Bah, should have waited another 5 minutes before I bothered posting my last long-winded ramble ;) > ALTER TABLE sessions MODIFY id char(32) NOT
Re: convert varchar to char
On Sat, Aug 13, 2005 at 04:01:38PM +0100, Pooly wrote: > > ALTER TABLE sessions MODIFY ip char(8) NOT NULL DEFAULT '0'; > ALTER TABLE sessions MODIFY id char(32) NOT NULL DEFAULT ''; Hello, Since you have two varchar columns, I don't think there's any w
Re: convert varchar to char
(`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 and now I've got fixed-length rows ! Thanks 2005/8/13, Roger Baklund <[EMAIL PROTECTED]>: > Pooly wrote: > > Hi, > > > > I try to convert a varchar to a char, but it doesn't seems to work. > > Fro
Re: convert varchar to char
Pooly wrote: Hi, I try to convert a varchar to a char, but it doesn't seems to work. From the manual: "...all CHAR columns longer than three characters are changed to VARCHAR columns." http://dev.mysql.com/doc/mysql/en/silent-column-changes.html > -- Roger -- MySQL Ge
convert varchar to char
Hi, I try to convert a varchar to a char, but it doesn't seems to work. show create table sessions; CREATE TABLE `sessions` ( `id` varchar(32) NOT NULL default '', `user_id` int(6) NOT NULL default '0', `ip` varchar(8) NOT NULL default '0', `l
Convert Berkeley db to ISAM
Hi All, Does anyone know how to convert Berkeley db to ISAM type? I have many Berkeley db files sitting on my hard drive. I want to port it to MySQL as ISAM tables. I understand I can directly load it to MySQL 4.0 by specifying the directory location. Instead I want to convert them ISAM type
Re: Convert subquery
2005/5/17, Kristen G. Thorson <[EMAIL PROTECTED]>: > I actually had something similar to this at one point, but I never got it > working. Your query returned 148 rows, which I can tell you right away > can't be right since there are only 130 items in `page`. I believe the > problem is that it do
