Databases Forum

I am running a script on our production database reffering two tables : our table of users (3700 of them) and the table of quotes that they have made (280000 of them). Quote is the main object in our application, a very large object, for whom many data tables are …

I've installed mysql 5.5 to work with php.From the workbench I tried to connect first time, impossible.I've allowed the program through the firewall,nothing.I read all the tutorials on the subject, still I don't understand one thing. How do I set admin privileges if I cannot connect? If I run the …

Hello guys, Do anyone know how to write recursive SQL statement for hierarhic output places from next table: id-----place----------idParentPlace 1......World..........Null 2......Europe.........1 3......Mediterranean..2 4......North Europe...2 5......Italy..........3 6......Greece.........3 7......Island.........4 8......Norway.........4 I was looking for alot of tutorials but didn't find anything useful. Any help is the most welcome! Regards, TP

Hi all, I'm trying to use recordset to create the following query: $query_GetCurMonthPlayerGoals = "SELECT PlayerName, Goals FROM ( SELECT PlayerID, COUNT(*) AS Goals FROM Master WHERE TeamID=$row_GetTeamDetails['TeamID'] AND MONTH(GoalDate)=MONTH(CURDATE()) GROUP BY PlayerID ORDER BY Goals DESC ) T INNER JOIN Master_Players ON T.PlayerID=Master_Players.PlayerNameCode"; The problem I am having is …

Hi, is there another way of hiding or formating column value in asterisk in select statement? im using the command replace SELECT REPLACE([Item].[Price],[Item].[Price], '**********') AS Price From Tablename it works fine, but is there anyway to do this? Instead of replacing/forcing the value to display asterisk, i just need if …

Hi guys I have a little mess up in my head going on i dont really know why. My question is how come a right join AND a left join were made to handle database queries, why both of them, isn t one enough? for instance let s take the …

I published my project in vs2010 and im trying to deploy it to other computers. I used this connection string that runs smoothly on my pc. This code tries to retrieve the servername and try to connect to database mysysDatabase. This forcely change the app.config. Private Sub btnOk_Click(ByVal sender As …

The following optimized select query select ***consecutive*** rows, i.e it chooses the first random row and the following ones will just be the ones below it: SELECT name,r1.id FROM entries AS r1 JOIN (SELECT (RAND() * (SELECT MAX(id) FROM people)) AS id ) AS r2 WHERE r1.id >= r2.id ORDER …

I've been having trouble with an UPDATE statement in the code below. The problem is that each time I submit the form to update an existing record in the products table, the records won't update. When I submit the form there is no error message and it redirects to the …

Hi everyone, i would like some help with a couple of mysql queries. I have a table of data which looks like this :  And represents a transaction log for players of a game. The ID is the primary key (auto incremented). DATETIME is the date and time …

i have 3 tables. leave_cri:typs of leave allowd 4 an emp leave_eli:all typ of leaves leave_detail:details of leave taken by an emp i need 2 write a query 2 select data based on these 3 tables. ie) i have 2 display these in a grid. leave details from_leave_details ; leave …

Hi. My web hosting provide will charge me extra money if I want to do backup to my mysql database. My size of my db is very small but I've alot of tables though. What's the best way to backup my database schema and data in a way so I …

Hi, I let say I use this code to retrieve date from database SELECT Table.Date FROM Table The format is 01/09/2013 (dd/mm/yyyy) How will i format this to get 09-Jan-2013 output then print this format to crystal report? I'm using dataset to connect data to crytal report I just noticed …

Hi all, I'm unable to get the below update SQL to run in Oracle, it's giving me th below error ORA-00933: SQL command not properly ended. Any help appreciated. UPDATE PDR.PH_Family_Match_by_Chassis a SET a.Launched = 'Y' INNER JOIN PDR.domCHASSIS ON a.chassis_id = PDR.domCHASSIS.chassis_id INNER JOIN PDR.domCHASSIS_MODULE ON PDR.domCHASSIS.chassis_id = PDR.domCHASSIS_MODULE.chassis_id …

I'm attempting to make a web-based scheduling system, but I'm having trouble figuring out how to make it work in the best manner. First, the current table structure: **shifts** Shift_ID (pk) Event_ID (fk) Dept_ID (fk) Start End **shifts_assigned** Entry_ID (pk) Shift_ID (fk) User_ID (fk) DateAssigned Position Notes Where pk is …

