2,403 Solved Topics
Remove Filter  | |
| | Hi - relatively new to MySQL & still coming to grips with its permissions system. Probably a slightly noob question - hope you don't mind! (should be easy then?) :) SITUATION: 1) I want to set up a standard set of records in my database (DB) with values that ALL … Databases mysql |
| | Hi guys, Very new to sql and my question is prob very basic. I have a table desing shown below. I will using a c# program to add new rows to the database but i only want to add a new row if the hostname doesnt currently exist in the … |
| | Hi, I have a table above 8.000.000 records. I am running a query like "select * from table where id=1093203". And the query turns in 24 second. This example i tested in SQL Server 2000 v8, Windows 2003 sp2. I am running same query in Windows Xp + Sql server … Databases mssql sql windows-server  |
| | Hey, so i have 4 tables i need to join together. basically this is how it looks table j: | id | uid | cid | text | | 1 | 3 | 1 | blah| | 2 | 1 | 3 | blah| table u | id | name … Databases mssql |
| | Hi, I've searched this and other forums and found what are clearly the right answers for some people but not for me. I have a database with an item table. Item has a field called image that stores a path to an image. Here is an actual example of a …  |
| | hi i would like to store the data of a text area inside mysql, and for that i want a suitable dtatype For eg if the data in textarea is [QUOTE] hello hie are you i'm fine! [/QUOTE] currently i'm using varchar but th eproblem is that the data apperas … Databases mysql |
| | Hi, I was seeking for an opinion concerning database design. I’ve got a Company Class having several properties. A value will be assigned to the property via GUI. These properties are quite static i.e. likely won’t change. Usually one goes for an approach whereby Property1, Property2, Property3 map into table … Databases database-design gui |
| | Hi I am trying to set up remote access to mysql on a headless server. From what I have read this can be done by installing phpmyadmin on the client pc. Is this all I need? I have changed the entry in my.cnf "bind = localhost" to "bind = ipofserver". … Databases client-server mysql php |
 | Ok, I love movies, and I am building a website to chronicle the movies in my collection. I have the layout, graphics and all of that. I can do all of that myself. I need to know what the best way to show the movie cover, synopsis and my own … Databases |
| | Hello all, I have been tasked with figuring out a way to automate a form letter process that currently is done mostly by hand with a lot of copy/paste. We have letters that need to get sent out based on our internal system. Someone now looks up the items in … |
| | Hi, I'm trying to create a database that stores shoes. Each shoe must have more than one size so I have created a table "mens_boot_test" with a field "size". In the size field I have an integer which holds the delimited values 1,2,3,4,5,6,7,8,9. I'm then trying to retrieve these values … |
| | Hi All I'm new here and have searched high and low for an answer to my problem, and have so far had no joy. I am trying to create a if/else statement depending on the outcome of a SQL command that should be extremely simple and basic, but for some … |
| | i ve 1 table named 'A',it contains many attributes in 1 attribute the values are stored like this [COLOR="Red"]"Q108:5380;Q208:5380"[/COLOR] this data present in table 'A' should be entered in table named 'B' in two fields named B1,B2 as B1 B2 Q108 5380 Q208 5380 like this in two columns this … Databases oracle |
| | hi, to all... im coming up with mysql codes...i have to come up with a command where reports which r produced is to be printed according to business needs, for example, clients, managers and clerk..im trying to use the 'select' to code this command,but it doesnt work. so, i tried … Databases mysql  |
| | Hi I have two tables that I want to use to build a third. They have a many-to-one relationship for one of the columns. Table A has the "one" side of the many-to-one relationship. Table B has many rows that have foreign keys referencing Table A. I want to write … |
| | Hi All, I am mysql newbie. Please have alook at this querry. [code=sql]SELECT b.date as date, a.tirthankar_name as tirthankar_name, a.kalyanak as kalyanak FROM table1 a, table2 b WHERE a.mass = b.mass AND a.paksh = b.paksh AND a.tithi = b.tithi AND b.date BETWEEN CURdate( ) AND (CURdate( ) +9) ORDER BY … Databases mysql |
| | Hi Guys I have designed reports in Discoverer Plus and the users are viewing the report using viewer. My need is that suppose there is a report which is made. Now if some user views the report by changing the layout and save the changes. Now problem is the change … Databases oracle |
 | hi i have a table which contains a datetime type column. i want to create a stored procedure that gets a surtain month and year as parameters and returns all the rows with the date column in the month and year range i sent as parameter. for example if i … Databases mssql |
