| |
| |
| |
|
Comments:
<0> any 'easy' way to add 2 to ever numer in a col?
<1> are you kidding?
<2> hopefully
<2> Eldritch: http://www.kfwebs.net/links/6 for SQL
<0> nope im just dumb
<0> so php loop it is
<2> ?
<2> wtf is wrong with UPDATE table SET field = field + 2; ?
<0> i can write a php loop faster than it takes me to find that thats wtf is wrong with it, i new it wasent the best solution, but it was the quickeist, since you lot where no help :P
<2> huh?
<0> bah
<3> Im trying to use mysqlimport to import a csv (comma delimited) file that has commas in the data. example row, HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Run,iTunesHelper,enabled,"iTunesHelper Module","Apple Computer, Inc.","c:\program files\itunes\ituneshelper.exe"
<3> this is a csv file created by autorunsc (sysinternals), Im having issues because only certain fields have "" around the data. Is their a mysqlimport option that Im missing?
<3> I can use fields-enclosed-by but then it requires all fields have the "" around the data. Im hoping for an option that only uses the "" to determine the fields if the "" exist (next to the commas) otherwise just use the commas to indicate a field change
<0> replace , with # then repalce #" with " then # with ,
<0> of course dont use # it its in your data
<3> hrm, intresting approach. I'll run down that alley a sec, sounds like it would actually work :)
<4> hi.
<4> Why does the "rows" column under 'SHOW TABLE STATUS' show a different value than my 'SELECT COUNT(*) FROM table'?
<4> Just 'cause, right?
<4> I mean why not display erroneous data.
<3> hrm. I think we are close, but all teh diff interations ive tried end up being not right ;) here is the output from following your suggestion exactly. HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Run,iTunesHelper,enabled"iTunesHelper Module""Apple Computer, Inc.""c:\program files\itunes\ituneshelper.exe"
<3> I did get it very close "" around all fields and commas etc. but it actually created a field for " inc." instead of leaving it with Apple Computer ;)
<3> is their a howto I should be reading or is this common sence stuff (and Im just dense) ;)
<3> the point of this is to automate it as I potentially need to do this import multiple times per day
<0> its the origonal outputting script not createinga proper csv then
<3> k, rough. Excel (unfortunately) deals with the formatting issues and thus the author has the opinion that it isnt broken ;( sysinternals autoruns
<3> maybe if I beg :)
<3> Ignoring the ,Inc issue for a second (I figure I can use sed to change ,Inc to Inc temporarily)... Im getting 6 warnings when importing my csv file using mysqlimport. how to I tell mysqlimport to tell me what the warnings were ;) comparing the data from the table with the csv file doesnt seem fun ;(
<3> using --verbose doesnt seem to do it... (the logical switch to try 1st)
<5> Does anyone know how to do a double order by? That is, first order by one field, and then order by another within that ordering?
<6> hello
<6> i always insert 5 char into column, which type must i use, text or varchar ?
<7> hey
<7> K_F-?
<7> have time to talk?
<6> i dont understand yes.
<6> huh
<6> without i dont understand, yes
<7> i upgrade my mysql from 3.x to 4.1.6 .... i use windows, how migrate my data? i only have the old directory: c:\mysql\data and the new mysql data dir: c:\Program Files\MySQL\MySQL Server 4.1\data
<6> move them
<7> only move the datadir?
<7> what about... isam and mysqm ?
<7> what about... isam and mysam ?
<6> move mysql\data\*.* to progra~1\my.....\data\
<6> mysql.com/isam mysql.com/myisam
<7> ok
<7> thanks
<6> you are welcome
<7> DotcomBRz have time to talk?
<6> about ?
<7> related mysql general dudes...
<6> topic is just ask ;)
<7> ok, i want not bother... but i ask..
<7> how create a trigger?
<7> can you give me a sample?
<6> have you tried to look mysql.com/trigger ?
<7> not
<6> but i can give you a sample ; CREATE TRIGGER test FOR test.test AFTER UPDATE EXECUTE
<6> (TRY
<6> IF NEW.hno <> OLD.hno
<6> THEN UPDATE test.first SET hno = :NEW.hno WHERE hno = :OLD.hno;
<6> CATCH
<6> IF $rc <> 100
<6> THEN STOP ($rc, 'unexpected error');)
<6> but pasting is wrong, we know ok ?
<7> please
<7> use: http://rafb.net/paste
<7> DotcomBRz?
<6> this is a sample jak2000.
<7> what is NEW?
<7> the databasename?
<6> did you looked mysql.com/trigger ?
<7> ok thanks
<7> DotcomBRz wich language programming do you use?
<6> sorry ?
<6> with mysql ?
<7> yes
<7> same as delphi
<7> and visual basic, php or java
<7> ?
<6> i am using php now. why ?
<7> ok
<7> a trigger is same in php a function right?
<6> maybe,you can use some commands in trigger function
<6> i am not good at that,look to mysql.com/create-trigger please.
<7> ok
<7> hey
<7> K_F
<7> _
<2> hi
<2> probably just the gf closing the wrong wondow..
<7> how many years have you_
<7> 29?
<2> huh?
<2> I'm 20
<7> more or less?
<7> really??
<7> ouch i am 32
<2> 21 in august
<7> good
<7> and your gf?
<7> 19?
<2> 21 in september
<8> salut
<9> If I have in a table a MEDIUMINT field called "points" and a row has the points value "x". Can I make that row have the value "x+123" without selecting and upgrading the table?
<10> Greetings,
<10> i'm working on a database and i would like to ask you about the types i'm gonna use if you don't mind.I need to verify this so i won't have future problems w/ it.
<10> I have a collection of LPs and the name of the database is Disc library, if i want to include name of song, name of singer, duration, size, type ( mp3/LP ), album title and year
<10> i'm gonna do varchar, varchar, int , int , varchar, varchar, int ?
<11> anyone familiar with perl ? Im having trouble checking a field if it's NULL or not, anyone know the correct syntax?
<12> ugg, seems there is no good way to list the enums in a enum column.
<13> hey, how do i select something on a foreign table only if the foreign key to that table is set?
<14> Can i set a constraint on a text field to forbid empty strings or whitespace only strings?
<15> textfield in mysql or <input type=text ?
<0> not null
<14> text field in mysql
<14> this is #mysql, right?
<14> not null doesn't seem to suffice
<16> hey guys. I'm tryin to combine records from similar tables that are located on different databases. Is JOIN the best way to do this??
<15> hm.
<2> damn I hate network diagnostics
Return to
#mysql
or
Go to some related
logs:
buq
#london
#MissKitten
modprobe: Can't locate module drbd
#linux
#linux
#chatzone
ERROR: The DSP Fileinfo.dsp does not exist.
triskaphobia
#MissKitten
|
|