Re: [Fwd: search issue] mysqlimport problem with , inside fields

Scott Hamm wrote: > > Line 48: > > "48", "14.729606", "10.1.1.22", "10.182.167.209", "TCP", "pop3 > > [SYN, > ACK] Seq=0 Ack=1 Win=16384 Len=0 MSS=1460" > Is the line 48 is different than other lines? -- View this message in context: http://www.nabble.com/mysqlimport-problem-with-%2C-

RE: Year - Field type

Why not keep the date of birth as a standard date field and extract the fields you need using the DATE_FORMAT function? eg. DATE_FORMAT(date_of_birth, '%Y') mysql> \u test Database changed mysql> create table test_dates (a int, mydate date); Query OK, 0 rows affected (0.29 sec) mysql> describe t

RE: Year - Field type

Mickalo I gave that a go now I have another issue I can only enter years 1900 onwards so when I enter 1887 it changes the value to 0 John B -Original Message- From: Mike Blezien [mailto:[EMAIL PROTECTED] Sent: 19 February 2007 23:10 To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject

row count inconsistency

Hi, I've got a very large table set up and have defined the id as auto_increment. No rows have been added, deleted, or replaced since the initial load so I'd expect the row count to equal the max(id) since mysql> describe fidcid; ++---+--+-+-+-

Re: Year - Field type

have you try using the datatype YEAR for you table field/column ? Mickalo - Original Message - From: "John Berman" <[EMAIL PROTECTED]> To: Sent: Monday, February 19, 2007 11:45 AM Subject: Year - Field type Hi Using mysql4 Sure this is an easy one a field in my dbase is year of b

Year - Field type

Hi Using mysql4 Sure this is an easy one a field in my dbase is year of birth, its always a 4 digit number, for some reason Im failing to sort by the field in my results, it was originally a varchar field so I updated it to int but still no luck. Pointers appreciated. Regards John Berman --

Year - Field type

Hi Using mysql4 Sure this is an easy one a field in my dbase is year of birth, its always a 4 digit number, for some reason Im failing to sort by the field in my results, it was originally a varchar field so I updated it to int but still no luck. Pointers appreciated. Regards Joh

RE: SQL_CALC_FOUND_ROWS using ODBC driver

Why not just SELECT COUNT(*) FROM MyTableName; and the result will be in rs.Fields(0).Value? John Bonnett -Original Message- From: Nuno Oliveira [mailto:[EMAIL PROTECTED] Sent: Thursday, 15 February 2007 11:34 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: SQL_CALC_FOUND_RO

Re: SELECT single row from 2 tables with WHERE clause

It sounds to me like you're needing to use a left outer join on t2. Give that a shot instead of the inner join you're currently using. Cheers, -bemansell On 2/17/07, Kerry Frater <[EMAIL PROTECTED]> wrote: I am trying to select a particular row from a table and include a column for aq second ta

Re: No Data on table

On 2007-02-19 Nhadie Ramos wrote: > Hi Christian, > > Thanks for the reply. I got the table repaired and deleted some data on it. > What combination can i use to overcome the 4GB limit? Read http://www.suse.de/~aj/linux_lfs.html and google a bit. Basically any recent Kernel 2.4 or 2.6 should do

Re: Update multiple tables strange behaviour

2007/2/15, Manuel Vacelet <[EMAIL PROTECTED]>: Hi all, I'm facing a strange behaviour with an UPDATE statement. I have a table like: +-+--+ | item_id | rank | +-+--+ |2812 |2 | | 13050 |4 | | 13051 |3 | | 13052 |1 | +-+--+ And I wan

Re: sum with update

Hi, Yes it is possible to use sum with Update, subject to the constraint -table to be updated must not present in the FROM clause of the select stmt. But in your query, the table to be updated is present in the FROM clause. Hence update doesn't support that and have to go for some procedures..