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
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
...
by SimonIoa 39 in Databases ()
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 ()
Member Avatar
Hello everyone! My Access MDB file has "disappeared" from his documents folder. I haven't deleted it, I have checked recycle bin, system restored, searched and so on. No luck! Any suggestions on what else I could do to recover the file?
by Nicko21 in Databases ()
Member Avatar
Hello, Is it possible to join two tables from two different databases. I have the following query whereas the table named "calendar" is in a separate database than the table names history. Any ideas on how to join bottom? ... I appreciate any thoughts on this. Mossa
by mbarandao in Databases ()
Member Avatar
I work for a small company made up of a salesman, a graphic artist, and an engineer. The engineer writes and maintains all of his own software to run a network of interactive kiosks around the globe. As artist, I use his tools to maintain and update the network content. …
by evandrosiqueira in Databases ()
Member Avatar
I currently wish to write a query to duplicate data in database while modifying one column. First of all, my database structure: table code ... The unique idx is the curcd,code,item. What I wish to achieve is duplicate data of code '80' with a set of code = '82' So, …
by lps 71 in Databases ()
Member Avatar
i want to retrieve a single row from my database i use this and i get nothing ... i found this online but still the same ...
by SimonIoa 39 in Databases ()
Chat Log Latest Posts