| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> When installing mysql I got three default tables it seems (mysql, test and information_scheme). Are these used for anything, or can I delete them?
<1> alex
<2> ...
<1> alexandersandstr: you have to keep mysql. never heard of information_scheme.
<3> you can delete test, the mysql database is for authentication/authorization
<2> information_schema is meta-database, I'm not sure you can delete it
<3> the information_schema database is a sort of virtual database
<3> yeah.
<3> it doesn't take up any space
<1> when'd that come in, 5.x?
<3> 5.0.3 i think
<0> Okey, test goes, the rest stays :)
<1> I really have to make that jump don't I...
<0> thanks for the advice/help!
<4> later
<2> um.
<3> ?
<2> today I was trying to figure out
<2> why the cl*** that was querying mysql
<2> was faster than apc_fetch()
<3> and?
<5> or?
<3> nor!
<6> !nor
<7> well you could see the format listed (2006-05-27 22:01:12.0) and the error is: 3 elements of civil date are necessary.... looks like i only have 2?? how can i make datetime have 3 elements?
<3> huh?
<8> Hello,
<8> I'm a spanish guy, my english language is not very good
<9> sigmo: that's fine, just try your best :)
<8> thanks flupps
<7> gleam.. i have an error when ruby tries to process the datetime field...
<7> gleam: is there a way of getting linux's version of datetime to be stored in my db?
<3> use date_format when you retrieve it to get the results in whatever you want
<7> gleam: but when i declare the table, instead of datetime, is there another field that will specify it as linux's format
<3> no.
<3> use datetime.
<8> well, I have a problem with a query very easy, but in mysqladmin return an error that I can't solve
<3> mysqladmin isn't for running queries
<8> yes, I'know
<3> ok :)
<3> what's the rest of your problem?
<8> I'm using it for some querys for my subjet of the university
<10> how do i reset my mysql p***word?
<10> nvm
<8> but if anybody can sugest me any program to execute querys easily ?
<9> sigmo: mysql
<8> I have installed mysql
<9> which operating system?
<8> win xp
<8> professional edition
<9> did you use the windows installer wizard?
<8> no
<9> how did you install?
<8> I did install it reading a tutorial
<8> unziping a file
<9> go to the directory where you installed
<9> then "cd bin"
<9> then just type "mysql -u root"
<8> ok
<9> ***uming you started the server
<8> ok flupps I have do it
<8> and now I can write my querys here?
<9> do you have the mysql> prompt?
<8> yes
<9> yes
<9> www.mysql.com/tutorial
<9> can be a good place to start too
<8> thankes
<8> thanks
<9> sure, good luck
<11> i have a list of items which i'd like to list by category, and display the category name at the head of each list
<11> since mysql 4 doesn't do sub-selects, i've managed to get the items listed in the proper order by using multiple left outer joins
<11> but i'm stumped as to how to get the category name to list first on a line by itself
<9> pastebin what you have so far
<11> flupps: ok
<8> flupps the error is the same at phpmyadmin
<9> sigmo: what's the command you're running? and what's the error?
<8> where can I copy de query?
<9> hashmysql.org/paste/
<8> http://hashmysql.org/paste/viewentry.php?id=1913
<11> flupps: pastebin.com/743551
<9> sigmo: SELECT VERSION();
<11> flupps: i included what i'd like the display to look like at the bottom...
<8> if I only execute the subquery it run ok
<9> gymsmoke: sheesh, man
<8> and return the min(fecha)
<8> 4.0.25
<9> sigmo: need 4.1.x or later for subqueries
<8> hahahaha, ok
<11> flupps: ?
<8> I must upgrade it
<8> ?
<9> gymsmoke: http://pastebin.com/743556
<9> If you want us to help, format it easily for us to help ;)
<11> flupps: oh, ok... sorry
<9> gymsmoke: what column holds the type? 'Cardio', 'Strength', etc?
<11> flupps: item_category in item_master (im)
<9> the display you pasted there isn't what the query displays at all
<9> do you mean the actual formatting?
<9> that you want that different?
<11> flupps: i pulled the code directly from my code file (http://dev.fitnesscenterequipment.com/packages.php)
<11> flupps: select "details" at the bottom of the description box
<9> so, you're retrieving the item_category
<9> but you don't do anything with it in your code?
<11> flupps: i'm retrieving the item category in the lookup table, and ordering by that category. otherwise the items come out in an altogether different order
<9> gymsmoke: right
<9> databases will return everything in table format
<9> so, won't be something like a header.
<9> What you do is return that column too
<9> and in your presentation layer (in this case your php script) you fix the header
<9> whenever the item_category from the last row isn't equal to the one of the current row, you insert a html header somewhere in the page
<9> formatting and presentation is almost always done above the database layer
<11> flupps: ok, that's an idea
<11> flupps: i'll give that a go -- thanks!
<9> sure
<12> I am trying to write a query where I compare a datetime in the database to see if it happend after today 12am PST time, how can i write that in sql?
<12> so basicly if it happend today
<12> but i am not in the PST timezone
<11> flupps: Woot!!!
<9> did it work?
<11> flupps: that did it - thanks again!!!!
<9> gymsmoke: sure thing :)
<9> it's all about the best tool for the job
<9> it's doable in the databawse
<9> but it would be a lot more complex
<12> so can anyone help me? i think i just need to do from_unixtime(sendstarttime) >= CURDATE() but how do i make it PST
<11> flupps: i'm so used to oracle and the big dbms's... i was shell-shocked to find out how much mysql 4 is really missing, but i was always told to stay out of mysql5 for production
<9> gymsmoke: 5.0 is getting stabler every day now, it's already labeled production, and in a few months it'll be ready for real deployment, I think
<9> gymsmoke: also, it started up in another end of the application spectrum
<11> flupps: god, i hope so! i miss transactions stored procs, etc...
<9> people that used MySQL 5-6 years ago didn't do it because they needed a fullly featured RDBMS, they started cause they needed a lightweight, fast, SQL-compatible (with some features missing, of course) data storage
<3> 3.23 had transactions and fks
<3> not stored procedures of course
<11> gleam_: and sub-transactions, and inherited transactions ? i didn't think it had all of that
<3> hehe
<3> i'm just talking straight transactions
<9> savepoints was in 4.0, I think
<9> which is just another implementation of sub transactions, no?
<11> flupps: basically, i think it is
<9> think you can do the same things at least
Return to
#mysql
or
Go to some related
logs:
out of range value adjusted for column decimal linux
ebuild howto sudoers
ninpomonkey
#python
yup rpm sles oes
free.partitioner windows
prism3 ubuntu
win32codecs debian-way
convert bin to deb
php array_push unexpected T_DOUBLE_ARROW
|
|