Databases Forum

Is it true that a relation which does not have a composite key will automatically be in 2nf. The definition states that every non key attribute should be fully functionally dependent on the primary key. So if there is no composite key every attribute qualifies as fully functionally dependent on …

Hi i was installing sql 2000 on win 7 but it gave a message something like "sql have compatibility issues with this version of windows". I want to use sql 2000 with vs2005. Is it possible to run sql server 2000 on win 7? If yes how can i run …

I tried to import a table intro a database and MySQL give me the next error message: "[COLOR="Red"]MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''table_ro2' INSERT INTO 'table_ro2' …

Hi all, i have a problem in writing a block of SQL code in mysql. The block of code will have too delete a single row/record from about 23 related tables all at once. The code that i have written so far will only delete 1 row/record in 10 related …

Dear All, I have a server with 16 cpus and 32g ram. The problem below when I run my top it show mysql %cpu is more than 100%. Below is my top results. The problem here I would like to why is mysqld is using up 137.2% of the cpu …

Hi all, i have a problem in writing a block of SQL code in mysql. The block of code will have too delete a single row/record from about 23 related tables all at once. The code that i have written so far will only delete 1 row/record in 10 related …

I am using COLDFUSION . And using coldfusion i am inserting a table using URLEncode function. For instance, the word 'Registration Fee' will be inserted into a table like 'Registration%20Fee' after encoding using URLEncode function in coldfusion.But I need to write a mssql statement to decode the word and want …

What is this cloud computing and how does it work.

Please Explain me what is difference between cluster and non-cluster index. Also if i create a primary key on a Table which index will be created automatically, cluster or non cluster. Thanks in advance.

Hello! i have a very simple query: [CODE]SELECT * FROM fornitori ORDER BY ragSociale[/CODE] this works perfectly in localhost on my PC (windows 7 pro-apache 2.2.17-mysql 5.1.54-PHP 5.3.4) but on my VPS doesn't work and it give me a query error without number or error description (VPS: centOS 5.5-apache 2.2.16-mysql …

Hi All, I'm very new to PHP and MYSQL and I'm having hard time trying to insert data from PHP form in MYSQL DB. I'm able to echo out the output on webpage but i'm not able to figure out how to insert the data in DB. Please help me …

Hi, There are three tables involved here. A kind of quiz localhost site, i did for me. Table 1 contains questions. ========================== question_id (autoincrement) questions (varchar 250) category_id Table 2 contains choices ======================== Choice_id (autoincrement) Choice_value (varchar) question_id Table 3 contains answers ======================== question_id choice_id I am displaying 10 questions …

i need to develop a search query for city portal ..select * from ....takes lot for time is there any good query to get fast retrieval form database??????? plz reply its urgent

Hello, Question: List the top 25% of employees in terms of sales. Your list should include employee number, last name, first name, total number of orders, total sales. Here is what I have so far (not sure if my inner joins or even the query is totally correct): select e.employee_no, …

hi, i have found a few ways on the internet to import an excel sheet into mysql. one of which is save to a csv and upload to a site which creates the sql statements and this is great and i have used in past. however my problem is i …

Hi I am having trouble trying to normalise my tables, I would really appreciate some help! So far I have: [B][U]Customer Table[/U][/B] CustId(pk) Cust Name Cust Address Cust Postcode Cust Email [B][U]Order Table [/U][/B] OrderID (pk) Order Date_Time CustID(fk) [B][U]OrderDetails[/U][/B] DetailsID(pk) Quantity OrderNo(fk) DeliveryID(fk) [B][U]Product[/U][/B] ProductID(pk) ProductType ProductDescription DetailsID(fk) PartID(fk) …

<?php $connect=mysql_connect("localhost","root","") or die(mysql_error()."Cannot find Database"); mysql_select_db("cubicle",$connect); $insert_query='insert into registry(username,password,firstname,lastname,eid) values ("'.$_POST['uname']'","'.$_POST['pass']'","'.$_POST['fname']'","'.$_POST['lname']'","'.$_POST['email']'")'; mysql_query($insert_query); ?>

