| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> TodoInTX: (Locking Reads SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE) : http://dev.mysql.com/doc/mysql/en/InnoDB_locking_reads.html
<1> err
<2> hehe
<3> frank-, how do you mean enumerate all the fields ?
<1> select field1, field2, field3, ... field10 from ...
<3> oh ok
<1> where field10 is the last field
<4> anyone have a solution for "Fatal error: Call to undefined function mysql_connect() in /home....."
<1> recompile php with mysql support
<4> tried that
<4> phpmyadmin works fine
<2> MstrJeff: if the mysql support was compiled with the 'shared' flag you need to make sure the .so is being loaded into php.
<2> method for doing this varry from distro to distro.
<2> could be a line in php.ini or on if it's includes.
<2> MstrJeff: you can also verify that the support is there with a phpinfo(); page.
<1> this should be in #php
<4> I'll check that out, thnaks y'all
<1> I hate wrack
<5> how can i get the dog information (name, breed, kennel address, owner) if i have the table dog(dogid, name, ownerid, kennelname, breedname) and owner(ownerid,name,phone) and kennel(kennelname,address)
<2> bladhasd: you should use a kennelid in the dog and kennel tables and do a join where the two match.
<5> select d.name, d.breedname, d.kennelname, o.name, k.address f\
<5> rom dog d, owner o, kennel k where d.ownerid = o.ownerid and o.name = 'Susan Brand' \
<5> and d.kennelname = k.kennelname
<5> i did this but it gave me multiple rows
<5> but i only want it to return 1 row
<1> limit 1
<5> no like the result should only return 1 row
<5> cause each dog is unique
<1> group by then
<5> i htink the query logic is wrong.
<1> probably
<5> how would you write that query
<1> it depends on the table defsa
<1> and the index fields
<1> make sure all the table have foreign indexes
<5> http://javanub.net/pastebin/app/view/435
<1> whats that
<5> kennelname, breedname ownerid are references to the owner,kennel tables
<5> the table def
<1> select * from table1 inner join table2 on table1.index = table2.index where...
<1> just use that logic
<5> can you show me the complete query frank
<1> I just did
<1> select * from table1 inner join table2 on table1.index = table2.index2 inner join table3 on table2.index3 = table3.index where ...
<1> for a 3 way join
<1> !m bladhasd inner join
<0> bladhasd: (JOIN Syntax) : http://dev.mysql.com/doc/mysql/en/JOIN.html
<6> how can i change a procedure's character set? when i use a procedure it does not care my database character set and insert wrong data
<1> someone ****in kick wrack
<6> any one has a guess?
<7> Anyone know the proper way to ORDER BY a 10 digit Unix Timestamp in a SQL statement? ORDER BY creation_timestamp DESC doesn't seem to be pulling the stuff from this year...
<7> Never mind!
<7> it works
<8> How would I setup a database to allow me to put in a url, a path to a thumbnail, and an id number?
<8> From there I would then use PHP to retrieve that and display the link with the thumbnail...How would I do all of this?
<8> Any guides online specifically addressing this?
<9> hi
<9> how can i fetch rows which created_at is today?
<8> No idea. :/
<10> any docs for reset root p*** for mysql?
<9> i mean, i know i can do BETWEEN, and create date with a script
<9> but thought that mysql has sth
<8> Ermm?
<8> Help?
<9> heh
<9> ;]
<6> when i use a procedure it does not care my database character set (utf8) and insert wrong data. does any one guess why?
<8> How would I set up a database that has 3 columns, id, path to thumbnail, and url, so that I can then use PHP to retrieve those and then display the thumnail linked to the url?
<11> !tell root404 about tutorials
<0> Alrighty.
<12> When you request data from a MySQL table, it seems to return the entries in the other that they were inserted. How can I get it to return the newest entries first?
<11> it will return them in no particular order
<11> sometimes you will get them in insertion order, sometimes not
<12> Ah.
<11> you have to use ORDER BY if you want some particular order... so if you want to have them ordered in descending insertion order, you really need to have a column that contains a timestamp
<12> Thought so, although I was hoping there was an easier way to do it. Thanks.
<11> what could be easier than that :)
<12> I mean, a built in way to do it :P
<11> anything else would incur a phenomenal waste of storage space for situations where it's not necessary to store a date
<6> stored functions and procedures ignore my database's character set! does any one know why?
<11> mustafa: do you have an example? what you're saying so far doesn't make much sense
<12> True
<6> i setted my databases character set utf-8
<6> so when i use an insert statement with turkish characters, it is ok. i see turkish character in table
<6> but when i use the same insert statement in a simple stored function or procedure, characters become ?
<6> i mean turkish characters
<6> that is the story :)
<13> is it possible for mysql to take p***word from while instead of from --p***word=... like .pgp*** does?
<14> from while?
<13> while?
<14> <13> is it possible for mysql to take p***word from while instead of from --p***word=... like .pgp*** does?
<2> crashev: you mean from a "file"
<2> the .my.cnf
<2> ?
<2> crashev: create a [client] block in the ~/.my.cnf with user= and p***word= lines
<14> TodoInTX: you are better at deciphering imbecile than me ;)
<2> infi: I think the .pgp*** part gave it away.
<13> TodoInTX: yes that's what i was looking for,thx
<2> heheh!
<14> congrats :) next stop: UN translator
<2> ;)
<13> infi: ah didnt even notice that I wrote while instead of file, Im just tired :)
<2> !tell me about table corruption
<0> But I don't know a thing about that.
<2> jeesh SQL is worthless for me today...
<2> !m crash recovery
<0> crash: (Forcing Recovery) : http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
<2> !m table maintence
<0> table: Nothing found
<2> no nothing.... are you sure....
<2> not even this... http://dev.mysql.com/doc/refman/5.0/en/table-maintenance.html
<11> maybe if you could spell maintenance!
<11> good lord
<11> "maintence"??
<2> I just have someone asking me "why did my table get corrupt?"
<15> guys ?
<15> running a mysql 4.1.18 on win32
<15> my command "create user joey identified by pwd;
<14> stop making up syntax
<16> Fishq: CREATE USER is for 5.0+ only.
<14> !m fishq grant
<0> fishq: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<15> Xgc, infi, SQL: thanks .. no wonder I was confused, tried v5.x earlier ..
<16> Fishq: You're welcome.
<2> Xgc: is there a fundimental difference between GRANT USAGE... and CREATE USER ?
<2> it doesn't appear so... so looks like it's just there for compatibility sake
<16> TodoInTX: GRANT is more general.
<2> ah... but DROP USER is new and exciting ;)
<2> so if you have DROP you might as well add CREATE...
<16> The main push was probably for clarity. GRANT isn't the first thing you think of when trying to create users.
<2> yea.
<11> no, it's for compatibility
<11> some DBMSs don't automatically create users when you start granting privileges
<17> This is more of a logic question. I am setting up autoresponders from mysql DB with field HoursAfterSubmit. I can ORDER BY HoursAfterSubmit ASC, and then for each member (make sure it wasn't the last processed one) and do whatever, then it will run sequentially through them. My problem is, what if someone adds a new one, which has a less HoursAfterSubmit... then it will run through them all again?
<11> so there is a separate mechanism for creating a user explicitly
<11> there is an SQL mode for no_auto_create_user or something like that if you'd like to activate that behavior
<18> hello people
<16> That's true too. It is a little odd to automatically create users.
<19> There's a table I can't drop. I get error 1217 (the one about the foreign key). I checked the key_column_usage table and it obviously is not referenced by any other table.
<20> I have a query like "select a, sum(b) from t1 group by a", now I want to get the row with the max(sum(b)) from the result, how can I write the query?
<21> cookoo, desc and limit
<20> syf, thx, I will try
<22> Trying to so something with mysql that should be real easy and is driving me crazy.
<22> Installed MySQL via yum originally. Haven't configured anything other than setting a root p***word. The hostname on the server needed to change and I'd like to change the 'host' field for 'root' in the mysql users table since it is still showing the old one.
<14> !m astryk update
<0> astryk: (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
Return to
#mysql
or
Go to some related
logs:
grub Hyperthreading disable
VobSub totem
ubuntu canon IP 1600
could not find working GL library ubuntu
+java 1.5 +rpm +sles10
#ubuntu
key ID 025e513b
gentoo debug symbols
#mysql
bind random ns list returned
|
|