| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> Is mysql-administrator on amd64 screwed?
<1> show full processlist seems to do it!
<0> I compiled it for 64-bit, and it... doesnt work
<0> lol
<2> can anyone help me with my codes? i'm stuck ! http://hashmysql.org/paste/1919
<0> well, when i go to "user admin" it freezes
<2> pls?
<3> nucleux: whats the problem exactly?
<2> i wanna insert values into 2 tables
<3> nucleux: Dont put NULL between quotes
<3> nucleux: yes
<2> but it only insert into 1 table
<2> i'm using php with mysql
<3> because you are tryin gto put a string in an integer field
<3> write 'LAST_INSERT_ID' as last_insert_id() wthout quotes
<2> i tried that b4
<3> nucleux: ceck the log for errors
<3> *check
<2> could it be the "$querySQL" as it can only reads one "insert"
<3> i have no idea. this is a sql channel, not a php channel
<3> but $querySQL is just a variable, so you can store in it what you like
<2> no errors on log :(
<4> when I use an INSERT query, do I have to include all fields, or only the fields I want to insert data into?
<3> [Ex0r]: depends
<3> [Ex0r]: if yo write INSERT INTO blah SET field=value, field2=value, etc
<3> or if you use INSERT INTO BLAH (field1, field2) VALUE(value1, value2);
<3> you dont
<4> so if I use INSERT INTO I don't have to list ALL the columns, only the ones I want to insert data into ?
<3> [Ex0r]: y
<5> !m [Ex0r] insert syntax
<6> [Ex0r]: (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<2> ...
<2> how do i write 2 insert statements into one $querysql then?
<3> why dont you just do 1 query at a time?
<2> cause i need the user input in a form
<3> normally you would separate the two queries by a semicolon, but i suspect PHP does not allow that to preent sql injecton
<3> *prevent
<2> one table for the user_details and another for his transaction
<2> i see
<3> just put the two queries over 1 connection otherwise the last_insert thingy will fail
<2> sundevil, thanks but how do i do that??
<2> http://www.hashmysql.org/paste/viewentry.php?id=1919
<3> something like: $con=mysql_connect($dbhost,$dbuid,$dbp***);
<3> to make the connection
<3> then mysql_db_query($db,$q,$con);
<3> where $q is the query
<2> but mine is already in the case statement
<3> then the second statement again for the second query
<3> nucleux: your what is in the case statement?
<2> case "queryProcessContactAdd" :
<2> from index.php
<3> yes, and? then make two calls in that case
<2> when the user chose to add a contact, it will be the case
<2> but theres only one form
<7> i'm working on a table with a timestamp field. is there an SQL function that i can use in a WHERE clause to put, say '2005-05-05' into the correct format for use in comparing it to the timestamp field, for example: WHERE TIMESTAMP('2005-05-05') = timestamp_field_name
<3> DATE_FORMAT(tiemstampfield,'%Y-%m-%d etc')
<7> sundevil_: thanks very much
<3> nucleux: it seems you have some php programming problems.
<3> nucleux: this is a mysql channel
<3> dools: np
<3> dools: or do something like: WHERE 2005050500000=timestampfield, just add some hours minutes and seconds
<8> Hi all
<8> what is the fix for ...
<8> [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
<2> thnaks
<3> kokoko1: did an upgrade huh :)
<3> kokoko1: http://bugs.mysql.com/bug.php?id=6629
<9> | ALTER TABLE users CHANGE name name varchar(48) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; | gives "ERROR 1062 (23000): Duplicate entry '' for key 2" but | ALTER TABLE users CHANGE name name varchar(48) CHARACTER SET binary NOT NULL; | runs fine, ideas?
<10> Error: Column 'name' cannot be null
<10> that sux
<11> i have a few runaway queries during testing, i'd like to cancel them
<11> how would I cancel them?
<12> nothingmuch: kill #####
<12> Where ##### is the id of the query, of course :)
<13> mendel: and what if id is longer than five digits?
<12> Uh, type more than five digits
<13> how?
<14> back of your toenails
<15> !tell domas about data
<6> But I don't know a thing about that.
<15> !tell domas about data type
<6> But I don't know a thing about that.
<13> you left enough space just for five :(
<15> !man data types
<6> (Column Types) : http://dev.mysql.com/doc/mysql/en/Column_types.html
<15> Domas- that is only represental concern
<15> The real value of int is what it says in the manual
<13> what happens when you get more connections that fit in int?
<15> if you say int(3) it can fit int
<13> !tell us about domas
<6> But I don't know a thing about that.
<13> !tell us about dammit
<6> domas asked me to tell you this: dammit is a celebrity!
<13> woooooooo
<16> domas is a troll
<15> erm...
<15> What happened to the manual online
<15> http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html
<14> !tell us about trolls
<6> But I don't know a thing about that.
<13> gleam_: I am not.
<15> It looks grey
<13> I was really concerned about ##### <--- space here
<16> are too
<15> Anyone see the grey background?
<14> someone is playing around with css?
<15> i guess so
<14> I do, and it's horribly ugly with the white on the literal stuff
<15> Its harder to read
<16> wow
<14> it's probably not intentional/going to stay
<14> if it is... private style sheets :)
<15> if they wanted us to read the main keywords they should put a view keywords javascript feature button
<15> http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html
<14> background-color: #DEADBEEF;
<15> Seems intentional.....
<16> or someone overwrote the css file accidentally
<15> Look at how they represented the code area, which is better than before
<14> it's okay on the multiline bit
<14> but ****s on the inline stuff
<14> I guess there is some intentional background-color: white; on there
<13> looks perfectly normal for me
<14> leave it off and it would be fine...
<17> hi
<18> will query in insert work, like this:
<18> will query in insert work, like this: 21:27:40 [ bonez39 ] [ faber3 ] [ Johnny23|work] [ mhillyer ] [ robla ] [ will[werk] ]
<18> crap
<13> jan__: this is invalid syntax
<17> "package MySQL-server-4.1.16-1 is already installed" but I am unable to use "mysql -root" ...error "-bash: mysql: command not found"...help ??
<19> Hmm?
<13> jan__: you have to use proper 'value','value'
<18> domas: i meant: INSERT INTO eventtime VALUES("",SELECT ID FROM event ORDER BY ID DESC LIMIT 1, ..
<18> hmm
<18> ok
<13> jan__: hehe, INSERT INTO eventtime SELECT ... ;
<18> ?
<13> on the other hand, you're doing something wrong
<13> maybe you need LAST_INSERT_ID() ?
<18> domas: i'm trying to get an ID of a newly inserted query and use it in a new query
<18> ok, very usefull
<18> :)
<18> can it be used in queries done by PHP ?
<13> jan__: can you fit more than 5 digits here?: #####
<13> jan__: mysql_insert_id()
<18> ok
<18> great, thanks :)
<13> answer my question now
<18> more ? no :)
Return to
#mysql
or
Go to some related
logs:
sudo Exec format error
ubuntu xwindows packages install
icedata500 firmware
chillispot depends on libc6
equivalent debug.exe linux
iptables cmd-owner smp
kernal panic : Aiee, Killing Interrupt handler !
#gentoo
#kde
#sdl
|
|