Questions tagged [mysql-5]

Question 1

I have 3 MySQL tables: products, orders and users. I want to show all ordered products where not all products are "pre-orders" or "discounts". Note: one user can have multiple ...

Question 2

I've been developing a C# Bus System app using SQL, and I need some advice. I don't know if asking on here is the right thing to do, but I essentially need someone to analyse the .SQL file I have, ...

Question 3

I wish to fetch all rows from table after the nth Position as i given offset value my table like id | Value 1 | A | 2 | B | 3 | C | 4 | D | 5 | E | ... N | R | I wants the 3rd row Data to Nth ...

Question 4

I have designed my database model with entities and they have relations along with normalization. Now I want to implement my design in my database engine. Before implementing I am puzzled with the ...

Question 5

I want to know if there is any signal that I can catch by which I can know that my mysql connection with the server has broken in c programming? I know I can check at query time whether my connection ...

Question 6

I see the below warning on the my slave server: 2016-11-18 22:48:03 12808 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, ...

Question 7

I have a large-ish (several GB) mysql DB that I'm planning to import via mysql -u root -p mydb < mydb.sql in a SSH session. What would happen if my SSH connection drops? Is it safer to run ...

Question 8

I am looking to generate a cryptographically secure string for password reset in MySQL. I know I could do this at the application level in PHP; but that requires the OpenSSL extension which many of my ...

Question 9

How do I create a table with a formula column in MySQL version 5? For example: I have a table named Product, which has 5 columns: id int, amount int, sold_out int, faulty int, remain_amount is (...

Question 10

We are in the process of testing MySQL replication before using it in production. The MySQL is being setup by Puppet in our case and I noticed that the binlog_format setting is different between ...

Question 11

I'm new to MySQL and I have a problem with one task. I have a table like this: +------------+------------+-------------+ | code | name | location | +------------+------------+----------...

Question 12

I have created a table (attendance_details) for storing every day attendance of Students in MySQL. Need to capture attendance for hourly (1-8hrs) every day. I have the student details in separate ...

Question 13

I have two MySQL databases that are for Wordpress websites. One db is for a live version of a site, the second is a copy of the original that is used in conjunction with a copy of the original site. ...

Question 14

I am pretty much a beginner having only created a few small php web applications relying on a MySQL database. I am now working on a somewhat larger project. I am in the planning stages of setting up ...

Question 15

I have the following table (MySQL): -------------------------------------------------------- | id |product_id| store_id | stock_id | priority | --------------------------------------------------...

Stack Exchange Network

Questions tagged [mysql-5]

MySQL with subquery becomes slow

Structure of my database design?

Mysql Select all Rows after nth Position

Table Creation Order

Signal handler on mysql connection break

MySQL Master 5.5 - Slave 5.6 - unknown system variable 'binlog_checksum', Error_code: 1193

Will a mysql db import be interrupted if my ssh session times out?

MySQL secure random string generator

Computed/Generated columns in MySQL 5

MySQL v5.1.73 - can the binlog_format betweem Master & slave be different?

Exclude entries from SELECT COUNT

Table Design for Student Attendance hourly for each day

MySQL UTF-8 Encoding Problem

Trying to avoid bad MySQL database design - can't figure out how to avoid too many columns

SELECT WHERE CASE

Hot Network Questions