|
Schema is the actual structure of the database described in such a form that understandable to humans...
A schema will contain definitions for tables, views, indexes, relations, procedures, functions and every other aspects can be accesses in the db...There is a possibility that for the same database there are several schemas, divided by access rights...So a schema is not equal the database but more a way one can see the database with the proper access rights...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
I'm new to mysql .. I need a One to many ralation tutorial.. like for example I made a table called MovieList with 1 column name TitleMovie and now I want to create another table called acc1_MyWatchlist and inside of it was also a TitleMovie..my question is I want insert a value in acc1_mywatchlist but only the available values in Movielist's TitleMovie and If I tried to create another table acc2_mywaychlist it should be the same as the first table and if I tried to edit some values in the MovieList table it should be affect all the table that has the same column TitleMovie....
in Access database I just use the lookup wizard but ofcourse mysql is differnt so can you give me some examples of this query..
|
|
|
|
|
I don't think you understand normalisation and references.
It sounds like your first table should have and ID of some type as well as the title. Other tables would then refer to that ID, not to the title. If you need to alter the title, the IDs stay the same and no other tables need to be updated.
|
|
|
|
|
ok thanks for the reply and tips so can you give me an example if you don't mind?
|
|
|
|
|
No. Just try it. And read up on normalization.
|
|
|
|
|
Hi,
Please let me know the solution of mentioned Oracle Query, that how can I use the same in MySQL.
SELECT A.CNAME, B.ANAME FROM CLIENT A, DEALER B
WHERE A.CCODE=B.ACODE(+)
Thanks
(Riaz)
|
|
|
|
|
Which part did not work? What error did it throw?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
MySql doesn't do implicit outer joins, you'll have to do the full ANSI syntax instead.
SELECT. A.CNAME, B.ANAME
FROM CLIENT A,
LEFT OUTER JOIN DEALER B
ON A.CCODE = B.ACODE
Wrong is evil and must be defeated. - Jeff Ello
(√-sh*t) 2
|
|
|
|
|
..that's what the plus does?
Nice 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Yeah, but note that the plus isn't on the outer side. It marks the side with the nulls.
Wrong is evil and must be defeated. - Jeff Ello
(√-sh*t) 2
|
|
|
|
|
|
|
COURSE (CourseID, Cname, Ccredit)
TEACHER (TeacherID, Tname, Toffice)
STUDENT (StudentID, Sname, Sclass)
TAKE_COURSES (CourseID, TeacherID, StudentID, Score, ClassRoom)
Question:
List all the name of students whose subjects are all past.
The answer is:
SELECT Sname
FROM STUDENT
WHERE NOT EXISTS(
SELECT *
FROM TAKE_COURSE
WHERE TAKE_COURSE.StudentID= STUDENT.StudentID AND Score<60)
I can't understand this sentence
WHERE TAKE_COURSE.StudentID= STUDENT.StudentID AND Score<60)
Can anyone please tell me how to resolve it?
Thank you very much.
|
|
|
|
|
The statement selects all the records from table TAKE_COURSE, but filters them by the WHERE clause. Saying WHERE NOT EXISTS at the start, filters out those records where the StudentIDs match but the student score is less than 60. So you should end up with all students who have a score of 60 or greater.
|
|
|
|
|
Yes.
I understand it.
Thank you very much.
|
|
|
|
|
Dear sir i have installed sqlserver 2008 r2 sp2 & vs.net 2010 I make a project in ado.net to add data in sql database with no error. the program runs well but when i go to the add button it says that "Login failed for this user" plzzzzzzzzzz help.....
|
|
|
|
|
Not enough information!
Use SQL credentials - user id and password registered in SQL server, do NOT use integrated security.
Create the user for your app in SQL server eg userid - MyAppUser
Give the user dbo rights to your database
Use those credentials in your connection string.
If this does not make sense to you then get a book or an article and work through the examples.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
What help do you need? The error tells you exactly what the problem is.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Case 1:
Suppose there are two computers (Ser1, Ser2) and SQL Server 2005 Express is installed on each machine, the input will be stored on the machine Ser1, if the data changes on the computer Ser1 will be updated again computer Ser2, the ask my SQL Server 2005 express can update data on the computer Ser2 from Ser1 ? How the computer config ?
Case 2:
Suppose there are two computers (Ser1, Ser2) and SQL Server 2005 Express is installed on each machine, the input will be saved to Ser1 or Ser2, meaning that if the computer Ser1 busy, it will save computer Ser2 or else, and 2 machine Ser this is always synchronized data.
if I understand this issue I find the document what ? or what keywords to search on google.com?
|
|
|
|
|
Here you go some Google Foo[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I do not get through formal classroom training school, not knowing I ask you help, if you are not only helping out loud, do not know without question, the more bites.
|
|
|
|
|
And english is not your first language, I understand that. However the results of the search I supplied will give you more information and better resources than a forum post. Your requirement is not trivial small.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
SQL Server 2005 Express cann't create Replication\Local subcriptions ? because sql warning: Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.
|
|
|
|
|
I would not expect replication to be available in an Express version as it is one of the advanced features of the database but I don't know as I use neither the Express nor do I need the replication features.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I configure SQL Server Merge Replication, when merger database together, if one of the two server machines damaged or die, the software did not transfer it, i have to manually reset ip to the software to run, how to automatically switch to 1 in 2 server fails ?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
