Databases Forum

Does anyone know of a free tool or utility that I could use with pgAdmin III that would accomplish the same type of import functionality found in Navicat?

I'm trying to set permissions in mysql for an ecommerce open source application (freeway) for a path: Set the permissions on Freeway/images directory to 777 in my terminal I have typed: chmod 777 /Sites/Freeway/images but it is telling me that "no such file or directory exists", and yet when I …

Hi I installed oracle 9i on my system. I am working with sql plus browser. my doubt is how to open iSQL *plus browser. I tried my level best to find out but no use. please any tell me how to open iSQL *plus. Thanks

Can someone help me figure this out. What do I need to do to set permissions in MySQL? Thanks in advance.

Hi everyone. Sorry if this question is in the wrong area..I posted it on the VB forum and they advised me to post here also. I have created a visual basic system that is connected to an oracle database. (I connected through data>Add New Data source>New Connection>Oracle Database etc etc) …

Hi Experts I am trying to develop a web application using Pl/Sql as scripting language. but i cant understand where to start and what i should implement the configuration for this purpose.

Hi, When i insert data into any table last number of sequnce get increased in all sequences that are listed below. These are for auto incremented numbers. All tables have their own autoincremented coloumns. Can anyone see mistake? Thanks [code] CREATE SEQUENCE FRANC_AUTOINC_SEQ START WITH 1 INCREMENT BY 1 NOMAXVALUE; …

Hi, Here is my mysql sentence: [CODE]select last_insert_id() from pp;[/CODE] and the table pp is created by: [CODE]create table pp(id int not null auto_increment primary key,name varchar(255) not null);[/CODE] Now I'd like to change the above into sentences that are right in Oracle. First I create table: [CODE]create table pp(id …

Hi. I Installed Apache 2, PHP 5, and Mysql 5 (All Latest Version) and now i when open e script on my localhost that needs a mysql connection (i tried with phpmyadmin) i get a error: Could not load module mysql.dll (ore something like this) but the service is running …

Hi All, We have many test artifacts and each unit is known as [B]U[/B]nit [B]U[/B]nder [B]T[/B]est (UUT). Each UUT is unique entity so it can be considered as a Primary Key. Also there are various defect categories (viz. CAT-I,CAT-II). Moreover each Category can be broken down into exact defect name. …

I am using MySql 5.0.51a and am trying to acheive the following I have 2 tables, one of categories and one of company details, each company can select up to 6 different categories for their business. In my category table, I have sub categories, and sub sub categories, eg, Main …

