7,494 Archived Topics
Remove Filter  | |
| | I have test to get a job in banking anyone cloud give me something could help me ? the position is about doing some query on database the exam will foucs on SQL help in nested SQL statements like nested select ? whats tuning ? put result into new table … Databases |
| | Hello, I am having a bit of a problem with my code. I have to link a php form with a mysql database. I know it is relativley simple, but I have been looking at my code for hours, and I can't find what is wrong. I have a sample … |
| | Hi... I am using following query to get data from a table *select * from emp where ename regexp 'rajkiran'* It will return only the rows with ename=rajkiran but I want to select all the rows with ename =raj kiran & ename=rajkiran using a single query  |
| | hi, i havent been able to retrieve a random row from my database hourly, daily and weekly. i need to display a row (doesnt matter if it repeats) but i need to make it change in one page hourly, another daily, and other weekly. For promotion. how could the code … |
| | Im trying to convert a procedure from using sql plus to mysql but cannot get it to work. **SQL Plus:** CREATE OR REPLACE PROCEDURE PRC_CUS_BALANCE_UPDATE (W_IN IN NUMBER) AS W_CUS NUMBER := 0; W_TOT NUMBER := 0; BEGIN -- GET THE CUS_CODE SELECT CUS_CODE INTO W_CUS FROM INVOICE WHERE INVOICE.INV_NUMBER … |
| | Hi, I have a table and I need to write a SQL to limit the resulset set based on 2 conditions, by IP and out of that resultset, remove the rows which have nothing in 2 columns. So I have tried this but it's not producing the expected results: SELECT … |
| | So I just started learning MySQL. I am learning from [Tizag](http://www.tizag.com). They are using PHP files. Now I can see that the PHP files are slightly complex, I'm only 15. And they also recommended PHPMyAdmin. This GUI tool has many complicated options. So I quite don't know what to use. … |
| | When the exchCode is empty the record shouldn't be displayed. However the code below display the records. SELECT * FROM( SELECT bhCliCode, exchCode = CASE X.Which WHEN 'accSgx' THEN accSgx WHEN 'accHk' THEN accHk WHEN 'accIdx' THEN accIdx WHEN 'accUs' THEN accUs WHEN 'accSet' THEN accSet WHEN 'accPhp' THEN accPhp … |
 | Hi all, Quick one for you, designing a bit of software in VB.net for a company that inputs data into an mdb file and then uses a web service to take this data an insert into an SQL server 2008 R2 database. I know I can have to instances of … |
| | Hello i am having problems creating an update query, I have two tables both have an Title column and one table has an ID column. I want to take the ID from the table that has it when the titles of both columns match one of the titles against any … Databases mysql |
 | I have created a table named student including column stu_id, stu_name & Blood_group.I created a delete button to delete rows and I used the following code when delete button is pressed.I take input using jtextfield.But this can only delete by taking input in stu_id.But now i also want to delete … |
| | Hi I have two tables Employee and Job, Employee's prmary key is EID and in Job there is a EID that is a foreign key to Job. job has another column as the status of the employee. first the employee is added to the database and then the job detils …  |
| | Hello, im a beginner at sql and i am struggling at comparing data from one table to another and then copying other data. *I have 2 tables both of which have 2 columns with the same name lets call them tableA and tableB. * tableA has a column id and … Databases mysql |
| | Hello, I have the following table, for readability I broke down the after every manager for every case number. The last column is the cumulative sum of the second last column. Value for month should ideally run from 1-3 (Like you see for both the cases for Chicago). But from …  |
| | I am having trouble figuring out how to execut the following SQL query. Say for example I have the following 2 databases. Db1 Col_1 Col_2 1 a 2 b 3 c 4 d 5 e 6 f 7 g 8 j 9 h 10 i Db2 Col_1 Col_2 1 j …  |
| | Hi guys! I'm currently making an integration of 2 different web apps. I would to ask if is it possible to restrict adding duplicate data in your table. for Example i have two different tables from two different databases. App1_Invoice (from Web App 1 database) e.g. transno name amount App2_Invoice … |
| | Hi guys... I have this page I'm trying to get to work, but no matter what I do it doesn't want to insert a new post into the database. Help? Please? <?php //ansluter till databasen $opendb=mysql_connect("****", "*****", "****") or die(mysql_error()); mysql_select_db("*****") or die(mysql_error()); //skriver information till den angivna tabellen om … Databases mysql |
| | Greetings, I have two tables named 'copyright' and 'logs'. Table : copyright Field : Copyr_md5 Table : logs Field : md5checksum Problem 1 Say i have a value stored in `$md5check` in php , now i want to check if the value stored in `$md5check` is found in field `Copyr_md5`.If … |
 | I want to display table by default in ascendind order with dynamically changing header. Here is my code. It is displaying the rows unordered. It should be in ascending at first look and then can change by column. $order = (isset($_GET['sortCostCode']) && strcasecmp($_GET['sortCostCode'], 'desc') == 0) ? 'DESC' : 'ASC'; … |
| | Hi everyone! I am pretty much new to Oracle it has only been 3 months or so I guess and I have a bit of a problem now. I'm running a query which will display the downtime of a machine. It will display the Start/End Time and its difference. The … Databases oracle |
| | Hi, how to pass values in mysql table from html form. give me simple examples. thanking you. |
| | hi guys can anyone explain to me what the codes in line 5 and 6 do? How does the WHERE works in those lines? Any explanation would be truly appreciated. Thanks in advance. SELECT LAST_NAME ||', '|| FIRST_NAME AS "NAME" FROM EMPLOYEES E, (SELECT JOB_ID, MAX(SALARY) SALARY FROM EMPLOYEES GROUP … Databases oracle |
| | I need to make time difference of 24 hours from registed time. In my database, there is column datelog with type "timestamp" Default value: CURRENT_TIMESTAMP I need the result if user with data: 2012-10-02 14:51:41 Test1 Test 2 User must not be able to register for next 24 hours. Thanks … Databases mysql |
| | so i now how to write quies and really really easy. its alot easier than being computer programmer. but sql salary are really high and computer programer which is alot harder is lower. why is this. a phd student told me that sql job are really boring. is that true??  |
| | hi trying to get a job where i have to write sql queries. i have writen some queries but i have to do a project. that way i can show the project to other people. any ideas of a sql projects? Databases sql |
| | |
| | Field defined as DECIMAL(5,2), trying to INSERT (250.00). When query is performed remotely to DB server, it fails with 'Out of range value for column...', when query is performed locally on the DB server, the query works. The query works remotely when the value being inserted is 226.24 (yes, that … Databases mysql |
| | Hi Prows,am creating a farm produce monitoring system using mysql and php.The database contains several tables of different produces that have the similar fields.The admin is supposed to update each table with different values.How will these datas relate. For example,maize field has Product-id,produce-name,location,date,time and mobile number of the buyer.Each table … Databases mysql |
| | Greetings, I want to know what is the pest practice in the following issue. I have a From for releasing decision such as hiring employee, discharging employee etc. The process of releasing a decision takes the following steps 1- You fill the necessary data within the from and then click … Databases data-structure mssql |
 | Hello! I've recently installed Windows 8 and since that moment my XAMPP installation has been acting a bit weird it takes over a second to establish a mysql connection (mysql_connect) where it used to take less than 0.01 seconds.Timed: Timer 1 (mysql_connect): 1.02864 Timer 2 (select_db): 0.00023 I have found … Databases mysql |
| | I have two tables (points, pointsmatch) Table 'points' have following fields id (int) seriesid (int) team (varchar) points (int) id seriesid team points 1 9 Chennai 4 2 9 Delhi 0 3 9 Kolkata 0 4 9 Mumbai 0 5 9 Bangalore 0 6 9 Mohali 0 7 9 Rajasthan … Databases mathematics mysql sql |
| | hope i worded this well enough... :D trouble working out a query Table: weeklyrevenue Week Number||value 25||20 26||40 28||60 Table daily_totals Week Number||quantity 26||10 27||10 28||10 Need week 27 totals to be multiplyed by week 26 revenue not week 28 revenue as the revenue would have been generated by the …  |
| | i have this problem for checking for duplicate username in database. this error appear whether the username is duplicate and does not duplicate. Please help. Warning: mysql_num_rows() expects parameter 1 to be resource, boolean in <?php include_once 'db/db.php'; include_once 'admin-class.php'; $admin = new itg_admin(); if(isset($_POST['Submit'])) { $con = mysql_connect("localhost","username","password","tablename"); if … |
| | i want to Calculate and list the average response time taken from the current set of job recruitment records, i.e. all the communications between the School and casual candidates for the express Job, and then update the response time for each casual staff according to updated response time =(currentresponse time … Databases sql |
 | Hey there, I have these three tables: A, B, and C. A has a one-to-many relation with both B and C. Right now, what I am doing is: I run a select query on A. I put the results on an array, lets say aArray. For each row in the … Databases mysql  |
| | I have two tables, author and quote: author: AID, Name, YOB, YOD. quote: ID, AuthID, Content. I currently get all the authors with one query and as I loop through them, I run a second query to get the count of quotes that have the current AID: $sql = "SELECT … Databases mysql |
| | I have two tables that I need to get the following information but I can't seem to figure out how to structure the query: Table 1 type show max min Table 2 model height width depth In Table 1 I have the following for the first row (as an example): … |
| | Hi I am attempting to build my own cms (although very basic) using php and mysql. Instead of having a static homepage, I want the content displayed to be dynamic. In other words, I want the homepage to be flexible/changeable based on whatever the latest 'content' entry into the database … |
| | SELECT t.* FROM (SELECT * FROM jobs WHERE `status` IN (0,1,2,3) ORDER BY `status` DESC, job_datetime LIMIT 11, 20) AS t That's a cut down sample of my sql. It was more complicated, but I've pared it down to this just to see why I was getting some strange numbers … |
| | i need a querry to add -- in the end of a table. for example if i have a table like tb name ze ad|ID| aa | -------------- 01|02|aa01 | 02|03|aa02 | how do i add -- to the end of all fields of aa column to be like aa01--\aa02--? Databases mysql |
| | hi guys just wanted to ask how to raise the pay of a worker in sql statement. By the way this is in oracle 10g.  I uploaded the instructions for your reference, thank you for those who will help out. Databases oracle  |
| | Hi, I'm wondering what type of mysqlfield would be advantageous for outputting the containing text as a bullit list in php and if the text should be formatted a certain way. I would be supergrateful for an example! :p Take care Adam |
| | Hello, I have problem with entering default values in MYSQL database. When i insert new record using phpmyadmin it works fine (empty fields get default value), but when i use the same query in my application (written in PHP), empty fields in html form don't get default value in MYSQL … Databases mysql |
| | how can i show the week number and corresponding dates using the tax year i tried Week(date, 0) but that shows 1-1-2012 as week 0 Eg; qc_data.date holds the date a qc inspection took place. if i want to show that the first full week in April this year (2 … Databases mysql |
| | Hallo there, does someone knows, where is the use of VARBINARY in MySQL database? Thanks, Danijel |
| | suppose there are given tables that has particular attributes, and for example I need to find how many ordered a specific dish.. example: "How many fried chicken orders were made in 1 month?" How do I do the sql statement for this? Thanks for those who will help. :D Databases oracle |
| | Hi, i have a Sql Server 2008 database, with a table that has around of 2.000.000 registers. The schema of the table is the following: idSpecie (PK, int) | Kingdom | Phylum | Class | Order | Family | Genus | Specie The kingdom, phylum, class, order, family, genus and … |
| | hi, am a newbie in database design and i really need some help. am supposed to create a database for the following scenario. "your organisation is a small firm that stocks equipment for hire to customers, you are required to help management create a database to simplify management of the … Databases database-design |
| | Happy aquatics specialise in insatlling aquariums into the offices of corporate customers,customers may order many installations but each installation is assigned to one specific customer.installations are classified by type.each installation may have one or more staff assigned to it, since these installations are often very large they may involve carpenters … Databases |
| | Greetings. I'm having a problem that is we have a fingerprint devices in the factory, we have 2 work shifts OK so the security guys must switch the devices from "in state" to "out state" so that the [in/out mode] in the database being 0 "means attend state" it changes … Databases mssql |
The End.