119 Recommended Topics
Remove Filter  | |
| | I am building a ipv4/ipv6 geo ip **MongoDB** database and i will have millions (100+) of ips Structure will of the database will be [ { _id: 58fdbf5c0ef8a50b4cdd9a8e , ip: '34.53.63.25', ip_hex: '0x22353f19' , type: "ipv4", data : [ { country : "CA", region : "region1" city : "city1", blacklisted … Databases client-server mongodb  |
| | I am new here. I passionately need the help of python gurus here to help solve this my statistics analytics problem. I want to write a python code that prompts for an imput. Then saves the new input data into a table of numbers at the last position while it … Databases python |
 | hello, i hope someone can help me i have a table ip in my database if there is 5 times in it he has to forward it in php to another page. thanks in advance  |
| | Hi Everyone! I am new here, and the main purpose of joining this community is getting some help. Actually, I am designing a PHP website where I need to fetch US vehicles data into PHP. I have already used this source to get the vehicle's dataset from here https://www.back4app.com/database/back4app/car-make-model-dataset. Still, … Databases microsoft-office php |
 | # Introduction # As we move into 2022, businesses will continue to look for ways to become more data-driven. This means that knowing how to use Structured Query Language, commonly called SQL or 'Sequel', will remain an essential skill for data scientists, analysts, and developers. In this post, we'll provide … |
| | import net.proteanit.sql.DbUtils; import javax.swing.*; import javax.xml.transform.Result; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; public class EmployeeRegistriation { private JPanel Main; private JTextField txtName; private JTextField txtSalary; private JTextField txtMobile; private JButton saveButton; private JTable table1; private JButton updateButton; private JButton deleteButton; private JButton searchButton; private JTextField txtId; private JScrollPane tabla_1; public … |
 | Hello, I am fairly new to VBA development trying to upgrade my employee training database in VBA from a single listbox with single line select/add/edit capability to one that pulls employee data from listbox1, searches training available by job title in listbox2, and combines the data into listbox3 also adding … Databases microsoft microsoft-office |
 | so we were trying to make a simple log in form and our professor simply told us to copy the codes he wrote:  i copied it but i got a red line under line 20 and 21 . I dont know what to do, no one is responding to … Databases  |
| | hii how can i make self join and sum data in other table by username i have table like this members (id, username, referral) ref_bonus (id, username, bonus) members id | username | referral ---------------------- 1 id1 id2 2 id2 null 3 id3 id2 ref_bonus id | username | bonus … Databases  |
| | The web application will have a database that consists of millions (over 20mil ... maybe 100mil or more) of hosts (ipv4,ipv6 and domains) and additional data to each host like blacklist, uptime, history, geo data (country, region, city, isp). I could, of course, use other RMDBS system like MySQL, Oracle, … Databases  |
| | Hello all, We have just launched a startup. Now, we are looking for a simple web-based relational database system where we can easily add tables and connect them to one another through foreign keys. For example, we would want to create a suppliers database in which we could perform a … Databases |
| | HELP! We are a volunteer-driven not-for-profit offering motorcycle safety training and skill development with a huge database issue as described below. We cannot identify any of our volunteers that can tackle our database issue...here it is, can you volunteer your time to help us? We would be glad to hear … |
| | package sadbinproject; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JOptionPane; /** * * @author Notebook */ public final class admission_panel extends javax.swing.JFrame { /** * Creates new form admission_panel */ public admission_panel() { initComponents(); Connect(); } Connection con; PreparedStatement pst; public void Connect() { … Databases java  |
| | I am a newbie and i am working with php and i have got the following error Parse error: syntax error, unexpected 'INSERT' (T_STRING), expecting ',' or ')' in verify.php on line 9 CODE SNIPPET:    |
| | Hello friends, I am new to this site, this is my first post, My question is.. How to calculate the one rows value for next row value? [code=sql]select @rownum:=@rownum+1 "sl.no", b.bus_activity_desc "Type",r.trn_no, o.Office_name,o.Address,o.Address2,o.Address3, DATE_FORMAT(r.trn_date,GET_FORMAT(DATE,'EUR')) as trn_date, l.Account_id , if(r.trn_type=6,r.total_trn_value,0) "Credit", if(r.trn_type=7,r.total_trn_value,0) "Debit", if(r.trn_type=6 ,@cbal:=(r.total_trn_value+@cbal),@cbal:=(@cbal-r.total_trn_value)) "Closing Balance" from(select @rownum:=0) s, office_master … Databases mysql  |
| | |
 | Hello. I am trying to check if a table definition (the default value on a constraint) is equal to UTC Time by using the following query: IF NOT EXISTS((SELECT object_definition(default_object_id) AS definition FROM sys.columns WHERE name = 'ModifiedDate' AND object_id = object_id('dbo.WorkflowAudit')) == GETUTCDATE()) However, you can not compare a … |
| | Illustrate a database for the video club using a recent video club entities Databases microsoft-access mysql sql |
| | I have an access Database with Chinese and German words. How can I had their audio prononciation wich I get from Forvo or Google translate? Databases audio microsoft-access sql |
| | I have managed to get blog posts displayed from each blog category but I want to limit it to 1 article from each blog category but unsure how to do it in the sql query I have, below is what I have so far (SELECT BP.postID,postTitle,postSlug,postDesc,postDate,postImage FROM blog_posts BP, blog_post_cats … Databases mysql  |
| | Create a table with following rules and regulations ma 1)Id should b identity 2)Name should allow only starting Letter with a to p 3)city should not allow Chennai,cbe, Salem 4) department should allo only cse,it,ece, 5) college default should b anna university 6) per should above only 70% 7) year … Databases sql |
 | I have a SQLite database that for some insane reason stores dates as the number of days since 1899-12-31. I want to create a view that will display the date as an actual date. I can calculate a specific date from a specific day number as select date('1899-12-31','Localtime','+44386 day') as … Databases sqlite |
| | Find product who hasn't had any sales in first three months of the year?  |
| | I have three tables: First table is 'user': user_id | Name | ---------------------- 1234354 | Abu Bakar | 2543353 | Ali | 3342342 | Aliza | 4234243 | Ali | 5234324 | Mike | Second table is 'meeting': meeting_id | meeting_name | meeting_startDate | meeting_endDate | room_name | ---------------------------------------------------------------------------------- 1 … Databases sql |
| | Hi Guys, Im not sure how to word the title of this question, but i have a table called "daily_recyclables". Inside this table, i have multiple columns of recyclable materials (example copper, stainless steel, brass etc etc) In my PHP application, i have a statistic card (like below) that is … |
 | Our database is running into problems, as many transactions are waiting for locks held by other transactions. Here is what each transaction is waiting for: · T1 is waiting on T4 · T5 is waiting on T8 · T2 is waiting on T7 · T6 is waiting on T2 · … Databases  |
 | 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 |
| | DaniWeb was written in Codeigniter, and when posting to the forums, we use database transactions that look like this: $this->db->trans_start(); ... insert into the posts table ... ... update the member's post count ... ... update the tags table ... etc $this->db->trans_complete(); On occassion, the error log will show for … Databases codeigniter 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 |
The End.