Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    herrifransisca
    @herrifransisca

    hello everyone, /\

    I'd like to make an app with nodejs, mysql

    1. what driver/module should I use ?
      (if mongodb, I use "mongoose")

    2. I'd like to deploy it to heroku, where should I host the database ?
      (if mongodb, I use "mlab")

    thank you very much for the guidance

    Nirvana
    @Himly1
    Hello
    Why this sql cannot run ?
    select * from project_application_records par inner join (select * from project_version pv where pv.project_id = par.project_id order by version desc limit  1) as prv
    Here is the error 
    [42S22][1054] Unknown column 'par.project_id' in 'where clause
    Here is the table struct
    id    bigint(20)    NO    PRI        auto_increment
application_info    json    NO    ""        ""
application_method    int(11)    NO    ""        ""
created_at    datetime    NO    ""        ""
process_instance_id    varchar(255)    NO    ""        ""
status    int(11)    NO    ""        ""
updated_at    datetime    NO    ""        ""
dynamic_form_id    bigint(20)    NO    MUL        ""
project_id    bigint(20)    YES    MUL        ""
user_id    bigint(20)    YES    MUL        ""
real_time_application_status    varchar(255)    YES    ""        ""
    lokendra singh chouhan
    @loks15
    Different Types Of SQL Joins https://www.technolush.com/blog/sql-joins
    Panyu
    @MarvellousBaby
    hello everyone'
    [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
    2019-05-13 16:41:21 140652249397056 [ERROR] Aborting
    Akash
    @Official-Akash
    Hello everyone,
    I want to get the hierarchical structure of all dbs and their tables in MySQL. What is the best way in MySQL to achieve so
    I want like: If I have two dbs: db1 and db2 with each db having 2-3 tables. I want to get the data in such form that It will print like (db1, table1), (db1, table2), (db2, table1)... and so on
    lokendra singh chouhan
    @loks15
    MySQL Data Types https://www.technolush.com/blog/mysql-data-types
    XaiPhyr
    @XaiPhyr
    hi guys, this is my first time trying to learn about mysql, and I am doing a mysql localhost:3306 but I keep on receiving access denied for user root@localhost, any of you encounter this error? thank you so much...
    Patryk Kotarski
    @patrykk21

    Hello, dears.

    I'd like to create an array of integers from 1 to 63,000. How do I do in mysql?

    Santiago Suárez
    @santiagosuarezecheverri
    @santiagosuarezecheverri
    hi
    I have a problem with mysql in nodejs
    no connect to database but the database exist
    Tarun Wadhwa
    @tarunwadhwa13
    Hi, I just restored mysql 5.6 dump to rds with mysql 5.7. have started getting malformed packet errors for specific keys.
    The confusion is that error doesnt come every time we query.Its quite random
    Mysql version 5.7.12. Things are working fine 5.7.25
    Tarun Wadhwa
    @tarunwadhwa13
    I get Lost connection to MySQL server during query django for specific keys only.
    vijendra singh
    @viju0731_twitter
    hi
    i am trying on this query
    any help
    This query gets run every month and produces results for a single month. I'd like to be able to input a base month, and have the query produce a table for each month, and then combine the output into a single output.
    IP_Census_Query (1).txt
    any help on it would be much appreciate
    Looking adjust in the the query
    寒秋
    @jackey
    have any mysql table shard solution ?
    ALLEN KENDRA
    @ALLENKENDRA5_twitter
    hello here
    Lucas Lobosque
    @Lobosque
    I have a table representing financial transactions between user with fields DateCreated, amount, sourceAccountId, targetAccountId --- How do I get the most recent movement for each user in a single query in an efficient way?
    drapeauc
    @drapeauc
    HI !
    Hi ! Looking for help in Php/mysql have few question if your avaible pm me ! Thanks
    aymenbraiek
    @aymenbraiek
    why my req not work for table 2 million rows ????SELECT ticket from ticket_custom USE INDEX(ticket_ov) where ticket NOT IN (select id from idanomalie)
    stherrienaspnet
    @stherrienaspnet
    Hello guys I'm having difficulty with an insert statement that is containing a where clause can someone assist me please
    Sushil Sharma
    @adrino181
    Hey guys
    i have a quick question anyone like to help
    After registering a user i want to fill all the empty data related to that user in other tables in my database i am using Mysql
    One way to do is , I can make another db calls at the time of user creation to fill the tables but i don't think its the best way to approach
    If its the only way then also tell me :p
    Nicolae Olariu
    @nicolaeolariu_twitter
    Hi everyone! Quick question: soft or
    Soft or hard delete data?
    I’ve read a lots of threads on the internet and opinions are quite spread and I was wondering what do you guys think.
    It’s about deleting some users instead of deactivating those. MySql.
    Brandon Zacharie
    @BrandonZacharie
    Users? Soft unless you’re ok with orphaning or cascade deleting referencing rows and the perf hit for deleting
    domdom8
    @domdom8
    hi guys
    when we use show global status and when go with "show status" ?
    anyone has ideas?
    daniramdani
    @daniramdani
    Hi guys, sorry I have question, I using Cloud SQL (MYSQL) in GCP, more than last 2 weeks the memory increased, my question why the spike not decreased again, the trend now is flat since 2 weeks. how do I check in detail the causes and how do I fix it ?
    Nalin Bhardwaj
    @nalinbhardwaj
    Long shot but does anyone here know how Mysql/InnoDB works with indexes if there are multiple tables with different collation servers? So, if I have table1 with utf8mb4 collation and table2 with latin1_swedish_ci collation, if I join them is there a big performance hit?
    Md. Alamin (Miraje)
    @mirajehossain

    Hi,
    I am facing an issue in group_concat when I export data from MySQL workbench,

    How do I set gorup_concat max length when export data????

    Lior Kedmi
    @lkedmi
    Hey! did anyone ever try to use sequalize with encrypted fields? I saw there's a library called sequalize-encrypted but it doesn't have proper documentation, at-least not for the latest version of sequalize.
    Thanks!
    Suryaobulareddy2932
    @Suryaobulareddy2932
    Hi
    I'm new to mysql database
    I would like to know anyone using mysql with timeseries data?
    brightinnovator
    @brightinnovator

    I want to read 3 crore csv rows which is of 2GB csv file size and need to insert into MySQL via Java.

    Could someone please help me know the fastest and memory efficient way to avoid out of memory exception as well load in lesser time?

    Please kindly advise.

    Brian S. Boros
    @brianboros7
    Hi all, I'm kind of new to Gitter, and I'm wondering if there is any SQL developers or engineers here who work with MySQL Workbench?
    learningdeveloper2021
    @learningdeveloper2021

    Approaches to handle 10 million records of 10 tables each with several joins

    I have 10 million records of 10 tables each with several joins. I am looking for the best alternative or DB assign or approach to read the records very quickly that is the query should be fast.

    option#1 - normalize the tables, don't go for joins unnecessarily
    option#2 - add all the columns in 1st query where multiple times the
    where conditions will be used in the looping construct
    option#3 - go for nosql database instead of mysql

    Please advise

    Thanks