Help with mysql download  mysql

7 years ago | 1 comment | self.mysql | Score: 1 Reddit

I need help with this 'simple' MySQL query  mysql

7 years ago | 5 comments | self.mysql | Score: 6 Reddit

Need a little help figuring out a table creation strategy to store shipping data  mysql

7 years ago | 6 comments | self.mysql | Score: 2 Reddit

Mysql-installer-community-5.7.18.1 installation on Windows step by step  mysql

7 years ago | comments | magazie.co.in | Score: Reddit

C ODBC Fetch doesn't return anything  mysql

7 years ago | 1 comment | self.mysql | Score: 1 Reddit

I Deleted some rows from one table in a DB, How can I add the rows back from a back from a Backup of the whole MYSQL DB?  mysql

7 years ago | 6 comments | self.mysql | Score: 8 Reddit

How to Use PHP and MySQL Document Store  mysql

7 years ago | comments | elephantdolphin.blogspot.com | Score: 1 Reddit

Create, Backup and Restore MYSQL Database using cmd in Windows  mysql

7 years ago | 1 comment | magazie.co.in | Score: Reddit

How to find unused indexes in a MySQL database?  mysql

7 years ago | 5 comments | eversql.com | Score: 21 Reddit

anyone tried to run mysql cluster on 100 nodes raspberry pi?  mysql

7 years ago | 5 comments | self.mysql | Score: 2 Reddit

MSQL DATA Querying Small Project that needs to be done $30 due tonight at midnight!  mysql

7 years ago | comments | self.mysql | Score: Reddit

Updates are faster than selects  mysql

7 years ago | 13 comments | self.mysql | Score: 6 Reddit

Developing an inventory system with PHP and MySQL  mysql

7 years ago | 3 comments | self.mysql | Score: 2 Reddit

How to get unique list of addresses within 60 seconds with fewer mysql calls?  mysql

7 years ago | 1 comment | self.mysql | Score: Reddit

[MySQL] How do I write a SELECT stored procedure or prepared statement with a variable column as well as the search parameter?  mysql

7 years ago | 3 comments | self.mysql | Score: 2 Reddit

my.cnf file doesn't seem to look like any of the examples I see online  mysql

7 years ago | 7 comments | self.mysql | Score: 2 Reddit

Visual Query Builder  mysql

7 years ago | 6 comments | self.mysql | Score: 5 Reddit

MySQL Workbench on Ubuntu why so dark?  mysql

7 years ago | comments | self.mysql | Score: Reddit

binary log GUI tools?  mysql

7 years ago | 1 comment | self.mysql | Score: 2 Reddit

Database to PlantUML, utility to visualise a MySQL database into a PNG, SVG etc.  mysql

7 years ago | comments | github.com | Score: 7 Reddit

Any other way to run MySql queries other than Command Prompt?  mysql

7 years ago | 17 comments | self.mysql | Score: 3 Reddit

Create, Backup and Restore MYSQL Database in Linux  mysql

7 years ago | 3 comments | magazie.co.in | Score: Reddit

If you could change MySQL optimizer to do one thing differently, what would it be?  mysql

7 years ago | 16 comments | self.mysql | Score: 5 Reddit

sql: mysql pipe  mysql

7 years ago | 1 comment | github.com | Score: 2 Reddit

Sneakernet sync of mysql and mariadb  mysql

7 years ago | 4 comments | self.mysql | Score: 4 Reddit

Allow Remote Access to user for Database?  mysql

7 years ago | 3 comments | self.mysql | Score: 4 Reddit

Latest Comment

So your mysql server is on a windows server, and you're trying to connect to it remotely? First this is not really recommended, but... These steps are basically what I do on ubuntu, steps should be in theory similar for mysql server for windows.

edit my.cnf change bind-address to 0.0.0.0

bind-address = 0.0.0.0
  • if windows firewall is enabled, allow inbound 3306 from <endusersIP>
  • create a user someuser@'<endusersIP>'
  • don't use % for the IP, lock it down to their actual IP
  • grant appropriate privileges to somedb.*

