#mysql
14 October 2007
Total 16 pages. You are browsing page 3/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
03:20 <****> Is there any way to ALTER TABLE ... DROP PARTITION without deleting the underlying data? I wan't the ability to access the data as an archive .....
03:20 <****> Cahaan: what's the benefit?
03:21 <****> jdavis_: would probably use less space, since unnecessary fields won't have to be set to null when the relation does not exist, and it makes more sense imho
03:22 <****> mysql question: http://dpaste.com/22373/
03:22 <****> the case is the following: I have t_object which represents different instances of object in the database, and t_zone, where an object can be set. For example, the position of the object inside the zone would be defined by posX and posY
03:22 <****> Cahaan: it sounds like it would end up being an extra table, but not really an intermediate one. Want to paste an example?
03:23 <****> but an object is not necessary in a zone
03:23 <****> see what I mean ?
03:24 <****> Cahaan: so what would your 3 tables be?
03:24 <****> What is the difference in Language between MySQL and SQL?
03:24 <****> I mean, if you build a table for example, the datatypes are called different right
03:24 <****> mysql question - better explanantion: http://dpaste.com/22374/
03:24 <****> t_object (object_id, type, name, ...)
03:25 <****> what do you think about this?
03:25 <****> (primary keys are underlined)
03:26 <****> Cahaan: oh, yes, that seems correct to me.
03:26 <****> all right, thanks :)
03:26 <****> Cahaan: you have some zones, and some objects, and you have a 1:{0,1} relationship.
03:26 <****> exactly
03:27 <****> Octopssy: huh? mysql is a server that (at least partially) implements the SQL language standard
03:27 <****> Cahaan: if they can each stand on their own, then it makes sense to have an intermediary table (speaking loosely).
03:27 <****> what do you mean by "stand on their own" ?
03:27 <****> ToeBee: For a course at study I'm asked to -create an already existing table in SQL" - the course is Oracle DBMS.
03:27 <****> Any clue what is ment with this?
03:27 <****> (english is not my native language, I don't get the meaning of this)
03:28 <****> oh no I understood
03:28 <****> recreate an already existing mysql table in SQL
03:28 <****> you mean that the relation is not necessary
03:28 <****> right?
03:28 <****> ToeBee: that's what i ment
03:28 <****> Any clue what that assignment is?
03:30 <****> Octopssy: The teacher that wrote that assignment doesn't understand english very well -or- simply doesn't know how to express a clear thought in the area of SQL.
03:30 <****> seems like a poor problem statement... why create something that already exists?
03:31 <****> indeed
03:31 <****> So no clue what can be ment with that?
03:31 <****> Octopssy: The assignment has no clear meaning, at least in english and SQL.
03:32 <****> Thought so yea
03:32 <****> damn crapola
03:32 <****> ask the prof
03:32 <****> Octopssy: It sounds more like you paraphrased the assignment badly or left out some information.
03:33 <****> Cahaan: oh, sorry, let me explain: I meant that if you can have zones without objects and objects without zones, then you should probably have an intermediary table.
03:33 <****> Cahaan: so the intermediary table makes sense.
03:33 <****> I got no idea, but for example
03:34 <****> When you describe tablename in Oracle SQL Developer
03:34 <****> jdavis_: all right, that makes sense
03:34 <****> You get other datatypes from the tables
03:34 <****> jdavis_: thank you very much, I appreciate
03:34 <****> Than in MySQL, right?
03:35 <****> sure
03:37 <****> Probably the assigment is saying to recreate tables from some older MySQL project into Oracle tables?
03:38 <****> Octopssy: maybe they mean use only standard SQL, and the mysql tables are somehow non-standard?
03:38 <****> Octopssy: not saying they are, just a thought.
03:39 <****> How can they be non-standard?
03:39 <****> Octopssy: Does the assignment refer to some existing MySQL tables and creating them in Oracle?
03:40 <****> No, it was just something like, pick some case, like -a videorental service- and create it in SQL
03:42 <****> Octopssy: So you didn't explain the assignment correctly?
03:42 <****> I guess so :<
03:42 <****> sorry
03:43 <****> any clue what is ment?
03:43 <****> Octopssy: Not until you tell us the assignment.
03:43 <****> No, it was just something like, pick some case, like -a videorental service- and create it in SQL
03:44 <****> Octopssy: why not just email your professor and ask for clarification? It's really not a good idea to ask about the assignment in IRC. The professor might consider this cheating, even if you aren't trying to cheat.
03:44 <****> Octopssy: It's not helping for you to paraphrase the assignment.
03:44 <****> "something like"? Don't you have it written down?
03:44 <****> no, was said in c ollege
03:45 <****> eh yea probably better
03:45 <****> Octopssy: Taking good notes is a challenge, I guess.
03:46 <****> Octopssy: professors generally respond quickly to emails, and most likely other people are confused, too. And I really, really think it's a bad idea to ask for help from anyone other than the professors.
03:48 <****> hi everyone,
03:49 <****> Hi!
03:49 <****> does anyone know what mysql-ndb and mysql-dng-mgm are used for?
03:49 <****> dng?
03:49 <****> I'm using ubuntu and installed mysql
03:49 <****> sorry ndb-mgm
03:49 <****> ndb is mysql cluster
03:49 <****> mgm is the management server
03:49 <****> oh okay
03:50 <****> so if I don't do db clustering then can I stop the services?
03:50 <****> do you have ndbd running?
03:50 <****> why'd you instlal those packages?
03:51 <****> i dont think there is a default configuration to run them
03:51 <****> oh is it :P
03:51 <****> I don't know I think I installed too many packages from ubuntu
03:51 <****> do ps and grep for ndbd
03:52 <****> no process
03:53 <****> :)
03:53 <****> thanks
03:58 <****> hello
03:59 <****> i am trying to export e database from phpmyadmin, but i can't i dont have shell access is there another php script?
03:59 <****> thnc in advance
03:59 <****> thnx*
04:01 <****> I thought phpmyadmin let you download the backup file via the web interface?
04:01 <****> yeap Toad
04:01 <****> hi
04:01 <****> yeap ToeBee
04:02 <****> but i cant i get an internal error
04:02 <****> my webhosting providers sucks
04:02 <****> and i dont have shell access
04:02 <****> is there anither php script?
04:02 <****> wouldn't you need shell access to install it?
Total 16 pages. You are browsing page 3/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last