2014/09/04 08:40 -0700, Jan Steinman
> From: "Ed Mierzwa (emierzwa)"
>
>
> FROM_UNIXTIME(1409304102.153) /*your epoch column here*/
I don't think the OP has a Unix timestamp.
The number looks suspeciously like concatenation of date digits, "140930" at
the beginning looks like Septem
- Original Message -
> From: "Jan Steinman"
> Subject: RE: converting numeric to date-time?
>
> I don't think the OP has a Unix timestamp.
OP explicitly says "epoch including milliseconds" - so it's going to be three
digits too long :-)
divide
> From: Jan Steinman
>To: mysql@lists.mysql.com
>Sent: Thursday, 4 September 2014, 16:40
>Subject: RE: converting numeric to date-time?
>
>
>> From: "Ed Mierzwa (emierzwa)"
>>
>>
>> FROM_UNIXTIME(1409304102.153)/*your epoch column
> From: "Ed Mierzwa (emierzwa)"
>
>
> FROM_UNIXTIME(1409304102.153) /*your epoch column here*/
I don't think the OP has a Unix timestamp.
The number looks suspeciously like concatenation of date digits, "140930" at
the beginning looks like September 30, 2014.
If that's the case, you need to
mber 01, 2014 5:51 PM
To: Rajeev Prasad
Cc: MYSQL General List
Subject: Re: converting numeric to date-time?
* Rajeev Prasad [2014-09-01 17:55]:
> I have a column in a table which is epoch time including milliseconds.
>
> e.g. = 1409304102153
>
>
> now i want to display all
* Rajeev Prasad [2014-09-01 17:55]:
> I have a column in a table which is epoch time including milliseconds.
>
> e.g. = 1409304102153
>
>
> now i want to display all fields in the table but this field as: "2014-8-29
> Fri 09:21:42: GMT" (whatever comes in )
>
>
> and i am not findi
I have a column in a table which is epoch time including milliseconds.
e.g. = 1409304102153
now i want to display all fields in the table but this field as: "2014-8-29 Fri
09:21:42: GMT" (whatever comes in )
and i am not finding anything on web about how to do that.
can anyone help
> -Original Message-
> From: Kevin Peterson [mailto:qh.res...@gmail.com]
> Sent: 27 March 2013 06:58
> To: mysql@lists.mysql.com
> Subject: Converting Mysql to mysql cluster
>
> Hi,
>
> My site is using mysql and PHP, now for the scale purpose want to
>
2012/09/30 11:07 -0700, Mark Phillips
The data for this table comes from a web page (charet utf8). I copy/paste word
files into gedit (on linux) and then copy/paste from gedit to a text boxes on
the web page input form. I had thought I was stripping out all the funky
characters by usin
the
single straight one. But that would be work for you to explicitly do.
If you are using PHP, see functions htmlentities() and html_entity_decode().
> -Original Message-
> From: Mark Phillips [mailto:m...@phillipsmarketing.biz]
> Sent: Sunday, September 30, 2012 11:08
oxes on the web page input form. I had thought I was stripping out all the
funky characters by using a simple ascii editor like gedit, but obviously
not.
After looking at the mysqldump for the table in a hex editor, I discovered
I have these characters scatter throughout the body and intro columns:
“
the encoding.
(sorry, don't have the link handy)
> -Original Message-
> From: h...@tbbs.net [mailto:h...@tbbs.net]
> Sent: Thursday, September 27, 2012 2:24 PM
> To: Mark Phillips
> Cc: Mysql List
> Subject: Re: Need Help Converting Character Sets
>
> >>&
To go along with what Rick is saying, this link might help you:
http://dba.stackexchange.com/questions/10467/how-to-convert-control-characters-in-mysql-from-latin1-to-utf-8
I remember doing a bunch of converting HEX() control characters (such as an
apostrophe copied from a Word document) before
ped into the observatory?s control room..."
Is there a better way to accomplish my first goal, without reading each
article and manually making the changes?
<<<<<<<<
I do not remember where on the MySQL website this is, but there was an article
about converting from
eclared for the column they go in. (Presumably, all the text columns will be
declared utf8 or utf8mb4.)
> -Original Message-
> From: Mark Phillips [mailto:m...@phillipsmarketing.biz]
> Sent: Monday, September 24, 2012 4:28 PM
> To: Mysql List
> Subject: Need Help Convertin
I have a table, Articles, of news articles (in English) with three text
columns for the intro, body, and caption. The data came from a web page,
and the content was cut and pasted from other sources. I am finding that
there are some non utf-8 characters in these three text columns. I would
like to
;>>> 2012/01/31 10:52 +0100, Johan De Meersman
Not *entirely* accurate: MySQL does include a CSV engine that you can use in
the same way you would use InnoDB or any other engine.
If you create a table a with engine=CSV and then go look at the data
dictionary, you'll find the files a.frm and
- Original Message -
> From: "Halász Sándor"
>
> noting that MySQL does not really support CSV: one can set all
Not *entirely* accurate: MySQL does include a CSV engine that you can use in
the same way you would use InnoDB or any other engine.
If you create a table a with engine=CSV a
I would appreciate the help if anyone could share what tools will you
recommend of converting SQL database to MySQL.
The Data Wizard for MySQL software by SQL Maestro Group includes a powerful
Data Pump tool that can transfer schema and data from any DBMS to MySQL:
http://www.sqlmaestro.com
>>>> 2012/01/30 15:06 +0800, James >>>>
I am involved in a project to migrate our entire database from Microsoft
SQL to MySQL.
I would appreciate the help if anyone could share what tools will you
recommend of converting SQL database to MySQL.
<<<<<&l
e:
> I do this quite frequently. In our case, we are converting competitors
> data so the process is to use Navicat (premium) to bring the data from
> MSSQL to MySQL (in the same fields, etc.) and then use a program to convert
> it into our format so it will run on our system. The onl
I do this quite frequently. In our case, we are converting competitors data so
the process is to use Navicat (premium) to bring the data from MSSQL to MySQL
(in the same fields, etc.) and then use a program to convert it into our format
so it will run on our system. The only thing I have had
Hi All,
I am involved in a project to migrate our entire database from Microsoft
SQL to MySQL.
I would appreciate the help if anyone could share what tools will you
recommend of converting SQL database to MySQL.
Cheers.
James
oedwards
-Original Message-
From: Jan Steinman [mailto:j...@bytesmiths.com]
Sent: Friday, February 11, 2011 12:53 PM
To: mysql@lists.mysql.com
Subject: Converting INNODB to file-per-table?
Our incremental backups seem to be filling with instances of ib_logfile1,
ib_logfile2, and ibdata1.
York, NY 10013
> 212-625-5307 (Work)
> 201-660-3221 (Cell)
> AIM & Skype : RolandoLogicWorx
> redwa...@logicworks.net
> http://www.linkedin.com/in/rolandoedwards
>
>
> -Original Message-
> From: Jan Steinman [mailto:j...@bytesmiths.com]
> Sent: Friday, Feb
y 11, 2011 12:53 PM
To: mysql@lists.mysql.com
Subject: Converting INNODB to file-per-table?
Our incremental backups seem to be filling with instances of ib_logfile1,
ib_logfile2, and ibdata1.
I know that changing a single byte in a single INNODB table causes these files
to be "touched
Dump the entire DB, drop the DB, restore the DB.
On Fri, Feb 11, 2011 at 11:53 AM, Jan Steinman wrote:
> Our incremental backups seem to be filling with instances of ib_logfile1,
> ib_logfile2, and ibdata1.
>
> I know that changing a single byte in a single INNODB table causes these
> files to b
Our incremental backups seem to be filling with instances of ib_logfile1,
ib_logfile2, and ibdata1.
I know that changing a single byte in a single INNODB table causes these files
to be "touched."
I put "innodb_file_per_table" in /etc/my.cnf, but apparently, that only causes
new databases to be
You can do some trickery with auto increment fields and multiple-column
indexes. Have a look at http://www.bitbybit.dk/carsten/blog/?p=131
Beware that this is apparently a MyISAM-specific trick.
/ Carsten
On Tue, 6 Apr 2010 16:02:48 +0530, "Suryanarayanan"
wrote:
> I am new to mysql a
I am new to mysql and am trying to develop a package in php using mysql as
backend database.
I have a table in mysql which has a customer code which is alpha numeric.
Eg: J0001 and name and address of the customer. The alphabet signifies the
first letter of the name of the customer viz. James.
ssage.
Regards,
Gavin Towey
-Original Message-
From: Steve Staples [mailto:sstap...@mnsi.net]
Sent: Monday, February 08, 2010 9:39 AM
To: mysql@lists.mysql.com
Subject: Converting MyISAM to InnoDB
Hello again!
I am trying to convert my tables to InnoDB, and i am getting an error...
Error:
Hello again!
I am trying to convert my tables to InnoDB, and i am getting an error...
Error: 1075
Incorrect table definition; there can be only one auto column and it must be
defined as a key
Now, I converted a table in my sandbox earlier this morning to do some
testing, and it worked fine... mi
At 04:55 PM 1/14/2010, Jacek Becla wrote:
Hello,
I need to convert a non-materialized MySQL view to
a MySQL table. Are there any tools to do that?
Thanks,
Jacek
Jacek,
Can't you just do a:
create table mytable select * from myview;
???
Mike
--
MySQL General Mailing List
For list arc
Hello,
I need to convert a non-materialized MySQL view to
a MySQL table. Are there any tools to do that?
Thanks,
Jacek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
2009/9/13 Dan Nelson
> In the last episode (Sep 12), Arthur Meeks Meeks said:
> > I have a database with about 1000 tables and 150GB. I have done a simple
> > "for f in $(cat tables); do mysql -uuser -ppassword database_name -e
> > "alter table $f engine=InnoDB;" ; done
> >
> > I took about 3 hou
In the last episode (Sep 12), Arthur Meeks Meeks said:
> I have a database with about 1000 tables and 150GB. I have done a simple
> "for f in $(cat tables); do mysql -uuser -ppassword database_name -e
> "alter table $f engine=InnoDB;" ; done
>
> I took about 3 hours and everything went fine, but I
Hello,
I have a database with about 1000 tables and 150GB. I have done a simple
"for f in $(cat tables); do mysql -uuser -ppassword database_name -e "alter
table $f engine=InnoDB;" ; done
I took about 3 hours and everything went fine, but I just realised that the
same database in another server i
Does anyone have any scripts that will help convert Visual FoxPro 6.0
style WHERE clauses to MySQL...
For the most part the problems are converting VFP functions to the
equivalent SQL. For example, Visual FoxPro has a function inlist()
that is used like inlist(X,1,2,3) which converts to the MySQL
Hi All,
I am converting some of the myisam tables to innodb.
What are the things i need to take care before doing this and also after
doing this.
regards
anandkl
tf8toiso88591(mycolumn) where id
> > between 500 and 600;
> >
>
> I don't know if mysql has this charset converting routine.
> But you can do it by application scripts,ie,in perl you can convert them
> by,
>
> use Encode;
> my $iso_str = encode('iso-8859-1
m looking for is something like this:
>
> update mytable set mycolumn = utf8toiso88591(mycolumn) where id
> between 500 and 600;
>
I don't know if mysql has this charset converting routine.
But you can do it by application scripts,ie,in perl you can convert them
by,
use Encode
if a table column is supposed to contain text in iso-8859-1, but utf-8
encoding have snuck in on a few rows by mistake, how are these rows
converted into iso-8859-1?
what i am looking for is something like this:
update mytable set mycolumn = utf8toiso88591(mycolumn) where id
between 500 and 600;
Any help on how to do this in mysql
On 5/30/07, Chris Hoover <[EMAIL PROTECTED]> wrote:
I have the following trigger in Postgresql, how can we do this in Mysql?
CREATE TRIGGER tr_encounter_lab_order_upd
AFTER UPDATE ON encounter_lab_order
FOR EACH ROW
EXECUTE PROCEDURE tr_encou
I have the following trigger in Postgresql, how can we do this in Mysql?
CREATE TRIGGER tr_encounter_lab_order_upd
AFTER UPDATE ON encounter_lab_order
FOR EACH ROW
EXECUTE PROCEDURE tr_encounter_lab_order_upd_trig_func();
CREATE OR REPLACE FUNCTION tr_encounter_lab_order_upd_trig_func()
Hi,
I followed the instructions to change columns values from an encoding
another
(in my case from latin1 to utf8), but the operation simply failed.
The manual reads
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html :
"
If you want to change the table default character set and all ch
In the last episode (Dec 05), Nstor said:
> I am not very savy with SQL and I need help. I have a char field
> that contains a date and the date is in DD-MM- and I want to sort
> it but the sort is wrong because 01-04-2007 comes out before
> 10-22-2006.
>
> Is there an easy way to provide a c
People,
I am not very savy with SQL and I need help. I have a char field
that contains a date and the date is in DD-MM- and I want to
sort it but the sort is wrong because 01-04-2007 comes out before
10-22-2006.
Is there an easy way to provide a correct sorted output list or do I
need to e
D]>
To:
Sent: Tuesday, July 25, 2006 11:51 PM
Subject: Re: Row count discrepancy when converting from MyISAM to InnoDB
On Jul 25, 2006, at 11:55 AM, Frank wrote:
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be d
nt: Tuesday, July 25, 2006 11:51 PM
Subject: Re: Row count discrepancy when converting from MyISAM to InnoDB
On Jul 25, 2006, at 11:55 AM, Frank wrote:
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be done to avoid loss of
Thank you to everyone who replied. It turned out I had index corruption and
after running an OPTIMIZE TABLE I was able to convert all the records to
InnoDB.
Thanks,
Frank
On Jul 25, 2006, at 11:55 AM, Frank wrote:
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be done to avoid loss of this many rows?
InnoDB doesn't keep a count on number of rows, like MyISAM does.
InnoDB only main
I have a table of type MyISAM that is reporting 47 million rows when I do a
SELECT COUNT(*). When I convert this table to InnoDB, running a SELECT
COUNT(*) returns only 19 million rows. The conversion confirms 19 million
rows were inserted and reports no warnings or duplicates.
I have done the co
At 14:16 +0200 18/7/06, Mike van Hoof wrote:
And for the everything in utf8... will try this next time i get this
kind of a problem...
When you do, you'll need to send out the proper header from your php scripts:
header ('Content-type: text/html; charset="UTF-8"');
and put this in your MySQL c
Chris Sansom schreef:
At 13:40 +0200 18/7/06, Mike van Hoof wrote:
Well.. gonna try some text-converting in php then...
And yeah, it really needs to be a blob field... not my choice, but we
got a CMS which operates on field types from MySQL... and a blob
field wil generate an WYSIWYG field
At 13:40 +0200 18/7/06, Mike van Hoof wrote:
Well.. gonna try some text-converting in php then...
And yeah, it really needs to be a blob field... not my choice, but
we got a CMS which operates on field types from MySQL... and a blob
field wil generate an WYSIWYG field... but i think i am
Addison, Mark schreef:
From: Mike van Hoof Sent: 18 July 2006 12:18
To: Addison, Mark
Subject: Re: Converting TEXT to BLOB with special chars
Addison, Mark schreef:
From: Mike van Hoof Sent: 18 July 2006 10:49
Hello,
I am having a
From: Mike van Hoof Sent: 18 July 2006 12:18
> To: Addison, Mark
> Subject: Re: Converting TEXT to BLOB with special chars
>
> Addison, Mark schreef:
>
> From: Mike van Hoof Sent: 18 July 2006 10:49
>
>
> Hello,
>
en i convert the TEXT field to a BLOB field these signs
> are lost
> and i get
>
> So does anyone know a workaround for this (and not converting
> to a BLOB
> is not an option... sorry)
What version of mysql are you using?
What character set is the TEXT column?
What are yo
a workaround for this (and not converting to a BLOB
is not an option... sorry)
Mike
--
Medusa, Media Usage Advice B.V.
Science Park Eindhoven 5216
5692 EG SON
tel: 040-24 57 024
fax: 040-29 63 567
url: www.medusa.nl
mail: [EMAIL PROTECTED]
Uw bedrijf voor Multimedia op Maat
--
MySQL
Wolfram Kraus napsal(a):
On 28.06.2006 13:54, Dušan Pavlica wrote:
Hello,
I have column of type char(2) containing hex numbers (e.g. "0A", "FF",
...) and I cannot find correct function which could convert those hex
numbers to integers so I can perform futher calculations. I experimented
with
On 28.06.2006 13:54, Dušan Pavlica wrote:
> Hello,
> I have column of type char(2) containing hex numbers (e.g. "0A", "FF",
> ...) and I cannot find correct function which could convert those hex
> numbers to integers so I can perform futher calculations. I experimented
> with HEX(), CAST(), CONVER
Hello,
I have column of type char(2) containing hex numbers (e.g. "0A", "FF",
...) and I cannot find correct function which could convert those hex
numbers to integers so I can perform futher calculations. I experimented
with HEX(), CAST(), CONVERT() but I wasn't succesfull.
Thanks in advance
...you're right on that too.
PB
Chris Sansom wrote:
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
SELECT category.name, page.name, content.title
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE conte
>Are there any advantages to converting this 'working' query below to
>use INNER JOIN ?
>If so, what would the correct syntax be ?
>
>SELECT category.name, page.name, content.title, content.body
>FROM category, page, content
>WHERE content.page_id = page.id
>
many thanks Chris :)
g
On May 24, 2006, at 1:19 AM, Chris Sansom wrote:
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below
to use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT cat
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT category.name, page.name, content.title, content.body
FROM category, page, con
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE content.page_id = page.id
AND page.c
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 16, 2006 3:08 PM
Subject: Re: Converting varchar field into primary key
> Jonathan Mangin wrote:
>
> >>>
Jonathan Mangin wrote:
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zer
> > > I'm creating a new MySQL database from an existing Filemaker db.
> > >
> > > My problem is that some of the existing 'numbers' in one column (it
> > > was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
> > > 001234. I need to maintain these numbers 'as is' - complete with
> > I'm creating a new MySQL database from an existing Filemaker db.
> >
> > My problem is that some of the existing 'numbers' in one column (it
> > was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
> > 001234. I need to maintain these numbers 'as is' - complete with
> > zeros
> I'm creating a new MySQL database from an existing Filemaker db.
>
> My problem is that some of the existing 'numbers' in one column (it
> was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
> 001234. I need to maintain these numbers 'as is' - complete with
> zeros. I've tried
Hello,
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zeros. I've tried al
Sorry,
I have no idea about that :)
Eugene Kosov wrote:
Yes I know restoring plain password from it's hash is impossible (at
least in theory ;)) but I don't need password itself.
I thought if we know f1(x) (PASSWORD) and f2(x) (OLD_PASSWORD) we
possibly can get such f(x) that will make exp
Yes I know restoring plain password from it's hash is impossible (at
least in theory ;)) but I don't need password itself.
I thought if we know f1(x) (PASSWORD) and f2(x) (OLD_PASSWORD) we
possibly can get such f(x) that will make expression f2(x) = f(f1(x))
truth for every x.
I haven't any
AFAIK,
PASSWORD() or OLD_PASSWORD() is one way function, it means in math if
you do f(x) = y, you never know x, all you now is the result of f(x) ~ y
Moreover, do you have a problem with new password format?
Eugene Kosov wrote:
Hi, everyone!
I have transfer user's database and grants from
Eugene Kosov <[EMAIL PROTECTED]> wrote on 03/23/2006 07:03:15 AM:
> Hi, everyone!
>
> I have transfer user's database and grants from one mysql server
> (4.1.15) to an older one (4.0.26). I don't know user's password and have
> only it's hash. How can I convert hashed password stored in
> mys
Hi, everyone!
I have transfer user's database and grants from one mysql server
(4.1.15) to an older one (4.0.26). I don't know user's password and have
only it's hash. How can I convert hashed password stored in
mysql.user.password field to the 4.0 format? Is there something similar
to OLD_PA
: Gabriel PREDA [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 14, 2006 6:30 PM
To: mysql@lists.mysql.com
Cc: Peter Lauri
Subject: Re: Converting database and its tables to UTF-8
Hi Peter,
That will be a lot of work !
1. First make a back-up... it's always a good ideea !
2. For every
Hi Peter,
That will be a lot of work !
*1.* First make a back-up... it's always a good ideea !
*2.* For every table in the database alter String Types into BINARY string
types
that means:
- *(VAR)CHAR(M)* will become *(VAR)**CHAR(M) BINARY* or *(VAR)**BINARY(M)*
- *TINYTEXT, TEXT, MEDIUMTEXT,
Hi,
I have a database with around 40 tables that needs to be converted to UTF-8
to support multi languages. What is the best procedure to do this?
And is it any way to change the default charset to UFT-8 so tables by
default will become UFT-8?
And can I have one table with different fi
Dan,
>I tried using prepared statements to make a procedure that
>converts every table in a schema from ARCHIVE to MyISAM...
"The following SQL statements can be used in prepared statements: CREATE TABLE, DELETE,
DO, INSERT, REPLACE, SELECT, SET, UPDATE, and
most SHOW statements. Other statem
Actually please ignore my previous question. I just had a brain cramp.
Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 1/18/06 11:34:11 AM >>>
Can you (or anyone else) explain to me how, or point me somewhere that I can
learn how this works? I'd really like to know more about how bitwise arithmetic
e END REPEAT;
CLOSE cur1;
END; //
delimiter ;
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 18, 2006 2:16 PM
To: Burke, Dan
Cc: mysql@lists.mysql.com
Subject: Re: Procedure / Prepared statements error converting table
"Burke,
Can you (or anyone else) explain to me how, or point me somewhere that I can
learn how this works? I'd really like to know more about how bitwise arithmetic
works.
Thanks
>>> Francesco Riosa <[EMAIL PROTECTED]> 1/10/06 4:58:47 PM >>>
Francesco Riosa wrote:
> And another one is (in inverse orde
"Burke, Dan" <[EMAIL PROTECTED]> wrote on 01/18/2006 02:05:24 PM:
>
> I tried using prepared statements to make a procedure that converts
> every table in a schema from ARCHIVE to MyISAM (there's about three
> dozen archive tables here). But for some odd reason it will give an
> error after doin
I tried using prepared statements to make a procedure that converts
every table in a schema from ARCHIVE to MyISAM (there's about three
dozen archive tables here). But for some odd reason it will give an
error after doing the first table, and abort. The really odd thing is
that the table it give
I have a timestamp stored in a datetime field. It gets set using Now()
when the record was inserted. I would like to pull the data back out
and have it in UTC time. Is there an easy way to do this? I've been
through the manual and on google but haven't come up with anything.
This is in a PHP sc
/www.innodb.com/order.php
- Original Message -
From: ""Patrick Herber"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Sunday, January 15, 2006 4:16 PM
Subject: RE: ERROR 1114 (HY000): The table is full converting a big table
from MyISAM to InnoDB o
o use
innodb_data_file_path?
Thanks a lot and regards,
Patrick
> -Original Message-
> From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]
> Sent: Sunday, 15 January 2006 15:09
> To: Patrick Herber
> Cc: mysql@lists.mysql.com
> Subject: Re: ERROR 1114 (HY000): The table is f
Hi,
I think you should change the tmpdir variable value to a directory which
have enough room to create your temp big table (by default, it points
to /tmp dir).
Regards,
Jocelyn
Patrick Herber a écrit :
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
Since
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
Since I have some performance troubles with "table-locking" in a multi-user
environment (when one of them performs a complex query all the other have to
wait up to 1 minute, which is not very nice...), I would like to c
Francesco Riosa wrote:
> And another one is (in inverse order for laziness):
>
> select
> (8 & 1) AS `0`
> , (8 & 2 > 1) AS `1`
> , (8 & 4 > 1) AS `2`
> , (8 & 8 > 1) AS `3`
> , (8 & 16 > 1) AS `4`
> , (8 & 32 > 1) AS `5`
> , (8 & 64 > 1) AS `6`
> , (8 & 128 > 1) AS `7`
> ;
>
but this one look
>
>
>
>
>>>> "Gordon Bruce" < [EMAIL PROTECTED] > 1/10/06 1:44 PM >>>
>>>>
> Actually CONV converts from any base to any base so if it is base 10
> then just replace the 16's with 10's.
>
> Too much ti
n just replace the 16's with 10's.
Too much time looking at dump's.
-Original Message-
From: Bill Dodson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 3:09 PM
To: Gordon Bruce
Cc: Ed Reed; mysql@lists.mysql.com
Subject: [SPAM] - Re: Converting decimal to
Reed; mysql@lists.mysql.com
Subject: [SPAM] - Re: Converting decimal to binary - Bayesian Filter
detected spam
If you really do mean decimal (base 10) you could use Gordon's solution
like this:
SELECT
MID(CONV(HEX(245),16,2),1,1) AS `7`,
MID(CONV(HEX(245),16,2),2,1) AS `6`,
MID(CONV(HEX(2
Ed Reed; mysql@lists.mysql.com
Subject: [SPAM] - Re: Converting decimal to binary - Bayesian Filter
detected spam
If you really do mean decimal (base 10) you could use Gordon's solution
like this:
SELECT
MID(CONV(HEX(245),16,2),1,1) AS `7`,
MID(CONV(HEX(245),16,2),2,1) AS `6`,
MID(CONV(HEX(245),16
+---+---+---+---+
1 row in set (0.00 sec)
-Original Message-
From: Ed Reed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 12:16 PM
To: mysql@lists.mysql.com
Subject: Converting decimal to binary
Can anyone tell me if it's possible, in 4.1.11, to convert a decimal
number to b
1 row in set (0.00 sec)
-Original Message-
From: Ed Reed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 12:16 PM
To: mysql@lists.mysql.com
Subject: Converting decimal to binary
Can anyone tell me if it's possible, in 4.1.11, to convert a decimal
number to binary and
1 - 100 of 364 matches
Mail list logo
