Databases Forum

I posted a similar question in MySQL section before but i think this one might be more general/easier to understand (hopefully): I'm doing a database (in MySQL) of different plants which is gonna store various (somewhat detailed) information about them. Here's a sample of two tables: Families (Plant Family) [code] …

Hi All, I am New in MySQL. I Want to Create a Database in MySQL. I am Using MySQL5.0 & Write This Sentex for Creating Database :- CREATE DATABASE db_name; But When I Use This Sentex Create Database With Single db.opt File. & I run this Database on Server Message …

Hi guys, I'm very new to MySQL -- so, your help is very much appreciated. I have a table that has 50 fields. 2 of the fields are primary (named: item_number and catalog_year). There are about 1200 different unique items on this table. Now, what I basically need to update …

Hi there I"m building a page that displays events for example: Event heading 05 June 2007 Event Description Another Event 19 June 2008 Event Description What I'd like to know is how do I sort the events by date in the format shown above. At the moment I have a …

Ok, i have a database where i'm storing information on plants and in one of the tables is a plants table: here's the first few fields in the table plants: [code] plant_id, family_id, genus_id, species_id, auth1, auth2, ... [/code] plant_id is the pk, family_id, genus_id, species_id are foreign keys. soon …

Hi All, I'm developing an application using VB 6.0 & using MS Access 2000 as backend. How many records can I store in a table? Is there any such limit?

Hi all, Im trying to create a trigger but keep getting a syntax error. Basically the trigger must be created after a insert on table_1 and update another table's fields with 1 depending on what was inserted into table_1 ( apple, orange, banana, grape ) CREATE TRIGGER trigger_name AFTER INSERT …

Hi All I am trying to create 2 tables Table 1 with cust_id , username and password (Cust_id is primary key here) Table 2 wth cust_info that will store info for that cust........now i want to use this Cust_id as foreign key here in table2 but i am not able …

Hi, I have been searching around for a few days and cannot find exactly what I looking for. Was hoping someone could point me in the right direction. Looking to query MYSQL with keyword. For each of the records or rows its finds based on match. Would like to retrieve …

I have a Database which is dealing with a book library system. I have a table which has a has a field dealing with the ReturnDate of a book. I was wondering if it is possible to do a SELECT statement that would return the the fines due on an …

Hi. Can anyone help me with this? If I have, for example, a MSSQL database named 'COUNTRIES' and an existing table in the database named 'COMPANIES', can anyone let me know how I can add an additional field name 'PEOPLE' with a string datatype (for example) to this existing table …

I want to generate a code that will automatically take the poll-id..of which the user wishes to view the result of that poll. there's the code:using mysql & java & another thing i wish to use this on a jsp page: [code] package votepiepack; import java.sql.Connection; import java.sql.DriverManager; import java.sql.*; …

The program I use is housed in a SQL Database. What I am trying to do is term Members based on meeting 2 guidelines (PCP and Insurance). WHat I want to do is term a group of members that have the same PCP and Insurance plan. This data is broken …

I'm not entirely sure If this is going in the correct location. What I want is to set up my database so that it will updated every hour. I'm a little unsure on how to tackle this problem. Does oracle actually support this type of updating, and if not, would …

Does anybody know if oracle saves "last modified" data? I want to use this in a archiving tool by only querying for data after/before certain dates.

how to write a query to insert a row that is deleted from one table to another table using sql server 2000 at the same time

I was wondering if anyone could offer a solution to this database design problem. I have very little experience with relational databases in Access. I have only used databases just to get easy data, but now it is starting to get complicated. I read a little on relational database design, …

hi every one, i want to know about configuring sql mail.i have sql server on my computer and i want to configure it to send sql mail.i want to know which account i have to use as local system account is not being accepted.when i try to create seperate account,i …

Hi everyone, this is my first post here! I am making a small application that helps manage merchandise returns in a computer store I work for. I am currently designing the database for it and an issue has arose which is probably obvious but is eluding me right now. I …

Hi, How to check if BLOB field is NULL or Not in a Table though other data is available in a selected row ? I need to do this in a sql statement. Thanks Sandy

I need to write a query that pulls out Zip codes by the first three characters, so I started with this: [code] SELECT SUBSTRING(Zip, 1, 3) FROM AvailHomeZips AS tZip [/code] But I would also like to query out the zips by those substrings I pulled out, so that would …

Hi, I've run into a situation where I can not see how to write efficient code to perform a check that I need to do. I am running on MSSQL 2005 The check is to compare a varchar passed in to the stored procedure against the words in a table. …

