Databases Forum

DELETE * FROM image_upload WHERE image_id=51You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM image_upload WHERE image_id=51' at line 1 if(!empty($_GET['image_id'])) { $sqlstr = "DELETE * FROM image_upload WHERE image_id=".$_GET['image_id']; //echo $sqlstr; …

hy, i'm having a big problem, thats because i'm new in this, i have two qrys unfort doesnt work if(isset($_GET['id'])){ $id=$_GET['id']; $qry=mysql_query("SELECT *,replace(category, ',', ' ') as category FROM articles WHERE id='$id'", $con); $sql = mysql_query("select *,Total17,sum(q5) Total18,sum(aste3) Total19 from articles where category= how ?",$con); if(!$qry){die("Query Failed: ". mysql_error()); } …

I am trying to look on the web for a way to create a stored procedure that I can run and then put in multile values and this is the closest I can find: CREATE TYPE dbo.EmployeeList AS TABLE ( EmployeeID INT ); GO CREATE PROCEDURE dbo.DoSomethingWithEmployees @List AS dbo.EmployeeList …

The above date is stored in varchar type i want to display the error date for rectification. so i tried NOT LIKE '__/__/____' but it didnot work. I want to display the records which does not have the 02/02/2000 pattern. thanks

I have the following table: Region IdDescription IdUser Metropolitan Right 5 Metropolitan Left 6 Metropolitan Right 5 Metropolitan Left 6 Country Town Right 5 Country Town Left 6 Country Town Right 5 Country Town Left 6 Metropolitan Right 7 Country Town Left 8 And I want to query the kinds …

hello! Being a newbie (70 years young) I an trying to complete this php code so my search-form with a multichoice-checkbox may return a selected response on a webpage from mysql 5.4 database. So far I have this query that is working BUT returning ALL members from the DTB regardless …

Hi guys, I hope this is the right section to post. I need to develop an application in visual studio 2012 that uses SQL (please bear with me as I'm not very well versed in databases and SQL and therefore I don't know what SQL visual studio uses), and when …

Hi guys, I'm building a small asp.net application about montlhy expenses. I was given a bit of guidance in this thread https://www.daniweb.com/web-development/aspnet/threads/488532/building-monthly-expenses-application about how to organise the database. The situation currently is this. I have 2 tables in the same database, table "expenses" and "expenseCodes". The first contains the following …

hello i have a column named products in which differernt shops and businesses insert their product names..if it is like a stationery shop it will be saved as TEXT column as [pen,pencil,sharpner,book,copy,fluid,marker,gel pen,ball pen]...in performance point of view whats the best way to find a sub-string in this column...??? like …

do mysql create another table when selecting rows?if this happens it will take up lot more space on hard disk as duplicate entries will be risiding in table formed by "select"...

This is my billing table in my sql: id pid quantity total discount price customer 1 1 2 20.00 5.00 15 a 2 1 2 20.00 3.00 17.00 a 3 2 3 15.00 2.00 13.00 b 4 3 1 2.00 1.00 1.00 a This is my product master table id …

Hi All I am developing win app so for that i am looking for database of indian State and Its Cities, tryed on google but failed Please help me if have any idea Thanks In Advance

Hi I do not know how to sum the one of the column in #table temp table It is my SP SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[usp_Customer_Due_Until_Now] @Code nvarchar(30) AS BEGIN SET NOCOUNT ON; select code as Code, Name as Name, sum(Nett) SINETT into #tableSI …

Hi I have an issue in store procedure. Error is Msg 4104, Level 16, State 1, Procedure W_usp_SO_Table, Line 38 The multi-part identifier "dbo.SVendorMaster.SVCode" could not be bound. Insert table is working fine. But update command is prompt the error Pls advice me Maideen Here is SP SET ANSI_NULLS ON …

Hi, can anyone please help me to find out a solution for the below mentioned problem?? While installing oracle 11g in linux on a remote desktop, failed dependencies occured when installing rpm packages [i want a soluion withou using yum software] [root@TomcatServer Server]# rpm -Uvh gcc-4.* warning: gcc-4.1.2-44.el5.x86_64.rpm: Header V3 …

This is my billing table in my sql: id pid quantity total discount price customer 1 1 2 20.00 5.00 15 a 2 1 2 20.00 3.00 17.00 a 3 2 3 15.00 2.00 13.00 b 4 3 1 2.00 1.00 1.00 a This is my product master table id …

I'm new to mysql and I need a ralationship 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 …

This is my output tabe: name SUM(billing.quantity) SUM(billing.total) SUM(billing.discount) SUM(billing.price) pen 4 40 8 32 pencil 3 15 2 13 rubber 1 2 1 1 Using : SELECT productmaster.name, SUM(billing.quantity), SUM(billing.total), SUM(billing.discount), SUM(billing.price) FROM billing AS billing LEFT JOIN productmaster AS productmaster ON (productmaster.id = billing.pid) GROUP BY billing.pid ORDER …

` how do i change from msql to msqli the below statement, am learning this mysql but keep getting Deprecated error. And where can one get an easy tutorial on how to make the changes. thanx $displayImages = ""; if($_GET['cat'] == "juice") $sqlSelProd = mysql_query("select * from tblproduct where prod_cat …

I'm making a kind of address book thingy and seem to have confused myself on the best way of organizing the tables. At the moment, I have two tables, Contact and Number. Here's a basic representation of my tables: ___________ | Contact | |-----------| | cid | | fname | …

I have an issue in select query. I want to select total_comment From comment table and show it under each post. **What I Try** SELECT SUM(total_comment) AS comment FROM user_comment INNER JOIN post ON user_comment.image_id = post.id WHERE status = 0 **And** SELECT SUM(total_comment) AS comment FROM user_comment WHERE status …

Hello, I need a little help with trigger, I have been doing database development for a long time now but this is my first go around at a trigger. It is not working, can someone please look at this and let me know what I am doing wrong: ALTER TRIGGER …

I was wondering if the following was possible with a query? If so, can someone give me an example query? I want to print a list of products, group them by color, and then have the totals at the end of each group. | Color | Product | ------------------- | …

I am trying to do a check to see if a student meets the prerequisite before they can register for a course section. CourseSecID = 27 (ID of the course section the student wants to register for.) What I am doing is querying the student's acad cred records to see …

cannot update the db with below query. little help will be much aprreicated. Thanks in advacne $order_number=$_GET['order_number']; $invoice_id=$_GET['invoice_id']; $credit_card_processed=$_GET['credit_card_processed']; $total=$_GET['total']; $key=$_GET['key']; $email=$_GET['email']; $query = "UPDATE register_users SET order_number=$order_number, invoice_id=$invoice_id, credit_card_processed=$credit_card_processed, total=$total, key=$key WHERE email=$email";

Am creating an online examination website. I need to store the answers answered by the participants who are given a unique ID. So I will be storing ID, Answers for the question, score. So I think I have two ways to do it. 1. Create a table for every student …

Hi, I own a business and through the business, I have amassed a large collection of training information and other things in the form of cds. For ease of access, I have ripped all my cds to mp3 format and stored them on my computer. This is not illegal and …

I have a table with in ms access with fields like . LoginID, UserID , CheckInTime 101 , 122 ,10/27/2014 4:32:27 AM iwant to filter the data in my vb.net form by date . what query i need so that i can filter the data by date? so that when …

I need to know if there is a way to improve the below function as it takes long execution time UserDefinedFunction [dbo].[GetChildrenAccount] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[GetChildrenAccount] (@AccountID INT, @DateFrom DATETIME, @DateTo DATETIME, @TypeTransaction INT, @Currnecy INT, @Branch INT) RETURNS DECIMAL(18,3) AS BEGIN DECLARE …

i was trying to login to this website I'm trying to create and i got this error: > Connection failed: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) please help me. TIA!

Dear experts I am running one mysql query which contains selection from multiple tables.The problem is sometimes the query runs very slow, but sometimes it is ok.Acctually when i run it first time it is very very slow, and from the next time it becomes fast.I wonder if it is …

Good day! I have 3 tables name property, personal and spouse, they have all the same id. I want to join the 3 of them, I had already join property and personal table but I can't join the spouse table. $userquery = mysql_query("SELECT * FROM property, personal WHERE property.id=personal.id") or …

I want to find who is the heaviest borrower among the student and displaying Sname and heavy count. I have the following tables. tablename student having attributes SID,Sname,Spho. tablename sborrow having attributes SID,CDID,borrow_date,return_date. tablename Cd having attributes CDID,title. I have executed the following query in Mysql but it gives me …

Hi! I am currently working on my thesis and I don't have any idea on how can I view the records stored in 3 mysql tables. Can someone please give me some code regarding on this. The records should be displayed in a table form then when you click a …

Good day! I am currently working on this code. My problem is that the delete option don't function. It gets the error "There has been a fatal error." as stated in the code, so please help me to fix this code. Thank you <html> <head> <title>Buyer's Profile</title> </head> <body> <?php …

I really would like to know the best way of going about this issue I need to union 2 select statements and then do a select statement from result of the union

Get records between date for example in mysql 2009-08-11 to current date 2009-08-11 is to retrieve all date , this is just an example I have tried WHERE time between date(time) and DATE(time) = CURDATE();

What do you think about PL/SQL ? Is this a language worth learning for the feature along with SAP?

I need to change the timezone of mysql to 'Asia/Calcutta'. I am on shared goaddy hosting. Please tell me how to do the same

hello i wanted to insert data into database like html format i mean i text wich contain html tag like H1 H2 OR P, and any basic other i must use BLOB OR LONGTEXT, if i uses BLOB i must enter that directly in database or upluad that file ?? …

Hi, Im trying to extract data from sql server where conditions are multiple and variying I have a datagridview with 2 columns ID and Name I need to create Select Query to extract data where condition is 'ID should be equal to the value or values in Datagridview ID Column. …

I need to know how the primary index is classified as a sparse index? The sparse index as described by some aticles and books has index entries for only some of the search values and has a fewer entries than the number of records in the file. When you make …

Is there a way to get a total counts from the resultset of two unions? This will be for DB2. select count(*) from ( select count(*) from xyz where abc='1' union all select count(*) from x1y1z1 where abc='1' )

A clustering index is an ordered file with two fields; the first field is of the same type as the clustering field of the data file, and the second field is a disk block pointer. There is one entry in the clustering index for each distinct value of the clustering …

Good afternoon, I'm drawing a complete blank on this, and decided someone in here could answer the question for me without an issue. I have a mysql DB with thousands of records in it, and over time have used an inadequate system for maintaining terminated records. I've been simply prepending …

Hi, I have to correct some data in SQL Server 2008 R2 database for an accounting system that was accidently over written. Basically I've to take stock items with fixed prices and compare those fixed prices against Sales Order Transactions for the stock item and correct entries where the transaction …

Hi all i need to update some iframe values in my videos table, embed column. Can I achieve this with this kind code below ? I tried already but i got syntax errors. Please help me. here is the code type of column embed is text. UPDATE videos SET embed …

I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change …