7,494 Archived Topics
Remove Filter  | |
| | Hi I am trying to implement a world cup 2010 database, but can't seem to find the best table structure. At the moment I have the following: Team TeadName PK group A with fixtures group B with fixtures group C with fixtures group D with fixtures group E with fixtures … Databases mysql |
| | OK, I admit I am completely clueless on how to perform this one. In one table I have a list zip codes and the user will select one or more from this list. Once I have those zip codes, I need to perform my query and this is where it … Databases mysql |
| | Hello. I have a simply php script for my school project that checks books back into a library database. What I was trying to accomplish was when you checked in the book for it to check and see if the book has been requested and notify the librarian that there … |
| | Hi all. I am new user here and I found a lot of usefull info in this board. What I am curious to learn is how can I update a record in MySQL and in the same time to Insert a new record in another table. For example, I have … Databases mysql  |
| | i got this error to on my database "Host 'localhost' is not allowed to connect to this MySQL server" and when i tried to use mysql workbench i got this "cannot connect to the database server" what is wrong with my database, its the second time happen to me. yesterday … Databases mysql |
| | I am having an issue creating a stored procedure but I keep getting an error "Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE PROCEDURE sp_Insert_Address ( in p_UserID … Databases mysql |
 | Hi im new to sql server 2005 and i have a big problem. i want to delete a record having the same name and surname Here is my table named Students StudID FirstName LastName 1 Erwin Lopez 2 Archie Lopez 3 Lobanz Lopez 4 Erwin Lopez 5 Chie Lopez 6 … Databases client-server microsoft mssql sql  |
| | Hi, I have a table with 2 date fields startdate and enddate. A program have a start date and an end date like this 01/01/2011-25/03/2011 . Now I want to test any date and get the program it belongs to. Say for the above, 12/01/2011 would return the above program. … Databases microsoft-access  |
| | - I'm using ms sql and then i export the database and then i save that export DB at desktop.After that i delete the database in ms sql because i want to learn how to import the DB.My problem is cannot import the DB that i export before.Anyone can help … |
| | Hey all, I'm looking for a way to insert values from one table from another in a pretty straightforward way, I just can't get the syntax... If table 1 has fields A,B, and C, and table 2 has 20 fields... I want to insert into: A a value that I … Databases mysql |
| | [CODE]-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 22, 2011 at 08:44 AM -- Server version: 5.1.41 -- PHP Version: 5.3.1 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- … Databases data-structure mysql |
| | hey guys, first time on this forum so sorry if i make mistakes .. My problem is .. I have done a final year project for a local pizza shop. It has some basic functions such as customer registration, shopping catalogue and ordering online. The website is linked to a … Databases database-design |
| | Hi everyone, I have a question. I am making a system that lets the user build web pages much like a custom CMS to learn about SQL, PHP etc. Anyway.. I have a login page and the user is allowed to click create new site. This then asks how many … Databases cms database-design web-design |
| | Hi everyone, I want to implement an "achievement" system of sorts into one of my projects. Similar to StackOverflow where if you do a certain thing or answer a certain number of questions etc you get a trophy that is linked with your user profile. The membership section of my … Databases mssql |
| | Hi, I want do pagination per page show only 25 records. Here is fetching data is too large and there I can't use rownum for that. in fetching data there is no any unique column. so tell me how can do it? Thnaks in advance. Databases oracle |
 | hi all..i am new to this sql thing..i am tryin to install it on win xp .but after i enter current and new password and then press execute button , the installer stops responding before starting the service .the two operation 1.)prepare configuration and 2.)write configuration file are done..after that … Databases mysql |
| | I'm still new to Microsoft Access so I don't have a great understanding of its workings but have spent the past couple of months working on a project to manage the company's telphone bills. I'm essentially compiling the usage from every company phone each month into a final table by … Databases microsoft-access |
 | Hi guys! please tell me - where is error here - [ICODE]select `OWNER.OWNER_ID`, `Previous_owner.GDATE` from `Previous_owner` left join `OWNER` on `Previous_owner.OWNER_ID`=`OWNER.OWNER_ID` left join `AVTO` on `Previous_owner.OWNER_ID`=`AVTO.OWNER_ID` where `AVTO.AVTO_ID` = 3[/ICODE] phpmyadmin shows error - [QUOTE]#1054 - Unknown column 'OWNER.OWNER_ID' in 'field list' [/QUOTE] the db structire is = [CODE]create table … Databases mysql |
