Databases Forum

Im trying to practice writing a small DB that involves three tables-internal users, external users, and a Rep (call rep) table to tie them together so if someone is partial to working with one of us it is notated. Here is what I have so far: Employees (for later down …

Hi, Simple query: [code]select * from MyTable where Id=123456;[/code] The first time I execute this query it takes 14 seconds. However, the second time I execute it takes 0 seconds. I wanted to clear the cache so the second execution takes 14 second just like the first execution. So i …

I have a query to find dates based on Between And criteria but I can't pull up anything in 2008. all 2007 dates work properly. What am I missing? Thanks

I am having a complicated problem with the design of a database. Lets Describe the problem This is going to be used in a job tracking system we will have a list of jobs so TABLE 1: JOBS ([U]JOBID[/U],DUE DATE, SHIP DATE, INVOICE DATE, STATUS, CATAGORY) what is category well …

hi i have a form where the user will enter the data based on the user input i want to retrieve data ex 1st textbox one get the standard (class of the student) 2nd & 3rd textbox get the range (ex rank 1 to 10) when the user clicks submit...i …

I need help to write a stored procedure, or pseudo code, that looks into a table named numbers_ranges and retrieves the next unused value. The table currently has the following data: Columns are: id, start_range (22), end_range (22), status (1), date_created (datetime), date_updated (datetime) 1 8057777777450780000000 8057777777450780000010 N 2007-11-29 16:28:46.793 …

Hi all, I'm currently finally starting mysql and am have difficulty getting it up online. what i've done so far is correct but only for this error: Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'www.dteeducation.ie' (61) in /usr/www/users/adv123site/home/youruser/public_html//settings/database.php on line 10 Cannot connect to database, check if username, …

I would like to know how to apply Constraints after creating a table. I was just practicing and creating a database HomeInventory by reading the free e-book from Microsoft. But I'm trying to implement the functions using T-SQL. So How can I do so? [code] CREATE DATABASE HomeInventory USE HomeInventory …

Has anyone installed it? I've downloaded both express and full developer edition but I can't get past the user account stage. Can someone give me valid userID's and passowords for it? I don't have a password on my user account though..

Am trying to develop a front-end to Mysql database. I do not intend to use it for web purposes so I do not need PHP. which slanguage can I use?

I was wondering is there anyway to wrap the text in the columns? Also, is there a way to adjust the column width automatically? I know how to do it manually, just wondering if it would adjust on its own. :?:

Hello! I have a query with multiple table joints and where clauses. Tables are huge and query runs for a very long time. I need to run another query, which is exactly the same apart for one Where clause (first time price = "P", second time price = "S"). I …

Hi, What is the datatype for storing dates? DATE datatype is not working.... I wanted to insert the joining date of an employee into the table...

Folks, Many years ago I worked as a dBase III programmer. In my early 30's I left the field of IT to persue another career. Today I am required to develop databases for a variety of stand-alone (PC) applications. I have Access to construct the database but I need advice …

I have been working on a program designed to read information from an Access database and display it on the screen. As my main development box doesn't have a copy of Access on it, I copied the data over to a PostgreSQL database and attempted to work from that. Now, …

Hi, Im only used to basic sql queries. wonder if anyone can help with the below - or at least get me pointing in the direction of the correct resource to solve. I have a table, with fields a,b,c,d,e,f I need to run a query that shows from the above …

I've two tables where their composite keys are foreign keys that references each other. table1 (projId, userId, name, add) table2 (projId, userId, status, responseDate, reason) I need to retrieve table1(name,add) and table2( status, responseDate, reason) with projId only.. my query is [CODE]Select ap.name, ap.add, p.status, p.responseDate, p.reason from table1 ap, …

hi... i have setup the mysql replication but i dont know for some reason its not replicating the data.. i may be missing some configuration.. please help me... to do the same.. Thanks in advance.. Pooran Jaiswal my.cnf entries on slave server [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old …

OK, I'm fairly new to PL/SQL, adn I have a query to write, which is confusing me. Let me explain: I have a table, with three fields, CustID, CustName, Number What I want to do, is identify and display all rows in the table, where the last four digits of …

hi, i want to kill all the sleep process in mysql , since it is unnecesserly taking the server memory and process.. Regards Pooran Jaiswal

I need a simple script to do the following... a form that a zipcode is entered into and when subbmitted returns the results matching the field zipid. Here is what I have but I can not get it to work... FORM <form method="post" action="http://alwaysaegis.com/cms2/content/results.php" target="_blank"> <div align="center"> <table border="0" cellpadding="0" …

HI.. I want to create an webpage such that when user will enter their username and password,the data will be stored in a database(I am using MySQL).I have the code.But when i am trying to run the servlet,its showing following error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver I have set the classpath of the …

This is an annoying error...tried re-writing the code a few times...deleting and recreating the table...etc...still the same result: " ... You have an error in your SQL syntax; check the manual that corresponds to your MYSQL version for the right syntax to use near 'desc) VALUES ( '', '1', '1', …

Guys, without saying anything much, I have such data at hand (rows from a database table): [code]111 | xyz | a, b, c[/code] Following someone's wise words, I would love to have this transformed to : [code] 111 | xyz | a 111 | xyz | b 111 | xyz …

Hi All, Newbie poster here. I have an, I guess, architectural question. I am still very much a beginner in mysql so bear with me. I have an e commerce site in which the prices of my products fluctuate very often. By default, my customers see the regular prices or …

I'm having trouble with the following scenario: drivers may have any of the 16 types of certificates, tasks may require any of the 16 types as well. What I need to do is build a query that will selectd all the tasks a certain driver can perform. Example: driver has …

Is it possible to select day from the DATE field in a db so that it includes a zero in front of it if the day is less than 10? If so could you post the code please. Struggling and stressed...with qwerty imprinted on my forehead

hi could u give me the code to open PDF file, or open a folder ?Thax

Hello, I'm working with SQL server 2005 and a database that has "equipment status" data that is spread across several tables and is time stamped in only one table, there are multiple instances of duplicate records with differing time stamps. I need to select only the newest time stamped messages …

Hi all, I need to use MySql in a commercial website. What License should I buy MySql in? What if I reveal the sourcecode? Do guide me. thanks kararu.

Hi, I have the following query i'm trying to execute: [CODE="mysql"] SELECT CONCAT_WS(' ', g.genus_name, s.species_name, i.rank, i.infraspecies_name, conf.auth1, conf.auth2 ) AS scientific_name, cn.common_name, GROUP_CONCAT(cn.common_name ORDER BY cn.common_name SEPARATOR ', ' ) AS common_names, ui.unvouch_image_src, ui.unvouch_image_alt, gh.growth_habit, gd.gen_distrib_name FROM plants AS p LEFT JOIN (genera AS g, species AS s) …

I'm new at SQL, and i found this book that is amazing, so, i thought it would be cool share it with those guys (like me) that want to study Databases (SQL specifically) and don't know where to start... maybe we can exchange book titles and stuff, so we can …

Hi to all, I have a question and I hope to have an answer here. the Question is, is using MySQL DB in commercialweb site free of license or not? I know it's an open source, and to the best of my knowledge the using of open source applications like …

We have an Access database that another department is taking over and considering switching over to FileMaker and using on our website (which we manage) with Sequel but - we have heard there are problems with using FileMaker with Sequel....does anyone know if this is true? and if so what …

hi, I have only done basic sql queries and need help on this major one trying to combine many queries into one. What I need is to make the following queries into one: [code]SELECT Username, LastLogin, DateCreated, Views, MainPic, Logged FROM Users WHERE UserID=? SELECT COUNT(AlbumID) FROM ProfileAlbums WHERE UserID=? …

Is it somehow possible to retrieve a string and then convert it into a mathematical expression? for example i have this string '14200 * 5' and then i want to convert this into a mathematical formula so that i could get the result of it which is 71000.. .. i …

Hello, I have a quick question. I'm currently using MS SQL 2005. I have a main table which has many fields. I created a view#1 which imports all the rows from the main table but I only select the "City" field, "PurchaseDescription" field and a "Cost" field. Only the city …

hi all, right now i'm trying to migrate from db2 running under linux to mysql v5.1. i manage to export out the db2 structure & data into a del (ascii) file. but when i try to load the data from the del file to mysql table, it generate an error. …

Greetings, I'm having a heck of a time trying to get this pl/sql program to work. I'm to invoke it using shopper id and then again by shopper last name. I've banged my head on this for a while now and it seems that every change I make creates more …

recently i created a system using php and mysql to record faults that the ict technicians could get reported faults out of. so far it does everything i want but some senior members of staff now want the front end to give a report of status, one of the things …

Hi, I want to store the text data with apostrophe in the table. I tried through this query like this insert into temp values(101,'vijaya's'); but it is giving error - missing comma Could anybody help this sql query for the following requirement? NAME vijaya's rajani's

Greetings, I've posted this question in other news groups (msdn and a few others) without any response.:sad: I hope I don't get into any trouble for posting this question here, but I reach out for your help.:confused: I have an excel file stored in a data base table as an …

Hoping someone can shed some light on this one, using MSSQL 2000, I have a query like this; Select T.TransactionRecordClass, T.ClassDetail from [remoteserver].otherdb.dbo.Data T where T.TransactionRecordClass like '10000002%' which will return around 10000 records in under 1 second. My issue is that I need to make this part of a …

Hi there, My database contains two tables namely [B]Products[/B] and [B]Stocks[/B]. Product table consists of [B]ProductName(VARCHAR[100]), PackingStyles(VARCHAR[2000]) and Grades(VARCHAR[2000])[/B]. Primary Key is the combination of these three fields. The values of PackingStyles and Grades are entered using a listbox and so they are stored as comma separated values. The Stocks …

I am trying to use this script to enter data into my database from an html form. [code] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Item Entry - Opulentworx - Private</title> </head> <body> <form action="/php/itemENTRY.php" method="post" id="itemENTERdb"> <input type="text" id="itemNUM"/>Item #<br> <input type="text" id="quant"/>Quantity<br> <input type="text" id="date"/>Date<br> <input …

I am pulling a simple query but basing it off of a group of sums. What I want to do is pull all the information from "albums" where albumID equals "photos" albumID. Then Grouping by Photos.albumID, I want to grab the sum of all the views of each albumid, and …

my second thread of the day... hey guys, I was wondering if someone could help me. I am new to SQL Server therefore new to T-SQL, I have worked with SQL before. I am trying to reference foreign keys when creating tables. The code I have in SQL is :- …

OK.. I want to start trying to develop a web app using an SQL Server 2000 database. The only language I know comfortably (but not totally) is VB (although VB.NET is giving me lots of problems). What should I use to develop this program? Dreamweaver? Visual Studio.NET has web development …

Hi, I want to implement a functionality in a database so that a menu can hold as many drinks and as many food items as possible. I am using a Link table for this functionality. Please have a look at the link Tables.doc file attached. There is a picture (er …

First of all this is a crazy thing I have just done.. so please sit back and read the whole post.............. Today I finished my math final and decided to learn a new programming language..... MYSQL. So I was able make my way to [url]http://www.freewebmasterhelp.com/tutorials/phpmysql[/url] using Google I followed most …