2,403 Solved Topics
Remove Filter  | |
| | Hello, I am a graphic designer who does some web design on the side. The store I work at had a website that the boss wanted transferred to a different host. So I downloaded it off the server and uploaded it onto a new one. I knew that I was … Databases database-design mysql web-design web-server  |
| | Hi, I am using the following syntax in VB 6.0 to copy distinct values from strTableName to TableName [code]strOpen = "Select distinct * into" & " " & strDupTableName & " from " & strTableName rst.Open strOpen, db, adOpenDynamic, adLockOptimistic[/code] But I am getting a runtime error "-2147217833". I have … Databases microsoft-access |
 | hello friends.... I am PHP programmer using mysql as my database... Now it is the time to make fast all my queries ,which im using in my programming... I heard about indexing... Tel me what is indexing,how to put indexing to my table... mainly what are the advantages and disadvantages...or … Databases mysql |
 | Hi! Is there any way I can save a database as an SQL file? Or at least save schema if saving data is not possible. Thanks in adv. |
| | I was wondering how to store this date into the database: Friday, August 28, 2015 and this time: 8:00PM I have one field that collects the date and another for the time.. Im looking to store them in this format, 0000-00-00 00:00:00.. Is there some way to turn this date … Databases mysql  |
 | I have a table which counts messages sent to a particular department. the important structure is basically ID Department Message DateSent I want to be able to retrieve a resultset where that looks like this: Department MessageCount something like a SELECT COUNT(ID) Where Department=XXX but collect each individual department count … Databases mssql |
