Mysql create copy of table and all of the data

MySQL
I need to create a backup copy of a table and all of the data in it. This is what I have tried so far: SELECT * INTO copy_cust FROM Customers; A...
2 months ago

MySQL Loop of Inserts

MySQL
I want to copy some rows data to another table, For example: I have this 2 Tables: (qa_items_purchases), (qa_suppliers_invoices) qa_items_purchases,...
2 months ago

Best way to store and retrieve big video files for a web based app ?

MySQL
I am making a video sharing site. So I was thinking on what is the best way to store lots of big video files. So that it will be fast and performance ...
2 months ago

MySql primary key does't consume any size

MySQL
I have those two tables schema: CREATE TABLE `myTable` ( id int(11) NOT NULL AUTO_INCREMENT, lat double NOT NULL, lng double NOT NULL, date d...
2 months ago

MySQL : transaction within a stored procedure

MySQL
The basic structure of my stored procedure is, BEGIN .. Declare statements .. START TRANSACTION; .. Query 1 .. .. Query 2 ...
1 month ago

Pros and cons of identifying relationship over non-identifying and vice versa

MySQL
Let's imagine simple real world customer-loan relationship scenario, where loan existence without customer is impossible, hence the relationship logic...
1 month ago

Mysql in Erlang

MySQL
I want get data in Mysql by Erlang but the data output I get it show all col_name and it not render one by one This is my output: {selected,["id",...
1 month ago

my python code write in a temporary data base

MySQL
I wrote a python code that write/read data in/from a MySQL DB. The problem is that the table still empty even after I write in it. And when I close th...
1 month ago

What are the Pros and Cons of Hashing Entire MySQL Database in PHP Bcrypt?

MySQL
I have seen on the internet that it is a good practice of hashing user names and passwords using BCrypt for better security. If your database was comp...
1 month ago

MySQL generated .sql Cannot add foreign key constraint

MySQL
This is the table I get "Cannot add foreign key constraint" error. -- ----------------------------------------------------- -- Table `mydb`.`Supervis...
1 month ago

PHP/MySQL Multi table selections

MySQL
I'm trying to select multiple rows from one table, depending on the ID given from another table. I've got it half working with the code below, howeve...
1 month ago

Pentaho Table input to table output in batches

MySQL
My input table in MySQL has 20 Million records and the target table in Oracle is empty. I need to load the entire table from MySQL into Oracle. I am s...
1 month ago

Search GROUP_CONCAT using LIKE

MySQL
I have an SQL query that uses GROUP_CONCAT to get all people attached to a certain order. Is there a way I can search inside the GROUP_CONCAT field? ...
1 month ago

How to select first 10 elements from database using SQL?

MySQL
There is a query like SELECT * FROM clients ORDER BY id. I want to select only first 10 elements. How can I do this? P.S. I'm using MySQL. ...
1 month ago

Hide empty td if count value is empty in datatables

MySQL
I have this script which works hidden NULL values in mysql db, but with EMPTY values always count them...so How can I hide this values too? <table...
1 month ago

Securely store Android Firebase Auth users in a MySQL database

MySQL
I am creating an Android native app and I am using Firebase Auth with multiple auth provides such as; Email, Facebook, Google etc, I will use the Fire...
1 month ago

how to syncronize datetime field in Codeigniter and Mysql

MySQL
i'm working with Codeigniter and Mysql for database.on of my table have one field called tgl_input with type TIMESTAMP.for that field my form in Codei...
1 month ago

Pass ID of row to Detail Page with PDO

MySQL
I'm trying to update a master/detail setup from mysql to PDO in order to be compatible with PHP7. I have got the master page working exactly as it sho...
1 month ago

How to get the top 5 countries with most number of clients in sakila database?

MySQL
I need a query to get the top 5 countries with most number of clients. I am using MySQL's sakila database example. The tables related to this questi...
1 month ago

mysql distinct query using joins

MySQL
I have a complex database relationship (to me its complex). In theory, I think it a good design, but my roadblock now is getting data out of it in as ...
1 month ago