| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> !m stephen_ sql statement syntax
<1> stephen_: (SQL Statement Syntax) : http://dev.mysql.com/doc/mysql/en/SQL_Syntax.html
<0> the links on that page, perhaps?
<2> Most all of the tutorials are ok for refreshing your memory. I'd probably run through several. For more details/complex SQL, you are free to ask here or in #sql.
<3> stephen_ you could always write you own database framwork... that way you would know how to use it!
<4> ah ha!
<4> Don't ask me why, but test@'%' wasn't working. I had to specify the host. It wouldn't work otherwise.
<5> mmm yeah, reinvent the wheel
<6> greets
<6> anyone run mysql on a dualcore server?
<3> leighm, whats the issue
<7> !tell me about memory usage
<1> But I don't know a thing about that.
<8> leighm: yes.
<6> is it good? like, does it depend more on kernel support?
<6> just wondering what hardware to setup this new mysql server on
<6> ive got serialATA and a dualcore CPU
<9> Can mysql's api be used asynchronously? Sort of like Windows' async sockets (calling a function when a query returns)
<10> no
<8> uru: threads...
<10> you can open multiple connections
<10> but a given connection is sychronous
<9> okay.
<9> Thanks. I guess I can simulate it.
<11> how do I set my root p***word initially
<11> or if I lose it.
<10> well those are two different question
<10> s.
<11> answer both if you can.
<10> run 'mysql_secure_installation' and it will secure your initial installation, including prompting you for a root p***word
<10> after that, do this
<10> !m dabaR resetting
<1> dabaR: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<11> Thank you.
<12> Any help with searching a mySQL database with one Letter, such as showing all last names (lname) that start with M?
<9> SELECT * FROM tablename WHERE lname LIKE 'M%'; or something like that?
<12> oh, didn't know you could use Like...
<13> i seem to be unable to find what key_writes and key_write_requests status variables really reflect. a number of web sites i've browsed say writes/write_requests should be less than 1 - on my server write_requests always equals writes... any pointers?
<9> there are a couple functions that can be made to do that too.
<9> Just read the docs~ =p
<12> You got a link, uru?
<9> dev.mysql.com/doc/
<14> What is the best way to find similar (except for the key) rows?
<15> is there a way to use a wildcard for an int in a where clause in mysql: "WHERE id = *" or something like that?
<12> Or you could just choose all. "SELECT * FROM tablename"
<11> pah
<11> People ask a lot of sql syntax questions here?
<12> thos9: Are you going to choose everyone who has an id?
<16> Is there any way to change your mysql user p***word without putting it on the screen in plaintext? both mysqladmin p***owrd and set p***word want the p***word in plaintext on the screen (and in your history)
<15> wizard, I want to fiirst look for a defined ID, if there are none, then I want to look for a defined category.
<12> wwalker, you could do a php page, p***word.php, that changes it without printing out the results.
<12> thos9: I've done this before.
<16> wizardx: true, but I do all my work via ssh, not web pages
<15> wizardx: i figured I'd do that by setting the id to a wildcard in my code, and then doing an AND of that and the category field
<9> id would be defined if it wasn't NULL right? =o
<15> or are there conditionals in mysql? I didn't think of that
<9> WHERE (logic for is defined) AND (logic for is in a category)
<15> I guess I could be less lazy and customize the db access code that is generated for me by Dreamweaver
<9> =o
<15> uru could you please be more specific? are you saying to use the key words "IS DEFINED" or what?
<12> thos9: "SELECT * FROM tablename WHERE id = $idlookingfor AND category = $desiredcategory"
<15> uru, the problem is, what if ID is NOT defined
<9> thos9, How do you determine how id is defined or not? Are you using NULL ?
<15> uru I could, it's up to me
<12> through if's, of course.
<15> wizardx: ifs in code or in mysql?
<12> code
<9> thos9, well if you use NULL, then go WHERE id != NULL AND ...
<15> oh, well, I was trying to avoid that
<9> Why avoid NULL?
<15> uru, but id ID is defined then I want to use that
<10> uru: != NULL doesn't work
<10> uru: nothing is equal to or not equal to NULL, because NULL is an absence of a value
<15> uru I was trying to avoid doing the if logic in my code
<9> right, right~
<10> "WHERE foo NOT NULL"
<9> anyway brb
<15> but I guess I will have to do that, stupid Dreamweaver
<11> uru: you can use != NULL?
<11> is not null would work, I think.
<11> != null means nothing, cause null != to anything, not even null
<9> my mistake
<13> ok... how about Handler_read_rnd_next , can someone here explain how to track down the "bad" queries?
<15> i want to do soemthing like this: http://hashmysql.org/paste/viewentry.php?id=1463
<15> duh, i can use LIKE on an int field
<17> thos9 why would you use like on an int?
<15> firewire: so i will always get SOMETHING, but if either of those vars are defined, I will get that: http://hashmysql.org/paste/viewentry.php?id=1465
<15> it's for a page where you can define one of two URL parameters, or define neither, but in any case, will get a result
<12> You could $_GET['variablwinurl'] for those, thos9.
<15> wizardx: what do you mean?
<12> www.thos9.com/index.php?a=hello for the fake address and then "$message = $_GET['a'];" and on another line "echo $message;"
<12> It would print out "hello"
<15> wizardx: ya, that's what I'm doing
<15> wizardx: did you see my code?
<12> cool, I used that to work with mysql queries.
<12> no, but I'm looking at it now
<12> looks good
<15> wizardx: thanks
<12> I'd set it to "8" is an else instead of setting it off the bat
<18> could I get some advice on my proposed DB layout? http://examancer.com/new%20database%20layout.txt
<18> What I want to know has to do with the Tags and TagMatches tables...
<18> I'm trying to add the ability for users to add keyword tags to records in the Folders, Feeds, and MetaLinks tables... what I'm not sure is if I should just duplicate the tag everytime I tag something, making a one-to-many relationship from records->Tags, or if I should do it the way I show in the proposed layout...
<18> where I have a many-to-many relationship between Tags and the records, and I use TagMatch to complete the relationship and match them together, so I don't duplicate tags
<18> it would seem I would possibly save space by using the matching table, but I'm also adding complexity, which I don't want to do unless there is a performance/scalability advantage
<19> i've got mysql installed, i can connect locally and using PHPmyAdmin but i can't connect from another host
<19> i've got % for host
<19> and reloaded the privs
<10> do you get an error?
<19> 2003
<19> also....
<19> can't connect to mysql server on 192.168.0.3 (10061)
<19> .........
<10> can you paste the WHOLE error?
<10> never chop an error into bits and pieces
<20> umm, pastebin please ?
<19> thats all i get
<19> its on query browser
<10> then I can't help you
<10> are you sure you're using the right p***word?
<20> wait, that's a windows 10061 error code
<20> hang on
<20> http://support.ipswitch.com/kb/WSK-19980709-EM01.htm
<20> Windows Sockets Error
<10> ok, so your MySQL server isn't listening on TCP
<10> check your my.cnf for 'bind-address' or 'skip-networking'
<20> either that or the port is blocked in firewall
<20> or the server is not actually running at all
<20> (hence, not recieving connections on the MySQL port
<19> how can i check its running?
<10> do what I just said
<10> if you can connect to MySQL via phpMyAdmin, the server is running
<20> Andy298: is the MySQL server on localhost ?
<20> if it is, then from the console to ps -A
<20> and see if mysqld is listed
<20> oh wait, he's on a windows machine
<19> im not im on debian
<10> yes
<10> ok
<10> then do what I just said
<10> and restart the server
<10> and it will fix it
<20> you got a windows 10061 sockets error on Debian ?
<10> Sneaky_Bastard: there's a difference between client and server
<10> ffs
<20> I wonder if the error code is the same in normal BSD sockets
<3> ah connection problems.
<3> ha
<3> i have a favor to ask of group
<3> anyone want to take the time to show me how to setup good database tables to accomodate family tree?
<10> not I
<19> the server is debian, im on doze
Return to
#mysql
or
Go to some related
logs:
suse 10 remote desktop connection
ircdriven
zv5330 ati ubuntu
mathematica diagonalizable test
#perl
xserver-xorg won't detect nvidia
ubuntu-fglrx-$arch
atyfb and Xorg -sparc
growisofs unable to anonymously mmap Resource temporarily unavailable
ipw2000bg
|
|