#mysql
13 October 2007
Total 15 pages. You are browsing page 4/15.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
02:45 <****> Ramattack: all keys/indexes are defined in the table schema
02:45 <****> I know I know
02:46 <****> but then
02:46 <****> Ramattack: your english no es buena : (
02:46 <****> lol :)
02:46 <****> I know ...
02:46 <****> look this example
02:47 <****> CREATE TABLE ftpgroup (
02:47 <****> groupname varchar(16) NOT NULL default '',
02:47 <****> gid smallint(6) NOT NULL default '5500',
02:47 <****> members varchar(16) NOT NULL default '',
02:47 <****> KEY groupname (groupname)
02:47 <****> ) TYPE=MyISAM COMMENT='ProFTP group table';
02:47 <****> sorry for pasting
02:47 <****> KEY groupname... it doesn't say PRIMARY or what...
02:48 <****> Ramattack: so it is just a regular key, an ordered set of data. You can scan ordered data faster than unordered data
02:48 <****> and what would be the difference if I set PRIMARY KEY instead on KEY only?
02:49 <****> Ramattack: it would make it unique for one. You could not have the same groupname twice
02:51 <****> so key is a way of ordering data and those who create a table without a key should for killing them then? (it's a joke)
02:51 <****> because they'll cause the whole scan of the table?
02:51 <****> Ramattack: right
02:51 <****> es correcto
02:51 <****> :)
02:52 <****> and if I have a KEY although the key could be repeated the search won't be sequential... it would be a indexed search
02:52 <****> am I wrong?
02:53 <****> Ramattack: it will try
02:53 <****> Ramattack: not always possible.
02:53 <****> why?
02:54 <****> Ramattack: if mysql thinks that the data matchs most rows it will do a table scan anyway because it will be faster for example
02:54 <****> and if it thinks bad? lol :) sorry but how does it know that
02:55 <****> Ramattack: it is very wise.
02:55 * chadmaynard chuckles
02:55 <****> :) ok
02:56 <****> 6950!
02:57 <****> and when a primary key is set instead of a key it won't never do a sequential search because key values are never repeated am I worng?
02:57 <****> wrong sorry
02:57 <****> thumbs: what is 6950?
02:58 <****> thumbs can speak spanish
02:59 <****> that would be the difference then with key in my example and primary key?
02:59 <****> that one of them could perform a sequential search and the other not?
03:00 <****> Ramattack: that's a possibility but that's also a very simple version of what really happens
03:01 <****> I know I know but that would be a difference then?
03:01 <****> mean that could be one difference if I set there primary key instead of key?
03:02 <****> Ramattack: I cannot give you a general answer because it depends
03:02 <****> I see...
03:02 <****> I need a mysql course... lol
03:02 <****> mysql.com
03:02 <****> nice book is enough
03:02 <****> offers training
03:02 <****> for beginning
03:03 <****> I run all my daemons against it but don't have enough knowledge
03:04 <****> have very general knowledge
03:04 <****> Ramattack: what is 2 + 3?
03:05 <****> 7 lol
03:05 <****> Ramattack: what is e ^ 0?
03:05 <****> wtf
03:05 <****> no idea
03:05 <****> what is e ^ ( pi * sqrt(-1) ) ?
03:06 <****> -1 :o
03:06 <****> yup
03:06 <****> glad someone knows some exponential shortcuts
03:08 <****> Ramattack: before you get any other answers you must give us the 7th degree taylor polynomial for sin(x) and evaluate sin(.01) in that polynomial without a calculator.
03:08 <****> sorry. I don't make the rules.
03:08 <****> I'm green on the concept of stored procedures.. is it possible to create a query and store it so it can be treated like a table? would that be done via stored procedure if so?
03:09 <****> lol
03:09 <****> jereme: sounds like you are looking for views
03:09 <****> !man view
03:09 <****> (ALTER VIEW Syntax) : http://dev.mysql.com/doc/mysql/en/alter-view.html
03:09 <****> hmm
03:09 <****> close enough
03:09 <****> I want a query that is actually an aggregate of several tables, so that I can hook a 3rd party CRM software into our database without creating a custom src data table
03:09 <****> cool I'll check them out
03:09 <****> thanks
03:11 <****> where are views stored?
03:11 <****> ah
03:11 <****> nevermind
03:11 <****> if I just rtfm the answers eventually show up
03:12 <****> : )
03:12 <****> damn, too bad we're not on 5.x yet
03:12 <****> soon though
03:12 <****> a few weeks even
03:13 <****> ohh
03:13 <****> yea it helps if your version actually supports them
03:13 <****> yeah, even if it won't work for me today, you've actually opened my eyes to something big here..
03:13 <****> I can think of a handful of places to use these views
03:14 <****> I assume they'd work over an odbc connection too..
03:14 <****> looks like they act like tables
03:14 <****> exactly the point of having them
03:15 <****> jbalint hears odbc and jumps in
03:16 <****> chadmaynard: :D
03:17 <****> anybody in milwaukee area going to barcamp tomorrow?
03:17 <****> thanks for the input guys
04:02 <****> hello... anyone want to help a noob?
04:03 <****> what is your question...If I know how I will
04:04 <****> so.. I need to get mysql up and running on my clients server... he's got an account with verio
04:04 <****> and I looked at the documentation... basically said all I needed to do was type "vinstall mysql" and everything was perfect
04:04 <****> hah
04:05 <****> what os?
04:05 <****> says "vinstall: commandn not found
04:05 <****> i typed in uname and it returned "FreeBSD"
Total 15 pages. You are browsing page 4/15.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last