sql

  1. K

    Constructing a large table with 8 million rows and 30 columns

    I have to create a table of 8 million transport workers with roughly 20 to 30 key values. Data will be ingested through an apps, The table can perform some simple data analysis. Can someone tell me which should be a lost code DBM architecture?
    • Kazi
    • Thread
    • aws create table gcp microsoft azure sql table
    • Replies: 0
    • Forum: Databases
  2. choudhmh

    JavaScript Need help with SQL / javascript

    Good day Writing this code there one of the database field is vote - within the javascript i have this parameter called increment votes. When any number is passed through the parameter the votes for that id within the table must be increased by the the parameter amount (or decrease). Got...
  3. timeolethug

    PHP how to make a mysql database on replit?

    Hello everyone, with a friend we make a dynamic website and for collaborate, we make it on replit.com, because we don't find how to create a database in this website. Did you know how to make it? (sorry for the spelling, i'm french) Thank you and good evening.
    • timeolethug
    • Thread
    • css database dynamic website html mysql replit sql
    • Replies: 1
    • Forum: PHP
  4. D

    C# C# form with sql file

    I wanna create a form with sql, myd data can someone help me. I wouldn't know sql.
    • deu
    • Thread
    • form myd sql
    • Replies: 3
    • Forum: C#
  5. Johna

    PHP Getting content from SQL database with PHP works fine until I add a for loop

    I'm trying to make a dynamic gallery page for a website. This code works fine: <?php $servername = "server"; $username = "username"; $password = "password"; $dbname = "dbname"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection...
    • Johna
    • Thread
    • mysql mysqli php sql
    • Replies: 6
    • Forum: PHP
  6. J

    Duplicate Rows on Multiple Tables w/ Linked Keys - SQL / PHP

    Hello All, Hoping someone with a little more experience than myself maybe able to help. I've been stuck on this issue with my code for months now, and it's started hurting my head thinking about it. Can anybody offer any guidance / advise / anything at all to help me on my way? ----- I'm...
  7. F

    HTML & CSS How do I store sign up information into an SQL database

    I've got the html and CSS code for a sign up and login system on a website but I don't know how to then store the information inputted into an SQL database and then retrieve that data when a user wants to login again. This is the HTML: <!DOCTYPE html> <html> <head> <title>Sign Up | By...
  8. N

    Write a database program whose input various information

    Hi, I want to write a program whose input is the names of the companies and when adding the name of each company, it will take various information from that company of different types, 1- TextBox (daily production rate), 2- CheckBox (select product features), 3- OptionButton (the gender of the...
  9. H

    SQL: Need Rows with Non-Zero Values

    Hi all! I'm conducting an analysis on spending. I'm trying to find how much individual customers have spent every month in the last year. I'm working with transaction data so we only have rows for transactions that actually happened. Therefore, for customer A who only transacted in January...
  10. Brandon3000

    PHP My Multi User Login System Won't Work

    I've been trying to make a multi user login system but when I try to log on it stays at the login page (index.php) page. What can I do? index.php <form method="post" class="form-horizontal"> <div class="form-group"> <label class="col-sm-3 control-label">Email</label> <div...
  11. ahmedbarbary

    Python How to keep columns header on excel without change after export data to excel file?

    I work on sql server 2017 I run script depend on python language v 3.10 . I need to export data to excel fileStudentExport.xlsx already exist, and keep header without change after export. header of excel file StudentExport.xlsx before export data to it as below StudentId,StudentName after...
  12. Roy Harper

    LAG() not working on phpmyadmin

    I created a view for weekly sales. Everything is working fine on localhost using MySQL. But when I upload the database on GoDaddy Lag doesn't seem to work. When I am typing LAG on phpmyadmin, no suggestion is showing. Can anyone help me with this one? Thanks the structure of vw_sales is...
  13. V

    SQL search by part of name

    Can u help with this: -find an item in the database by entering part of its name CREATE TABLE Confectionery ( IDConfect INT IDENTITY NOT NULL PRIMARY KEY, NameProduct NVARCHAR(50) NOT NULL, Category INT NOT NULL, Quantity SMALLINT NOT NULL, Price DECIMAL(20) ); CREATE TABLE...
  14. Roy Harper

    Prepared statements needs to be re-prepared.

    I tried uploading my website on 000webhost but I am getting error "Prepared statements needs to be re-prepared." I search through the internet and found these two solutions: It happens every time I query through views table. 1. Increase table_definition_cache - The problem is, 000webhost does...
  15. Roy Harper

    PHP Generating unique txID or Using auto_increment in SQL

    I am just curious as to why others generate unique strings or ID for transactions or orders when they can just use the primary key in SQL. Is it recommended to generate id like this 111834039007163223, or is it okay to just use the primary key in SQL generated using auto_incement? I always see...
  16. Roy Harper

    Changing datetime in computer affects CURRENT_TIMESTAMP in SQL

    I have blog page in my website. Whenever I write a blog, I only save the content of the blog, and let the SQL handle the current timestamp. So my code goes like this: CREATE TABLE blogs( blogID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, title VARCHAR(255) NOT NULL, content TEXT...
  17. Roy Harper

    How to select records if the total from another table is not equals to Zero (0)?

    I have a product categories listed in my website. But, I don't want to show categories that has 0 products under it, as you can see in the image below. Here is my code: SELECT c.category AS category, (SELECT COUNT(*) FROM products AS p WHERE p.categoryID =...
  18. Ben711Gaming

    VB.Net + SQLite "Column not found" -_-

    I am new to SQLite and am trying to make a program that creates a database (if it doesn't already exist) then allow the user to input data. When I go to press 'input data' it gives the error "Microsoft.Data.Sqlite.SqliteException: 'SQLite Error 1: 'no such column: CustomerID'.'". I can use DB...
  19. cartel_coder

    Crucial Resources 2020-05-03

    A repo I just took from my local and made it on github Crucial Resources. Im new to coding and would love some extra input as I know I am missing a lot. I use these daily so feel free to fork or clone and enjoy them. -Cheers Crucial Resources
  20. Ghost

    Tutorial Create Table in Installation Script

    Much like popular online software, we can create scripts that automatically generate database tables. This comes in handy because it allows the user to simply give us the database name / user / password / host information instead of forcing them to upload an SQL file or manually create the...
    • Ghost
    • Thread
    • create table generate table if not exists insert installation script mariadb mysql query sql
    • Replies: 0
    • Forum: Databases
Top Bottom