| | Hi, How to connect to remote server with storedProcesdure sp_addlinkedserver where the server has an instance SQL2005. suppose the servername as 'SrvName\SQL2005'. Also please provide the procedure how to delete a remote server from sysservers table. Thanks, Ukbasak Databases mssql  |
| | Hi I have made a website where it is possible to see the days program on one page, it updates itself so it is only for that day. But now I wan't to be able to insert a picture that changes position according to what time it is. For example … |
| | Im a newbie at this stuff, so could someone please post how to alter a table so that i can make a field called numbers to be auto incremented. I dont know how to do this please. The table is called blog. Or can you post how to setup a … Databases mysql |
| | hi i have an existing table . i'm working with sql management studio. how can i change columns properties ? set column as idenity true. set column as indexable. |
| | Hi all, I have a very simple query but this is driving me nuts. I have installed sql server 2008 on my system. Its working fine, but the main thing is that i am not able to configure the report server. Can anyone help me how to configure the report … Databases mssql |
| | If anyone can point me in the right direction I would greatly appreciate it. I am making an Asset Management database. I'm looking at having about 50 fields in a table. Of those 50, 25 could potentially be used for searching. In some cases multiple fields would be used to … Databases microsoft-access |
| | Hi all. I have a table with a this records: [CODE] <!-- Table user_activity --> <user_activity> <id>1</id> <event>LOGIN</event> <username>user@domain.com</username> <domain>domain.com</domain> <remote_address>ip_address</remote_address> <date>2008-05-23 20:19:36</date> <comments></comments> </user_activity> [/CODE] I am trying to query the DB to get the total results of activity PER DAY. This is my query (which obviously doesn't work): … Databases mysql |
| | Hi guys, I want to select records from the database, i need to pass start index and end index, then the result set will include those records. Let say my database table has 100 records, i want to get the records between 30-50. How can i do that? Databases sql |
| | Help Please! I am trying to create a maintenance plan in sql 2005 server. I am getting an error Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI) I am unable to create maintenance plan. I am on sp2, and applied a critical hotfix from the microsoft website. I thought maybe it was client tools, but isn't … Databases client-server mssql sql windows-server |
| | I have created two table valued multi-statement functions using SQL Server 2000 and am now trying to develop a VB.NET front end application where I run the functions and pass string parameters to them. Below is a code fragment for one of the functions. [code="SQL"] CREATE FUNCTION ViewCustomers(@Region varchar(6)) returns … |
| | Hi all, I am fighting with this a while allready, a moving average with mutilty items The (example) tabel : item datum volume item1 1/1/2009 10 item1 1/2/2009 11 item1 1/3/2009 12 item1 1/4/2009 11 item1 1/5/2009 10 item1 1/6/2009 10 item1 1/7/2009 10 When i do this with only … Databases mysql |
| | Hello, What SQL query should I use, in order to copy records from one table to another, both of the same schemas, in such way that only records that don’t already exist in the destination table will be copied? For example: Table A – Destination table ****** Col1 Col2 Col3 … Databases mssql |
 | Hello all, Are UDFs written only on SQL Analyser in within the SQL? Can we use them in programming code?How to use them in the code? What are the actual benefits of UDFs? We can write the method in the code and connect to the database and execute which yeilds … Databases mssql |
| | I have a program that uses a Stored Procedure to create a report. Unfortunatly the SP has a problem in the VB6 code. The program could pull the information perfectly until 2 days ago. Now the program times out after 60 seconds after sending the params to the sp. I … |
| | Hi people... I have phpVideoSearch script, and want to add a feature, that if someone a specified page, to add to mysql a +1 value... Example this is the page: [CODE]watch.php?title=Riz+Khan&link=http://www.youtube.com/v/[B]xE0wOa5R6KY[/B][/CODE] i've set a code to create a id for this video like: [B]yt_xE0wOa5R6KY[/B] Can someone help me create a … |
 | Can someone help me with this database, code bellow [CODE]-- -- Table structure for table `bapps` -- CREATE TABLE `bapps` ( `bappID` int(11) NOT NULL auto_increment, `bappFROM` int(11) NOT NULL default '0', `bappBUSINESS` int(11) NOT NULL default '0', `bappTEXT` varchar(255) NOT NULL default '', PRIMARY KEY (`bappID`) ) ENGINE=MyISAM AUTO_INCREMENT=51 … Databases data-structure mysql |
