New answers tagged

1

Exactly the same happened to me, I tried the following query and it worked: USE mysql; CHECK TABLE db; If it returns db is corrupt, then repair it using REPAIR TABLE db; CHECK TABLE db; You should get status as OK.


1

You could try to change the Compatibility Level of the database to 100 (for SQL Server 2008/R2 default) that may support ACT. Changing compatibility only gives you partial backward compatibility though, but it should work for majority of the times. To change the compatibility level, go to the properties of the database and then "Options"


0

I was able to regain root access via phpMyAdmin using the following command in the terminal killall -9 mysqld Followed by restarting the web service for this particular server. That seemed to fix the problem.


0

If you updated to a 16.04 Ubuntu server, and are using 5.7.12, you are encountering--at least in part--a bug eating up RAM, and some dynamic optimizations/default settings that are based off the server's available RAM and are set less than ideally. This has been problematic for lots of people, but especially for smaller server/vps with low RAM. Search ...


2

You can do what you want based on an Excel Macro. You have to turn on the Developer tab in Excel 2013. Then Record a Macro with "Use Relative Reference" turned on and create a loop that will take company, name2, title2 to a new row. Then do it again for name3 and title3. The macro steps are: go to A2 assuming you have a row header start recording the ...


2

In addition to imtheman's answer which is good, you can also do a create view command which only allows them to interact with the columns you wish them to see. All other column are not even present. See this microsoft msdn article: https://msdn.microsoft.com/en-us/library/ms187956.aspx


3

Yes you can, like this: GRANT [Permission] ON [SchemaName].[TableName] to [UserName] Where [Permission] is SELECT, UPDATE, DELETE, or INSERT. You can also use DENY instead of GRANT to take permissions away. Further reading: https://msdn.microsoft.com/en-us/library/ms188371.aspx


1

See the setup of the table below. It's from Excel 2013, so it looks different, but the idea is the same.


2

It’s LevelDB, a key-value store. You can use NodeJS and levelup to access the data: var levelup = require("levelup"); var db = levelup("path/to/directory"); db.createReadStream().on("data", data => console.log(data.key, " => ", data.value)); (levelup requires leveldown to be installed for accessing on-disk databases.)



Top 50 recent answers are included