7,494 Archived Topics
Remove Filter  | |
| | HI, Could you please explian this code so it will work, { "display **all** from **tablename** **colloum_id** in a **random order** " } I am trying to get all the data echoed into a random string ie. echo = "3,4,5,6,7,3,2,6,3,22,43,132,ect. not in a table. thanks. |
 | Hey Im trying to start from scratch a MySQL installation in Linux but for some reason through apt-get and the software center, when I remove it, my users (and privileges) still exist. How can I remove everything releated to MySQL and start from 0? Thank you Databases mysql |
| | I am having trouble to find the entities for this condition. Can anyone please help me here. A university has different types of staffs, e.g., lecturer, receptionist, cleaner etc. Should be recorded is class of jobs - Academic, Technical and General. An Academic can teach many subjects in a session … Databases session |
 | Hi all , I need to insert a value in to a table if that value does not exist more then twice , If once that value exist then it should insert only once .. could any one guide me.. thanks in advance Databases mysql  |
| | Each childrow has a parentid and position. For childrows with the same position there is one row where start='1'. What i'm trying to do is return the pending rows with their start row. The results that should be shown are; start(owen) pending(dave,paul). This is because they have the same position. … Databases mysql  |
| | Hi. I am trying to perform a "process of elimination" type of search using MySql. I have a table with a lot of values that people could search for- and currently if they search for 1 value it works great. But if they search for lets say "value1 value2" it … |
| | Hello, Is there any way of restricting the values returned in MySql? For Example: There's a field in my table called points whihc I want to restrict from 0 to 17 only. This means the values more than 17 are unacceptable for field. Is there any way of implementing that? … Databases mysql |
 | I want to know how M/S ACCESS database can be connected to html page hosted on local host Databases html-css microsoft microsoft-access |
| | Hi, I'm trying to create a form in which a user selects a Customer from a Combo box and then can select a "Dongle" (or Product they have) from a list box. Below is a screen shot of the relationship between the tables.  Also here is a screen … Databases mssql |
| | Dear All, I am beginners in MS Sql, now I have three tables (Companies, Product, SaleBody). and their fields are (CompanyId, CompanyName), (ProductId, ProductName, CompanyId, PurchaseSTPrice, TradePrice), (SerialNo, SaleId, ProductId, Quantity, Price, TotalPrice).............. I want to create Report in which I want (companies.CompanyName, product.ProductName, product.TradePrice, salbody.TotalPrice) How can I get … Databases mssql  |
| | Hi, On executing CROSS APPLY Clause using UDF: create function Reg(@pc int,@pp varchar(15)) Returns Table As Return select cr from crt where piod=@pc and cr=@pp Go select distinct a.cr from cdet AS a CROSS APPLY Reg(a.cr,a.piod) AS a where a.piod='208'** Am getting this following errors: Incorrect Syntax near '-'. Thanks. Databases client-server mssql sql  |
| | Hello I am trying to write a select statement that will compute the average room rate under the assumption that if the room rate is "null" it should be replaced by the minimum room rate from the table. The following is all the details of my table : create table … Databases oracle |
| | Hello All, i am new to oracle , i need to know where to start (books , videos , tutorials) where to start from scratch Thanks a lot. Databases oracle  |
| | Hello everyone, I want to create a web application where an artist can register with us and create their own profile which others can view. The site should also enable members to view the names of all the albums produced by said artists and confirm if the serial number for … Databases database-design |
 | hello! i am working on a client and server application , i want to connect my server with my client application to perform some database transactions.i think it is very simple to connect a client with the server , but here is the point , i have two pc , … Databases client-server mssql windows-server  |
 | What is a reasonable number of queries to Memcached per page? We do use getMulti to try to fetch what we know we'll need in advance all at once, but we mostly use getDelayed() (which is a two-part call with fetchAll(), and we do some other processing in between them. … Databases caching-memcached |
