#mysql - Sat 28 Apr 2007 between 00:01 and 01:21

NY Lost Funds



hypersonicI don't know if I have access to the mysql server settings ,it's a remote server. :\
Will backslashes still escape special characters, but just not be removed with that mode set, or will they not escape at all?
erflynnhi is there a way to drop a list of tables that start with a prefix?
instaif "EXPLAIN SELECT ..." returns select_type of "SIMPLE", a type of "ALL", and possible keys is blank ... does that mean the query won't use an index?
SnakeOhey, how is this done: http://digg.com/search?section=news&s=mysql
the result highlighting?
instait's nothing with MySQL
SnakeOso that's postprocessing the results
with php or something
instabasically $content = str_replace($_GET['s'], "<strong>" . $_GET['s'] . "</strong>", $content);
blobaughSnakeO: yup. just pulled s out
SnakeOsweet
thanks
Kenmani see the wiki lists MySQL by Paul DuBois as a good book, would it be good for someone with minimal mysql/sql knowledge?
SlynderdaleAlright, a mysql question for your smart folds. I simply want a second oppinion, from the look of this structure: http://75.83.72.61:8080/mysql.txt Is it possible to call the users.usersname, usermoney.balance and money.name by making a query where username = a persons name in the users.username field and money = the name of the money in money.name. My oppinion would have to be yes, how about yours?
Kenman*opinion
SlynderdaleThanks Kenman
So would this be possible to call the data from all three tables with the username from users and money name from money?
TheodredHey guys
03:02 < root__> I'm having a problem with mysq/phpMyAdmin
03:02 < root__> I'm trying to login as a user I created, phpbb, and a password I setup.
03:03 < root__> I know that I have not mis-typed the password, I know that (I've re-set it several times, in fact) but when I enter the info into the phpMyAdmin weblogin, it says "Failed Authentication"
03:03 < root__> Any thoughts?
actionthe_little_mouse pokes his little head in... sniffs.. umm whats in here...... wags tail....wiskers twitching .......
the_little_mousepokes his little head in... sniffs.. umm whats in here...... wags tail....wiskers twitching .......
TheodredWhoops...
Sorry for that one.
actionthe_little_mouse ..............scurries across.........................room..........................>>............. #php ............................................
the_little_mouse..............scurries across.........................room..........................>>............. #php ............................................
PHPdesignerhow do we join a un group for example, with a simple click..with php.
TheodredI'm having a problem with mysql (using phpMyAdmin) where I have created a user (phpbb) and a password I know, but cannot log in as that user.
I know that I have the password and user right, but it won't let me in...
I can log in fine as root to mod things, create users, etc, but I like to have non-prived users to do other tasks.
Any ideas why this is happening?
blobaughTheodred: have you tried it from the command line to make sure it works?
Theodred: did you give the user a db?
PHPdesigner: huh? explain
Theodredblobaugh: I'll just check if I can do it from the cl. One moe...
PHPdesignerblobaugh something like join this group, with orkut
SlynderdaleTheodred: Did you set up the neccesary permissions with the account and then linked the password to the account?
blobaugha mysql group?
Theodredblobaugh: Well.

Page: 2 9 16 23 

IrcArchive

NY Lost Funds