7,494 Archived Topics
Remove Filter  | |
 | Hi all, I am working on a website that requires two queries from a table at the same time. They must select a row based on the id, and then another random one not including the row just selected. I currently have: $query = $pdo->prepare('SELECT title, content FROM cards WHERE … Databases mysql |
| |    |
| | I have the following table: my_contacts which contains the following columns: [CODE]contact_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, frist_name VARCHAR(20), interest VARCHAR(20)[/CODE] [CODE]-----------+-----------+---------- contact_id | fisrt_name | interest + ---------------------------------- 1 | smith | swim + 2 | mark | dance + ----------------------------------[/CODE] I need to move the interests column … Databases mysql |
| | A balanced tree is one of the data access techniques in a database. How does it work? How data can be inserted in. How data can be deleted from it; how data can be updated? And how data can be reviewed? By giving an example explain all of them. Your … Databases  |
 | I want connect microsoft sql server database using servername,username,password,port number and service name to asp.net api 2019. This code segment I'm using SqlConnection con = new SqlConnection(@"server=10.d.13.2q0; database=sdssdsd; Integrated Security=False; User ID=lmgdgdfdfddgs; Password=sdsdsdsds"); please help me. what is the correct code |
| | I am starting an online business with an American lady. I don't know anything other than her phone number. So want to verify her records. Databases |
| | Would you mind if I troubled you for some help? I’m working on an NDA’ed project and we’ve been asked to try and address a problem which is currently causing some pain. Imagine there was a merger between two blue-chip communications/media companies, and Company A was offering discounted deals to … Databases microsoft microsoft-access |
 | I want to split database access and permissions with another person. The problem is we don't know how we can make sure we both have the same rights and permissions to operate the database. So if anything goes wrong for example, one wants to change the password of the database … Databases |
| | I have a snippet that inserts data in a row in a MySql database. If that data already exists the existing row should be updated. In my case, I continue to get insert only. What is wrong with this snippet? $page = basename($_SERVER['SCRIPT_NAME']); $ip_address = $_SERVER['REMOTE_ADDR']; include_once("includes/connection.php"); $sql=mysqli_query($con, "SELECT visits … |
 | Like the title says, I'm trying to coloring an empty cell in bounded datagridview. I've got this code to coloring a cell with specitic value and is working well. This code is in the DatagridviewCellFormattingEventargs. If e.ColumnIndex = 5 AndAlso e.Value <= Date.Now.ToShortDateString Then e.CellStyle.ForeColor = Color.DarkGreen e.CellStyle.Font = New … |
| | Good evening everyone, I created this file to be able to print the data from the database on the screen. Everything ok but all the data contained in the database appear on the same line. I would like them to print like this: nome email titolo dataeora msg nome email … |
 | Hi guys im using VisualStudio2017 to make a chat program from a youtube video i keep getting an error and wondered if one of you might be able to help me out. Exception thrown: 'System.InvalidOperationException' in MySql.Data.dll The code: Imports System.Security.Cryptography Imports System.IO Imports MySql.Data.MySqlClient Module Con_Add Public usernamefriend As … |
 | create table dummy{id int ,invoice int } insert into dummy values(191,10),(192,11),(193,0); I have to update 193 with invoice 13 but i want to fetch max invoice and then increment invoice by 1 for 193 . i had tried update dummy set invoice=(select max(invoice) from dummy)+1 where id=191. It wont work … Databases mysql |
 | Hi. I'm trying to set up an AMP system on my machine. It's called UwAmp. Anybody there to tell me how to setup the MySQL in this thing? Thank you  |
| | Good day, I am actually a young programmer, who wants to develop a webpage that enables someone to take a practice test. It was given to me as an assignment that determines if I will remain a programmer. I know little about PHP codes but none in Mysql. I came … Databases mysql php web-design |
| | Hi All, I am having an issues with an SQL query and I can't quite work out how to resolve it. I have searched Google for the answer but can't seem to find the solution there either. Basically I have a database andin one of the tables it has a …  |
| | Hello Could I please ask for assistance? I need a file that I am able to download that holds all the streets and postal codes of the Ireland. Databases php |
| | Looking for directions. Where would one go to find a downloadable excel sheet, listing the streets of Algeria city? Databases microsoft-office php |
 | I have the following query which has died after running over an hour on my local mysql 8 server: UPDATE download LEFT JOIN lookup ON download.ip_address between lookup.start_ip AND lookup.end_ip SET ref = ( SELECT lookup.id FROM lookup WHERE download.ip_address between lookup.start_ip AND lookup.end_ip); All ip fields are IPV4 and … |
| | Hi. I'm trying to write a game in PHP. Now a weird item shows up in my database. http://www.leondegroot.nl/files/mysql_nieuw.png "Nieuw" means "New". Do you have any idea what this is and how to delete it? Thanks, Leon Databases mysql |
 | I have a table with the following fields: CREATE TABLE text ( drawing INT NOT NULL, blockID INT NOT NULL, entityID INT NOT NULL, style INT, txt VARCHAR(255) NOT NULL, attrib INT); My csv file contains the data: 19 1CB2 E49 2 CLIENT MODULAR 1C2A 19 1CB3 E4B 2 CLIENT … Databases sql |
 | ERROR 1054 (42S22): Unknown column 'Firstname' in 'field list' I'M gettin the above error when I enter: mysql> insert into people (fname, lname) -> VALUES (Firstname, Lastname); Here's the table: mysql> desc people; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | fname … Databases mysql |
| | Hi there, Not sure if I am in the right place, but I wanted to ask where I can access a csv file for all the streets in Belgium? Databases microsoft-office mssql sql |
 | Hi all, I have a question about updating two values in a sql table using a subquery. My database is called books and the below table books too: id title author location_id 11 Tera Netrear 4 14 Disser Bubu 1 15 Tenno Puoio 4 16 Oban Tyrone 5 18 Sisnobi … Databases sql |
 | Hello. I am making a database using SQLite. Then I need to make an API with functions that returns information about that database. Then I need to print out a report. However, when I try to return an answer to a query using inputs, nothing is returned. I either get …  |
| | |
 | Hi, can someone help me solve this please I have tried so hard but can't figure it out? In past years, approximately 20% of all U.S. families purchased potato chips at least once a month. You are interested in determining the fraction of all U.S. families that currently purchase potato … Databases microsoft-office |
| | I would like to develop an attendence regiater for my company. i would like to use,Mongodatabase,node.js and javasscript am i the register should the availble on an link. am i in the right track Databases first-post javascript node.js |
| | Hi all, I have assigned a column called "friendshipstatus" as a default value =0 in addfriends table that user can add other users to it to be friends as the code bellow which will give any users added as friend in addfriendss table the "friendshipstatus" value of 1 <?php include … |
| | 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 … |
| | 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 |
| | 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 |
 | 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); … |
| | 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 |
| | What about mobile crossapps? Im willing to code one if Dani is busy. What you all think Databases |
| | 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 |
| | 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 |
 | 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 |
| | 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 open-source vb.net  |
| | 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. |
 | 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 |
| | 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 |
| | 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 |
| | 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 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 … |
| | 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 |
The End.