Hello, I was wondering if there anyway to Select rows where the date column falls into a certain range? For example, heres a table [code] The date field is generated automatically by MySQL with the DATE function Heres the table: [user] . [wins]. [date] bobby.......4..... 2006-08-21 boby1.......3..... 2006-08-22 boby2.......6..... 2006-08-24 …

Hi all, This is a follow on from my last post. Here is my current query: SELECT * FROM ( SELECT * FROM ( SELECT TeamID, PlayerID, COUNT(*) AS Total FROM Scored WHERE MONTH(GoalDate)=12 AND YEAR(GoalDate)=2012 GROUP BY PlayerID ) T GROUP BY TeamID, Total DESC ) T GROUP BY …

Hi, I'm having trouble to filter a Customer Set by the date of his first buy(First Activity). I've tried this two ways: 1. Returns all customers, even with FirstActivity Null SELECT { [Measures].[Valor Item], [Measures].[First Activity] } ON 0, { Filter( { [CLIENTE].[Cliente].[Cliente].Members }, ( [Measures].[First Activity], [Time].[Year].&[2012-01-01T00:00:00] ).Count > …

I am trying to create an application which will send a reply back once a customer (registered user) sends a a question to the system. The application will select the correct answers (based on keywords) from a database and send it back in SMS to the customer’s mobile phone. For …

Hi all, Regarding a football (soccer) league: I am trying to find the top goalscorer for each team in the league in December 2012. Each time a player scores a new row is created in the table "Scored" with their name in it and their corresponding team and the date …

Hi everyone, I would like to ask a question about MySQL. Say, I have a database like this: database 1: articles |- id |- title |- description database 2: tags |- id |- articleID |- tag I needed to search from articles.description and tags.tag and while doing so, the searched …

Hi guys ! I am newbie, I have downloaded oracle 11g release 2 but i don't know where to start and how to connect C# program to database. I want to write simple program of username and password in which I it stored in database. And also maps the username …

Sir, having a problem. I have two tables i.e directives and para_comments_sect. there is no direct connection with each other . what i want is to get the data field from directives and para_comments_sect of para_id=15 ( its a foreign key from para table). any suggestions and guidance for it …

Good Morning, This may seem like a very basic and simple question from someone that has been doing programming as long as I have, but it is something that has always eluded me, and I've never taken the time to ask, so here it is... When I am doing queries, …

Hello Floks, I have been working on a database design for my company which is in the filed of calibration. I have came up with thae attached design and i need you to give me feedback.

Good Morning... I seem to be having a problem getting the data that I want from a single query... I have a table that contains various information on record processing it has an auto increment field called period_id also a field called max_pl_trans What I need to be able to …

My case is Input is "abdknmgbm". BUT The record in database that i want to query out is "abkdnmgmb" The input and database record is quite similar. String length is same, only some arrangement of character are not same. In the above case, dk and kd ; bm and mb. …

hello! I got this error when I tried to connect to my db in sql server. > Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 8945dcd8080cc91' or one of its dependencies. The system cannot find the file specified. …

Hello I had a problem uploading or adding a file on the database and shows the error stated on the title. The column holding the binary data was set to varbinary(MAX). I couldn't find what was my error because I was able to upload a 900kb MS Word Document but …

hi i want sql query to insert encrypted passwrd ?? foreample if user password : 123456 what is the sql query to insert it incrypted

Heres my statement: SELECT A.AccountID, A.LastName, (SELECT SUM(InvCurrency) FROM B WHERE B.BillingPeriodStart Between '2012-01-01 00:00:00.000' AND '2012-12-31 23:59:59.000' AND A.AccountID = B.AccountID AND StatusID = 1 AND (ServiceCode=13 OR ServiceCode=14) AND (ServiceCode=15 OR ServiceCode=16) AND (ServiceCode=17 OR ServiceCode=18) AND (ServiceCode=19 OR ServiceCode=20) AND (ServiceCode=21 OR ServiceCode=26) ) AS 'Paid' FROM …

Good Morning, Hopefully someone can help me with a quick answer. I have a transaction table with a 'description' column that contains a combination of the members name and some static information i.e. "'username' PURCHASE" or "'username' PAYMENT" and a 'type' column that contains various types of transactions i.e. 'FEE' …

select a.EID, b.ShopName, a.TxnMonth,a.TxnYear,a.TxnDate, a.TxnAmount,a.TxnDay,a.DateCreated, a.SubmissionType from [UA-DCM]..DCM_FTPDailyData as a Inner Join [UA-DCM]..MMS_ECR as b on a.EID = b.EID where a.TxnDay between DateAdd(day,DateDiff(day,0,GETDATE() - 14),0) AND DateAdd(day,DateDiff(day,0,GETDATE()),0) and a.SubmissionType = 'ECR' or a.SubmissionType = 'FTP' and b.AssetID = '71' and a.TxnAmount not like '"%' and a.EID = '7100101001' Order by …

Dear All, I'm facing a problem when using DISTINCT in mysql. Please refer my database design below. id lang album singer title family writer song hits In my db i want distinct title and the id from the db. I'm trying the following code. But it only fetching the results …

This is my word "नमस्कार". (It is Indian language (Marathi language) ) mysql is showing like something in image attached How to store Unicode characters to Mysql to show properly?

how to get values from other table to update table

what is the syntax to insert an image to mysql table

Hi everybody, I am in the process of building a small web application which will hold around 10 pieces of information for every person inserted. Due to data protection the majority of this information must be encrypted. Using the CodeIgniter framework and the CodeIgniter encryption class I can encode the …

Hi all, I am attempting to rename a file using the File System Task Editor in SSIS. In the Expression Builder, I have @[User::fileName]+(DT_WSTR,2)DATEPART("mm",GETDATE())+(DT_WSTR,4)DATEPART("yyyy",GETDATE())+".zip" but it returns the following error: > TITLE: Expression Builder >------------------------------ >Expression cannot be evaluated. >------------------------------ >ADDITIONAL INFORMATION: >The data types "DT_I4" and "DT_WSTR" are incompatible …

Hello all. I want to know whether it is possible to retrieve list of all tables found in a particular database titled 'Company'? It have got several tables with the names, Suppliers, Customers, etc etc. Just like Oracle, where you retrive all tables using select * from tab; . Is …

I'm creating a password protected Volunteer Database and everything is going well. I have created a 'password protected' form before entering the hidden database(seperate form). How though am I able to prevent a 'user' to find out the password by going through "Build Event" in Access?

Wow.. I guess I must have been living with my head in the sand for a few years. I write everything using PHP/MySql, and now it seems that eveything I am reading is referencing MySqli... So I started researching that and found that it has been around for years and …

Hi Guys....i am facing a small issue with an SQL statement here. Will you be able to help me out? I wanted to grab the page title, page author's name which is in the users table, the no of comments, and the page publish date. "SELECT * FROM pages INNER …

I don't quite understand how to make a Procedure as most of my processing takes place in my scripts. I have a set of 3 Queries that are almost identical that I would like to combine them to return a result set. The queries are: SELECT Date, Location, Sum(SubTotal) FROM …

In my database table, 16 rows are inserted with null values for all columns. How can I delete these rows using SQL statement?

I need to update values form one table to another and create values if they are not there How can I do this for all values or form values from one ID to another This is the query but I need to run it for every ID and that is …

Dreamweaver 8 in windows 8 with xampp following 2 errors 1) Unidentified error occured 2) There is no testing server found on this server machine /.php> These are occured When clicking on plus then MySql Connection dialog box opens Connectin name - Con MySQL server - localhost user name - …

script in file 1 <?php // Check if he wants to register // - Make sure that param exists // - Check length if (isset($_POST['username']) && strlen($_POST['username']) > 0) { // Check if passwords match. // - Make sure that params exist // - Check length // - Check matching …

Hey guys, I'm working on a job. I need sql statement for the following query: "List all Employees Names with equal ages." (If possible, along with their year of birth, or date of birth.)

hi friends, i am using oracle 10xe edition, when i use "select * from tab" in between other table name i found "BIN$VAmBblokS5GK+8YXdhI5EA==$0" give me tips to delete this. thanks for your time.