| |
| |
| |
|
Page: 1 2
Comments:
<0> in my case, our descriptions and extended descriptions are so inconsistent that i have to use % on both ends
<0> fortunately it's a small database
<1> yeah, but % itself is a multi-character wildcard
<1> so '%%' wouldn't make sense
<0> %angle%
<1> however '%a%' would
<1> exactly
<0> that's what i have to do
<2> and .. for the record
<0> it's sad that this erp system we use can't handle that
<2> 'bee%' is exponentially faster on a indexed field than '%bee%'
<2> becuase the % at the beginning forces a full field search
<1> grazzy: you're missing the fun here
<2> really?
<1> I got dugg
<2> cool
<1> kristianf@alpha ~/webs/kfwebs/logs $ cat access_log | awk '{print $1}' | sort | uniq | wc -l
<1> 6757
<0> when i get all this stuff straitened out the searches will be better
<1> unique IP-addresses past 3 hours
<2> my lvm broke :(
<1> ouch
<3> thank to all. bye .. .c`u
<3> whats is my better? english or mysql?
<3> ;)
<0> lol
<1> grazzy:
<1> pmsg..
<0> hey, no secrets!
<0> ;)
<1> not secret, just un-related to the scope of discussion of this channel
<1> related to the borked LVM
<0> ah
<4> Hi, I get this error when I try to run mysqld
<4> [root@thebenke mysql]# Starting mysqld daemon with databases from /var/lib/mysql
<4> STOPPING server from pid file /var/run/mysqld/mysqld.pid
<4> jre demain
<5> how do I copy a whole database, so I can have both open with different names
<6> lo chaps
<6> noob questions, i have a date field in my database and its using the 0000-00-00 format, but i need to use a 00-00-0000 format, can this be set in the database or will the database always use this format and i need to reformat it in my server side script?
<7> hello
<8> hello, I am trying to import a csv file into mysql by using the "Insert data from a textfile into table". I just have one column of data in my csv file, but when it uploads, it inserts as one single record. How can this be fixed?
<0> ^Skonk^, you will have to reformat the date in your script
<0> miSsGuRL, use lines terminated by ','
<8> it adds a row, with nothing in it
<0> give an example of one of your lines
<0> from the txt file
<8> its just a list of animals
<0> so just one word or name per line?
<8> yup
<0> but you have more than one column in your database right?
<8> in the database i have the ID and name- (name of animal)
<8> in the csv file, i have one column
<0> duh, i see my fubar now
<0> is the txt file from windows?
<0> or unix?
<8> would that matter?
<0> yes
<8> i'm working on a mac
<0> there is 'fields terminated by' and 'lines terminated by'
<0> i mixed that up earlier
<0> i don't know how a mac terminates lines
<8> but i do have those choices
<0> you could try 'lines terminated by '\n' or lines terminated by '\r\n'
<0> forget the fields terminated by since you only have one in the text file
<9> i went through something like this between win and linux
<0> http://tyson.homeunix.org/notes/mysql.html
<0> there is an example in there
<8> it says, "When exporting data from Excel, make sure there is a \N in all cells that don't have data."
<9> mac is freebsd right?
<9> i used a dos2unix command
<9> ... on linux
<0> depends on the mac
<9> i saw a mac once
<9> it was all shiny and pretty
<9> it had a glow to it
<0> as i recal, the \N is necessary to put null values into the other fields of the database
<0> otherwise the number of columns don't match up
<9> that sounds about right
<9> in pg, depending on how you inserted the data you used either \N or NULL
<9> but this isnt a pg channel NOW IS IT!?!?
<8> so the name field should be 'null' and 'not null'?
<0> miSsGuRL, use a pastebin and upload your table description, a few lines of the txt file and the command you are trying to use
<0> give me the link when you are done
<8> i've been following this tute: http://www.php-mysql-tutorial.com/mysql-tutorial/insert-data-mysql.php
<0> that's not much of a 'tute'
<0> http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
<0> that one is much better
<0> also there are good resources at kfwebs
<8> still not working
<8> gr
<0> did you put anything up on a pastebin?
<0> guess not
<10> http://www.pipelinecard.org/
<0> NeoFuture, let me know how that goes for you. i have to admit, i'm a little skeptical.
<11> Hi gang. I'm using a "select count(1) " with a "group by" clause to get a count of how many records exist in a table, grouped by a particular field. Is there a way to filter the output so that I only get the rows where count(1) is greater than 1?
<12> HAVING
<12> look in the manual under "select"
<11> Superb - thank you very much
<12> no problem
<13> morning al
<1> hi
<0> K_F, one or two people posted comments on digg about your 'get the facts' article ;D
<1> yeah, everything has slowed down but some are still reading it
<1> :)
<1> wonder if that is one of the 16 hosts that were *.microsoft.com
<0> heh
<0> it's funny the logic that some of those people used
<0> like the 'it's faster to go get my oil changed than to do it myself' one
<0> the guy that says he's been using ms for ever without a virus doesn't realize his boxes are probably spamming the hell out of people
<1> hehe
<1> I like the comments about my grammar.
<1> Would love to see them write anything in Norwegian.
<0> yes, i saw that
<0> fact is, you speak better english than most americans
<14> i can speak pretty good norwegian (or viking as i prefer to call it)
<14> "mmm de bork bork"
<15> swedish chief
<14> ;)
<0> heh
<15> i like the meat balls
<14> i bet you do
<0> K_F, i mentioned on my blog a book i'm reading. it's english but definately not modern english
<1> hehe, second
<0> has norwegian changed that much over the centuries
<1> you don't want to know
<0> ;)
<1> http://en.wikipedia.org/wiki/Norwegian_language
<1> old norse had 13 casuses or something
<1> http://en.wikipedia.org/wiki/Old_Norse_language
<0> interesting
<1> but in answer to your question, it has changed much more
<0> those are some very good wiki pages
<1> much of English as well is inspired by Norse
<0> cool
<1> including, but not only the word: "sheep"
<1> hmm, I have something about that somewhere
<1> http://www3.kfwebs.net/kristianf-Jul29-225028.pdf
<0> cool
<1> BIRTH
<1> - (ON burr ) [1016-1150]
<0> WINDOW
<0> - (ON vindauga literally .wind eye.) [1220-1250]
<0> heh
<1> norwegian word is "vindu"
<0> microsoft vindus
<1> hehe
<0> ;)
<1> enough wind in the security holes anyways
Return to
#mysql
or
Go to some related
logs:
amaa maldives
gsl esp properly saved
Do you spik Englich?
#java
#tanger undernet registration
xI-porn
#AllNiteCafe
#linux
#linux
u sexythin
|
|