117 Recommended Topics
Remove Filter  | |
| | I'm studying SQL with Oracle 11gR2 and I'm trying to write sql query to solve this problem. Q. Assuming that campaign's budget is divided by the number of ADs included in the campaign, show the campaign that contains the AD that consumes the largest amount of budget and the campaign … |
 | My code has a query that looks like: INSERT INTO table VALUES (...) ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id), ... id is a PRIMARY KEY. My question is that I can't for anything remember why I have id = LAST_INSERT_ID(id). I wrote it years ago and it's not commented. … Databases mysql |
 | Hi all, Before I begin this question, and before you tell me we dont do homework, I would like to state that I have read a few articles, I have tried a couple of functions (=REPLACE, =SUBSTITUTE) but i'm not able to get the reuslts require, I'm new to Excel … Databases microsoft-office |
| | Dear sir, Please help me about below query. here is two table sale and purchase. i want product wise result in output table like below picture. please help me  Databases client-server mssql mysql php sql |
 | Notice: Undefined index: ID in C:\xampp\htdocs\tugas\phpdb\ubahsimpan.php on line 10 im tired ,,, how i can fix that? My ubahdata.php <html> <body> <?php $koneksi=mysqli_connect("localhost","root","") or die ("Koneksi Gagal".mysqli_error()); if($koneksi){ mysqli_select_db($koneksi,"buku") or die ("Database gagal dibuka".mysqli_error()); $ID=$_GET['ID']; //Mejalankan Querry $sql="select * from anggota where id_anggota='$ID'"; $qry=mysqli_query($koneksi, $sql) or die ("Querry gagal".mysqli_error()); $data=mysqli_fetch_array($qry); …  |
| | Hi there i need help on how I am supposed to do this ER Diagram based on this question. I need to have entities, attributes, relationships and primary/foreign keys. here is the question You are given the following business scenario. SmartService is a newly setup car repair and servicing workshop … Databases microsoft-access microsoft-office mssql mysql sql |
| | What about mobile crossapps? Im willing to code one if Dani is busy. What you all think Databases |
| | I've just started working with PHP and MySQL, and I'm trying to create a table in MySQL. If I've got this right, I'm trying to do so by going to my host's SQL MyAdmin page and typing in mysql_query("CREATE TABLE example( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(30), … |
| | [B]Mysql - How to use UPDATE with SELECT???[/B] I have two tables: [B]1) products_category[/B] -cat_id -cat_name [B]2) related_category[/B] -rel_cat_id (exaclty same as products_category.cat_id==related_category.rel_cat_id) -rel_cat_name [B]products_category table[/B] [IMG]http://www.ephpsolutions.com/scud/rrr/product_category.gif[/IMG] [B]related_category table[/B] [IMG]http://www.ephpsolutions.com/scud/rrr/related_category.gif[/IMG] I want to get cat_name from products_category and want to store in rel_cat_name in related_category tabel. and the query should … Databases mysql |
| | Imports System.Data.OleDb Public Class Form1 Dim pro As String Dim connstring As String Dim myconnection As OleDbConnection = New OleDbConnection Dim command As String Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click pro = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\sinthu\Documents\Database1.accdb" connstring = pro myconnection.ConnectionString = connstring myconnection.Open() If myconnection.State = … Databases vb.net  |
 | I Have **"user_chat"** table name his 4 columns "msg_id" Auto Increament "chat_from_id" "chat_to_id" "chat_msgs" SELECT `chat_msgs` from `user_chat` where chat_from_id='2'AND chat_to_id='10' LIMIT 0,10 Also I have used **DESC** using above queary but not worked I want to fetch last **5 recent records** from **"chat_msgs" columns** Suggest me. Thank you Databases sql |
| | I have the following two tables: TABLE 1: +-----------------------------+--------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------------+--------------------------------------+------+-----+---------+-------+ | patient_id | bigint(20) | NO | PRI | NULL | | | patient_wpid | int(11) | NO | PRI | NULL | | | age_at_visit | … |
| | can you please help me to answer that problem? This is a question, I have an employee salary table, How do I find the second highest from it.? A big thanks to those who will help. I appreciate it a lot. Databases mysql |
 | Hi helpful people. Its been a while since Ive been here, ever since I employed someone who knew about IT to look after it for me. I'm back on my own again, and looking for a bit of guidance please? I run a small sales company and receive daily sales … |
 | Hi, I am new with sql server. I want my date formate like dd-mm-yyyy.. but i could not able to do so. please help me and give me proper syntex fro the same Databases sql |
| | Hello all. I have a funtion in MYSQL to substruct days from a date. This function seamsto work but some dates it times out. This is my function CREATE DEFINER=`root`@`localhost` FUNCTION `Calculater`(intrval int, req date) RETURNS date DETERMINISTIC BEGIN declare calculated date; declare added int default 0; Lbl_Loop: Loop IF … Databases mysql |
| | Hey! I am really stressed out about my TURBO CPP project. I wrote a program on periodic table using file handling. when i compiled it crashed and not the project is unusable. I want to submit it at the earliest. I was hoping some one might drop their out projects. … Databases |
| | I'm using phpMyAdmin to manage my databases, I have 2 projects that use 2 different database the first one uses 'root'@'localhost' and the 2nd is 'root'@'127.0.0.1' I don't know how i ended up using 2 different server but it was working fine until i tried to edit codes with the … Databases client-server mysql |
| | Hello guys, i've the following table in database : IdCity int CityName nvarchar(20) it has the data like this in it : IdCity CityName 1 Абакан 2 Азов 3 Александров 4 Алексин 5 Альметьевск 6 Анапа when i try to run the following view SELECT IdCity, CityName FROM dbo.City WHERE …  |
| | Hi everyone, right now I am looking for a database b2c (consumers) from the UK and SPAIN with more than 200k leads. This is to buy, someone interested? Databases |
 | I come across this problem every so often and end up having to do work arounds when I would prefer to keep it in the database. I have a query where the data in the query updates frequently so the query won't stay in the cache but I don't need … |
 | Hi all :) Currently now I used MS SQL Server Management Studio 2008. I have an existing table with data already store on that table. Table Name : Application Column : Categories (nvarchar(1), null) Sequence (nvarchar(1), null) Detail (nvarchar(150), null) I would like to ask how to add primary key … |
| | Spent a day trying to gen any info on this but didn't find anything so maybe someone here could help me out . here's the html code and a css style. Maybe it's not that difficult in the end but I have never done this and php is not my … Databases html-css |
| | Hi all, I wanted to procedure to return number of days and weekdays between two dates. This is what I came up with and it seems to work ok, but I'd like to read what others think. And if there's already a single line function for this, oops. Also, I'm … |
| | Hello. At work, I have to count about 5k in a day for products. When someone takes out or puts in products for example 450 I have to recount again. So I want to create a system that when someone puts some kind of product on the shelf they would … Databases microsoft-access vb.net  |
| | I am looking to create a database to record when students' work has been handed in to the office. I have created the form but it needs to be able to record who signed in the work. There are several people working in the office and will use the database. … Databases microsoft-access |
| | I am using bootstrap modals, when i query to populate a dropdown to fill in to my form, my query is show all but the first record and i can't figure out why. My form looks like this <div class="form-group"> <label for="deptcode">Department</label> <select class="form-control" id="deptcode" name="deptcode" value="<?php echo $mem['deptcode'];?>" <?php … Databases mysql |
The End.