| | Please this has being coursing me a sleepless night, can someone kindly help me out once again I have multiple links of movies in my site for download but the movies are uploaded with a different site (my Host site).so is just the links that will lead to the Host … Databases  |
| | I need to build a database for a theatre booking system Im not sure how many tables I will need to have for the seating etc. The theatreSeating Numbers are as follows. • 800 seats on two floors (500 on top, 300 on bottom, however without seats capacity is 750) … Databases database-design |
| | #MySQL TABLES CRASHED BUT STILL WORKING WHEN RESTORED TO MySQL ON ANOTHER SYSTEM, WHY ???# Hi everyone, I'm a software developer and just started my professional career life, question here i want to ask is ... that few days ago i was at client site to resolve some issue in … |
| | Hi, I have a database called my_db1 which contains 3 tables. Out of the 3 tables one table is being populated 24*7. My hosting provider (i.e godaddy) provides 25 Mysql databases 1 GB each. What should I do if the database exceeds the 1 GB size limit? Is there a … Databases data-structure mysql |
| | hi, how to create nested table in sql server for example employee table contains 3 column id name address where name should contain 3 sub columns like firstname middlename lastname how can i get this one help me plz Databases mssql  |
| | Hi, We heavily use Memcache and I was wondering if there were any places where I could read up about good tips to improving its performance. Everytime that I try to google improving memcached performance, I just end up with pages upon pages of links to how to improve performance … Databases caching-memcached |
| | I need some help updating data in my table based on data in the supply chain group's table This is how the table looks on their side ##Table Name: ProductSC## ID Code Description Status 1 N461579 Phone Available 2 N836257 Headset1 Discontinued 3 N836258 Headset2 Available 4 N748956 Adapter Available … Databases mssql |
| | Hello there, I am a newbie in MySQL and I am extremely confused about one thing. I am currently creating four tables. There's a primary key I have specified for the first table which is a foriegn key in the second table. Now the problem is that I want the … Databases mysql |
| | I am newbie in sql server i'm using sql server 2005 and the northwind database i wanted to join order and order details tables and calculate the total purchase made by each customer by using group by clause. When i used select orders.orderid,orders.customerid,orders.orderdate,orders.shipcity,orders.shipcountry, orderdetails.unitprice,orderdetails.quantity,(orderdetails.unitprice*orderdetails.quantity )as total from orders inner join … |
 | |
