7,494 Archived Topics
Remove Filter  | |
| | I want a database that should fetch images from a URL.How can I do that?  |
| | hi, I need a query to get the start date and end date of a month when given the month name. For eg., When given month='august' it must display 01-08-2011 to 31-08-2011 Thanks. Databases mysql |
| | 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 |
| | Recently I have been working with Mysql and PhpMyAdmin a lot on Ubuntu, and I have stumbled across a very annoying error, or set of errors. I keep on getting a bunch of random loosely related error messages. These are the errors I get. When I try to log in … |
| | [B]Hi guys, Well I just reinstalled vBulletin 3.8.6, on top of the other. I tried to make a new THREAD, after posting it says:[/B] ___________________________________________________________________ Database error in vBulletin 3.8.6: Invalid SQL: UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts); MySQL Error : Unknown column 'newposts' in 'where clause' …  |
| | 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 |
| | So i have this problem with a database. Under a section Date of Birth there are about 110000 entries. There are some that just have the year, for example 1978, I'm wondering if there is a way where it can automatically put in /00/00 after the 1978? so it would … Databases microsoft-access sql |
| | I'm running sql server 2005 and I need to pull information from 2 of the databases(all from the same server). All of the databases are identical minus the data. database1 = LCDEL database2 = LCDFV I need all of the location data from each database and instead of querying them … Databases mssql  |
| | |
| | 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, I am trying to find out list of employees who have no dept_id. Below code works. [B]select e.emp_id, e.last_name, e.dept_id from employees E where dept_id IS NULL[/B] Below code does not work. i want to rewrite the query using NVL to replace the value by 0. does not work. … Databases oracle |
| | 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 |
| | hey guys, i have a query wherein one table has the same id as the other using inner join.. SELECT c.cat_name, g.maxscore, g.description FROM grp_performance INNER JOIN category ON g.cat_id = c.cat_id Is it possible to use inner join when deleting a row? like.. DELETE FROM grp_performance INNER JOIN category … Databases oracle |
| | 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 … |
| | [B]Hi all i am writing a software for a department store, how can i package LDF and MDF of its database and .exe of its windows form application design? i want to have one .exe file and give just it to department store's manager? could you please help me asap:) … Databases database-design mysql |
| | Hi.. I am frequently using XAMPP's phpmyadmin for MYSQL database. I want to install original Mysql database from their developer's site([url]http://www.mysql.com[/url]). I am very confused that I found 6 types softwares. Which one should I install? I also need to access the software using GUI.. Any body can help me? … |
| | Can anybody tell me the difference between a Primary key and a Unique Key ?Kindly let me know the idea.Any help would be highly appreciated. Databases oracle |
| | I have a query which generates a soccer standings table and am trying to create a different version which will only include the 6 most recent games for each team. An example of the output of my current query can be seen [URL="http://www.margate-fc.com/content/test/standings.php?season_id=104"]HERE[/URL]. The full query is below and I … Databases mysql |
| | Is it necessary to install mysql workbench in order to run database based php web apps? Databases mysql  |
| | I am new to using sql .i have two table expense statement and revenue statement such as revenue statement accountname debit A 100 B 200 expense statemnt accountname credit X 300 Y 400 is there anyway i can join these two table like this, if so can someome tell me … |
| | hey guys.. i have trying for 2 weeks now to connect 2 tables in the way that i need them to print out.. [B]to understand the table structure please see attachment 001[/B] Now... i have managed to join both table but the problem is that each time i insert a … Databases mysql |
| | Hi All, Couldnt figure out to obtain the nearest date in query properly. find below the sample. Insert Fsample (ESN varchar(10), optn_type int, auditdate datetime) values('123',2,'2011-1-03') values('123',11,'2011-2-20') values('123',2,'2011-03-02') values('123',2,'2011-4-10') values('123',11,'2011-5-18') 2=shipdate 11=returndate result ESN|Shipdate|returndate 123|2011-01-03|2011-02-02 123|2011-02-20 123|2011-04-10|2011-05-18 Thank you in advance. Jonel Databases mssql |
 | |
 | 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 an application in which user will put the query in text box and will get the output in gridview and i need to keep track that which user has run which query. for that i will be taking query from textbox and store in one variable I need … Databases oracle |
| | 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 … |
 | Person is trying to do a sea food preparing and selling company.name two system development systems he can use? What is the best and why? thanks Databases |
| | I'm having troubles designing the following ERD, I find it extremely hard, so I would appreciate any suggestions on how to resolve it. I need to store sentences in PHP and another ones in JAVA, always mapping them between languages and map their equivalent position between them too, so every … Databases web-design |
| | this is the scenario pls help me: We have been asked to analyze the data requirements and develop a conference management system to keep information about all the conferences and papers presented in the conferences. Conferences are conducted in different parts of the world. Each conference is identified by its … Databases |
| | hi all, i am using temporary table to store ids,from this i am calculating the records count,it is working fine and i am getting the result.The problem is i am getting warning that temporary table does not exists Databases mysql |
| | Hi Guys, I am having few issues testing a software for which I have to develop a front end GUI. Basically, the previous person failed to document on how to run the system and left all the pleasure for me :D Anyhow, the system basically is a web crawler and … |
| | |
| | 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 |
| | Hi, I have four tables tab1,tab2,tab3 & tab4 [CODE] #contents of tab1: Id dataname 222 perl [/CODE] [CODE] #contents of tab2: Id data_desc 222 perl is a scripting language [/CODE] [CODE] #contents of tab1: Id other_desc 222 Regular expression [/CODE] [CODE] #contents of tab1: Id date 222 22-33-1964 [/CODE] I … |
| | hello guys can any one let me known where to find database design template.i am confused in making of my design for the database. Thanks in Adavance Databases database-design 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 |
| | Hey guys, What are your opinions on rating systems in this case? I have users submitting ideas. Now other users can rate an idea UP or DOWN. I want to keep track of what user rates what idea, up or down, and want to be able to display this information … Databases mysql  |
| | Hello to everyone! I am an engineering student and we have this class wherein we use Microsoft Access. Our instructor gave as a hands on homework using the MS Access. As I do it at home and inputing numbers and etc all that I need to input, suddenly this [COLOR="Red"][B]ERROR[/B][/COLOR] … Databases engineering microsoft microsoft-access |
The End.