2,403 Solved Topics
Remove Filter  | |
| | HI friends..I have a tab delimited text file with country, city, Participants field.. Now, when I search for a particular entry for eg. Country England, then I want it to show all the cities associated with it Inot just one). My actual table looks like this. [IMG]http://i56.tinypic.com/2dceg4p.jpg[/IMG] Now, If I … Databases mysql |
| | I have sql table with 3 columns id, parentid and name.I have attached the table i have . Also i have attched the table output i want. In the name column ,there are so may values out which yes and no are two values which occur more than once. I … Databases mssql |
| | Create a script named *just_lee_trg.sql* that contains the PL/SQL code to create a trigger named *books_qty_on_hand_trg*. The trigger should be set up to fire whenever the quantity on hand for a book has been updated. When the quantity on hand becomes zero, it should call the *insert_reorder* procedure and pass … Databases oracle |
| | Hi I am trying to build a MySQL database. I have made a table where some fields are VARCHAR and others are INT. All of them are null. One of the columns I made is Vote which is INT(5). Now I am trying to import data from a text file. … Databases mysql |
| | The MYSQL db has a Location field with entries like: CAN CAN ON CAN ON, CAN BC CAN AB, CAN BC NY OH CANFIELD, OH TOLEDO WA, OR, CA Thus the location field can have multiple entries, all separated by a comma, but still held in the single Location field. … Databases mysql |
 | Here is the image of the table of the Question [url]http://oi55.tinypic.com/2d0gkmh.jpg[/url] Here is the First question(in the image) [url]http://oi52.tinypic.com/2ztix5l.jpg[/url] Above one is question (c) help me to answer that this is the other question(below, as Text) d) Create a database view to display the above output of part (c). help … |
| | Hello All I'm converting an access database to MS SQL for a webapp and have a question if anyone knows how to do this. 4 fields [TimeReported] [TimeOff] [TimeOn] [TimeAssigned] Access only stored time, so date is incorrect. 1 Field stored date separately [Date] I would like to take each … Databases mssql |
 | select companyname,sum(sale) as TotalSale,sum(purchase) as TotalPurchase from invoice group by companyname Having companyname IN (select companyname from invoice) It returns sum only for those column whose all sum are not blank, how can i show blank sum values I mean there are 7 companies but only 4 records are shown. … Databases oracle |