| | I have a live update system for a football team, which I input the following: Date, Score, Event (Goal, Red card, Yellow Card, none), Details So 4 columns. At the top of the page, I want to display the latest score, so bascially I want to grab whatever the current … Databases mysql |
| | hello ! how are you all , hope all of you are in great state of health and peace , well i have some questions , 1- WHAT IS MSSQL TRANSACTIONS . 2- where we use it. 3- Advantages /Disadvantages 4- Any imp information or point which you think it … Databases mssql |
| | I have developed a web application and it works very well in the localhost. but when i put it to the web server the relationships in the table doesn't work. for example when a parent row is deleted all the child rows associated with it should be deleted. but it … Databases mysql web-server |
| | I have a table ... Ratings (userid, movieid, ratings, time) where ... select count(*) from ratings where userid = X; (No of ratings of a particular user) Here, X ranges from 1-6040! How should I get the count of each user and then store it in another table 'Users' in … Databases mysql  |
| | hello :) i'm using MS access as a database of my Windows form application. i'm having problem with create table query, with variable table name. i have tried, but it din't work, as i tried. plz provide an example that can make me understand. suppose, string city = "newyork"; and … Databases microsoft-access |
| | Hi I have imported a number (500+) posts into Wordpress from another CMS (Expression Engine). On a number of posts I have a problem with the way paragraphs are being displayed and I can trace this back to the post data that has been copied across. For example, when the … |
| | Hi all, I have a table 'table 1' which has a primary key. Now I want to create two other tables with a composite key in each one, composed by primary key and a foreign key both referencing table 1 's primary key. However I can only do it with … Databases mysql |
| | I have a table which has a foreign key that links to a primary key in another table. That id has information on it in which I want it to show while having a sum on the information. Is there a way to do it? To clarify here's a code … Databases mysql |
| | I thinking about a project to build up a web based application. I am not able to understand what should be structure of the database. [B][COLOR="Red"]Problem:-[/COLOR][/B] Data is in bulk which is of a big general store, and they have 50,000 transaction minimum each day. They store all data and … Databases data-structure mysql |
| | Hi, Am having, some doubt, please clarify this? [CODE] 1. Using Import/Export wizard, can i able to import the excel data into the temporary table ? How ?[/CODE] 2. The following TSQL is working fine. Can i able to do this, from the CLIENT Machine itself. I don't want to … Databases client-server mssql |
| | Dear all, The first query works while the second doesnt, am not able to figure, can u please help me out. 1) // $query3="insert into ttrough(am,pm) select ttam.subject,ttpm.subjectpm from ttam,ttpm where ttam.class != ttpm.classpm limit 1";// this one actually takes two columns from different tables and checks whether they are … Databases mysql |
| | Hi i am making a stored procedure with multiple select statements when i execute them than different resultset are maken for each select statement all i need is to get one resultset from all select statements of sql quries in the stored procedure......HERE is the SP code..[CODE]SET NOCOUNT ON; Select … |
| | Hi, Trying this Query, [CODE][B]DECLARE @SR VARCHAR(8),@SC CHAR(15),@ST CHAR(15),@SNO int; SELECT * FROM (SELECT DISTINCT ROW_NUMBER() OVER (ORDER BY a.rno) AS rowid, @SR=a.rno,@SC=a.kat, @ST=a.type FROM SMas a, SDet b WHERE b.id='X' AND a.rno=b.rno) AS C WHERE C.rowid=4 [/B][/CODE] but getting this following error: [CODE][B][I][U]Msg 102, Level 15, State 1, Line … |
| | Hi, I am trying to create a stored procedure to add a new column into a database from an ASP web application. The SQL Code for this is:- [code] ALTER TABLE tablename ADD COLUMN columnname columndatatype [/code] I have tried to insert this SQL into a stored procedure:- [code] CREATE … Databases mssql |
| | How to get last auto number? I've got 2 tables I.e. booking and booking membership One person is the leader of a booking, but many people can be members of that Still, when I inse the booking I want to also do an insert into the bookingmembership table. The booking … Databases mysql |
| | When People are trying to insert an sql inection, that time mysql errors displays the table name with the column names, how can I turn off this, My site is built in MVC framework, and this is how developers have queried the database, [CODE] $offset=0; if(isset( $_GET['offset'])) $offset=$_GET['offset']; $array_list=$DB->q("select *,users.user_list_id … Databases mysql |
| | Good Afternoon, I have a bit of a dilema, maybe 2 or 3... I have a members table in MySql, that includes a field called join_date which is designated as DATE type field I have 7 position tables named position_1 thru position_7 These each have a field called create_date which … Databases mysql |
| | Dear all, Am half way through my computer lab management project. to generate the timetable automatically i've written an algorithm. and for it to work i need an sql query that can : table-> ttprofile: id lab_name subject_name. now i looked every where, is there a command to take the … |
| | Hi, I'm rather new to MySQL/db management, though I do have a more substantial background in web development with HTML, CSS and PHP, as well as some C++... so while I may be sort of familiar with some of the general concepts needed to understand and utilize MySQL database design, … Databases database-design html-css objective-c web-design |
| | the below table is order by rank .. however i want order by in a way that 'Cpl' comes first. 'lcpl' comes second and 'pte' come last.. if i use ascending or descending it will order by a random manner. Databases mysql  |
| | Basically I have a trigger that is fired off whenever a workorder is reopened to close it again. The trigger works perfectly but I want to track the workorders where there is an attempt to reopen it. so basically if workorderid 8 is attempted to open again I want to … Databases mssql |
| | i have two tables in my sql database one is "vendor" and other "purchase_order" they both have one common attribute "vendor_name" my problem is that i want vendor name in my "purchase_order" table to be same as that in "vendor" table but vendor_name is not a primary key in "vendor" … Databases mssql |
| | I'm trying to create a webpage that will allow the user to input a vendor number(text box) and if the number exists populate the form with vendor name, phone and state using a stored procedures. Below you will find the stored procedures and after it my webpage. Stored Procedures: SELECT … |
| | Primarily, I need a table of employees with the following fields: Name, Photo(s), and Bio. So the rest should be easy enough, but I know nothing about databases.... so the photo field I'm assuming should be of the blob type, however I need to have a primary photo, and then … Databases mysql |
The End.