| | I have to create database of student having different subjects and marks in respective subjects. Now many students will many subjects so there is many to many relationship. My database design: Table 1: Student table (PK)Stud_id, Stud_name Table 2: Subject table (FK)Stud_id, Sub_id, Sub_name, Marks. Table 3: Stud_Sub table Stud_id, … Databases database-design |
| | I have an invoice type of system and am having troubles trying to update an item.. I have 3 tables that deal with the orders.. Here they are: [code] CREATE TABLE `dw_orders` ( `order_id` INTEGER unsigned NOT NULL auto_increment, `customer_id` INTEGER unsigned NOT NULL, `order_date` DATETIME NOT NULL DEFAULT '0000-00-00 … Databases mysql |
| | Hi; This is my first project. I am developing a project: student feedback system for an institution. Here each student will get an userid and password . There are six tables in database to support project 1. User—consist of user information like username, password etc. 2. Groupid—consists of various groups … Databases data-structure  |
| | I have a table with 3 columns as follows: lower upper id 12 20 100 100 150 200 I want to select range of numbers based on lower and upper column. For example I want to display numbers between 12 to 20 or from 100 to 150. How to do … Databases mssql |
| | Does anyone know how to change the look of the java files that are listed when you expand the java folder in the tree structure of the database? i have these numbers infront of the class file, but have no clue what they are, they are not there in toad(i … |
| | i have just had to go into the backend of an old site to fix the mysql db as some had deleted the wrong db. i have got most of it working again now but did not know what this line of code is doing. [CODE]$sql = "SELECT id,thumb,image,designer,title,(total/freq) AS … Databases mysql |
| | [code=php] <?php $result = mysql_query("INSERT INTO ".UPREFIX."items` VALUES ( '', '".$item_name."', '".$item_descr."', '".$item_action."', '".$item_rarity."', '".$item_value."', '".$item_folder."', '".$item_image."', '".$item_cat_id."', '".$item_visibility."')"); ?> [/code] I didn't know if this would be php or MySQL. I'm getting returned the following error: You have an error in your SQL syntax; check the manual that corresponds … Databases mysql |
| | I am stuck between deciding between MySql and Oracle, The reason being, I want to know how long it will take for MySql to reash the level of the current Oracle, if its gonna take more than a year....I guess Oracle is worth the money else not. Any views on … |
| | Hello, If I have a table like this where i have the year and the month, how can a get something like 2008 3 after a select? - I mean the maximum month for the maximum year? Thank you. [CODE] year month 2006 1 2007 1 2006 2 2007 2 … Databases mssql |
| | Hi There Normally I'm not designing database but have the need to implement an internal questionaire system. I'm wondering if anyone has examples of desigining a database for exams/etc? What I'm finding difficult is the need for multiple types of questions: 1. Multiple choice, one correct answer 2. Multiple choice, … Databases database-design |
| | Hi, I'm developing issues database. How to get the ageing or how long the issues has been outstanding. TQ Databases |
| | hello guys, i wanted to write a query, or a view to be exact to display data from two tables as follow: 1. schedule_table (scheduleID as pk) 2. remarks (remarkID as pk, scheduleID as fk) meaning a schedule can contain many many remarks and non at all. now the problem … Databases mssql |
| | Hi, How can i pick next or prevoius day in mysql? Any function like curdate() ? Thanks Databases mysql |
| | Hi, [inlinecode]Select closing From balance Where account_no = 12 Limit 1[/inlinecode] returns an error "You can't specify target table 'balance' for update in FROM clause" Where is mistake? Thanks [code] AFTER INSERT ON Close BEGIN Insert into balance (date, opening, account) Values (CURDATE(), (Select closing From balance Where account_no = … Databases mysql |
| | Hi, I have been trying to get MySQL to work on my apache server with PHP on it. My Apache version is 1.3.29 and my PHP version is 5.0.0RC2. I'm also running Windows XP Professional SP2 32 bit. I tried modifying the php.ini file to load the php_mysql.dll, but I … Databases apache mysql windows-server  |
| | there is another problem that i am facing..i got 2 comboboxes filled with values from MS Access and they have values like 1.00,2.00,2.98,3.00,3.25 and 8.00 I want to be able to choose 2 values i.e. one value from each combo box and when I hit click I should get queries … Databases dataset microsoft-access mssql |
| | Hi, Code below is wrong but i can't find the mistake. [code] Set @RecAdj:=(SELECT SUM(Paid) AS Total FROM payment WHERE PayDate = CURDATE()); if ISNULL(@RecAdj) set @RecAdj:= 0; end if; [/code] Or is there any other way? Thanks Databases mysql |
| | hi, i want to select from more than two table using a single mysql query.please tell me a example query/. thanks in advance Databases mysql |
| | range of datetime data type (show all records in between 2 dates. example: form 2008/10/01 to 2008./12/12). thanks Databases mysql |
| | Hi Guys, I have a text file which looks like this 123456 Amanda Morris and I would like it to look like this "123456","Amanda","Morris" The file has about 2000 lines how would I go about inserting the quotes and the commas. I use textpad to open the textfile and I … |
| | I want to select data from ranges like Column1 Column2 25000 10 50000 20 75000 30 I want records like upto 25000, I get 10 upto 50000, I get 20 upto or more than 75000, I get 30 Can anybody suggest me a simple query for that? Thanks in advance, |
| | Is there a keyword in SQL that would allow you to select a value from a field in the previous row? I am looking for something that would give me the speed field value for the row before: [code]SELECT min(Parsed.Time), [Parsed.Number] FROM Parsed GROUP BY [Parsed.Rev Number] [/code] Databases mssql |
 | hi i need to store data more than 8000 char in varchar in sql server 2000 how can i? plz help. Databases mssql |
| | i am trying to set up this db and i am getting a parse error which it says it is on line 24 i cannot see the error. help need [CODE]$sql="CREATE TABLE IF NOT EXISTS `merc_users` ( `****` int not null, `******` varchar (250) not null, `*****` varchar(250) not null, … Databases mysql  |
| | Hopefully this will be an easy one for someone. I am trying to write a SELECT statement that pulls the row with the least time for each Special Number. Example data would be: Time Special Number 3:25:00 1 3:26:00 1 3:25:30 2 3:26:30 2 The expected output would be: 3:25:00 … Databases mssql  |
| | Hello, I recently bought a new server and I'm trying to move the MSSQL database from the old mssql (MSSQL 2000) to the new system MSSQL Express 2005. I made a .bak file in the old server and restored it succesfuly in the new server. the thing is that it … Databases mssql web-server |
| | Hi! so I am trying to design a relational database and I think I am on the right track, but I am a little confused as to how I will actually update the data... Normally I build a flat file table and use a web form to add/update/delete data, however, … Databases database-design web-design |
| | [B]Is it possible in a query to delete a row specifying its row index?[/B] I want to delete a row from my table. I'm trying to figure this because when I delete rows from my datagridview, it does not update. So I was thinking if I just directly delete it … Databases mssql |
| | hi friend I want insert value to three table in single query any body have idea pls send the query for me advance thanks by san.. Databases mysql |
| | Hello I seem to be having a problem, I have this query that pulls back correct results [CODE]SELECT hourStamp, SUM(CASE WHEN datestamp < GETDATE() THEN 1 ELSE 0 END) / @numberofdays as HourAverage, SUM(CASE WHEN dateStamp BETWEEN DATEADD(d,DATEDIFF(d,0,GETDATE()),0) AND GETDATE() THEN 1 ELSE 0 END) as HourToday FROM webstats GROUP … Databases mssql |
| | Hey guys, I have some question about a query in SQL I'm buliding for my software. This software meant for Bills managing. I have main screen which display all the bills and another screen which display the bill details, this screen built on 3 tables : Bill,BillItem,Payment tables. My question … |
| | I'm getting the error Incorrect syntax near '=' when running the following query. I'm fairly new to SQL, but this looks like it's pretty straightforward. Basically, I have a table with smartphone information (A_INV_SMARTPHONE) and a table for Windows CE Pocket PC information (A_INV_WINDOWS_CE). Both tables contain columns for Manufacturer … Databases mssql smartphone |
| | Hi Please tell me if you know a dis-advantage of auto-incerment PK Thanks Databases |
| | I have been trying to figure this out, surf thru google but I came back empty handed... I wana move data from Database A to Database B that means copying the content of one database to another database, I am using SQL server 2005... any help will be highly appreciated Databases |
| | Hi I have Client, Owner, and Staff entity, they all are persones!! with additional criteria... Client ID, FName, MName, LName Owner ID, FName, MName, LName Staff ID, FName, MName, LName so Is there a concept of inheritance in RDBMS like SQL-Server-2005 if so how can I implement it. At lease … Databases client-server |
| | Hi, I need a clue on how to design a Many to Many relational database. For example, I have a products table and a supplier table. each product can be supplied by many suppliers each supplier can supply many products how can I orgranise this data in the tables? I'm … Databases database-design |
| | I am currently testing replication on mysql 5.0.9 running on Win XP Pro on 2 servers , one as a master , and another as slave , basic master-slave configuration. The slave have 2.5 GigaB of RAM,300GB SATA2 HD & on Intel 2.4ghz Core Duo and the master have 1 … Databases mysql |
| | I am trying a multi select query in management studio and I am only expecting a result that is a single output per row, however, when I tried executing it. The rows I called repeated once. For example I have 2 rows in my column1 and when I multi-selected my … Databases mssql |
| | I am a new convert to MySQL. It sounds like an answer to my prayers, BUT when I look for some training I find the cost to be substantial. I have purchased a book Beginning MYSQL by WROX but I now realize that I need some more structured training. I … Databases mysql  |
| | hai friend's i am beginner in MS sql db . so can any one explain me detail about Foreign key and primary key , please give example also , thank;s in advance..... Databases mssql |
| | Hello, I try with the following query to calculate the working time of employees: [code=mysql] SELECT TIME_FORMAT( ADDTIME( TIMEDIFF(TIMEDIFF(hour_end, hour_begin),(hour_pause)), TIMEDIFF(TIMEDIFF(hour_end_o, hour_begin_o),(hour_pause_o)) ) ,'%H:%i' ) AS total FROM hour [/code] This works correct, if the pause is filled, if no pause is given, no total is displayed (NULL). How can … Databases mysql |
| | Whats wrong with this query? [code=mysql] TIME_FORMAT( DATE_ADD ( TIMEDIFF(TIMEDIFF(u.hour_end, u.hour_begin),(u.hour_pauze)), TIMEDIFF(TIMEDIFF(u.hour_end_o, u.hour_begin_o),(u.hour_pauze_o)) ) ,'%H:%i') AS total, [/code] I get the error: [QUOTE]#1305 - FUNCTION system.DATE_ADD does not exist [/QUOTE] BTW: I am using version 5.0.51a. Databases mysql |
| | Does anyone know how i can get a list of the java stored procedures that are inside the oracle database using oracle sql developer? If anyone has used Toad, i m referring to the list of java classes that comes up when u click the Java tab in Toad. Thanx. |
| | Hi, I couldn't get this to work, but I was using a PHP script to go through the rows in a table in my database and if it found a specific value, to delete that row. However, it deletes ALL the rows no matter what I do and throws an … Databases mysql |
The End.