Hi, I'm putting an autocomplete textbox on my website to help users type in a location. I want users to be able to type a city or just a state (ex. Seattle, WA or Washington) kind of like what you see on Indeed ([url]http://www.indeed.com[/url]). How do I get the states …

This is on my Gentoo box. Recently, a MySQL upgrade seems to have broken my UDFs, specifically those in lib_mysqludf_preg. I first noticed errors like: FUNCTION tablename.PREG_RLIKE does not exist I figured, OK, I must have to reinstall them. I try the config command for lib_mysqludf_preg and get this: ERROR …

Hi Friends , I got a row in my table like follows date | Name | id -------------------------- 22-August | Ram | 15 14-July | Krish | 17 14_March | Anwar | 145 --------------------------- I want to sort this with date ie, 14-March 14-Jusy 22-August Using both date and month …

I have a column "etype" which stores enum('r', 'p'). So with each selection I want to extend the row number until the number of etype->'p' will reach some number, for instance 10. If I use LIMIT 10, the total number of rows will be 10, but there is no guarantee …

[CODE] pstmt = conn.prepareStatement("INSERT INTO tableA (userid, itemid) VALUES (?, ?) ON DUPLICATE KEY UPDATE value = ?"); pstmt.setString(1, userid); pstmt.setString(2, itemid); pstmt.setString(3, value); pstmt.executeUpdate(); [/CODE] This code works [CODE] pstmt = conn.prepareStatement("INSERT INTO tableA (userid, itemid) VALUES ((SELECT userid FROM user WHERE userid = ?), ?) ON DUPLICATE KEY …

Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ?

Please let me know how to drop constraints within a table having no names. :-/

How to store both cyrillic and latin in MySQL and is there anything special that I should know to display cyrillic with PHP? (conversions etc.) Thnx in advance

[ICODE]select eid from(select count(*) cnt,eid from certified group by eid)as foo where cnt=(select max(cnt) from (select count(*) cnt,eid from certified group by eid)as goo);[/ICODE] This query displays the eid with maximum no of entries in the table certified. Which in this case is no. of aircraft licensed to an eid. …

I want class,ER,Activity,Sequence,Usecase Diagrams for job portal as soon as possible.

I have a program for students in my school uses asp with mssql database with a small server in the school, and I want to make a website with php and mysql database, can I always update the queries by exporting the mssql to mysql? and how I can do …

why is this?

Hopefully someone can help me. Explaining this may be a pain for ya, but I would really appreciate any assistance that you may be able to give me. Here is my scenario. -I am trying to import a csv file into phpmyadmin. -The MySQL database is for Wordpress. -The .csv …

Hi I am working on a procedure to log the users and times of our reports. Our reports are all executed from stored procedures. The generic logging proc which will be placed in the 30+ report procedures. I'm having a problem with getting the start and end times for the …

I'm having a really hard time trying to figure out how to make the following search: "Find the sellers specialized in selling cars of the year (They can only sell cars produced during a specific year, example 2010). The tables I have are: Seller: {[U]Seller_Id[/U], Name, City_Residence} Business: {[U]Car_Id,Seller_Id[/U],Year_car_Produced, Business_Date, …

Ok what I am trying to do is submit changes. I have all the information being collected. I'm just having trouble with the proper query to run. I currently have: [CODE] $sql = "UPDATE anime_list SET anime_name = '$animename' rating = '$rating' episodes = '$episodes' WHERE id='$id'"; $result = mysqli_query($dbc, …

Hi, I need a little help importing an XML file into sqlserver 2008. I followed this example [url]http://www.sql-server-performance.com/articles/dba/Loading_XML_data_into_SQL_Server_2008_p1.aspx[/url] (make sure you goto the rest of the pages in the article!) , generated the schema etc., but I can't get the import to do what I need. I was able to …

Hello I've large data in a table in which one of the columns is description. in this column i'm to store description of materials and their tolerance which is a (+/-)ve value. for sample:18K 1/4W ±1%. while restoring the data on a test system i observed a special character before …

SQL 2008 database disappeared after canceling copy Hi All, We have an SQL 2008 database of around 12GB. I was trying to create a copy of the database through the Microsoft SQL Management Server Studio. The server is in production mode, and it was taking too long to copy, and …

I want to get the list of items from a database as a Java resultset. When I use the following SQL statement it works perfectly fine [CODE]SELECT First_Name FROM dbo.Names where First_Name LIKE 'A%';[/CODE] However when I pass it as a parameter, it does not work I have tried a …

I can find a lot of information about the concepts of normalization, but I don't really see documentation for how to actually bring a table, for example, from first normal form to second normal form. I'm using SQLite through Python to automate some data processing, and I have three input …

I need to write a query that will get the value of a previous records and add it to the current record. In detail: I have a table (Table1) that contains PolicyNum, RecordID, and SequenceID PolicyNum RecordID SequenceID 123456 456 0 123456 456 0 123456 789 1 123456 789 1 …

hello guys, I am doing a project that deals with the mining and pattern finding from a medical database. But the problem is that I can't get a medical database. If any of you please help me getting a one, will be a great help for me. In other case …

Hi guys, I've started learning SQL after spending several years in the industry. I've got a table defined ... [code] CREATE TABLE [dbo].[Computer]( [Id] [int] NOT NULL, [Name] [nchar](10) NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS …

Hi friends, In one of my table I stored some names of students . I need to select all the names starting letter "A" or "a" .... Please help me Thanks in advance Rajeesh

Hi, I am learning store procedure. my table structure is user_id int(9) primary user_name varchar(100) user_first_name varchar(100) CREATE PROCEDURE Sp1(OUT p VARCHAR(100),OUT p1 VARCHAR(100),IN p2 INT) SELECT user_name,user_first_name INTO p,p1 FROM pm_user WHERE user_id=p2; CALL Sp1(@Name,@Fname,2); SELECT @Name,@Fname; Output comes like @Name @Fname [BLOB - 0B] [BLOB - 0B] How …

Hello All, My problem is, i have one database and application in web server, another application in local server which is having another database . But some tables are same in database server and in my local database. I want to update these particular tables from data base server into …

How to recover data from .ibd file if innodb is corrupted I have one test database and many table with the extension of .frm and .idb file. from frm file i got strucure of database but how to restore data from individiual file of .idb file.

Hi friends, I had a database table as follows ... Id | Film Name | Director | Cast | ---------------------------------------- 12 | Dhoom | Name | 123,128,125,458,12 12 | Dhoom 2 | Name | 129,158,147,455 ------------------------------------------------ I need search by cast column For eg : If I select :- [ICODE]select …

I'm making a visitor management application and I made three tables namely tblStudent, tblEmployee and tblVolunteer in SQL. I made a table according to the categories of a visitor. Do I still need to make a tblVisitor that would be the "general" table for the three tables made? I'm really …

In my hosting account I have set up a database named george. There is one table named "news". There are three fields "id" (primary key), "date", and "text". I am keeping this simple for illustration. What is the best/easiest/fastest way to import the data or records to the table via …

$sql = "UPDATE USERS SET password='changed password' WHERE login = steve"; header( 'Location: [url]http://steveworld.000space.com/prof.php[/url]' ); this is my code, im trying to allow users to change their passwords at anytime, I put in a set text and it still doesnt work, it is very agitating!

[FONT=Courier New]I have been told that views in MS SQL aren’t very good to use. Let’s say that you have a view X with 2 columns Car and Color that looks like this Car Color ----- ------ Alfa Yellow Volvo Yellow Volvo Blue Ford Yellow Ford Blue If you then …