| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> it's totally redundant, and only overcomplicates the queries unnecessarily.
<1> i agree with you
<1> is just that i wanted to follow the example on that site
<0> then again, I don't expect much more from a PHP programming site's tutorial ;)
<2> My other client bugged, so i don't know if i ever got an asnwer or if, indeed, my question was asked. I understand that bit() is limited to 64. Is there a way to extend this, even as far as 2048 bits?
<1> and just because of that i start to notice a lot of problems, one was my initial question. how to know if a user exist on both the users table or on the signupt table
<0> twotontony: you can probably use a couple of BIGINTS and bitwise shifting, but I am not sure if the >> and << operators are in there.. hold
<3> :)
<0> twotontony: yes, it has the << and >> operators. but it appears you are right, the bit type only allows a max size of 64.
<0> twotontony: why do you want 2048 bits, anyway?
<4> hello how can i login to mysql
<4> the command
<0> sharmaa: I already answered you. mysql -u USER -h HOST -p DBNAME
<4> the db is located on storo login is db3***2 and p***word is 9335
<4> i dont know what HOST is
<0> the hostname of the database server.
<0> and don't post your freaking credentials on IRC.
<5> in my case HOST is localhost since mysql is on the same server
<2> infi that's for your help. It's going to hold lots and lots and lots of switches. I figured I could do it with many fields, but i'm lazy. Thanks for your help
<0> twotontony: a bit is actually a tinyint(1), so you're not saving any space, FYI.
<0> though it might compress them in a bit(64). dunno, never used the datatype before.
<4> so what would i write
<4> the whole syntax i mean
<3> muhahahahahaha!
<0> twotontony: since you appear to be on MySQL5, you might create a few of them, and just use a stored procedure to pull the correct bit out, and return true or false if it is set or cleared.
<4> hello can someone show me the syntax please
<4> with the stuff i sent u
<6> What kind of Index would be good to use, when the query is going to use a WHERE clause for "address" and "domain", where address is full email addresses, which will also have the domain in them, and domain is redunantly repeated in the database?
<2> infi: well, a bigint is a 64bit value as well, i was just thinking that by specifing bit length i could get a larger value than 64bit
<0> redundantly repeated multiple times, repetitively?
<6> Oh yeah, and address is the PRIMARY already.
<0> twotontony: sez you can't do that in the dox.
<2> yup, just checking... ok, thanks
<4> helloooo
<4> mysql -u USER -h HOST -p DBNAME
<4> do i have to say -h HOST
<4> it is local host
<4> what would i say
<0> all of the arguments are optional.
<4> bo709-9-05{sharmaa}7: mysql -u storo -p db3***2
<4> Enter p***word:
<4> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
<4> i tried this infi
<4> it still doesnt work
<0> you totally and completely missed the point.
<0> !m sharmaa tutorial
<7> sharmaa: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<4> hello can somebody please show me the correct way to login
<4> i tried
<4> mysql -u storo -p db3***2
<4> the db is located on storo
<4> and login is db3***2
<8> I guess: mysql -h storo -udb3***2 -p
<9> using mysql 3.23, is there a way I can subtract a query from another one? both queries use inner joins from the same table... ie:
<9> explain select * from subscribers_data t1 inner join subscribers_data t2 using (subscriber_id) inner join subscribers_data t3 using (subscriber_id) WHERE (t1.demographic_id = 3 AND t1.value = 'Virginia') AND (t2.demographic_id=2 AND t2.value <> 'Charlottesville') AND (t3.demographic_id = 10);
<9> however.. if I change t3.demographic_id <> 10 ... it is not nearly as fast and adds a whole lot of more rows
<9> so what I want to do is have all my includes in one query... then subtract any matching subscriber.id's from a 2nd table
<9> *2nd table/2nd query
<4> CAN SOMEBODY PLEASE TELL ME HOW TO LOGING
<4> into mysql
<10> Good Night (For real this time) <3 You all. Spread the love through out the world please.
<4> i tried mysql -u username -h host
<4> it doesnt work
<9> mysql -u <user> -p (use p***word) <database>
<4> The database is located on storo, the login is blah and the p***word is blah
<4> how would i do that bricecube
<11> sharmaa: If someone says x=1, y=2 what is x+y, can you do that?
<11> If so, then I think bricecube answered your question.
<0> as did 15 other people all day long.
<4> well somehow i cant get a correct answer
<4> of how to login
<4> otherwise it wouldnt give me an error message
<0> hire a consultant.
<4> bo709-9-05{sharmaa}8: mysql -u storo -p db3***2
<4> Enter p***word:
<4> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
<12> sharmaa: either the client is looking in the wrong place for the socket, or the server's not running
<4> hm
<4> could you give me the syntax again darien
<4> what you think the way to do it
<4> ill try it gain
<4> the login is db3*** and the database is called db3***2
<4> and p***word is "..."
<11> I always wondered how SQL worked.. guess sometimes people just get lucky eh? ^
<11> SQL injection*
<13> bricecube: MINUS -or- LEFT JOIN ... WHERE t2.id IS NULL
<13> bricecube: MINUS may not be supported yet.
<4> hello could someone show me the correct syntax to login into mysql
<4> mysql -u storo -p db3***2
<4> this does not work
<13> sharmaa: Your description is incomplete.
<14> Hi, does anyone have any recomendations on design tools for MySQL, such as microOlap. Right now, I've just been using vi .....
<9> Xgc, not yet ;(
<9> 3.23
<13> bricecube: You're out of luck. Just use temp tables.
<9> XGC -> http://hashmysql.org/paste/viewentry.php?id=1488
<13> I can't help you with 3.x.
<9> Xgc, do you think the left join is applicable here?
<9> Xgc, or is this a subquery only thing ?
<13> bricecube: Right.
<13> bricecube: The LEFT JOIN still applies, but you'll need to use temp tables in the JOIN.
<13> one or more.
<9> Xgc, ahh this thing keeps getting more complex! :)
<9> Xgc, I tried AND NOT's but there's some problems that go along w/ that ..
<15> A deveoper of mine is having problems, An error occured while trying to login to your MySQL database: 'Access denied for user: 'carlos@plain.ev1servers.net' (Using p***word: YES)' -- what is causing this? I did a grant all on * to carlos
<4> does anyone know how to use wildcards
<4> select name from dog where name = 'c%'
<4> ?
<16> sharmaa google for "regexp" (I would answer it right away if I knew the answer. Google for it would be just what I'd do now. )
<16> Ah, right. I guess youre talking about these wildcard-thingies in mysql - yes, they are % if I remember it right.
<4> hm
<4> i have a question for you yawgrooth
<4> how can i like if i press a button that it stores the value i inputed
<4> and so tht i can use it later on for an sql query
<16> So, if I have acceleration_pillar1, acceleration_square42 and acceleration_steeringwheel85 in my database and I query for acceleration% I would get all of the three for a result.
<4> http://pastebin.com/571415
<4> yawgrroth
<4> how could i make so that it actually keeps track of the value i input
<4> in the echo <input type = radio> part
<0> I can't stand it anymore!
<16> Sorry, I am not very good with MySQL yet.
<0> INSERT INTO ignore (chan, nick) VALUES ('#mysql','sharmaa');
<17> drop table infi;
<17> err
<17> database
<17> hha
<9> infi, is this plausible to implement in MySQL 3.23 ? -> http://hashmysql.org/paste/viewentry.php?id=1488
<0> bricecube: Xgc's answer earlier was pretty complete on that matter.
<9> Xgc mentioned creating a temporary table... although I don't know which'll be easier for me.. use the parser
<0> I would highly recommend upgrading or finding an ISP that supports 5.0
<0> the differences are astonishing
<9> infi, I run 5.0 personally, but am doing this for higher portability
<9> I originially had the software set @ mySQL 4.1.. but then got complaints ;)
<9> infi, I've been searching mysql.com's docs for creating temp tables.. and believe I'll have to execute 5 queries. 1, create temporary table to subtract from 2. create a temporary table containing subtraction ids. 3. query into the subtract from table using insert...select 4. query into the subtract table using insert... select.. 5. make a query to perfrom the subtraction
<9> I wonder if I should have 2 arrays in my program acting as the 'temporary' table .. versus using mysql .. tho I believe mysql will be fastere
<0> bricecube: you could probably trim that down to 3 queries. however, it will definitely have to be executed with multiple queries.
<0> that is not "more portable." it is slower and inefficient.
<9> that's what I figure ;)
<18> gah, I don't understand why all the gyrations ?
<9> I mean portable in terms of distributability .. minimal system requirements
<18> infi: isn't that way unnecessarily complicated procedure ?
<0> yes, in 5.0
<0> however, he is talking about 3.23
<9> I could use a MINUS in other DBs.. or at least a subquery!
<0> bricecube: and you can in versions of mysql that are less than 6 years old, also.
<9> infi, lol.. I know.. thing is there's a lot of users of bMail (http://bmail.sourceforge.net) that are 3.23.. I think some oldschool hosting companies are using versions of RHEL
<9> 2.0 or something. Debian stable is @ 4.1 for christsakes ;)
<0> I don't know what to suggest other than to use different hosting providers that keep up with their application software.
<9> infi, should the type be a heap ?
<9> lol nbm
<9> nvm
Return to
#mysql
or
Go to some related
logs:
javascript SyntaxError: missing ) in parenthetical
mindeq
#kde
#kde
#gentoo
xmms-mad rpm Packman
pcntl_fork daemon
#perl
#perl
reinstall sudo ubuntu
|
|