7,494 Archived Topics
Remove Filter  | |
| | I have an Access 2007 file that I was working on at my office. I left for the day and the database was still open. When I came back the next day the system had shut off so I rebooted (no issues). I tried to open the database and am … Databases file-system microsoft-access |
| | Hi, I am new in pl/sql programming and I need your help. I would like to make a procedure. To be more specific, I have tables like the folowing TABLE1 ================================================ |COL1 | COL2 | COL3 | COL4 | COL5 | COL6 |COL7| =============================================== |600 | 140 | 2 | … |
| | I have a table of names that have done something on a certain date, now this could be over and over again yet of course on different dates but never the same. I need to update a field called last_time that corresponds to the previous date that they occur and … Databases sql  |
 | Hi, I need to drop tables from a database where all the email addresses end in the same domain, ie, say I have 1000 email addresses i need to input an MYSQL query to delete all rows containing email addresses ending with @mydomain.co.uk. Does anyone know how to do this? |
 | registration table broker_id , email , affiliate_id.....etc 40 abc@gmail.com 9999 62 xyz@gmail.com 8888 affiliate_Stats table status_id , affiliate_id , banner_id , campaign_id , clicks impressioins , ctr , sale , sale_price, total_earned...etc 27 9999 3 0 0 1 0 29 9999 3 0 1 0 0 affiliate_chain id name recruitedby … Databases mysql php web-design |
| | My problem Im almost certian is a permissions issue but im still very new to this so bare with me. I have a server running the latest mysql with mysql workbench installed and im tryign to modify the users and privilieges for either my one table or all my tables, … Databases client-server mysql php sql |
| | Dear friends, I have several dbf files, by exporting them from the same shp file in ArcMap. I would like to know how can i merge them in one, in order to get my final results. I would like also to inform you that these dbf files have the SAME … Databases |
| | 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: [Click Here](http://sqlfiddle.com/#!9/caa5c) The report needs … Databases mysql |
| | 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. |
 | 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? Databases mysql |
| | Hi Guys. I have the following scenario: 1. I have build abig management database at our HQ and it is to be fed from several databases spread across regions. 2.I only want to have records of specific tables from those distributed databases be sent to my central database.Changes in Those … Databases mysql |
| | 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.. <?php session_start(); include("php/class.user.php"); $msg = ""; $msg2 = ""; //$submit = $_POST['btnaddnew']; if(isset($_POST['btnaddnew'])){ if(empty($_POST['txtUserId']) || empty($_POST['txtFname']) || empty($_POST['txtMname']) … Databases mysql |
 | 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 … |
| | 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. CREATE TABLE mysample … |
| | I am retrieving from table based on standard and date. For first standard It, has two sections A & B. A has one subject and B has two subject. While displaying I want to display in a table like this: section | Description A | English B | French,English My …  |
| | Dear community, today I am facing a new problem, maybe due to a black out. I am trying to select from a table based on the results from a select statement, however, the result only contains the first few characters of the field. The main table has the field "category" … Databases mysql |
| | I'm not able to open Clipper application (app is 15 years old) because i'm getting : error dbfntx/1012 corruption detected Anyway to fix corrupted dbf besides restore from last backup? Please advise. Databases |
 | Hi Why I got error ? CREATE TABLE customer_table( KNR INTEGER(10) FN VARCHAR2(10) NOT NULL, EN VARCHAR2(10) NOT NULL, Mobil NUMBER(10) NOT NULL, Tell INTEGER(10) NOT NULL, constraint knr_pk primary key(KNR) ); Error report - 00907. 00000 - "missing right parenthesis" *Cause: *Action: Databases oracle |
| | hello, I am having a problem opening my database. Before this I could directly go to phpmyadmin after logging in to cpanel without entering username/password. Today, I was directed to a page to enter username/password before going to the database so I did but I got this warning: Warning in … |
| | hello: i was given a corrupted mdf file, the server the database (sql 2000) crashed and the only file recovered was this .mdf file. I have tried as many of the options that i can find, and still cannot get this database recovered. downloaded several of the programs that claim … Databases file-system sql |
| | **Hello, please help me on this. I want to select from these table,** table name: User | Register_date | --------------- | 2015-02-04 | | 2015-02-04 | | 2015-02-14 | | 2015-03-14 | | 2015-04-04 | | 2015-04-14 | table name: Reservation | Order_date | Amount | ----------- | ------ | … Databases mysql |
| | Really need soem help here. I'm new to Mysql. my server crashed on me two days ago. I was able to do some data recovery to access the mysql file. the problem is how do i go about getting access my tables after this. I have no backup to restore … Databases mysql |
| | The Database ID 5, Page (1:9248), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE I am having above error on sql 2008 R2 , i have identified the table which … |
| | Hello, What seems so trivial, has been bugging me. I have a table with duplicate values on one column, while non-duplicate (date) values on the other. If I am to use DISTINCT it will only eliminate the row with the same date. But how do I use DISTINCT and only … Databases |
| | Hi What is my misstake? I got error whwn I run my code! DECLARE V_num number := ‘&enter_an_integer’; V_test number; Begin V_test := mod(V_num,2); If V_test = 0 then Dbms_output.put_line(’even number’) Else Dbms_output.put_line(‘odd numbers’); End if; End; The error was 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a … Databases oracle |
| | I forgot what type of hashing used for passwords in my database. How can I recover passwords in my database? -Any solution to my problem? or any suggestions? -Thanks in advance. Databases mysql  |
| | Hi all, Below is my sample data. I am trying to get the 'product' name only if the percentage count is varying. Could you please suggest your maximum no of 'Mysql' queries to approach this. Thanks in advance. Input: ============================================== percentage product ============================================== 100.00 A 100.00 A 100.00 A 2.18 … Databases mysql |
| | Hello, I am right now having a dedicated server and when i try to execute a INSERT query in table of 2 Lakh rows it takes about 0.02 seconds. so i am having a website where i need to update all 2 Lakh rows every 15 mins. but it sims … |
| | <div class="panel-body"> <div class=" col-xs-12 col-sm-12 col-md-12 col-lg-12"> <form class="form-inline" role="form" action="leadentry.php" method="POST"> <div class="form-group form-groupp"> <label>Business Name</label> <input class="form-control" type="text" name ="business_name" placeholder=""> </div><br> <div class="form-group form-groupp"> <label>Contact person</label> <input class="form-control" type="text" name="contact_person" placeholder=""> <div class="person" id="TextBox_person > <button id="add_person" type="button" value="Add more" class="btn btn-default btn-sm" placeholder=""> <span class="glyphicon … |
| | I have been having problem where files are left open and on shutdown it corrupts the file. is there a way to open c connection to dbf table and read the data like in .net So that as soon as you read the data you can close the connection? Databases |
| | I am new to sql server .I have recently downloaded Sqlserver 2008 and connected from vb.net . I am trying to create dynamic tables with two columns such as name,amount by passing table names from text box . CREATE TABLE " & TblName & "( [Name] TEXT(10), [Amount] TEXT(6))] table1 …  |
| | am trying to find out what is wrong with my sql statement below, i get the following error: "The multi-part identifier "P1Totals.StudentTotals" could not be bound" what am i doing wrong? UPDATE StudentRegistration SET Year ='2016', Term = 'Term 1' where P1Totals.StudentTotals >='300' and P1Totals.StudentTotals <='400' Databases mssql |
| | Hello group, I've decided I want to take some classes in SQL, to better understand how to write queries. In looking online for where to turn to for this kind of training, I also see classes to prep for certification. I'm curious of what the value to my employer would … Databases oracle  |
| | 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 … |
| | Here's my scenario: I have been trying to re-establish mirroring on my SQL Server 2008 R2 instance since a VMWare outage took it down a few months ago. Here are the servers I'm using: Primary- prodDB.mydomain.com, on DataCenter1 Mirror- recoveryDB.mydomain.com, on DataCenter2 Witness- testDB.mydomain.com, on DataCenter2 DataCenter1 and DataCenter2 are … |
| | I am trying to update for some products their category in Database. But I get an error and and I dont understand where my statement is wrong. Please help me. I want to find products that have in their name a specific word and after that I want to update …  |
 | 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, … Databases sql |