| | How to take a user table backup from that user account? I mean i want to give him grants to take backup... also query to take backup. Databases oracle |
| | The below line generates this error. Can anyone gives me a solution Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\wamp\www\MySite\php files\approve_page.php on line 25 [CODE] $query = "UPDATE transaction SET approved_status='1' WHERE account_number='$account_number' AND tran_id='$_POST['tran_id']'"; [/CODE] |
| | Hi all, [INDENT] i am facing a serious problem working with MySQL and Nhibernate 2.1.2.4.0 named queries. I have written a stored procedure and i am calling it in C# using a flat class to map the database fields. My problem is it seems to work fine with Mysql 5.1 … Databases mysql |
| | Hi Guys, Kindly please help me on how to this in scripts. How to calculate and get the average aging based on the Aging period. I could not figure out on how to do this in script. btw, even the format is not like my sample it's okay, unless i … Databases mssql  |
| | Hi All, When I run this script using bulk insert i got an error message but when I try the first 6 records there is no problem. can anyone give the reason and what is the problem? [CODE]Use chrisMartin Bulk Insert SampleTable_Jonel FROM 'c:\planning\ProductRecoveryDataFeedytd_3.csv' --Sheet 1 With ( DATAFILETYPE = … Databases mssql  |
| | Just started learning MySQL, more specifically using Python and MySQLdb and everything is up and running fine. I have an interface where i generate buttons: 1) Firstly the main catagories are generated. 2) on clicking these buttons, sub-catagories of these catagories have thier buttons generated. 3) once again on clicking … Databases |
| | Must need coffee or something :/ Cant figure this out. I have a table with following info: [CODE][B] unique_id block_id column_id order_id user_id[/B] 1 block-1 column-2 0 1 32 block-2 column-3 0 7 7 block-1 column-1 0 2 8 block-2 column-2 0 2 10 block-6 column-2 1 1 11 block-7 … Databases mysql |
| | Hello, I'm trying to write a sql statement that would update a record only if a particular row column is empty; else, insert a new record. Is this doable? Currently, I have this update statement: [CODE]//query for additional cars 1 $mysql_query=("UPDATE additional_cars SET clientID='$edit_clientID', registeredstate='$edit_registeredstate', dhtmlgoodies_category='$dhtmlgoodies_categoryupdate', dhtmlgoodies_subcategory='$dhtmlgoodies_subcategoryupdate',caryear='$edit_caryear', servicearea='$lastservice', currentmileage='$edit_currentmileage', todays_date='$date2', … |
| | i have no idea where to start but; i'm looking for a way to change all emails from [email]suppliers@test.domain.com[/email] to [email]title@test.domain.com[/email] in a MySQL DB. DB Name: simons_directory Table: listing Fields: title, email caveats - title has words with spaces, if possible to remove the spaces so "My Business Name" … Databases mysql |
| | Hi all, I want to sort some sql results by a certain list. I don't want it sorted alphabetically or anything. I want to specify a certain list. eg "order by `office` = 'president', 'vise President', secretery'" ect. Is there anyway to do this? I didn't type this example exactly … Databases mysql |
| | Hi, how do I add (using SQL) string that has the char ' ? I have many words that look like this- dsf'dfdf or dfsdf' but when I'm trying to add them the query command thinks that the ' is the end of the string and then messes up everything … Databases mysql |
| | I installed mysql on ubuntu 10.10 using the terminal screen but when i give in the command %mysql -u root -p .it gives me the following error( as attached in the screenshot)..Please tell me as to how can i access my mysql account and create databases etc. |
| | Hello Guys, I need your help to obtain this records. I could not figure how how to do this in script. I would like to get the RMA # 3. but the records will pull out based on the type equal to 2 and date range.. Here is sample data: … Databases mssql |
| | Hi Everyone, Thanks for your time. I have a question about COUNT in sql. Does anyone know how to display the COUNT if it is equal to 0? Please feel free to ask me any question if you don't understand my enquire. Thanks for the post. Databases mssql  |
| | I have 2 tables: Users and Log I want to select ALL users from Users who are not in Log having already received a msg_id matching 'x' What I have so far is this: [CODE] SELECT * FROM users AS USR WHERE USR.user_id=2 NOT IN ( SELECT * FROM msg_log … Databases mysql |
| | hi all, i am writing store procedure so please send me steps to follow that increase the performance Databases mysql |
| | Hi Guys, I encounter error when i converting the string into datetime. My datetime field is shipdate and returndate. also there is a Null value both of this field. btw, here is my code. can you please modify my code any idea that you can share with me to fixed … Databases mssql |
| | Hi, I have a table field with var char data type having values like TVM/345/2000,TVM/01/00,TSR/42/01 etc.I want to extract the sub string from first location to the second '/' location as TVM/345/. Is there any built in function to solve is? Thanks Databases mssql |
| | I have a PHP shopping cart system and it's using MS SQL for the backend. Currently it's using the mssql driver. Now I want to move it to Windows Azure and I'm required to change the driver to sqlsrv 2 in order for it to work there. Can anybody tell … |
| | Is it necessary to install mysql workbench in order to run database based php web apps? Databases mysql  |
 | There must be a better way… Hello all, I am now designing a new data structure and I faced this problem that I am going to describe making me think that maybe I should redesign it. Maybe the solution is in front of my eyes, and please if you have … Databases data-structure mysql |
| | "Good Day.. Its my very first database project and I am really excited about it, trying to make for myself… I am an insurance manager and also learning access through free resources like training videos on youtube etc.. kindly help me on my problem Two Tables, tblContributionRegister & tblAgentDetails. tblContributionRegister … Databases microsoft-access |
| | I have a query which generates a soccer standings table and although it works fine there I am trying to implement a couple of variations on it but everything I have tried has failed. I have searched and asked many times and for both problems and it seems as though … Databases mathematics mysql sql |
| | Don't know if this is right place for my question, but Does anyone know if it is possible to have multiple forms visible at the same time while developing an application with Access in "Form View" mode? If so, how does one tell Access to do this? This applies to … Databases microsoft-access |
 | Hey guys, I'm having some trouble setting up a form to delete a specific row in my database table. Here is the idea: I have one page that makes looping calls to MySQL for a query result, at the same time I print out the html as I need to … |
| | Hi All... I'm wondering if an extra pair of eyes can find a problem with this trigger: [CODE] DELIMITER // CREATE TRIGGER `auto_approval` BEFORE UPDATE ON `my_table` FOR EACH ROW BEGIN SELECT security INTO user_sec FROM users WHERE userid=NEW.userid; IF user_sec >= 10 THEN set NEW.admin = 1; IF NEW.admin … Databases mysql |
 | So I have a table containing various software and a table containing various features. Each software entry need to have a list of features. Here's where it gets tricky: In my application, I need to be able to select a software entry if it has all the features in a … 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 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 |
| | 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 |
| | 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 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 |
 | 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 |
| | 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 |
| | 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 … |
| | 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, 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 |
| | 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 |
| | 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 |
The End.