seslie

You marked as solved without a reply. Did you figure out the answer? If you did, you could post back to tell us how you did. If not, make sure the two columns (the referenced column and the one to be referencing) are of the same datatypes see this [link](http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html) …

Hello Taino, Your query is right! :-), well almost `where UPPER(CITY) = 'GROVE';` is the only correction. alternatively, you could use the 'Lower' function `where LOWER(CITY) = 'grove';` Try this also: `select cust_num, cust_name from customer where upper(city) = upper ('grove');`

[Click Here](http://dev.mysql.com/doc/refman/4.1/en/alter-table.html) btw, ur subject says; > **altering tables** in MySQL and your question says > I need a really good tutorial on how to **alter** MySQL **databases** Which one is it?

Hi rhfh, But you understand the concept of ER diagram right? if not, you should probably do a quick background search on it and have n idea of what it is (no knowledge lost). For validation rules, I dont really understand what you mean by the S, G and T …

Welcome...took us 3weeks but we did it..:-)

Too late? Him replying or you replying to him? :s

Hello sanghvikevin, Try looking up this link..[http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm](http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm). There's a section that explains your question..'The RR Datetime Format Element ' If you still don't understand, post back for extra details. Regards, Seslie ;-)

Hi gilgil2, rch1231's right..u're using insert query..the correct syntax is `UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value` SET is the keyword you're missing here.

Hello shapam, what kind of database? what;s the description of the table? did you write an encryption key to store data that way? what kind of data goes into the table?

Hi bangor boy, The relationship could be one/many staff can work on one/many company projects one staff can manage one project at a time Depends on what u term as 'machine', one/many company projects may be accessible via one/many machines or one/many company projects may be worked on via one …

Hello Flames1, I assume you are trying to insert into a database table through php. Am i right? First you need to create a trigger. That trigger is where you specify the form of the short ids. You can make it random, or decide to increment by 1 or whatever …

Hello samc36, Sorry for the late reply. I'm pretty sure you might have submitted the project by now. Well, ur ERD looks good. Were you asking of how to translate this into tables in oracle? PS: does EER mean?

Hello end3r, I'm finding it rather hard to understand what you mean. What do you mean by "finding intervals not covered"? Do you plan to get the results stated below? I cant seem to get what the problem is. Could you be a little clearer, please? Regards, Seslie

> how can i delete whole row for this user IF there is no data saved in skills Why would you want to delete the whole information cos a particular column is empty? well, it depends on what the table is there for. But I think this will cause a …

Hi Biswasparajuli, Are you looking to get help in drawing the ER diagram or designing the database for this?

Hello caltech, what i usually do before i begin any of my applications is to sketch how the interface is gonna look like on a piece of paper, somehow this helps me figure how to design the database... So, also wanted to ask about the schedule. Is it static? for …

Hello Akash, I'd say you have a relatively strong team for a starter, that's if they're really good..Well, I'm not a pro or anything but basically i feel inorder to start a company, u should do the following 1. Analyse the risks of going into the business... 2. Define projects …

Hi dujdaran, Keeping ur homework, especially one u aren't very good with, to the last minute is bad practice. Try to get something 'reasonable' done first, post it, the problem u're having and we're willing to help. Be sure to read the rules too... ;-) Regards, Seslie.

Couldnt have said it better myself. Good post Lusiphur. It's all in the database(at least most of it)

Hello rithish, [QUOTE]what is the use of varchar compared to character???[/QUOTE] CHAR and VARCHAR2 types are used to store character string values, although they behave very differently. CHAR stores fixed length character strings while Varchar stores variable length strings. see [URL="http://www.orafaq.com/faq/what_is_the_difference_between_varchar_varchar2_and_char_data_types"]this[/URL] and [URL="http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:123212348063"]this[/URL] [QUOTE]what is number(7,2) i mean 7,2 i …

This is definately a very late reply but just incase some one googled and gets here. Incase you(Shapam) are still in need of this, First of, if you are tracking this yourself, you need to have an audit trail table. This table basically keeps records of all activities performed on …

Hello Weblion, you need to restructure the way you ask your questions generally, Seen a couple of threads from you and they're arent really clear. meanwhile checkout [URL="http://www.w3schools.com/"]this site[/URL]if you're looking to learn html. Regards, Seslie

[URL="http://www.daniweb.com/software-development/csharp/threads/414508"]Check[/URL]

And just for a later time, try to avoid using the word 'Help!' alone as a topic for your thread...

Hi munitjsr2, So, let me see if i get you right. You have a table: Oppar that needs to be updated based on the script.. [QUOTE]But there are cases where there is no record in the table oppar where the column oppar_job_rec is XYZ or LMN.[/QUOTE] You would need a …

Hello Canniemar, apex.oracle.com to the best of my knowledge is for hosting applications built with Oracle Application Express. Did you use that in building yours? I have a workspace on the site and it works just fine. Regards, Seslie

Hey, Could you rephrase your question, can't understand.. but checkout this site and see if it's what you're looking for or if it helps. [URL="http://stackoverflow.com/questions/5660380/updating-a-column-depending-on-checkbox-value"]http://stackoverflow.com/questions/5660380/updating-a-column-depending-on-checkbox-value[/URL]

Hello zooferic, please could you be a little clearer with your question. I don't really understand what you're trying to do. Regards, Seslie

Hey ShadyTyrant, Sounds good to me. When you start to create the tables, you would need to link them up via foreign keys and the likes and normalize. You would also need tables to hold user posts and threads and information like that.

Hello Kelvin, Welcome on board!

Welcome!

No address provided...

Hello Everyone, Hi, just started learning c# recently although i've known the basics for a while now. I am required to start creating plugins for a particular program. Please, i need help, materials sources, exercises and projects that would help me get familiar with developing plugins as soon as possible. …

Hey optimus203, nyc to 'meet' ya, welcome.

Have you started creating your tables? I think people might need more info inorder to help u. I could help u with part of the database part but I'm not a guru, doh there r lots of them here. Just post some work u've done so that we can build …

Hi..I'm new here, posted my problem before but can't really keep track of it, don't know where it is so i decided to start a new thread,, i hope this is not a problem... I'm trying to create a database for a school..it should be able to incorporate virtually everything …

Hi, currently doing a kinda IT program in company that does practically everything using sql..so i guess i might also be able to help...