Windows 10: Query records from the MySQL database and display them in color?

Hi, I have a question,

How can I color the text I query from my MYSQL database using Php? My code looks like this

<td>user name:</td

<td><?=$_SESSION['name']?></td>

I tried to load the whole thing via the css with

.tablename {

font-size: 12px;

font family: Helvetica, Arial, sans-serif;

line-height : 19px;

font-weight : bold;

color: #FF0000;

}

unfortunately without success.

Best regards

:)

 

How to completely uninstall MySQL?

Hi,

Thank you for writing to Microsoft Community Forums.

Which version of Windows is installed on your device?

Refer the article ‘Which Windows operating system am I running’
to provide the details.

I suggest you to follow the steps mentioned below to uninstall MySQL from the device.

Step 1

Uninstall MySQL from Control Panel. To do so,

Go to Control Panel >Programs and Features > Select
MySQL > Click on Uninstall.

After you have uninstalled MySQL through Add/Remove programs, you now need to remove the existing database information which includes your actual data. If you need any of that data, be sure to back it up. Next you can delete
the data directory.

Step 2

Run Command Prompt as Administrator and execute the following command to stop and remove MySQL service.

Net stop MySQL

Sc delete MySQL

Step 3

1. Click on Start, type in Show hidden files and folders.
   
2. Select the View tab and select
   Show hidden files and folders.
   
3. Now explore the following locations and delete following folders.
   
   C:\Program Files\MySQL
   
   C:\Program Files (x86)\MySQL
   
   C:\ProgramData\MySQL
   
   And if exists, delete the folder from the location.
   
   C:\Users\[User-Name]\AppData\Roaming\MySQL
   
4. Restart your device and check the status.
   

Get back to us for further assistance on this issue. We will be happy to help you.

Regards,

Muralidhar

Microsoft Community Moderator

 

Slow update Query.. (PHP/MySql)

Hello,

I am using PHP/MySql, I am updating a table having about 2000 records, I am updating using the index key and just update one column.. its taking about 0.03-0.09 secs, I feel like its slow.. as I have other similar update queries on the page so it could a big time..

the Select query on the other hand takes only 0.0006-0.001 secs

 

Slow update Query.. (PHP/MySql)

if you have a key on id then there is nothing else you can optimize from a query perspective.

could you look into your mysql server variables like buffers etc