Recent Questions

I have Windows 10 on a Surface Pro 3. I am trying to use Visual Studio Code. Unfortunately, there seems to be no combination whatsoever where I can run my program. Any time I hit F5 or ctrl f5 or shift f5, the windows 10 search bar from the OS pops up. There seems to be no way to make the application received the F5 before the OS and I can find no way to swap any key to make the program Let's block ads! بخوانید...

I have a MySQL database that was created from data output by another application. On of the columns is for an email address, however the data in this column is all duplicates. For example, the "email" for a single record looks like this "[email protected],[email protected]". I would like the field to contain the address just once. Is there a way through a MySQL command, to remove anything from the , onward? I know I can write a PHP script to loop through all the data, but i was hoping there was a simpler way through MySQL. This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-on...

I'm trying to restart my mysqld process on CentOS 6.6. I have root access to the server and when I run top, this is the first line: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 3874 mysql 15 0 2859m 336m 7188 S 120.5 16.4 74730:50 mysqld Clearly there is an issue there (and I may need to increase the DB server since it's maxing out) but the first step I want to take is to put the process through a power cycle to restart it since it hasn't been restarted in a very long time. I've tried as root to do many different processes: service mysqld restart (I get service not found) If I run which mysqld I get /usr/sbin/mysqld . I tried: /usr/sbin/mysqld restart T...

Just experimenting with mysql and batch file (call me nostalgic :-) ) echo SELECT some_field FROM some_table WHERE some_field like '%needle%' G > command.sql mysql -s -q -h %svr% --user=%user% --password=%pass% %database% < command.sql This command works perfect for numerical results, but for string results, it is just blank. even if I list the complete table result, it shows all the numerical values, but the field that has strings it is just blank. example 2 rows have "jane doe", and mysql displays ************* 1. row *********************** Name: ************* 2. row *********************** Name: but age works ************* 1. row *********************** Age: 33 ************...