| | 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 … |
| | Hi all :) Before i'm starting futher more about my problem. lets me tell a short description about my program. user will choose path ID (retrieve all this data from table TPATH of database SDO) that they want to delete. before the path ID would be delete, it will compare … Databases asp.net mysql vb.net visual-studio |
| | Good evening, I wanted to know if we can create a table with an array type fields with phpMyAdmin , thank you Databases mysql |
| | 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 … Databases file-system microsoft-office |
| | I have two tables tb1 and tb2. I would like to sum up field values from two tables. How to do this using a SQL statement. tb1 Name Salary Bob 1000 Tom 2000 John 3000 Winson 4000 tb2 Name Bonus Bob 100 Tom 200 I would like to get the … |
| | 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 … |
| | Hi. I am Sorry that I don't know how to ask question for my Scenario. Thats why I just used "How to update qty into table2 from table1? " This is the scenario of one of my customer Table-1 Subscription Master(News Paper) - Received Subscription CustCode Name Copies date Agent … Databases mssql  |
| | 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 … Databases mysql |
| | Our Day cares have a program called procaresoftware. We have 2 sites 47 and 35 From what little I know everytime you add a child, parent etc it puts it into an .MBD FILE. Lately the 35 center has been having issues that they cannot save any new customer. They … Databases |
| | Hi, I am displaying list of jobs that are posted by admin from mysql db. In that Table I used requisition_id (job id) , and the datatype is varchar(255), if we click the job id , it will show the description . My problem is, if it more than one … Databases mysql |
| | 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 named "history". Any ideas on how to join bottom? SELECT C.theDate as day, IFNULL( sum(case when DATE( CAST( H.timeentry AS … Databases mysql |
| | Hi, No matter what I do I get the Access denied for user error.I watched the video but still get it. Are there any common errors I should be aware of in setting up a db user? Thanks, duchaine Databases microsoft-access mysql video |
| | Hi I have this query: `SELECT SUM(`KN`) + SUM((COALESCE(`EUR`, 0)))*7.5 FROM log WHERE `KN` IS NOT NULL and `EUR` IS NOT NULL` And it retunrs 0 SUM(`EUR`)* 7.5 should be zero but SUM(`KN`) is 60. I am not shure what I am doing wrong here, I want to add numbers … Databases mysql |
The End.