| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> whoop, fixed my issue. script works like a gem :-)
<1> BartVB: OK I removed the GROUP BY but I get too many rows. I should only have one for each user
<2> shabbs:
<2> I had the old mysqlcc and you could
<3> hmm, should have a bit more time, more sleep and an example table to play with :)
<3> can't think straight anymore :) Need to get some sleep I guess :D
<2> Whats a browser?
<1> BartVB: THanks for your help. I see that you query should work. I will take a bit of time to see if I can get it to work.
<4> socrates2: The Query Browser, a query tool and companion to MySQL Administrator.
<5> !tell us about query browser
<6> But I don't know a thing about that.
<5> !tell us about mysql query browser
<6> arjenAU asked me to tell you this: A cool development GUI on Linux, Windows and OS X: http://dev.mysql.com/downloads/query-browser/
<1> mhillyer: do you know when the beta version for workbench will be out?
<4> vhd: Do you know how many times I have been asked that? ;-)
<4> vhd: Best answer I can give is sooner than later.
<1> mhillyer: I guess we are all really waiting for it ;D
<7> mhillyer, 1,247 times?
<1> :D
<0> mysqlcc rox
<4> Ungy: 1,248 now.
<3> vhd; I'm starting to doubt if the query actually works as advertised :) Hmm. Anyway. Need to finish something and then get to bed :) Good luck with your query :)
<7> mhillyer, damn I was close thoguh
<1> BartVB: Thanks!
<7> later folks
<3> cya Ungy :)
<1> mhillyer: On the forum they reckoned it would be out by the end of Jan, we are already mid Feb.... can wait! :-)
<2> why 2 apps when one used to do it all?
<4> socrates2: Many users did not want to do it all, they wanted to either use MySQL for queries or manage MySQL.
<8> how do i force mysql cli to not be autocommit by default
<4> Those who wish to do both can download both.
<8> i want to always use transactions?
<4> SET AUTOCOMMIT=0
<4> winmutt: That is per session BTW
<1> Does mysql administrator or query browser allow you to snc two mysql databases on different servers (for data and for structure)?
<1> I menat sync
<9> if I want to select up to and through a DATE field.... can I do NOW()<=field ... or do I need to increment field by 1 DAY and just do NOW()< that
<9> DATE() is not available.... im 4.0.x
<2> Tac_Work: you still TA ?
<9> nope, out of school ... im the lead developer over at a company in detroit
<10> got a question.... let's say my database is set to utf-8, and my fields size is 100 characters.... what does that really mean?
<9> im just editing a live site, and so im asking this question before I just go try it :-p
<2> Tac_Work: how much do you get paid?
<2> more than $50,000 a year
<9> very little right now.... its mostly bonuses
<9> youd laugh for a long long time at my salary
<2> you know java?
<9> yeah i wish i was doing java
<9> im doing PHP right now
<9> hence the lower salary :-p
<2> I hate php
<2> you cant make webb apps
<11> wtf
<11> what does that even mean?
<2> proper, OO web applications
<11> and why's that?
<12> hi. is there anyway to set the maximum number of rows that a table can have?
<13> you can make webapps, but you can't make large ones without a significant amount of planning or you'll go insane... INSANE, I tells ya! ;)
<12> I mean, doing it directly on the database without using a logic model to control it
<2> I was talking to zircu
<11> mlopes: what for?
<9> PHP is good at what it does.....
<12> well, sparing some bytes :P
<12> i only need ten records..
<14> When I try to access mysql from the command line (as root) I get the following error: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using p***word: YES)
<14> ... Any ideas?
<12> because it's being continuously recycled
<4> elbac: Wrong p***word?
<12> the idea is to keep the latest 10 searched queries
<2> Tac_Work: okay, what degrees you have?
<14> mhillyer, nope its the right p***word
<14> I'm connect to the machine remotely...
<4> Aah.
<4> elbac: Then your mysql.user table either lacks an entry for root@localhost or has a different p***word than the entry for root@remotehost.
<14> I can get in as another user, do you know how I can repair that?
<4> Another root user or another standard user?
<4> You can connect remotely as root?
<14> oh crap
<14> I got it
<14> how do I update my p***word
<15> what permissions do I need to give a user, so the user can insert a record from a view ?
<4> !tell us about reset root p***word
<6> But I don't know a thing about that.
<4> !man reset root
<6> (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<14> ty
<9> socrates2: check /msg
<16> hey do i have to add anything when creating a table that has no primary key?
<4> Yes, a Primary Key.
<17> heh
<16> how do i say there isnt one then?
<18> u dont have to add one if u dont need it
<4> You don't. Having a primary key is just good design.
<16> ok thanks
<19> if there is a table users = [username, p***word, roles]. what would CREATE INDEX credentials ON users (username, p***word) do?
<5> something unnecessary.
<5> why index pwd
<19> i don't know
<5> if you don't know the answer, don't index it ;-)
<19> haha
<19> ok
<9> well that would technically do what a PK would do ....
<9> only overkill ...
<9> you can set multiple fields combinations as the PK right?
<20> Does anyone have any experience with hit counts and rolling them up for reporting? I'm kicking around two different ideas and I'm looking for someone with some "best practice", "been there done that" advice.
<20> Basically I have a system that counts by day for 7 days back, by week for 6 weeks back, by month for 12 months back, and by year forever.
<21> can bind-address accept multiple ips?
<20> I'm trying to decide if I should just insert new hits into the days table, the script to roll the days info up every night at midnight OR write all 4 tables on every hit.
<22> swampwork: check http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html
<22> swampwork: search for "The MySQL FULLTEXT implementation regards any sequence of true word characters" -- start reading there
<23> what might be causing an error "EROOR 1005 (HY000): Can't create table './test/e911.frm' (errno:121) ?
<24> trying to do foreign keys?
<25> !perror 121
<6> System error: 121 = Remote I/O error
<6> MySQL error: 121 = Duplicate key on write or update
<23> oh... one of my foreign key names exists already... forgot to change it, thanks litheum
<2> Tac_Work: sorry was away
<2> plus not registered so can pm
<2> I thought you where an lecturer or someink thats why i asked
<2> but you are not
<26> What's the most efficient way to grab all the records in a table except for the ones with `id` 8, 9, 24, and 67?
<4> bjork24: Get them all and drop the ignores while processing.
<26> So there isn't an easy way to exclude them in the call? Like, "WHERE `id` != (8,9,24,67)"... ?
<4> NOT IN (8,9,24,67)
<27> Can a DATE be null?
<4> Is it set NOT NULL?
<27> No.
<25> !tell farrioth about tias
<6> Alrighty.
<4> !tell me about tias
<25> !tell US about tias
<6> Alrighty.
<24> meh, sql ****s
<25> oops
<27> What type should one use for storing an array of integers?
<4> One should not store arrays in a single column.
<27> How should one store arrays?
<4> http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
<4> Read that farrioth.
<28> hi, i am trying to create a table with with field: uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment, but mysql returns a 1067 Invalid default value for 'uid'
<4> You need not set a default for an auto_increment.
<28> mhillyer: could you give an example?
<4> Sure, your example minus the default part.
<28> alright, so the default will auto start from 0?
<27> Okay, thanks.
<4> deconvolution: From 1 IIRC.
<28> mhillyer: anyway forced it from 0?
<4> Why?
Return to
#mysql
or
Go to some related
logs:
t
No such child resource trac
#suse
menu.lst showopts manpage
downgrade gentoo-source
undelete rows marked for deletion mysql
#ubuntu
#awk
#ubuntu
audiowrapper source
|
|