Loading
Forums in MySQL
How to Recover a Corrupted MySQL Database?
First, stop writes to the affected database and create a copy of the database files. For InnoDB corruption, check the MySQL error log to identify the affected tables or pages, then use innodb_force_recovery starting with the lowest applicable value to bring the server into a recovery state. If the d
How bind the menu from myslq db in _Layout.cshtml with eg code ?
Hi , can anyone suggest with sample code to bind fmenu from myslq db in _Layout.cshtml . ? sample code is vital for implement. Thanks in advance Karthik.k
How bind the menu from myslq db in _Layout.cshtml with eg code ?
Hi , can anyone suggest with sample code to bind fmenu from myslq db in _Layout.cshtml . ? sample code is vital for implement. Thanks in advance Karthik.k
mysql
The following query results in 2,698 rows of data being retrieved, but the auditor_report table only has 1,620 rows. Analyse the query and select the reason why this discrepancy occurs.
File operation to Mysql Database in python
i have date and month based folder are there thousand & lakhs of file there inside the folder s what is good approach for that insert in to database in daily based like scheduler or service
MySQL calculator tools
Hi everyone, I’ve been using MySQLCalculator.com to calculate memory requirements for my MySQL setup, but I’m now looking for alternatives that might provide more detailed estimates or advanced features—especially for high-traffic MySQL environments. Are there any other tools or calculators you would recommend that can help with calculating buffer sizes and memory usage based on factors like query load, connection count, and server traffic? Any insights on tools that offer better memory optimization suggestions, or provide more specific recommendations for tuning parameters such as innodb_buffer_pool_size, query_cache_size, etc. , would be greatly appreciated! Thanks in advance for your help!
Generate Dynamic Date Columns as per input.
DECLARE @StartDate DATE = '2024-01-01'; DECLARE @EndDate DATE = '2024-01-07'; -- like a temprary table must be create with columns as. -- thes start date and end date is dynamic. so it can go 7 columns , 12 columns , 70 columns..etc _____________________________________________________________________________________________ id |2023/01/01 | 2023/01/02 | 2023/01/03 | 2023/01/04 | 2023/01/05 | 2023/01/06 | 2023/01/07 | --------------------------------------------------------------------------------------------- so i want dynamic generated columns for the temporary table. where the StartDate and EndDate are dynamic example 7,14,90 days.
Show employees who satisfy the following description: was 45 when hire
Hi guys, had a collum brith_day and hire_ date ,i need to show empolees who had 45 yers at the moment of hire i try to (birth_date-hire_date) = 45 but dosnt work, can someone help me? still learn it
root password of my sql
I didn't get option to set root password of mysql during installation. Now, I am unable to form instance I am beginner in mysql I have tried reinstallating the software watching youtube still didn't got that option.
insert is not working in mysql 8.0
use test -- insert INSERT INTO cust VALUES ('hi'); -- fetch SELECT * FROM cust test is my database name cust is my table name have only 1 column varchar getting error code 1064 you have an error in syntax
mysql on xammp keeps crashing any permanent fix?
Hi Team Yesterday i installed xammp newest version and worked fine including setting up the database well. This morning keep getting weird errros and cant seem to get permanent fix. Saw my options some do work like uinstall the software xammp 8. Is there any permanent solution could apply because i keep delaying my work because of silly misconfiguration set up each day. 9:38:57 AM [mysql] Status change detected: stopped 9:38:57 AM [mysql] Error: MySQL shutdown unexpectedly. 9:38:57 AM [mysql] This may be due to a blocked port, missing dependencies, 9:38:57 AM [mysql] improper privileges, a crash, or a shutdown by another method. 9:38:57 AM [mysql] Press the Logs button to view error logs and check 9:38:57 AM [mysql] the Windows Event Viewer for more clues 9:38:57 AM [mysql] If you need more help, copy and post this 9:38:57 AM [mysql] entire log window on the forums full; Please wait ... 2023-03-24 9:38:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2023-03-24 9:38:55 0 [Note] InnoDB: Waiting for purge to start 2023-03-24 9:38:55 0 [Note] InnoDB: 10.4.25 started; log sequence number 706133; transaction id 1032 2023-03-24 9:38:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool 2023-03-24 9:38:55 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-03-24 9:38:55 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded 2023-03-24 9:38:55 0 [ERROR] Failed to initialize plugins. 2023-03-24 9:38:55 0 [ERROR] Aborting
select Query between today's time and Tomorrow's Time ?
Hi All , we are in a situation to select records in my sql on basis of Today's time as start time and Tomorrow's Time as end Time . For eg : consider the following scenario Start Dt : 2022-10-17 : 11:00 Am ( Current Day ) End Dt : 2022-10-18 : 03:00 Am ( Next Day ) If the current time falls in the following condition , so the select query have value else Not .This is for the purpose of Operative Hour concept in webapplication. If anyone knows this query suggest me with example query . Thanks in advance , Karthik .K
Create a derived column using SQL to take alternate days
I need a SQL query to insert data in another physical table and a derived column called reporting period should be created based on the FirstCoolOffStartdate. First row of that derived column should be null and second row will always have reporting period value of the respective FirstcoolOff_Created_DT column and also FirstCoolOffEndCycle45Days should show only the 45 days completion date for the alternate days.
How can I move all the records more than 10days from main table to ano
Hi everyone, please help me with this.... How can I move all the records more than 10days from main table to another table every day
does EXISTS suppose to return all record if the subquery is true ?
hi everyone, i have a question ... does EXISTS suppose to return all record if the subquery is true ?
When insert new row, delete old data when data reaches 10 rows.
Hello, How can I delete old data with Mysql? For example, delete old data when data reaches 10 rows.
Which is the best method for load balancer in MySQL 8
Hi everyone, Which is the best method for load balancer in MySQL 8
is this possible
Hallo friends... is this possible ... I have two tables whereby I want to insert to table 2 by selecting from table 1 and then delete all the data in table 1
Anyone know how to convert cvs files from encoding utf-8 to utf-16?
Anyone know how to convert cvs files from encoding utf-8 to utf-16?
