Databases Forum

hi i need to know how to query a number of count on a particular table let say i have [B]emp_id[/B] and [B]emp_name[/B] field. on my table their are 2 records. the result looks this: rowcount | emp_id | emp_name 1 1000 albert 2 2000 leah is it possible? thanks, …

Hello. I have experienced a very weird problem with my myisam table with appr. 1M rows. Query [CODE]select num,subnum from a where trip='!mOWjKAWAII' order by timestamp asc limit 10;[/CODE] executes immediately, which is just as expected. But with a slight modification: [code]select num,subnum from a where trip='!mOWjKAWAII' order by timestamp …

Hello, thanks in advance to anyone who can help me with this query. What I am trying to do is to retreieve a list of all the users from the table 'users' and count how many posts the user has made. The code below will shows a list of users …

Hi All, I plan to have a website that has database connect to it. On my database, I want to display vietnamese characters (Input and output). How can I add vietnamese collation on my MS SQL Server 2005 developer edition? I am looking forward your help. Thanks.

Hello, I am somewhat of a SQL newbie. My question is how would I go about creating a query that searched for things like: 1. users who have collected a complete set of promo items 2. users who have purchased every movie from actor X 3. users who have purchased …

hi, what is the diffrence between delete and truncate command in sql. plz send me tutorials of oracle also. waiting for your reply. <URL SNIPPED>

I want to find duplicate names from my database I wrote the following query. But it is displaying more that existing records. I guess it is taking cartesian product. select a.name from emp from emp a,emp b where a.name=b.name; can anyone correct this query. I want to display all the …

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 …

Hello, I am quite new to PHP and MySQL. Could anybody please help me with this problem? Suppose I have a database like this, [ICODE][U]Type[/U] [U]Name[/U] [U]Price($)[/U] A ABC 150 A DEF 350 B XYZ 250 B UVW 450 C ....................... .............................[/ICODE] The user is required to choose the type …

I am designing a site with a javascript login that leads you to a flash actionscript site. What language would I be looking at for a database? Mysql? I can use any feedback.

Hi i had a mysql database ( coading in php ) in my real estate web site. It had 4 columns. 1. for ( ie, buy or rent ) 2. district 3. Type ( villa,house,.....) 5. price ( 1 lakh, 2lakh, 3 lakh ...) I need to add a searh …