if this were a linux box i'd suggest using ssh tunneling for port 3306 so you don't have to bind mysql to a public internet facing IP e.g. 0.0.0.0. For my use case, I use ssh tunneling to connect to remote db's all the time, and for those scenarios where I can't use ssh tunneling I ensure mysql is bound to 0.0.0.0 and I only allow a whitelist of IPs through the firewall (either ufw, iptables, or appliance fw's).

As another approach I haven't used it but I thought xtrabackup from Percona allows remote mysql backups where your scenario fits in as a perfect use case, but I could be wrong.


7 years ago

Merge multiple join in single row  mysql

7 years ago | 2 comments | self.mysql | Score: Reddit

Latest Comment

Nevermind think there issn't another way than to use a lot of left joins and where name = and use the value


7 years ago

Get list of unique users (online users) MySql &amp; PHP - not showing array of uniques  mysql

7 years ago | 2 comments | self.mysql | Score: 1 Reddit

Latest Comment

  1. This is not a PHP help forum.
  2. You provide no warning or error output to help diagnose the problem.
  3. You provide no expected vs actual output to help diagnose the problem.
  4. You never call the function in question.
  5. The function returns the value, it doesn't display it.
  6. You do not provide table definitions or explain what data they might contain.
  7. You provide literally no context about your situation at all.

How do you expect us to help you?


7 years ago

Most efficient way to backup 1m TPD MySQL DB?  mysql

7 years ago | 3 comments | self.mysql | Score: 6 Reddit

Latest Comment

Are your tables all innodb? If so then xtrabackup is your answer. If not, well now's your excuse.

Even if you make s slave replica to pause and backup, how are you going to build that slave in the first place?

Xtrabackup will pause the engine to snapshot the .frm files at the end, and it will have to flush tables with read lock in order to copy off any myisam tables, so you'll want to not have any. Otherwise it's good stuff, you'll learn to love it.


7 years ago

MySQL Equivalent of VLOOKUP using INSERT?  mysql

7 years ago | 5 comments | self.mysql | Score: 4 Reddit

Latest Comment

Where not exists in subquery is known to be slow. The standard optimization for this is to do an outer join and test for null. This of course assumes you have an index on email otherwise you're not going to get too far.

SELECT t1.email, t1.code, t1.id
FROM t1
LEFT JOIN t2 ON t1.email = t2.email
WHERE t2.email IS NULL;

7 years ago

Way to join these 2 queries together? Create entry 'if don't exist' and 'add amount', or 'if exists' 'add existing amount'  mysql

7 years ago | 3 comments | self.mysql | Score: 1 Reddit

Latest Comment

if primAddress has a unique key:

INSERT INTO thedatabase (primAddress, theirBalance) VALUES (:Reciever, :Amount) ON DUPLICATE KEY update thierBalance = thierBalance + :Amount;

7 years ago

Group by multiple values in same column  mysql

7 years ago | 3 comments | self.mysql | Score: 2 Reddit

Latest Comment

That's a factorial-level increase in resultset size. You've got 3 group ids and you want 6 results. If you had 4 groups, you'd have 24 rows. If you had 5 groups that's 120 rows. 10 groups is 3628800 rows. At 100 groups you're at 9.3e157 rows.

Bottom line, it doesn't scale.


7 years ago

Is it possible to host Facebook on AWS?  mysql

7 years ago | comments | blog.sqlizer.io | Score: 5 Reddit

Possible changes to /r/mysql rules  mysql

7 years ago | 21 comments | self.mysql | Score: 6 Reddit

Latest Comment

My personal rule is to filter the links I post to be relevant (i.e. behavior changes and deprecations are often useful to get the word out on.)

But I would love to have "MySQL Product Manager @ Oracle" user flair.


7 years ago

The MySQL High Availability Landscape in 2017 (The Elders)  mysql

7 years ago | comments | percona.com | Score: 13 Reddit

Querying Data with no success  mysql

7 years ago | 9 comments | self.mysql | Score: 1 Reddit

Latest Comment

You aren't joining the meeting table, as such, MySQL doesn't know what you are trying to get when you are asking for meeting.meeting_start.

Also your joins seem off... Can you post the actual raw query that you are running?


7 years ago

Newbie - Using multiple connections?  mysql

7 years ago | 5 comments | self.mysql | Score: 2 Reddit

Latest Comment

If 10 people were totry to retrieve data at the same time, you would need 10 connections.

Yes but if you did things right, the queries execute very quickly and are done in a small fraction of a second.

Also, you can cache complex results and serve them out of something more appropriate, like a key-value store.


7 years ago

Debian 9 and MySQL: Watch Out!  mysql

7 years ago | 5 comments | mysqlrelease.com | Score: 1 Reddit

Latest Comment

Name brand fruit is good for you. Beware of counterfeit fruit as it may not be as nutritionally complete as name brand fruit.

-Sponsored by the Name brand fruit growers association.


7 years ago

Still a Beginner, How to Search all stored Procedures in a database.  mysql

7 years ago | 2 comments | self.mysql | Score: 3 Reddit

Latest Comment

SELECT
  ROUTINE_SCHEMA,
  ROUTINE_NAME,
  ROUTINE_DEFINITION 
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE 
  ROUTINE_SCHEMA='selected database'
AND
  ROUTINE_DEFINITION LIKE '%certain string%';

7 years ago

Is it possible to set the default security type for newly created views to be "Invoker" instead of "Definer"?  mysql

7 years ago | 3 comments | self.mysql | Score: 3 Reddit

Latest Comment

Sure, you just specify it as part of your view definition, e.g.:

create sql security invoker view 'my_view' <query text>;

https://dev.mysql.com/doc/refman/5.7/en/create-view.html


7 years ago

Move columns with identical ID + import/update  mysql

7 years ago | 7 comments | self.mysql | Score: 2 Reddit

Latest Comment

I found a working query. But need to do it two tables at a time, had issues with the id=id when more than two.

CREATE TABLE merged AS (SELECT * FROM table1 LEFT JOIN table2 on table1.id = table2.id

);


7 years ago

Is it normal for mysqldump on different machines (but same database) to output different file sizes?  mysql

7 years ago | 4 comments | self.mysql | Score: 3 Reddit

Latest Comment

How significant is the difference in size?


7 years ago

[HELP] Select from multiple tables, and SUM  mysql

7 years ago | 3 comments | self.mysql | Score: 4 Reddit

Latest Comment

This seems wrong in many ways.

  1. Why are you using a table with your list of tables? That seems inefficient
  2. Instead of Select * , if you only care about the count, you should do a count().
  3. You could probably write a stored procedure to do this for you.

7 years ago

Cannot find practice exam or books for 1Z0-883  mysql

7 years ago | 3 comments | self.mysql | Score: 2 Reddit

Latest Comment

Sadly the Oracle Press started work on a prep book and even had a mock-up for sale on Amazon but never came to terms with the author. This exam is tough (And I used to write questions for MySQL cert exams but not this one) and you need a few years of experience before considering tackling it. Study the material listed on the exam contents in depth. Good luck.


7 years ago

how would you import the stackoverflow developer survey full results?  mysql

7 years ago | comments | self.mysql | Score: 2 Reddit

Doubt in creating tables  mysql

7 years ago | comments | self.mysql | Score: 1 Reddit

Latest Comment

Why do you reference to the XML file in the database? Just use database and abandon the XMLs.
So you need to create columns for all the XML attributes, such as the number of players.


7 years ago

How MySQL triggers can affect queries - Triggers &amp; Updateable Views  mysql

7 years ago | comments | percona.com | Score: 1 Reddit

How to store past prices while scraping.  mysql

7 years ago | 5 comments | self.mysql | Score: 3 Reddit

Latest Comment

You need two tables, ITEM and PRICE.

ITEM will have one row per item. PRICE will have one row per item-price. PRICE will have a foreign key like ITEM_ID that will be the primary key in your ITEM table.

Google/YouTube foreign keys.


7 years ago

The tale of weak mysql student  mysql

7 years ago | 5 comments | self.mysql | Score: Reddit

Latest Comment

Okay. I think i've finished Vanya and Students. Can you confirm my code? SELECT COUNT(total) FROM students WHERE (total-10)/2 > 15 If its correct then only one more to go. But i have no clue on how to sort varchar lexicographically. I don't know how to sort anything lexicographically.


7 years ago

8 Different Types of Tools You Can Use to Document your Database  mysql

7 years ago | comments | dataedo.com | Score: 3 Reddit

Latest Comment

That's nicely presented. Many of the options they listed are sufficient for many small databases, but a couple of those (including theirs) look useful for larger systems.


7 years ago