| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> You need like three words to make your second query do what you want.. heh.
<1> really ?
<1> i've been trying for days
<0> Someone want to give him the answer? Or do we make him beg?
<1> can i show you what i've done so far
<0> Sure
<2> I dont suppose a Distinct would be in order?
<0> Not from what I see/think.
<0> Maybe not three words...
<1> will: can i show you my join that works...but in different columns
<1> and then you tell me how to get em into one
<0> Sure
<3> does 'default NULL' work on fields with datatype varchar(2550?
<4> why would it not eleftherios ?
<3> andrewbryson, just making sure because on 'describe table' it does not show it
<4> well the default is null if you do not specify another default...
<3> andrewbryson, while a 'default 0' I have specified in a different field shows
<4> 0 is not the same thing as null
<3> hm, well, on a describe on a another table it shows explicitly
<4> null is the default default as it were :P
<3> andrewbryson, I understand that but I got puzzled because I saw an explicit 'NULL' under the default column in a description of another table...
<5> a string containing column type, if defined as "not null" will have the default of an empty string
<3> I just want it to have the string value 'NULL', therefore shall I specify it as 'default 'NULL''?
<4> well if it is defined as "not null" it could hardly have a default of null :P
<5> i don't see why that wouldn't work. im fairly positive that if you don't specify the default and you don't declare it as "not null", then it should default to null
<4> yup it does
<3> andrewbryson, I don't want it to be 'not null'
<4> yes i know you don't
<3> the field may be left empty
<2> Null != '' (empty quotes). do not confuse the two
<3> so if I define a field with the type varchar(255) without specifying anything else, if an insert statement leaves it empty it will default to 'NULL'? Correct?
<4> more than likely
<4> why not just try it and see ?
<2> nope, it will default to '' :)
<5> if an insert statement does not have that field listed in the set ... section
<4> i mean it would have taken all of 30 seconds to experiment and find out :P
<5> if you set field = "", it will be a blank string
<3> andrewbryson, sure but here I learn other things on the side as well
<3> :-)
<3> thank you guys
<6> mornin
<5> oops.. forgot to go to bed
<7> careless :-)
<4> well plenty of time for that when you're dead :P
<5> thx for reminding me.. good morning.. and good night!
<5> which will be tomorrow morning when im late for work
<5> heh
<5> err.. this morning.. doh
<4> lol nite seymour1
<3> have a good rest seymour1
<8> if i set a field in a table to Not Null, then run an insert query. To insert a series of values to that table. And leave the field which was not Null as a blank insert value. Could that cause the page to blank out?
<3> hm, I think it is somehting about MySQL 5, that's why it doesn't explicitly show 'NULL' on the default values column
<8> ?
<9> seymour1, there's a street in Vancouver called Seymour
<0> There is a BMW called the M3
<9> seymour1, my previous office was on the corner of Seymour Street
<9> lol
<8> lol
<9> will r u joking with me again
<8> can someone help me debug what i've done wrong
<0> No I am not joking.
<9> wow
<0> You should go to sleep.
<0> akumanz, Depends. How about just pasting?
<9> me?
<0> Oh you did.
<0> M3, Yes you.
<9> heh :)
<9> There's a Smith called Will
<0> akumanz, PHP?
<0> That's me.
<8> yeah
<8> 2_artistx
<8> 2_albumx empty
<8> 3_artistx 83
<8> sorry
<8> thast the debug output i got for testing purposes - http://pastebin.com/643700
<10> I have the following query: INSERT INTO rhymes( idx, rhymes ) VALUES ( '#?2,M+?*.+:', 'COMPLEMENTED COMPLIMENTED') and I get this error: #1062 - Duplicate entry '#?2,M+?*.+' for key 1 Notice that they key does not have a ":" character as the last character.. what is wrong?
<9> and I bet Will Smith doesn't drive an M#
<9> err, M3
<0> I drive an M5
<9> will smith drives a Z8
<0> That's what you think.
<9> ah, huh
<9> but don't worr will
<9> u r close
<9> they share the same drivetrain and chasis
<0> zanzina, Column type for idx?
<10> oh
<10> yea
<10> too short
<0> M3, Yeah I know but I don't like the Z8
<9> why not?
<0> If I wanted a convertible, I'd get an H1 :P
<9> cause it's not quite as heavy as the M5?
<0> Na, just looks
<9> H1?
<0> www.hummer.com
<9> come on mr. smith, it looks way better than the new 6
<9> ah, no, not the Hummer
<0> Aww he left.
<9> will is tasteless
<0> I will conform you. Or break you.
<0> What do you think about frilly toothpicks?
<9> how does will change to red font?
<0> Because I'm cool
<9> but M3 loves Mr. Smith even more
<9> does will really drive the lovely M5?
<0> Do you know Mitch Hedberg?
<0> And have you seen the movie Fight Club?
<9> sorry, no
<0> It's your job to find out who he is...
<9> again, no, but i've heard of it
<9> yessir
<0> And watch that movie sometime this weekend.
<9> for sure
<0> No, I drive a Silverado.
<9> i'm on vacation here in Vancouver
<9> OMG, that's what i drive too
<0> Great. These will compliment your vacation.
<0> uh oh
<0> About Mitch, also listen to #2
<0> (riddle!)
<9> i drive a white 1500 with the 4.7 engine
<0> hah
<0> Grey 1500 with 5.3 Z71 :P
<9> wow
<0> 4.7 or 4.8?
<9> i love the new vortec v8
<0> yah
<9> not sure, myself
<0> I have to get back to work..... grr...
<0> I thought 4.8. Could be wrong.
<9> u might be right will, (4.8L)
<0> Ever go to www.gm-trucks.com ?
<10> is it possible to have a char(10) columns set as primary ID differentiate between capital letters? (for PK)
<0> Yes
<10> how
<0> Set it to be BINARY
<0> In the col def
<10> thanks
<0> !m zanzina create table
<11> zanzina: (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
<9> set it to BIMMER zanzina
<10> BIMMER?
Return to
#mysql
or
Go to some related
logs:
splash=verbose vga=
#python
Ubuntu Error opening/initializing selected video_out(-vo)
is display set properly
#math
#math
lib6c deb
ksmoothdocker
#perl
#perl
|
|