7,494 Archived Topics
Remove Filter  | |
 | I don't need the exact query , just the logic of how I should go about it: I need to compare for equality all records of a table for a given set of fields. If count of such similar records exceeds a particular value, I have to delete all those … Databases mysql |
| | hi guys I really need some help I don't quite understand the instructions in our homework, I uploaded it below for your reference. Please explain to me how to do the things required on the instructions, it's not clear to me at all. Thank you for those who will help. … Databases oracle |
| | Hi I have 2 Tables: CREATE TABLE IF NOT EXISTS `questions` ( `question_id` int(11) NOT NULL AUTO_INCREMENT, `createddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updateddate` timestamp NULL DEFAULT NULL, `active_flag` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`question_id`), UNIQUE KEY `id_UNIQUE` (`question_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE `alarts` … Databases mysql |
| | Okay, I am a total newbie stuck with the following task. I have one table, that looks like this: | id | name | rating | date | ------------------------------ What I am trying to do is gettin an output showing which 'name' has the best 'rating' based on months, showing … |
| | I need a suggestion on the scenario I have, multiple application sharing same data. -I have a set of tools which is developed independetly, but there is a set of data they share. -Its around 7 Applications sharing some of the basic data and few data are specific to the … Databases |
| | I forgot the way to write a query where you can psuedo name a table, for instance I have a table named user but I have to access it twice in one query and I want the results to be different. something like select user(a).f_name, user(a).l_name, user(b).f_name, user(b).l_name from user(a), … Databases mysql |
 | In MS Access2007, I want to query ([I]q_Notes[/I]) a table ([I]t_Notes[/I]) in which one of the fields ([I]t_Notes.Topic[/I]) is populated from a Combo Box based on a field in another table ([I]t_Topics.Topic[/I]). I will have a table of several hundred records. I want to use the q_Notes query as the … Databases microsoft-access |
| | Hi, I have a question that can we use a mysql query in Concat clause. I want to make a query like this SELECT CONCAT(AVG(value),'-',(select Count(UserId) as counts from user_details )) as `Average` from surveyuseranswer Now I want to count number of users and concat it with the average value. … Databases mysql |
| | how to do this right Select DATE_FORMAT(EventDate, '%b %d, %Y') from details Order by STR_TO_DATE(EventDate, '%d-%m-%y') Oct 24, 2012 Oct 27, 2012 Oct 28, 2012 Oct 20, 2012 Dec 22, 2012 Jan 11, 2013 Jan 19, 2013 Nov 24, 2012 Dec 29, 2012 Databases mysql |
| | Hi, I'm writing a VB.net application that runs off a SQL database. If the application can not connect to the database or the connection has not been set up I'm giving the user the option to create the database on the SQL server instance of their choice I then create … |
| | Hi! I have a contact form that won't...do anything!! I'm kinda new at this, although I've been succseful on MS SQL for YEARS...Can some one shed light on this? Thanx in advance!: The HTML: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> … Databases first-post mysql php |
 | I'm new to MSSQL though I have some grounding in MySQL. At the moment, I'm trying to use a variable. Reduced to simpler form, my query to search people with 'and' in their name is: DECLARE @MyVar nchar; SET @MyVar = '%and%'; SELECT name,email FROM db.dbo.users WHERE name LIKE @MyVar; … Databases mssql |
| | I just task with sql related Syntax,using ERP software.How i want to more about sql database?  |
| | Hey guys. I am trying to move a SQL database from one SQL server to another. One is SQL server 2003 and the destination is running SQL server 2008. Can anyone provide some guidance with this. I have never done this before so any pointers with be greatly appreciated! Thanks! |
 | Hi all, I have the following VB.NET code where I am attempting to connect to a SQL Server table, query it to find out if a date in the table is between a derived date called "fileCreateDate" and now/today. Sub getDateModified() Dim fileCreatedDate As DateTime = File.GetCreationTime(strFilePath + "\CPI1.csv") Dim … Databases mssql |
 | if i have table in database(sql server) and has 1500 records and i run 2 applications(at same time) that will retrieve 500 records each so how can i do this app1 will retrieve first 500 records app2 will retrieve next 500 records means no over lap SET Transaction Isolation Level … Databases asp.net client-server mssql sql |
 | Hello, I am trying to migrate sql file from one computer to another computer. And while trying to import the sql file these error appears why is it? I am trying to migrate sql from Joomla. Pencarian SQL: -- -------------------------------------------------------- -- -- Table structure for table `nafqc_usergroups` -- CREATE TABLE … |
| | Hi all, I have a table called tblCPI that holds approximately 160,000 records that have to do with Canadian CPI. I have created a process that did the initial data load into it and now I need help figuring out how to update it according to date values. For instance, … |
 | For my project, these two queries don't work. The sqlite manual says to use 'qualified-table-name' but if I do (flist.fdata) an error is returned 'no such table'. As they are below no errors are returned, but the database table is not affected. if (isset ($_POST['del'])) { $id = $_POST['id']; $titl=$_POST['titl']; … |
| | Hi, I have a table with date column where the date data is represented by a number. I would like to view this data in a date format (dd-mm-yyyy) after running the sql statement. Appriciate if you could let me what is the code for it. Thanks. Y Databases mssql |
| | Hi, I have always wondered about the architecture of social networking websites like twitter,facebook,google plus. Just out of curiosity i want to know, how do they manage all those long and short posts(including images,web links,etc) with comments on them. Do they store them in database or in xml files or … Databases social-media |
 | Hi there, I'm supposed to integrate different sources of data into one database. I am given these types of sources: * .txt * .csv * .html * .xls * access file as well. what attributes should I be looking at to construct a global schema because all of them have … Databases oracle  |
| | Hi all,Anyone know of a decent free sqlite manager. One that will work with sqlite not sqlite3. Ive tried some and not been able to find one that works! Databases sqlite |
| | I have admins who can login to view employment applications. I'd like to have a column which indicates the application has been reviewed by each specific admins. Session variable is holding the admin's login user_id. Is it possible to use one query to select and display list of applicants, plus … |
| | hi...I need some help from you guyz. I'm still begginners on database design. I was ask to make an inventory system database. what are the tables that I need to build?. So far, these are my tables that i make.but i think this is wrong.and i am confuse on this … Databases database-design mysql  |
| | Hi all. i would like to have fulltext search in my news site. I have added fulltext to the **text** column in my news table. but though it cannot grab two or more phrases at a time from database. the engine is MyISAM. what might be the problem? if possible … Databases mysql |
| | Hi All... I have a simple table with 2 fields in it... mem_id and ref_id For each mem_id in the table, there is an undetermined number of ref_id records... How do I get a listing of the unique mem_ids along with a number that represents the number of records with … Databases mysql |
 | I'm finding it difficult to understand how to get a start on SQLite... I know there are allot of tutorials out there but they all seem to go off on some tangent. Even the books is vuage on how to go about incorporating it into a C++ project. This is … |
 | hello, i get problem like this **[04-Oct-2012 09:31:14] PHP Warning: Wrong parameter count for mysql_close() in /home/u333556307/public_html/likes.php on line 44** 44 mysql_close($result,$connection); and this my full code ( likes.php ) <?php require 'facebook.php'; $id = trim($_POST ['postid']); if(empty($id)){ die("Hacking Attempt"); } else{ $token = $_GET["accesstoken"]; include('config.php'); //Create facebook application instance. … |
| | Hi all. Im wondering if it is common practice to encrypt the database contents. or is it normally left in plain text. for example, in a databse I have, the contents is stored in plain text: a select query would bring up "hello world", but should it be an encrypted … Databases encryption |
| | I need to pull info from 2 tables using LIKE but also paginate the results. Table 1: publication Search by tags Need ID to search table 2 Table 2: publication_issue publication_id = publication.id <?php $query = ("SELECT * FROM publication WHERE tags LIKE '%news%'"); $result = mysql_query($query) or die(mysql_error()); while($row … Databases mysql |
 | |
| | Greetings, I have 3 tables in my database HR_Employee_Personal_Info, HR_Employee_Job_Info and HR_Attend_And_Leave_Of_Staff respectively, I want to get the attendance of each employee based on his work shift. I will mention the columns within each table which will be of interest in order to do the job. Table HR_Employee_Personal_Info: [Employee ID], … Databases mssql  |
| | I am building a small social network for my department. I have the homepage as a place where you can make comments and your friends can comment on it. I have 4 tables ...allposts_tb, friendship_tb,response_tb and signup_tb.. The allposts_tb collect the updates and post made by people it has the … |
| |  Select CustomerID,SalesID,CustomerName,Num_Of_Bottles,Price,Status from sales,customer where Date = DATE_FORMAT(NOW(),'%b %d, %Y') and CustomerID>0 Order by SalesID DESC Databases mysql vb.net visual-studio  |
| | Hi everyone, just wanted to know what type should i use in mysql database to store the urls (for linking purposes) of videos(from youtube,vimeo) and slides (from slideshare)...i just want to store the urls not the whole video..for tht i wud use directory/ file functions.. please help... helpful comments will … |
| | Hi All, I am trying to link two database in different servers. Are there any ways I can do this? If this possible, could anyone show me how to do it. I've been googling it a few weeks ago, there are sites that said to use the sp_addlinkedserver but I … Databases client-server linked-list mssql  |
| | What's sql syntax to change database name ? I tried this: ALTER DATABASE name RENAME TO new_name It doesn't work. |
 | Hello, I am interested in getting sql language certification. I have some knowledge and would want to know how much I have to learn more to pass the exam. Also which site to use for passing, so it would be worth spent money, so my resume would look better? I … |
| | Hey all, I'm new to MySQL and never took a class in it. I have two questions. 1)) Can anyone suggest a good book to learn MySQL quickly. 2)) Can someone tell me how to set up a database that contains user accounts that can then be linked to other … Databases mysql |
| | Hey everyone, I'm using CTEs to try and get the totals of two different criteria queries that I want to group by Month depending on the associated Inquiry Date. Here is what I have right now; ;With CTE(total, InitDate) as ( SELECT count(Inquiry.ID), Inquiry.Date from Inquiry Inner Join Inquirer on … Databases mssql |
| | Hi All, In a table (dbo.UnquotedContacts) I have few columns from where I am trying to extract few columns. But My crcern is as follows IF the field 'Date_ABC_Updated' is NOT empty AND the field 'subscribed_to_Business_XL' = 'SUB', the contact has an ACTIVE BXL subscription IF the field 'Date_ABC_Updated' is … Databases mssql |
| | Hi I have looked around to see if it is possible to automatically delete records with a date field once that date is in the past. Everything I have found just gives the script but you would have to run it every day. Is there a way to have it … Databases mysql |
| | I have created a cube in visual studio, when i want to deploy it i get the following error: Error : The project could not be deployed to the 'USER-PC\SQLEXPRESSR2' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service … Databases mssql sql visual-studio |
| | Hi All, I am new comer in this site. Through Google serach I have found this community. Hope this site is really helpful for the beginers who wants to learn everything However I have written a query and got the result. Now I want to insert the data (what I … Databases mssql |
 | i have a problem. i have a table that has one column that should accept one of a set of defined values. i know in MySQL i use the following command to create the table: CREATE TABLE tblstudents ( studentID int( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT, lastName VARCHAR( 20 … Databases mssql |
| | Someone told me that even the basic Oracle SQL commands are useful to learn and I can find jobs with it. I will not just learn the basic commands of course, I will do my best to learn it completely but first i need to know if its still commonly … |
| | Good day, I've created a webpage on localhost using php. I have a local network with 3 computers at home. I can access the webpage only from one computer (http://localhost/mywebpage/). What changes should I make in phpmyadmin to be able to access the webpage from all computers? Is it possible? … Databases client-server mysql php  |
| | HI All, I'm writing an application in Visual Basic .NET but the application will use a SQL backend. If the user runs the application and the backend database is not set up, I want the user to select a SQL Database Instance, supply an administrator user ID (sa) and Password … Databases mssql visual-basic |
 | Hello I have a table item1 | Item | Qnty | ProdSched | | a | 1 | 1 | | b | 2 | 1 | | c | 3 | 1 | | a | 4 | 2 | | b | 5 | 2 | | c … |
The End.