Changing AUTO_INCREMENT value in MySQL
How do I change the AUTO_INCREMENT value? ALTER TABLE database_name.table_name AUTO_INCREMENT=5000
http://www.mikecolbertonline.com
How do I change the AUTO_INCREMENT value? ALTER TABLE database_name.table_name AUTO_INCREMENT=5000
Configure TextEdit on your Mac for use in coding projects, edit the settings below. TextEdit –> Preferences –>
To unlock a user account on Oracle SQL: ALTER USER username ACCOUNT UNLOCK; To reset the password on an Oracle SQL account: ALTER USER username IDENTIFIED BY a_new_password;
Visit https://futureboy.us/stegano/ Original iPhone 5s photo iPhone 5s image w/ hidden message. The password is ‘pAssw0rd’. The images were FTP’d into a directory and this WordPress post linked to the images. If the images were uploaded into the WordPress media manager, the steganography was lost – maybe due to compression(?).
To create a login (server wide account) which uses a simple username + password combination for SQL authentication: CREATE LOGIN ReadOnlyUserName WITH PASSWORD = ‘strong_password’; NOTE: This allows the user to connect using SQL Management Studio. It is not required if the user only needs to connect to a specific database. To create a user to … Read more
To determine the MSSQL version: SELECT @@version
On Error Resume Next ‘turn off error handling Application.DisplayAlerts = False ‘turn off alerts Worksheets(“Summary”).delete Worksheets(“RBI”).delete Worksheets(“HR”).delete Worksheets(“ERA”).delete Application.DisplayAlerts = True ‘turn alerts back on On Error GoTo 0 ‘turn error handling back on
Each photo is 4 seconds – 3 seconds for the photo and 1 second for the transition (cross dissolve). I use the photo album theme with a senior pic as the album cover along with their name. Each video is roughly divided into 4 sections (pre-elementary, elementary, middle, and high school). The first three sections correspond … Read more
Using Microsoft Azure PowerShell and Azure Service Manager, this script will loop through all provisioned cloud services and display them in a selection box to allow multiple cloud services to be selected to be deprovisioned and deleted, easily, at one time. Very handy for cleaning up after demonstrations and student labs. # Modified from a blog post … Read more
To count the number of rows in a Microsoft SQL database table: SELECT COUNT(*) FROM dbo.table_name;