Our Databases forum encompasses everything related to data storage, both for the web and other uses.

13 6 5 5 4 3 3 3 3 2
Member Avatar
Please help me.... I want to upload up to 5 photos and save in database. I want by selecting photo it will upload automatically and then the selected photo will appear in the page. It will occure with one by one photo, up to 5 photos and the photos can …
by babir in Databases ()
Member Avatar
Can anyone give a clear,short and simple explanation about database indexes?
by Teddy112 in Databases ()
Member Avatar
Hello Everyone, So I've begun a new project, in an attempt to show off my progress with Javascript. I'm making a little text-based RPG. However, I would like for it to permanently save your character and their progress. Thus, I need a MySQL database. I won't lie, I've only used …
by RGStrat in Databases ()
Member Avatar
In the work I came up against a situation when the working database at the end of day went to the Suspect Mode. And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to …
by alain.marion85 in Databases ()
Member Avatar
I am not sure if this is possible or not, but I need help writing a query for a running balance report. I tried a few queries on my own; I've come close but not exactly what I need. For convenience, I've created an sqlfiddle: ... The report needs to …
by joshmac in Databases ()
Member Avatar
Hello All, I have a table with column_name as USERNAME where USERNAME is VARCHAR2(20) and I want to display it as "USERNAME@email.com". How to write the select query for this. QUERY: SELECT USERNAME AS EMAIL FROM STUDENT Thank you.
by Azii in Databases ()
Member Avatar
Hi Pls advice me the following calculation in stored Procedure my scenario is packing the magazine Example: Order = 6042 copies. 6042 have to be packed by 20 each. so 302 bundle. balance 2 copies. If I divide 6042 /20 Result is 302.10 . How can store 302 and 2 …
by Maideen in Databases ()
Member Avatar
Hello i have formatted my pc with Windows 7 and installed wamp server. My local project doesnt work. I am familiar with the difference between mysql and mysqli? Do i need to install a most recent version of Mysql than the one provided by Wamp Server?
by SimonIoa 39 in Databases ()
Member Avatar
Converting mysql to mysqli. i need help av been scratching my head how to make necessary changes but its like am making more errors. please help or give direction what to change.. ...
by nitos in Databases ()
Member Avatar
Hi group, I'm getting an "single-row subquery returns more than one row" error when running my routine. Looking through the table I'm querying, it is listing a date twice for some reason. Since I'm not able to remove this one row, is there a way to return the first instance …
by doncwilson_1 16 in Databases ()
Member Avatar
Hi all, I am not able to get correct count, if col1 (percentage with respect to product) and col2 have uniq value. Below I post my sample table data and expect output and which i query I tried. Please help me to get in to right direction. ...
by k_manimuthu 43 in Databases ()
Member Avatar
I want to select from these table ... And i want to create a table like this for whole year ... How should i do?
by Lau_1 12 in Databases ()
Member Avatar
Member Avatar
Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to DECLARE these as NUMBERs. However I'm not sure how to do this correctly as I'm getting errors preventing me to …
by doncwilson_1 16 in Databases ()
Member Avatar
Before upgrading to EXCEL 2010, I am able to open dbf files created in Visual Foxpro 7 or 9 in Excel 2003. I am not sure why after installing EXCEL 2010 I am no longer able to open the file. I get the error message when I tried opening the …
by calebclark in Databases ()
Member Avatar
Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL to prompt for a date(s)? Here is what I want to do: Question 1: Enter Beginning Date (user to enter …
by doncwilson_1 16 in Databases ()
Member Avatar
Hi group! I'll be up front and say I'm very new to SQL. I'm just now getting my feet under me in my new job. So I have lots of questions. I'll start simple (I hope). I've created my own tables (2) that have multiple columns of data that looks …
by doncwilson_1 16 in Databases ()
Member Avatar
Hi. Im using VS2008 and SQL Server Management Studio 2008. I want to ask, i have two different table, TableA and TableB in same database, DatabaseX. Both table have two same column, ColumnY but the data are different within this table. Example: TableA, ColumnY : A1, B2, C3, D4 TableB, …
by nimz143 in Databases ()
Member Avatar
Hi I have this query: ... KN ... EUR ... KN ... EUR ... And it retunrs 0 SUM( ... )* 7.5 should be zero but SUM( ... ) is 60. I am not shure what I am doing wrong here, I want to add numbers and avoid counting NULL …
by mehnihma in Databases ()
Member Avatar
Hi I am new to MySQL and not too shure how can I update row form another table while cheking if logged in user is same: `Telefonist='".$_SESSION["UserName"]." And also I need to check if date is the same so It gets to right pearson on right date in a row: …
by mehnihma in Databases ()
Member Avatar
Member Avatar
Hi, In a representative table, I have fields, like, id, mark_id, rep_id rep_name, father name,etc, In this table, rep_id field is empty, And in rep_area table, the fields are like id, rep_id, dist_id,etc, in this table, rep_id has values. While editing the representative form i want to display rep_id from …
by AntonyRayan 15 in Databases ()
Member Avatar
I am using the MySQL C API and having problems defining a stored procedure. MY SQL script works fine in MySQL Workbench but the same script fails in my own software. A test script which shows the problem is: ... The error message I get is: ... I have studied …
by SalmiSoft 102 in Databases ()
Member Avatar
i does not know about store the image in database. what is the datatype of picture in oracle?
by N kamatchi in Databases ()
Member Avatar
I have created a sp little bit confuse about it. how to count result set if data availabe then show it and if not then retun ResultStatus is zero. did not work much with sp. thanks for any help suggestions. ...
by mangel.murti 5 in Databases ()
Member Avatar
hello. I am getting a blank page on localhost/myproject/ i am pretcty sure th.at\ it cant connect to the database because when i am using a simple echo it returns. for example ... THE THING IS THAT I AM USING WOS PORTABLE IS IT POSSIBLE THAT IT DOESNT SUPPORT PHPMYADMIN? …
by SimonIoa 39 in Databases ()
Member Avatar
Member Avatar
I am trying to insert a set of attribute rows into a table based on the range of a unique key (product_id) and three passed variables. This is on a MySQL database. The three variables are the start_product_id, the end_product_id and the batch_attr_id. The stored procedure does not return an …
by mskat02 in Databases ()
Member Avatar
Ok, here is what I get when I run the query. 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 newmessage ... 0 ... companyi' at line 4 Here is what it …
by Sutarusu in Databases ()
Member Avatar
Hi I have a query and I like to see the result until the condition match. I am trying to find if the end date(+1day) is equal to next row start date if so list it. I have the below query does the job but it also list whole table …
by kadriirdak in Databases ()
Chat Log Latest Posts