I'm building a large scale application and was wondering the difference between static counts vs dynamic counts. Right now, I'm using dynamic counts. For an example: [code] SELECT *, (SELECT COUNT(1) FROM CarImages WHERE CarImages.carid = Cars.id) as ImageCount, (SELECT COUNT(1) FROM CarBuyers WHERE CarBuyers.carid = Cars.id) as BuyerCount, (SELECT …

Hi I am new to SQL and I am trying to connect to mssql server via vb.net with a code someone else has done. I am not sure why it won't connect. part of the code is below: _DBConnection = New SqlConnection '(ConnectionString) _DBConnection.ConnectionString = "Server=MASTEC;Database=CHH_Cardboard_DA_new;User ID=sa;Password=xxxx;Trusted_Connection=False" _DBConnection.Open() when I …

hi.. i've created a table named :Survey [code]CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DateCreated] AS (getdate()) , [coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL …

Hi everyone, What is the difference between UNIQUE and DISTINCT? It seems that they do the same thing. Thanks, Nick

Hi every1, Is there any way that i can secure my ms access. i want when ever any one opens my database,it should ask for a password. any way of doing it? the database has already been created thanks in advance

hi every1 i m using jbuilder9 to develop my website and mysql as its back end when i use mysql with simple java program it runs as i store the jconnector in jdk1.3/lib/ext. but when i stor the jconnector in jbuilder/jdk1.3/lib/ext it does not work. can any 1 plz tell …

hi every1 i hv created my database in mysql now i have to run the s/w on my clients system. can any 1 plz tell me the steps to export the mysql database and then to import it on my clients computer. thanks in adv

Hi. I'd like to ask you another question. I read a lot of articles about the topic but I'm still not very sure how to deal with the following problem. I want to design a database that contains the properties that a real estate agency offers. The problem is - …

Hi everyone, I am still fairly new to Oracle and SQL. I have two tables with the same information in them. Table1 has the same columns as table2. The differnce between them is the date column. Table1 has 2005 records while table2 has 2006 orders. I am trying to write …

Hi. I have tables like these: [B]table1 [/B]([U]table1_id[/U], table1_attribute1, table1_attribute2) [B]table2 [/B]([U]table2_id[/U], table1_id*, table2_attribute1, table2_attribute2) The primary key of the first table is table1_id. It is auto incrementing and it is also a foreign key for the other table - [B]table2[/B]. Let's say I want to add a new record …

Can somebody please help me to little customize the view of the phpMyAdmin? Curently this is what I [URL="http://www.peterbudo.f2s.com/extra/myAdminC.jpg"]see [/URL] but I would like to have as [URL="http://www.peterbudo.f2s.com/extra/myAdminW.jpg"]this[/URL]. Simple, I don't like options to be displayed as list of links but as tabs. What shall I change in config?

Hello everyone, I am fairly new to oracle and SQL and I am having a little trouble figuring out how to accomplish a task. I have three columns from a table, we will call them 'a', 'b', and 'id'. I first want to order by 'id' and then query the …

Hi all - I am a newbie to this forum, but maybe someone there can help. I have a table using an Identity property. The purpose of it is to just have a unique id value... the problem is that the system automatically fills this table with lots of data, …

Hi Guys, Just Wondering if it's possible to choose whether to run a macro or not depending on which user logs in. I've got a macro which updates the database everytime it starts. I want to restrict it to only limited number of users. Thanks for your time

Hi Guys, I'm having a bit of problem with my reports. I've got a report containing a subreport which has some headings in its report header. The subreport normally goes for 2 or 3 pages. The headings of the subreport appear on the first page but do not appear on …

Hi Guys, Just wondering what's wrong with this coding UN = Form_MAIN!LOGIN_DETAILS.Value model = Form!COMBO_MODEL.Value stDocName = "MODEL_SELECTION" stCOND= "[MODEL_LN]='" & model & "'" And "[TM_NAME]='" & UN & "'" DoCmd.OpenReport stDocName, acViewPreview, , stCOND I'm getting a type mismatch error on the line where I specify value to stCOND. …

ok, well i know sql well but i am new to MySQL, learned that(mysql) few months back. however i have installed a new software called Altova DatabaseSpy to make my work much easier. Its working with all other databases Oracle, MSACCESS and all but not running or connecting with MySQL. …

Hi can anyone help me on how to get the names of the tables from a DB - MSSQL 2k server? i need to list them or add them into a combobox, but i also need to select them by owner, or by type. user defned or system. thx in …

Hi, I want to edit the sql server regestration. I want to change the Connection property from Windows authentication to Sql server authentication. But when I edit the sql server authentication with sa username and password, it gives error message saying that the [B]registration has failed for user sa, not …

I'm confused between LEFT JOIN and INNER JOIN - the differences and when it's appropriate to use one over the other. I tried to wrap my mind around it but it seems to me that INNER JOIN statements can always be rewritten as LEFT JOINs?

I've constructed a photo gallery with a dynamic CMS backend that allows the content providers to upload, delete, etc images. All images are stored as reformated jpeg files (processed by the GDLib on upload) and the relevant metadata is stored in a table called `gallery`. References are made by an …

I am using MySQL 4 and trying to cache my queries per this tutorial: [url="http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html"]http://dev.mysql.com/doc/refman/4.1/en/query-cache-configuration.html[/url] Right now, my query_cache_size is set to 0. I would like to set both the query_cache_size and query_cache_limit parameters. However, I'm receiving the following error message: [code]mysql > ERROR 1227: Access denied. You need the …

I'm looking for a way to compare 2 lists of keywords and return the number of matches. I'm currently working with PHP and MySQL, but I'm not sure how to go about this task. Any suggestions are appreciated. Thanks, J_

Hello have a good day is there any way to retrieve record number with each record in simple sql qry? e.g select "REC_no",name from "table_name" the result should display like this 1 ,noman 2,imran 3,Jose etc take care thanking u in advance Bye

Okay, another easy one, but I can't remember how to do it. I have a table that I want to be able to update multiple records in. I thought I could just run an update query, but I have 2 yes/no fields and one text field that I want to …

I am making a database that tracks the inventory of a tool room. This includes info about both shelf tools and tool box inventories. Each inventory has about 300 items in it, and there are about 9 kits. The info was already put into excel, and instead of re-typing the …

I need a help. I have a SQL SERVER database where I have put persons with their birthdate. I need to calculate ages of them. For examble my birthdate is 12/27/1982 and I have to debit (minus) from current date. Does anyone have any idea how to solve this problem.

Please help !!! I am designing a database system and I am a bit stuck and do not know my next step forward. I am using SQL Server 2000 to develop a database system from scratch for a medium sized company which does not have an IT dept therefore I …