I am trying to design a web base system for A1 Holloway car hire, I am not sure about my Entity Relationship diagram as when I try to make the relationship between two table it never goes the way, here it is: booking_tbl ( PK booking_id, FK vehicle_reg, FK customer_id, …

hi there when im trying to connect to a remote mysql server im getting an error i searched for it and i came to know that MySQL database server remote access disabled for security reasons by default and they provided with lot of steps to enable it the problem is …

Still in a VERY steep learning curve with MS Access 2000 / 2003 Main Table has LastName - HomePhome - MobilePhone plus others of course Some rows will have no entry in the HomePhone field but will have one in the MobilePhone field. I am trying to set Query criteria …

Hello, why wont this code give my "Rubrik" a link with its ID? I only get "www.yada.com/open.php?id=" [code=sql]<a href="skapaannons.php">L&auml;gg till annons! </a> <?php $con = mysql_connect(" "," "," "); if (!$con) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("annons", $con); $result = mysql_query("SELECT annons.id, annons.datum, annons.rubrik, annons.pris, …

Greetings all, I've been asked to create a database to track and report testing progress of a large number of IO points for an industrial plant. I can't seem to come up with an elegant way to split up the data, so I'd appreciate input from folks with more experience. …

i am new to this database. can i know where can i type the command?:'(

Hi, I have just downloaded 10g express edition but there is no user interface like SQL Server has. Does anyone prefer any program because i am new for Oracle and have never used before. Thanks

I work here at UPS in the HR department and they use a Microsoft Access mdb database that connects to oracle servers to retrieve tables. It then creates a local copy of the tables and the queries run off that. The tables are updated every morning at 6am by a …

Hi, Below trigger increments double(2,4,6,8...) not single. I want single. Where is mistake? If you can not help, is there other way to do auto increment? Thanks [code] CREATE TABLE MY_TEST ( IDNUM NUMBER, NAME VARCHAR2(4000) ) ; create sequence test_seq start with 1 increment by 1 nomaxvalue; create trigger …

Suppose a table ABC have column XYZ containing data 3PSY0001-06-08-F 3PSY0001A-07-09-P 3PSY0001-02-09-P 3PSY0001-07-07-F 3PSY0002-09-08-P 3PSY0002A-01-03-P 3PSY0002-07-07-F How can i write a query so that the data ending with P without A can be updated with A. For example, with that query, data 3PSY0001-02-09-P AND 3PSY0002-09-08-P will be updated as 3PSY0001A-02-09-P …

Dear all, Requirement is - There is online Form with lot instructions and also user inputs values and there is also a row column intersection values also to be stored. Eg - Name, details1, instruction1, instruction2 - There are having singular values. Other - Prospective loss - Here the user …

Hey all, Ok first my problem. I have a database that has an employee table and then also an absent table(for when they are off sick). The problem i have is using sql to find the employee that is off the most! So for my sql on the absent table …

Hi all. I'm experiencing an issue in my database design.. In my Products table I must assign a Quantity Per Unit column but the problem is the value of that column for the same product could be 5 or 6 or 7 .. how can I solve this problem in …

Hi, Could you pls explain me the confusing, diffterece between the views "USER_ " , "ALL_" and "DBA_". On which table query should be executed to get all the list of views like user_constraints, user_sons_constraints, user_source,user_sequences etc. Regards Pointers.

I have production data on one server and test data on another. I need to move one record from the production server into the test table on a different server. I setup the production server as a linked server one the test box. I can read/select fine, but when I …

HI im new to the forum and new to access. I just recently took a position with alot of acces develpment involved. My first ques tion is how to pass a value from one form to the next. i want to keep track of what user edits certain records i've …

Hi dudes, I desperately like to know the best way for learning Oracle including all accessories with regard to that I am fully familiar with database designing and Mssql into the bargain. Show all ways like all materials,tutorials and so on. All the best!!!

Im MarcusMaximus. I registered to see if i could get help in access development i never did it in college to the extent i need to do it in work and i am stuck on a lot of things as im now the only person in IT here and nobody …

from last thread, I figured it out my tables relationship and they do work i believe. however, i can't successfully get elements from each of the table out. if i do: select b_customer_name, h_customer_firstname, h_customer_lastname, telephone from customers c, business_customers b, home_customers h where c.customer_id = b.b_customer_id and c.customer_id = …

i am trying to send out an email which contains images from a database of images that have been uploaded. when i send the email out only the text and any images that have been hard codeing in using the img tag. i have done some research on this and …

Hi! I am trying to use MS access to develope a database which can store "Multiple choice questions and options " as input. And out put shold be taken randomly from the database and it should prepare a word file. But I am a physics lecturer. I have a less …

The following code coincides with an onClick event on my form to move to the next record in a file, but I keep getting the Error Code: 424, object required. I have (3) other buttons on my form: MoveFirst, MoveLast and MovePrevious, but they all work fine. What is different …

hi i have two tables,i want to display the details in startpost and based on the userid i want to display the username ie i want to print posttitle,date,name using single query please help [CODE] CREATE TABLE `creuser` ( `uid` int(11) NOT NULL auto_increment, `username` varchar(100) NOT NULL, UNIQUE KEY …

I've been away from sql for quite a well and need a little push to get restarted. Need to report out of a single table, with values coming out of only two columns. Need to group items from column 1 as the left column in the ouput table with totals …

Having braved the task that is getting mySQL6.0 installed onto my machine, after listening to the preferences voiced by database users everywhere I was delighted when I finally got down to a bit of a play!!! The problem I found almost immediately, was that a lot of the returned results …

I gotta make an EpoS system. Does this look right, as a first attempt?

Hi there, Anyone to help me on sql code for SUM. I need a query that gets the SUM of one table column and subtract it from the sum from another table column: I tried this but it gave me wrong answer; [icode]SELECT SUM(i.amount-p.amount) FROM income i, payments p;[/icode]

Dear All, I am new to MySQL. Can i retrive the result of a query as the combination of different fields of a single record.. For example.. if the result record of a query is ... id(1), country(India), Location1(maharashtra), Location2(pune), Location3(Navi Mumbai)... My doubt is that can i retrive the …

I want to get two columns data from two tables which are not dependent to each other i.e. no key common in both they are not related to each other. I can't use JOIN because it needs where clause which uses a common field from both tables. I just want …

hi guys... i have an urgent problem please give an idea about it.. Question#1: I want to know the correct date syntax in query database using MySQL... Question#2: I currenly using the MySQL connector/OBDC 3.51 is their any problem about it?? thxx in advance.... and ned asap reply... thxxxxxxxxxxxx guyzzzzz..

I have to create a trigger having the following database. I'm confused in using the trigger type(row-level,st-type). Please help me out. Consider the relation schema of the COMPANY database given below EMPLOYEE (fname, minit, lname, ssn, birthdate, address, sex, salary, superssn, dno) KEY: ssn DEPARTMENT (dname, dnumber, mgrssn, mgrstartdate)KEY: dnumber. …

Hi, I have some tables (below), but I'm having trouble entering multiple lines of data. Here are the tables I have created. [QUOTE][B][U]CUSTOMER table[/U][/B] SQL> create table customer 2 (customer_no char(6) not null, 3 name varchar2(30) not null, 4 address varchar2(50) not null, 5 credit_limit number(6,2), 6 constraint customer_customer_no_pk primary …

hi all..i had problem here..hope someone can help me.. i`ve create a db that contains several tables. myproblem now the foreign key doesnt parallel with primary key. i had create table named form which form_id is the PK..then table named register which id is the PM.i put form_id in table …

Hi, Firstly, I'm not a programmer nor a web-developer, but rather a statistician. I am doing equity-related (shares / stocks) research and I need to place my data in a database (MySQL), since it is too big to work with in a spreadsheet. I have weekly closing price, volume, market …

Hi all, I am currently designing a database for a warehouse but I cannot get the ERD Wright. The entities which I am using are( Warehouse, order,customer, suppliers, products) these are my tables but after handing in my assignment, it has been returned to me and been tolled there is …

Friends, I recently switched to SQL server 2005 from SQL server 2000. Well in SQL server 2000, I used to made databases manually and applied other SQL commands from Query Analyser menu. Where's the same functionality is provided in SQL Server 2005 . Where's the path to go there? Waiting …

I want make a query to retrieve only those records from table which are unique on the basis of some coloumns

I have written the following code to try and run a report that will list customers names and ytd charter costs whose ytd charter cost are greater than the average charter cost for all customers. There are 4 table involved: customer: PK cus_code, cus_fname, cus_lname|| charter: pk char_trip, char_date, cus_code,char_distance,ac_number|| …

can anyone tell if it is the right way to connect these tables? What is the query display customerid, b_customer_id, and h_customer_id... thxxx --customers [code=sql]drop table Customers cascade constraint; create table Customers( Customer_id Number(5) primary key not null, Credit varchar2(20), Street varchar2(20), City varchar2(12), State varchar2(2), Zip varchar2(5), Telephone varchar2(14));[/code] …