103 Recommended Topics

Remove Filter
Member Avatar for
Member Avatar for larry29936

I'm trying to create a trigger that does two things, first take an ip that's in dot notation and run inet_aton on it and put the result in another field. Second, checks a lookup table to identify an ip range that the result of the first action falls into and …

Databases mysql
Member Avatar for larry29936
1
255
Member Avatar for p0qrs0

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 …

Databases oracle sql
Member Avatar for peelsequal
0
101
Member Avatar for Dani

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
Member Avatar for Dani
0
1K
Member Avatar for ami_2

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
Member Avatar for Gilbertsilva123
0
890
Member Avatar for nishita_1

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 ![22222.jpg](/attachments/large/4/f8a1f4cfc8eaaad4bde70a850826b310.jpg)

Member Avatar for drmrkrch
0
1K
Member Avatar for Yumaris

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); …

Databases mysql php
Member Avatar for pritaeas
0
241
Member Avatar for Barbra_1

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 …

Member Avatar for pritaeas
0
215
Member Avatar for macfan

What about mobile crossapps? Im willing to code one if Dani is busy. What you all think

Databases
Member Avatar for Dani
0
150
Member Avatar for Patiodude

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), …

Databases mysql php sql
Member Avatar for surveypacific
0
885
Member Avatar for rahulephp

[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
Member Avatar for jaswanth reddy
0
54K
Member Avatar for Jeyaraman_1

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
Member Avatar for Reverend Jim
0
749
Member Avatar for ravi142

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
Member Avatar for Purvi_1
0
440
Member Avatar for bioplanet

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 | …

Databases mysql sql
0
107

The End.