Databases Forum

I have a MySQL table table with two fields: id and name. id is primary key with auto_increment. The thing is when I insert a record and then empty the table, and insert a record again, the id value does not start from 1, it keeps increasing even though the …

can anybody tell me what is wrong with my sql statement because it runs well if their is only one or but when I put another or it gives nothing to display [CODE]"SELECT * FROM tbldoctor_info i, tblmonday m, tbltuesday t, tblwednesday w, tblthursday h, tblfriday f, tblsaturday a, tblsunday …

Hi, I have created a database, where it is possible to create posts and see them on a different page. On the page where it's possible to see all the records I want to create a delete link so it is possible to delete the record where you have pressed …

Hi, I am having problems with deleting part of a record. The record has approximately 15 different fields, and I only wish to delete 3 of them using the following piece of SQL coding: DELETE [PMID 1], [PMName 1], [Price 1] FROM Subscriptions WHERE [Customer ID]="001" The code works absolutely …

I have to create a stored procedure that will view data from a table. The user will audit the data, with paid dates. The user comes back to the view report, check/select all lines that have the same paid dates to change. The user will enter the paid date, then …

Hi Friends!! I am coming across this problem that whenever I am trying to retrieve the data in a dataset Through database, it is taking around 10 min to get the data no the localhost. And when I am running the same code on the live server it doesnot take …

hi , i have a textbox control in one sheet and a range of data in another sheet in the same file. how do i copy the range of data in paste it in the textbox control? appreciate a reply thanks

Hi friends! i have a drop down combo box which holds names of persons with php mysql order by asc query like a's name put in 1st and after b's and c's and in last it shows z's name now i want that if it will show tahir name in …

$dbQuery="select id, name from artists where name like '$keyword%' order by name asc limit 15"; $dbResult=mysql_query($dbQuery); echo mysql_num_rows($dbResult)."\n"; while ($dbRow=mysql_fetch_array($dbResult)) { // for each artist, return the number of albums belonging to that artist // use a separate query here to obtain the number // return the number after the …

how to create a short summary form in Access Database? I have created a database in which I have created 4 tables 1. Pregnant Women Data 2. Feedback of Pregnant Women Data 3. Traditional Birth Attendants Data 4. Villages Data I have registered 3397 pregnant women, and issued some women …

I am working with a database application and am currently having a problem in joining the tables.. Table 1 : Materials -- Columns (item_code PK,item_name,p_rate,n_rate) Table 2 : Projects -- Columns (proj_id PK,proj_name,etc,etc) Table 3 : Proj_Mat -- Columns (id PK,item_code FK,proj_id FK,qty) Here Proj_Mat works as the bridge table.. …

I am creating a shared database to record requests entered by a team of 30. I need to record the Order Number, Reviewer Name, Date, Action Type(Order Type), Client Name, and a comments box for each order entered. When creating forms, Currently Reviewer Name and Date are auto-input so the …

Hello every one, I have a question about creating users in Oracle using SQL*PLUS. But what I want to do is write the syntax in a txt file first (script) then when I run the script by calling it using the @ or by copy/past it should prompt me for …

Hello !! I need help fot the following situation: I have 2 tables: test1 and test2: each one have the same columns name: data test1: column data values (black, white) test2: column data values(white,black,orange, yellow) what sql sentence i can use to show only the values (orange, yellow) the difference …

Hi, How do I design a table column named UpdateDate that will give the default date and time upon inserting a record into the table I'm using Enterprise Manager in MSSQL Many Thanks

After INSERTing record(s) to payments_table (from paypal IPN), $query = "SELECT sum(payments) FROM payments_table WHERE customer_id='{$customer_ID}'"; $result = mysql_query($query); //get the value from result here $query = "SELECT customer_id FROM discounts_table WHERE customer_id='{$customer_ID}'"; $result = mysql_query($query); //if row > 1 //loop until reached a certain condition THEN genarate a NEW …

Hi! I have a table for payments what I want to accomplish is: once a certain customer Id reached a certain amount by his accumulated payment, it will trigger an insert into statement to my discount table to generate a code specifically for him. i understand thats trigger is only …

Hi all I have following table structure [CODE] pk_cat_id(int) cat_name(varchar) cat_desc(text) fk_cat_id(int) [/CODE] table is self related as one to many i want to select cat_name, cat_desc and parent_cat_name() i.e. from fk_cat_id, how i can get cat_name

Hi I am trying to cross join 3 tables and use the values from this to calculate cumulative Accuracy for each student. But I am missing some students name when they dont have values in one of the tables. Eg: [CODE]mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); // to …

