User Tools
Writing /app/www/public/data/meta/toolsandtechnologies/creating_mysql_queries_in_excel.meta failed
toolsandtechnologies:creating_mysql_queries_in_excel
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| toolsandtechnologies:creating_mysql_queries_in_excel [2017/05/05 15:50] – mmcc | toolsandtechnologies:creating_mysql_queries_in_excel [2021/06/25 10:09] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Creating mySQL Queries in Excel ====== | ||
| + | |||
| + | Author: Michelle McCausland | ||
| + | |||
| + | ===== Introduction ===== | ||
| + | |||
| + | Creating SQL queries in Excel can be a much more efficient way of generating usable queries from a large table of data such as trap knowledge, contact responsibilities, | ||
| + | |||
| + | ===== Implementation ===== | ||
| + | |||
| + | * In this example we will be working with the following address detail information that we want to update: | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | * It looks as though we have all the data we need to generate an update statement. | ||
| + | * Start by clicking on the next blank cell in the column after the first row of data and type an sql statement to work from: | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | * So now we have an sql statement to populate with data based on each row. Click into this cell with the SQL query and wrap it around '' | ||
| + | * Now you can replace F, G and C with data by typing the following: | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | * Note this is used to select a cell '' | ||
| + | * Note this is used to select a cell '' | ||
| + | * So now you have your query and you can copy it down to the other rows by clicking the cell, hovering over the bottom right corner until your mouse icon changes, and then double clicking. (You can also click and drag the handle to copy cells down) | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | * Now you have all of your queries which dynamically reference cell contents! | ||
| + | * Be sure to double and triple check these values are correct before running any sql. | ||
| + | * It is a good idea to copy the sql column and "paste values" | ||
Page Tools