| | SQL is my "weak" part, however I can handle it. I was wondering if there are alternative ways of writing my queries below. Any alternative is welcome, it's a way to learn more. I have the expected/correct results on all of them. **Shows which shops have the product code 1234 … |
| | hi every one my problem is is to convert id column values as comma separated ex: id 1 2 3 4 5 6 i want result set as string "1,2,3,4,5,6,7....." Databases mysql |
| | [ICODE] mysqldump -u root -p pass**** coke_pos > testbc.sql [/ICODE] i tried this command to generate back-up of my database but i got an error about, eroor in my syntax i have mysql 5.5.11 community server and i am using mysql workbench 5.2, i am using windows 7 please help … Databases mysql |
| | Hi, i'm having the following problem. i have a list of products and each product has different items attached to them for example(it's all about wines) [CODE]id prodid text bedrag 35 1 1 fles kist Prosecco Tallero 14,95 36 1 2 fles kist Prosecco Tallero 26,95 1 10 1x Fles … Databases mysql |
| | Hi all, I need your help. I have an insert query which insert a few rows into the table A. TableA has two primary keys, which are fieldA and fieldB. The SQL is written as follows: INSERT INTO TableA (fieldA , fieldB, fieldC, fieldD) SELECT DISTINCTROW TableB.fieldA, TableB.fieldB, TableB.fieldC, TableB.fieldD … |
| | Dear All, I have run this query SELECT (3958*3.1415926*SQRT((2.20569-3.13900)*(2.20569-3.13900)+COS(2.20569/57.29578)*COS(3.13900/57.29578)*(102.25616-101.68686)*(102.25616-101.68686))/180); and it gives a value of 75.49810.... The problem is that the first city (2.20569,102.25616) and second city (3.13900,101.68686) is hundred plus kilometers far apart. Can any one verify what is wrong here? Databases mysql |
| | Hey guys.. i have been having trouble with this script: [CODE] $con = mysql_connect("localhost","XXXXXXXXX","XXXXXXXX"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("XXXXXXX", $con); echo "<table class='viewuserprofiles'>"; echo "<tr>"; echo "<td>שם האתר</td><td>סוג</td><td>קישור</td><td>משתמש</td><td>סיסמה</td><td>תיאור</td>"; $query = "SELECT * FROM ProfilesWebsites, ProfilesAccounts ". "FROM ProfilesWebsites LEFT JOIN ProfilesAccounts ". "ON ProfilesWebsites.ProfileWebsiteName … Databases mysql |
 | Hi guys. I know this is a long shot, but does anyone know if parallel computing (multiple simultaneous programmers/developers working on the same file) is possible for SQL databases? What I'm wondering if is possible is working on a local database that updates the mdf file in two computers, which … Databases client-server mssql sql |
| | Hello community, can anyone provide me the answers please? I am not a MySQL guy, i know that this is not an excuse, but this is how it is. Thanks in advance. [CODE]Employee (**Employee ID**, Employee Name, Employee Last Name) Director (**Employee Code**) Cashier (**Employee Code**) Customer (**Code Card**, Customer … |
| | Hello! I was looking for some help with something I'm trying to accomplish with MS Access. I have data set up in the following manner: [CODE] CUSTNBR|TRANSYTD| RPTDATE --------------------------- 1 | 7 | 5/28/2010 1 | 10 |12/31/2010 1 | 2 | 4/29/2011 2 | 8 |12/31/2010 2 | 6 … Databases microsoft-access sql |
| | Is there a way to exclude column from a table or View or Stored Procedure without specifying all the columns in the Select List Especially with table or View |
| | Hi guys Ive created a piece of software to extract data from 2 fields in an mssql table, and using php translate them into a graph. Im now trying to extract the field names as titles for my axes. I'm using sqlsrv_query s and have retreived data from the table … Databases mssql |
| | Hi, Im using Oracle 11g, and i have a query like select * from test where ID_PRIVILEGES = 'ADMIN'; but in database ID_PRIVILEGES is stored as Admin, I want case insensitive search to be done. I cannot change my query as select * from test where ID_PRIVILEGES = 'Admin'; Can … Databases oracle |
| | Where can I get a free mysql thesaurus database? I would literally like to download a .sql file, and just upload it straight to my mysql host. I would just want in the thesaurus... Word Synonym #1 It would be great if it also had... Part of Speech Synonym #2 … Databases mysql |
| | *** I read and reviewed the rules and don't think this violates them, but please feel free to remove this if so. *** I've got this really great idea but no expert knowledge and no experience in how to execute it. I figured I'd come ask the experts. I want … Databases ecommerce |
| | I have a report based on a query that uses parameters (Date datatype). In the report header I have some other data that is also generated using the parameters (Same parameters). This data is generated programatically and I use a dialog box with date in it. Now, I want to … Databases microsoft-access |
 | Can nay one tell me how can i set user permissions on form level to control user i.e i want to allow user1 only add permission and uer2 should have both add and edit permission how to do it on form level. Thanks in advance. Databases oracle |
| | [B]Problem:[/B] I have a zip_code/city/state table that has full names and abbreviations for some common things like FT (FORT) and IS (ISLAND). So, I may have a record something like this: zip = '31522' city = '[COLOR="red"]IS [/COLOR]HARBOR POINTE' locationtext = 'Is Harbor Pointe' location = 'US-GA-[COLOR="red"]IS [/COLOR]HARBOR POINTE' and … |
| | Hey guys.. going crazy over this :'( This is my form [CODE] echo "<form action='addwebsitekeywordsscript.php' method='post'>"; echo "<input type='hidden' value='" . $currentwebsite . "' name='id' /><br />"; echo "<div class='kywrdformcontnr'><div class='kywrdform'>מילת מפתח:</div> <input type='text' name='keyword[]' class='kywrd1' /></div>"; echo "<div class='kywrdformcontnr'><div class='kywrdform'>חיפושים:</div> <input type='text' name='keywordSearch[]' class='kywrdsrc1' /></div>"; echo "<div class='kywrdformcontnr'><div class='kywrdform'>שפה:</div> … Databases mysql |
| | I am getting data by view but there is too large data. so I want to select data in particular slab (i.e. 25 rec) but in my resulting data there is no any unique record in column for fetching. so please give me solution. selection records like rows 1 to … Databases oracle |
| | Not sure if I should out this here or in the php forum, I have a question that's probably gonna include both SQL and php... I'd like to add an image field to a table I have but I've never stored images in an SQL database before and I'm not … Databases linked-list mysql |
| | I have a table named "Table1" Its schema with data is like this [CODE=text] Id col2 col3 col4 col5 isUnique dbUnique 1 red 3M 1995 UK 1 null 2 red 3M 1995 UK 0 null 2 red 3M 1995 UK 0 null 3 red 3M 1995 UK 0 null 4 … Databases mssql |
| | Hi, in oracle 10g express, I logged in system/HR. I typed: CREATE USER SHIPU IDENTIFIED BY SHIPU1. click Run. Then I typed, GRANT SELECT, INSERT, UPDATE ON EMPLOYEES TO SHIPU WITH GRANT OPTION click Run. I logged out and logged back in as SHIPU/SHIPU1 I typed SELECT * FROM EMPLOYEES. … Databases oracle |
| | I am fresher in Database Design I want to Design a Database for an online Auditing Tool...for Auditor and Project Managers.. so far I have the following tables... Employee (EmpID , EmpName,EmpLname ,Phone) Administrator( AdminID ,EmpID, AdminEmail) Company(CompanyID, CompanyName,ProjectID) Auditor( AuditorID, Name, LastName) Questions(QuestionID, Question) Results(QuestionID,Result,CompanyID,ProjectID) User One Auditor: will … Databases database-design |
| | Hello all, I have a database which has 10 tables. Each table has an id, a title and a date. Now i'm having difficulty finding the best way to extract the [B]latest date[/B] from each unique table, while also doing a count(*) attribute to show how many rows I have … Databases mysql |
| | I am trying to update a column of a view in a DB. It throws up an error saying the column i am trying to update is a virtual column. I want to know the SQL statement to find out the base tables of th view and also the base … Databases oracle |
| | hi everyone i have a problem how to connect sql database with html and must display the columns and rows of the database to html template... |
| | Hi, Can anyone pls suggest me how to configure autoreconnect option in oracle 11g as in mysql. Thanks, Databases oracle  |
| | Hi, Although I'm not really a novice when talking about web development, I'm not really used to writing MySQL queries that are a bit more advanced than the absolute basic SELECT/INSERT/UPDATE/DELETE queries. Anyway, currently I started working on a project that shows relevant items to the user: A 'you might … |
| | Hi, I've created a MS Access (2007) database storing details of a charities clients. Is there a validation rule/piece of code for the following: FIELDS: Date, Time, Duration, Room CODE FOR: Not being able to select a room if it is on the same date and time/duration? I'd really appreciate … Databases microsoft-access |
| | [B]Hi... I have a table named empl with following fields(eid,ename,esal) I had inserted the following records to empl table 1 Govind Raj 20000 2 GovindRaj 600000 3 Govindraj 10000 4 govindraj 50000 5 Govind.Raj 50000 6 Govind-Raj 20000 7 Govind_raj 2000 8 Govind.raj.3000 9 govind,raj. 4000 10 Govind'raj 6000 11 … Databases mysql |
| | how to connect mysql databse into html and must display the rows and columns of the database to html template Databases mysql  |
The End.