| |
| |
| |
|
Comments:
<0> when i fetch an array, is there a way to fetch the row number i want?
<0> SELECT * FROM `auctions` WHERE ('desc' like '%Real%' AND state='CA' AND type='property') ORDER BY name ASC; when i use %% instead of %Real% they all show up, but even if desc contains *Real* it returns nothing
<0> any ideas?
<1> hello
<1> is there a way to let mysql put a date in a timestamp field on every insert and update?
<1> i have version 5 installed
<2> rtfm
<3> is there a advantages of using datetime instead of bigint?
<3> dealing with a date like 200603111900
<2> more when dealing with dates like 2057-12-15
<3> so its okey to use bigint?
<2> and store it as a UNIXTIME?
<2> but what are you using it for anyways?
<3> inserting events from a calendar-interface
<2> DATETIME then
<3> but what did you mean with dates like 2057?
<2> limitation on 32 bit systems, a unixtime is stored as the number of seconds since the 1st of january 1970
<2> aka the UNIX Epoch
<2> it bugs out around 2054
<2> then again I'm using a 64bit system myself
<2> but you were actually talking of storing "200603111900" <- literally as a number?
<2> that would just be, uhm, well, stupid
<3> why?
<2> http://www.kfwebs.net/links/59
<2> read through some of the resources and come back and ask the question if you still wonder
<3> bad url.. http://www.frick-cpa.com/ss7/default.htm
<2> thank you, I'll flag it and check it tomorrow again, seem to be a networking issue
<3> ok
<2> the DNS reply doesn't contain an IP-adress
Return to
#mysql
or
Go to some related
logs:
#linux
#php
google desktpo
#squid
unbuntu wlanconfig
Epidermal cells, palisade cells, and veins are parts of a ________.?
#chatzone
#php
mass deop
#java
|
|