Dear All, I have a system with the web server(apache) and db(mysql) server install on separate machines. So at times when the traffic is high I can not access my system. So first I would like to know where is the error and where is the error log file will …

can anybody help me how I can use four tables at the same time with different conditions to fetch records from my database? this is my sql code that im trying to modify because this is only for two tables: [CODE] <?php session_start(); if (isset($_SESSION['username'])) { include("database.php"); $username = $_SESSION['username']; …

Hi Guys, I willing to hear your suggestions and advice regarding a problem of DB design in MySQL. The situation is that I need to develop a DB design which brings High Performance under the following conditions: + There will be 10000 users that will consump and generate data. + …

Hi all, SQL definitely is not my area of expertise, so I need help with something. Suppose I have 3 tables (I'll try and keep this is as simple as possible): - User (with UserID). There are 13,000 records - Status (StatusID as the PK). There are 10 records - …

I have developed following web service in vs2008 but cannot resolve th following error System.Data.SqlClient.SqlException: Arithmetic overflow error converting varchar to data type numeric. here is my web service code using System; using System.Linq; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml.Linq; using System.Data.SqlClient; using System.Data; using System.Configuration; [WebService(Namespace = …

Hello again I have two questions regarding the REPLACE command. The first query I am running is [CODE]update phpbb_posts set post_text = replace(post_text, '[del]', '[ b][ i]') update phpbb_posts set post_text = replace(post_text, '[/del]', '[/i][/b]')[/CODE] Note - in the above code I have had to add a space before the …

is it possible to create a view with a primary key.. if so... how can i do that using a query of t sql.. anyone.. help..:?:

Hi, I am trying to transfer values in one table to a new table with a different structure. The current table has 3 fields id, content_id and value and for each content_id there are several records. I would like to transfer the values for each content_id to just 1 record …

Hello guys I am having a problem regarding queries in PHP because I not very familiar with queries especially inner join function, I need to make a profile page wherein it will display records from tblpatient_pass and tblpatient_info connected by (PK)MR_no from tblpatient_info and (FK)RelationMR_no from tblpatient_pass here is my …

The query below is correct. It returns the rows `paul` and `rick` because they have the highest rating of the child rows. This was solved for me with the below link. I am having trouble understanding the query. I understand joins, what i don't understand is `t2.rating is null`? [URL="http://sqlfiddle.com/#!2/97e60/2"]http://sqlfiddle.com/#!2/97e60/2[/URL] …

Hi, I am making a website for a car database. I made a table called Cars with fields Name,Make,Model,Color,Doors. I have also made a search function: [CODE]SELECT * FROM Cars WHERE Name LIKE '%$search%'[/CODE] This is a general search that will search the whole table, but what if I wanted …

I set up a MySQL databse following this tutorial: [URL="http://www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/"]http://www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/[/URL] Here is what I did: [CODE]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51a-3ubuntu5.1 (Ubuntu) Type 'help;' or '\h' for help. Type …

Hi thought i'd try here see if anyone can help solve this quicker. First off we have a email database. The main table is the email data, all unique rows per email address with a unique id. eg. emailid,email 1,email@example.com 2,email@example.co.uk Next we have another table which logs the data …

I have bought a legal copy of SQL Server 2000 to put on one of my websites but can't seem to get it to load. Any ideas?

Hello, I have a table with clients: id, name, email and the likes I am looking to find all ID's where emails are the same, I tried the following [code]select db_email, db_medlem, count(*) from kunder group by db_email HAVING count(*) > 1;[/code] however this generates an error due to not …

I would think that this wouldn't be a complex thing, but I guess I'm wrong. I want to create tables in a database based upon a string created by input variables including a parent ID. My Code: -- create table named the value in @newname SELECT CONCAT('Entity_', @@IDENTITY) into @newname; …

Hello, I am trying to populate a spreadsheet using Access data, however I am having trouble with the line noted below, which is giving a run-time error. I am not familiar with the Excel Object Model, so not sure how the "selection, range, etc" should be used. Any help and …

Hey guys I was hoping I could get some help with the design of this database. If need be, I'll try to explain it best I can of what it's supposed to do, I think I have most of it set up right, I just think something is wrong with …

I know this might be a very simple one, but yet I can't figure that one out! How do I get data from one table that are not in another? Let's say Table ServerA has: IP, User, Password, Table ServerB has: IP, CanConnect. If ServerA has 20 rows and ServerB …

is it possible to have a script that when i run that script it will log into a database and delete all the entries from specific database tables? if it is how would that look for database name "test" and "table 1, table 2, table 3, table 4 and table …

How to connect mysql with difference server If my all file is in 192.168.0.100 and mysql server is 192.168.0.200 I got Error "sorry, could not load your data, please try again later" when try it. If bote all file and database is in same server , It run correct. [CODE]<?php …

hi frends i m in fifth semester of engg in info.tech and i need info abt projects of database particularly hospital and railway reservation management pls send me informatuion from where i can get these projects and front end of projecs shuld be in visual basics VB

How can I ensure that the stored procedure below is able to use either one or all the parameters to filter records from a table? CREATE PROCEDURE ABC @StartDate datetime = null, @EndDate datetime = null, @UserId varchar(255) = null, @AccNo varchar(255) = null AS BEGIN IF @StartDate IS NULL …

I am using Doctrine as my ORM and it only reads XML/YMAL files and I was given a schema in form of MySQL script. Is their anyway to dump a MySQL db to a ymal file?

hi everyone, I wish to share the mdf file on the network so that other computers can use the file to capture or retrieve the data. Is there any way I can do this on MS SQL SERVER 2005?

Below dynamic query will set StartDate and EndDate to 1st of March to 30th April as UK financial year. DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 …

Hello Guys, I am trying to get the data from two columns of two different tables using Join as combining them as a whole to insert into dropdownlist... The situation is like this: There are two tables named tblPropertyCategory and tblPropertySubCategory.. I have PCName in tblPropertyCategory and PSCName in tblPropertySubCategory.. …

hello iam started taking oracle 10g i have few doubts please clear me for example create table employee (ename varchar2(10),salary number(7,2)); what is the use of varchar compared to character??? what is number(7,2) i mean 7,2 i dont understand please explain me

Well, when almost finishing this tutorial: [INDENT][/INDENT][url]http://msdn.microsoft.com/en-us/library/ff677562.aspx[/url] I found a problem on connecting the Add-in to the database, and so the lobInstance can´t be opened: [url]http://i.stack.imgur.com/AFzie.png[/url] This is the error code. (in fact the error message was being popped out when the Excel 2010 client starts, but I commented the …

Hello, I want to do horizontal fragmentation of a table say employee. But fragmentation is often related to distributed databases. So i want to ask how can i do this on my single home computer? Could anyone list out the steps that should be performed. I saw the concept of …

Good Morning... First let me start by thanking those of you that respond with great education information in here.. You have made my learning curve (time invested) much shorter than it would have been with just a reference manual. I know I still have a lot to learn, but this …