I would appreciate a critique for the following database from anyone who is willing and has the time: [url=http://edwardgdanaii.info:8000/EDanaII/Programs/MediaLibrary/]Medieval Media Library[/url]. All comments welcome. Ed.

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 everyone, I'm trying to convince my boss that using normalisation is the best way to design a database but he's a hacker rather than a coder and he's taking some convincing. If we take the typical Staff\Department scenario as an example (where it would be possible for a new …

hi i am looking for a jiob as a junior Oracle DBA can any one please advice me on how to get an Oracle DBA job. i have beeen looking for where to startup my career but everywhere i go to they are asking for 3 or more years real-time …

I have a user table that contains username, password and status jobs. The user have a option to fills unemployed and employed in jobs field. My question how to make sql statement to count how many people that choose unemployed and employed. Then view the result for number of unemployed …

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 …

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 …

Hello everyone I need a solution for my problem. The solution can be a simple PL/SQL block or a trigger I have a table called T_SBSTTN_VLTG_MSTR with following data SBSTTN_CD VLTG STTS DT_ENTRY FK_TM_ID 10111111 11 Existing 2/9/2009 19:32 10144 10111111 33 Existing 2/9/2009 19:32 10144 10111111 132 Existing 2/9/2009 …

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 …

Note: I debated whether this should go in ASP forum or SQL Server forum and I think it belongs here. Ok, I have a classic ASP web application, a custom intranet, which has been used in 7-8 different installs, 3-4 different servers with no issues. It uses a SQL Server …

what exactly is a 'Database Schema' ?? and how can i make one ??

Hello all, i have SQL 2005 installed. i have written a table-valued function getdepartments() which is as below: [code] CREATE FUNCTION getdepartments() RETURNS @departments TABLE( DNAME VARCHAR(25), DEPTID VARCHAR(10), DBONUS DECIMAL(7,2)) AS BEGIN INSERT @departments SELECT * FROM DEPARTMENT; RETURN END [/code] i need to invoke this statement from java …

Basically I have made a database that does all of my company's human resources needs. Now I have no training and everything has been learned from trial and error and/or looking up on the internet, but try as I might, I cannot find the answer to this question. Basically on …

Hi Sir.. I am Using MySQL-Front 5.0 .. I want to create a Trigger n Stored Procedure.. But I Could't Do In MySQL .. It shows an error message n ask Super privilages... My Doubt is .. Can we Do Trigger n Storedprocedure in MySql-Front 5.0 and .. If Possible,, …

Good Day All i have a table that carries a Field that has data like this [CODE] 10101010101010[/CODE] Now the Function that adds this 1's and 0's is working like this. If its selected insert "1" else "0", So if i can interpret the above if will be [CODE] 1 …

Hi, I would appreciate some help, I cannot get my query to work: [code=sql]UPDATE journey j SET j.occupancy=j.occupancy-1 Inner Join passengers p On p.journey_id = j.id Inner Join shuttle s On s.id = j.shuttle_id WHERE s.id = '1' AND p.passenger_name = 'bill gates'[/code] It is used when a cancelation is …

Hi, I'm new to coding (anything) and my manager has tasked me with developing a stats page for the IT dept. trouble ticket system (php helpdesk by EXOScripts.com)(MySQL database) I have laid out the table on the page but just need to populate it. the table has the following coloumns …

Hi, I get this error in my myPhpAdmin in WAMPserver 2f. [code]#1045 - Access denied for user 'root'@'localhost' (using password: NO)[/code] How can i solve it?

Hi, I'm new to SQL Server. I just installed SQL Server 2008 Express. Then I opened Management Studio, right clicked on Database and created a new Database. Then I expanded Database, right clicked on Table and created a new Table. Now, my question is, how do I add data to …

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 …

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". …

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 …

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 …

Hello everyone! if someone knows any source code (PHP or whatever) for creating an online dictionary, I would appreciate a lot if he would share it with me. But this is Database Design section right? :D so, I want to create an online dictionary service, and lets say I have …

Hi, Could someone please tell me how to get all the tables in one program/file so that i can run them as one. Please very important..thank you

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 …

I noticed that my backup of my 2005 sql server didn't work over the weekend. I don't really know where to start as I haven't dealt much with servers. But I can tell you this.... SQL Server agent has a big red circle through it for not working on the …

I want to write an sql statement in c# where I want to pass a "true" or "false" value basing on some condition... can we pass true to sql statements Ex: [CODE]select * from emp where (empid=1234 and true); select * from emp where (empid=1234 and false); [/CODE] This true …

I am new to Oracle and SQL. I need to write a select statement for a student extract at a college. For ex: select ss_id from id_table This will return all id's from this table and they are a length of 9 digits, i need to return just the last …

I have two tables, say t1 and t2. t1{ txn_id varchar status varchar } t2{ txn_id varchar date Date } I want to built an update query which will update t1.status='X' with join condition t1.txn_id = t2.txn_id and t2.date < sysdate. Please let me to build an update query.

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'm new to T-SQL and trying to program a simple query: Table1 Location ID Flag Table2 (many to Table1) Location ID Code Select Table1 Location_IDs where the count of Table2's Code=value is 0 Thanks for your help!

Hello everyone! I can`t find a solution to the following problem in SQL Server Reporting Services 2005. I created a table which has multiple columns. It can happen, that some columns have the same values for multiple rows, only the most right column has different values. For example Column 1 …

Hi, first of all Hi to all members. i have a shopping portal in which we data coming from different merchant on web of there products in CSV format. the CSV of the product come in standard Structure from all the merchant. we get these CSV at same time schedule …

Hi folks, I’m planning on building a site somewhat similar to a web hosting directory and was hoping to get some input/advice on the database design from all you coding gurus :P I’d like to have two different types of users: 1) hosts 2) normal users Because of the this, …

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 …

Hi guys, i have a big problem, hope you gurus in MySQL can give me a hand. I installed the following package in 2 servers that have all in common except that the server A is in a Domain, and have SQL SERVER 2005 installed. The package installs with no …

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 …