Hey everybody I want to let you know that I have undertaken the grueling task of getting the heck away from WordPress. I was so sick of the problems and updates I had to do all the time. I am now using my ezbloo system and I am integrating all my old posts into the new system. It sucks, but in the end, I will save bundles of time. I needed to keep things simple and that is why I created ezbloo. I'll have more on this later for you guys after I am done with the total integration of my old posts here. So if you are looking for a post and need it faster, shoot me an email and I will make it a priority. [email protected]
To find records that start and end with a certain value use this command. SELECT * FROM [table] WHERE [column] LIKE '[val_ue]';
Read MoreTo find something that starts with a certain string use this code. SELECT * FROM [table] WHERE [column] LIKE '[value]%';
Read MoreTo find records containing something use this command. SELECT * FROM [table] WHERE [column] LIKE '%[value]%';
Read MoreTo select specific records in terminal use this code. SELECT * FROM [table] WHERE [column] = [value];
Read MoreTo count and select group records in terminal use this command. SELECT *, (SELECT COUNT([column]) FROM [table]) AS count FROM [table] GROUP BY [column];
Read MoreTo count records enter this command. Take out square brackets and replace names accordingly. SELECT COUNT([column]) FROM [table];
Read MoreTo select parts of records use this command. SELECT [column], [another-column] FROM [table];
Read MoreTo explain records use this command. Take out brackets and replace table with your table name. EXPLAIN SELECT * FROM [table];
Read MoreTo select record in terminal for mysql use this command. Change the value of table and take out the brackets. SELECT * FROM [table];
Read MoreFor date time input use this function. NOW()
Read MoreTo insert a record use this command in terminal. Customize the values. INSERT INTO [table] ([column], [column]) VALUES ('[value]', [value]');
Read MoreIf you're working with a MySQL database, you may find that you need to add a new column to a table. Fortunately, adding a column to a MySQL table is a straightforward process that we will do using the MySQL terminal command. Here's how:
Read MoreTo create a new table with columns use this command. CREATE TABLE [table] ([column] VARCHAR(120), [another-column] DATETIME);
Read MoreTo see all indexes on a table enter this code. show index from [table];
Read MoreTo show the table structure in terminal use this code. describe [table];
Read More