 | | | MySQL General | | Mostly because use 2 field to represent the same data is a waste of storage i think.
----- "Martijn Tonies " <m.tonies@(protected) > escribi??
> >The aplication which is writing to the database is sen >The aplication which is writing to the database is sending the date in unix
format.
>I can 't no change that so i suposse using a triger will help.
>
>The application pass the 'xxxxxx.xx ' value when The aplication which is writing to the database is sending the date in unix format.
I can 't no change that so i suposse using a triger will help.
The application pass the 'xxxxxx.xx ' value when is i >If i define that the value for the field must be varchar data type `fecha`
varchar(25) default NULL the triger records the right date.
>I think because is wrinting a string only. But if i define thMartijn
If i define that the value for the field must be varchar data type `fecha` varchar(25) default NULL the triger records the right date.
I think because is wrinting a string only. But if i deGiven that FEHLGESCHLAGEN means "failed " and coupled with the proceding
text I would assume that you don 't have mysql installed in the first
place. If you are on an rpm based system try the followiif u do ps -ef | grep mysql what do u get.
regards
anandkl
On 10/12/07 Daniel Bau <daniel.bau@(protected) > wrote
>
> He say he can not connect to the server -- > no server is installed and noHe say he can not connect to the server -- > no server is installed and no socket is in
var/lib/mysql ....
When I install it he want to start the server and say "FEHLGESCHLAGEN "
No mysql server or manwhat is the error ur getting.
regards
anandkl
On 10/11/07 Daniel Bau <daniel.bau@(protected) > wrote
>
> Dear MySQL Support team
>
> I have bis problems to upgrade my MySQL 3.23.58 Version o--Message-Boundary-7095
Content-type text/plain charset US-ASCII
Content-transfer-encoding 7BIT
Content-description Mail message body
Dear MySQL Support team
I have bis problems to upgrade myHi
> I have a problem with a trigger which should conver a unix timestamp to a
MySQL date datatype.
> The trigger works if the column is varchar but when the column is date
type it write the date > QUESTION What are the most secure permissions settings for
> administrator
> access to connect to my server without using a static IP address?
Assuming a unix server (or even a windows server runI am trying to change this value and it doesn 't seem to work.
Looking at the processes I have
mysql 21752 0.0 0.1 1652 1092 p3 I 3 50PM 0 00.01
/bin/sh /usr/local/bin/mysqld_safe
--deMichael
im converting the unixtime to "normal " time with from_unixtime.
So after i did the convertion i write the result to the table.
It works ok when i write to a varchar column but not to a date Hi
I have a problem with a trigger which should conver a unix timestamp to a MySQL date datatype.
The trigger works if the column is varchar but when the column is date type it write the date of This and Frederic Wenzel 's suggestions were exactly what I was looking
for.
Thanks!
Bob
> -----Original Message-----
> From Erich C. Beyrent [mailto erich.beyrent@(protected)]
> Sent Thursday OcI have two tables.
TableA is current data.
TableB (created with 'Create Table A like Table B ' ) is an archive where
deleted data is inserted from Table A before being deleted from table B with
"INSDont trust anything The more secure you can be the better What
happens if you have not patched a single server (maybe you are
testing) then someone gets into it and then has unrestricted access to
aMy take on this never have no password..
At no time any data you have someone else will also want therefore
running a open query with nopasword on the system for a couple of
hours will get access to I 've been working with Drupal for some time and there is a module that
allows you to create event-based content with a repeating schedule. The
schema that it uses may be of some help to you.
CREAOn 10/10/07 Ramsey Robert L <robert-ramsey@(protected) > wrote
> I 'm looking for a "best practices " way of creating tables to store both
> one time and regularly repeating events. These are classes At 02 40 PM 10/10/2007 Baron Schwartz wrote
>mos wrote
> >At 01 24 PM 10/10/2007 Baron Schwartz wrote
> > >Hi
> > >
> > >Tiago Cruz wrote
> > > >Hello guys
> > > >I have one monster database running on MySHi
I 'm looking for a "best practices " way of creating tables to store both
one time and regularly repeating events. These are classes so for the
most part the have a regularly recurring time but Eric Frazier wrote
> Andrew Carlson wrote
> > If you do what Baron suggests you may want to set Innodb to create a
> > file-per-table - that way in the future you could save space when
> > tables
>mos wrote
> At 01 24 PM 10/10/2007 Baron Schwartz wrote
> > Hi
> >
> > Tiago Cruz wrote
> > > Hello guys
> > > I have one monster database running on MySQL 4.0.17 using InnoDB
> > > 270GB Oct 10 14 35 Andrew Carlson wrote
> If you do what Baron suggests you may want to set Innodb to create a
> file-per-table - that way in the future you could save space when tables
> are dropped or you could rSo just to clarify optimize table just defragments the index?
Apologies I misinterpreted the documentation then.
Thanks
Dan
-----Original Message-----
From Baron Schwartz [mailto baron@(protected)At 01 24 PM 10/10/2007 Baron Schwartz wrote
>Hi
>
>Tiago Cruz wrote
> >Hello guys
> >I have one monster database running on MySQL 4.0.17 using InnoDB
> >270GB Oct 10 14 35 ibdata1
> >
> >I 've deleteHi Tiago
Tiago Cruz wrote
> Thank you guys!!
>
> I have a lot of MyISAM and a lot of InnoDB on this database.
>
> I did one little "for " to run one "OPTIMIZE TABLE " in each table that I
> have oThank you guys!!
I have a lot of MyISAM and a lot of InnoDB on this database.
I did one little "for " to run one "OPTIMIZE TABLE " in each table that I
have on my database.
If this step don 't save e |
|
|
