How to Select From MySQL in Python
First, you will need the mysql.connector. If you are unsure of how to get this setup, refer to [How to Install MySQL Driver in Python]1.
Technical Articles
In-depth guides, insights, and best practices for modern software engineering
How to Insert into a MySQL Table in Python
If you need to insert data into a MySQL table using Python, then look no further.
If you need to first learn about the mysql.connector and how to get …
How to Create a Primary Key for a MySQL Database in Python
You can create a Primary Key for your MySQL database in Python as follows.
First, you need to know if the Primary Key already exists.
Option 1 – The …
Read Article →How to Create a MySQL Table in Python
If you need to create a table in a MySQL database using Python, then you can do the following.
How to Create a MySQL Table in Python
import …How to Create a MySQL Database in Python
In order to create a MySQL database in Python, you first need to initiate a connection using the mysql.connector. You can learn about how to create a …
How to Install MySQL Driver in Python
To begin using MySQL in Python, you need to do the following:
Step 1 – Install the MySQL Connector
Using pip, we can install the MySQL Connector …
How to Resize an AWS EBS Volume in Bash
If you need to resize an EBS volume in AWS, you can do so using bash.
Step 1 – Create a bash file
Create a bash file called resize.sh:
#!/bin/bash …How to get all checked checkboxes in Javascript
If you need to get all the checked checkboxes using Javascript, then you can do the following:
Option 1 – In a single line
const checkedBoxes = …How to Setup Credential Helper for AWS CodeCommit
AWS CodeCommit is a git code repository service by Amazon Web Services.
You will want to clone your repository and setup your remotes using credential …
How to Flex Grid 2 Columns using CSS
If you would like to flex grid 2 columns in CSS then you need three (3) divs.
Step 1 – Set your HTML template
Create some HTML with this layout. …
Read Article →How to Create a Hashtag Generator in Javascript
If you want to create a hashtag generator in Javascript, then you can do the following:
function generateHashtag(string) {
if (string.trim() === …How to Confirm before Leaving Page in Javascript
You can implement a function to be called before the user leaves a page with Javascript as follows:
window.onbeforeunload = function(e) {
return …What are the multiples of 3 from 1 to 1000
If you need to calculate the multiples of 3, starting from 1 up until 1000, then you can use the following code:
n = 1
v = []
while n <= 1000: …How to Count Files in Directory on Linux
If you need to count how many files are in a directory on Linux, then you can use a combination of the ls command to list all the files, and the wc …
How to Read a File Line by Line in Java
If you need to read a file line by line in Java, then you can use one of the following three (3) options.
Option 1
You can use the FileReader and …
How can I clear or empty a StringBuilder
You can use Java’s StringBuilder to create and manipulate Strings as follows:
StringBuilder sb = new StringBuilder(); …How to Approve a SageMaker model in AWS CLI
Sometimes you will need to manually approve a SageMaker model package from the AWS CLI.
Step 1 – Get a list of the available packages
aws sagemaker …How to Assume Role across Accounts in AWS
If you need to assume role between AWS accounts, or allow an account to assume a role and use resources in another AWS account, then you need to …
Read Article →How to Style an Element using Javascript
If you need to style an element using Javascript then you can use the style object to support all your CSS needs.
<html>
<body> …How to Wait 1 Second in Javascript
If you need your Javascript code to wait one (1) second (or more) while executing, then there are a couple of ways to achieve this.
Option 1 – …
Read Article →How to use forEach method in Javascript
Arrays come with a useful forEach function that allows you to loop through the array.
var colors = ['red', 'blue', 'green']; …How to Remove an Element from an Array in Javascript
If you need to remove an element from an array in Javascript, then you can use one of the following five (5) options:
Option 1 – Use splice to remove …
Read Article →
How to get the Alphabet as Array in Javascript
If you need to get an array of alphabetical letters in Javascript then you can use one of the following:
Option 1 – Explicitly define the array first …
Read Article →The Power of Two (2) Table
With the Power of Two, you can ask the following:
- How do you find the powers of 2?
- What does the power of 2 stand for?
- How much is the power of 2? …