| | Hi. I have this problem Group by will make the table only show a value of that group once. So lets say there was 1000 results without group by. 500 with a single group by. But now i want to do another group by to filter it down more to … Databases mysql |
| | Hello all, using mysql I have the folowing (example) table +------------+--------+ | date | total | +------------+--------+ | 2009-01-08 | 150000 | | 2009-01-09 | 151000 | | 2009-01-10 | 156000 | | 2009-01-11 | 154000 | | 2009-01-12 | 153000 | | 2009-01-13 | 157000 | +------------+--------+ Now i … Databases mysql |
| | Hi, I am wondering is there a solution to do this type of problem. I would want to release a list of queries that only show only orders that does not match each other. For a order to match it will be companyname from different hiddenkey are the same and … Databases mysql |
| | Hi, I don't know why the server I recently get to manage, has the SQL Server 2005 installed but with the Management Studio Express!... I need to upgrade it with the Dev version, but when I put the DVD of the SQL Server installer, It won't show my actual installation … |
| | Hi, I have 2 instances of SQL Server running on one machine (One 2K -default- and one 2K5), I have no problem connecting from a PC on LAN to the 2K5 instance, but when I try to connect to the 2K instance, it fails (it gives me an error: "Named … |
| | Hi all, I have a Stored Procedure without an output parameter but it returns one row always, this SP is called by another SP, so I need to store some of those columns in a variables of the first SP. How can I do that? Please help. P.D.: I have … Databases mssql |
| | I have two "entity" tables: Company and Agency. Both Company and Agency can have multiple addresses (shipping, billing, etc.) and multiple contacts with titles (president, sales rep, etc.). Rather then put address and contact information in each entity table, I want to create a table that is common to both … Databases |
| | Hello, I have two tables, one with the main users details in and a users movement table which has an entry to everything they do. I want to pull out a list of all users which havent done a specific task, put only pull the results once. So for example … Databases mysql |
| | We have an MS-Access DB that we would like to create emails from is that possible. Approx. 140 employees we like to create emails to from Access. Thanks for any pointers. Russ @ scaninc.org Databases microsoft-access |
| | I have a table with 32 fields. Is there a shorter way - [ other than select sum(field1 + field2 + ... Field32] to get the sum of all fields for a date range. I know, I know, once I create the query I can save it for future use … Databases mysql  |
| | I wonder if someone can point me in the right direction for securing my site more effectively. Having experienced problems with Google warning pages being placed on my site relating to potential malware, I've been looking into "beefing up" security, but am find the tutorials relating to safeguarding against sql … |
| | Hi folks, I want to access Oracle 9i table "emp" in Java... I do not know what driver to use .. The name of the Oracle database under which "emp" falls is "Oracledb" I do not know what the connection string is? Pls help... |
| | Hello everyone, At first, I would like to wish an happy new year for everyone. Now, my problem! I'm starting a new web app (which is the first one I will completely write) and after modeling the database, I encoutered a problem for adding datas in my category's table: [code]-- … Databases mysql |
 | I wanted to ask this before I tried to build these two large tables myself. Does anyone know where or if I can find an MS Sql table of the United States, Cites and States. Possibly with the relationship between state and cites already built, or even an Sql procedure … Databases mssql |
| | How would I select everything from last month in a sql statment my cell has a time stamp in it [CODE]SELECT DateTimeStamp from Get_estimates[/CODE] Ouput [DateTimeStamp] 2008-02-28 11:39:35.247 2008-03-09 13:15:12.513 2008-03-09 13:16:53.700 2008-03-26 13:30:20.077 2008-03-26 13:30:51.810 Databases mssql |
| | I'm trying to make a membership system where users can 'approve' or 'disapprove' another member only once. If they have approved the member previously or disproved the member previously, I want to be able to detect it. I also want to display the average user approval for each member on … Databases |
The End.