MySQL Questions Asked in Companies

mysql> SELECT * FROM tablename WHERE fieldname = “pcds”; To show certain selected rows with the value “pcds” in MySQL, you can use the SELECT statement with a WHERE clause. Here’s an example: sql SELECT * FROM your_table_name WHERE your_column_name = ‘pcds’; Replace your_table_name with the actual name of your table and your_column_name with the … Read more

mysql> show columns from tablename; In MySQL, you can use the DESCRIBE statement or the SHOW COLUMNS statement to retrieve information about the columns of a table. Both commands provide details about the structure of a table. DESCRIBE statement: sql DESCRIBE your_table_name; Example: sql DESCRIBE employees; SHOW COLUMNS statement: sql SHOW COLUMNS FROM your_table_name; Example: … Read more

mysql> SELECT * FROM tablename; To show all data from a table in MySQL, you can use the SELECT statement. The basic syntax is as follows: sql SELECT * FROM your_table_name; Replace your_table_name with the actual name of your table. The * is a wildcard character that represents all columns in the table. For example, … Read more

mysql> drop table tablename; In MySQL, you can delete a table using the DROP TABLE statement. Here’s the basic syntax: sql DROP TABLE table_name; Replace table_name with the name of the table you want to delete. Be cautious when using this statement, as it permanently removes the table and all of its data. Make sure … Read more

mysql> SELECT SUM(*) FROM [table name]; To get the sum of a column in MySQL, you can use the SUM() function. Here’s the basic syntax: sql SELECT SUM(column_name) FROM table_name; Replace column_name with the name of the column for which you want to calculate the sum, and table_name with the name of the table where … Read more