mysql

Once again, after several years, I'm trying to get into PHP/MySQL website building. Turns out I'm still not very good at it. I have a specific problem that I'm hoping someone can point me in the right direction for. I have a page that contains half a dozen text and textarea inputs for updating...

So I'm inserting the following string: INSERT INTO scGUsers (userName, userPass, userEmail) VALUES ("KoihimeNakamura", "deleteme", "test@example.com"); into CREATE TABLE IF NOT EXISTS `scGusers` ( `userID` int(11) unsigned NOT NULL AUTO_INCREMENT, `userName` varchar(255) COLLATE utf8_bin...

So, I want to use the Entity Framework. The problem is that Microsoft doesn't allow integration on VS 2012 Express with that and MySQL and I super don't have 471.99 + tax. Is there anyway to do that? Or do I need to give up using it?

Ok, first of my chest: I have recently started my course on ASP.Net and SQL with C# (not the ones I had asked about, but this one is multumuch better :D). 15 weeks in total web programming nirvana (ok 4 or 5 of those are reps and final projects, but still). What I want to know: WHY WEREN'T I...

I am still struggling with the Drupal site I inherited. I'm talking to a couple of developers about taking it over, but they've asked two questions that stumped me. I wanted to check the funny feeling in the pit of my stomach with you all. 1. They want admin access to look at the database...

I have tried to import a .sql file into a musql database using phpmyadmin I get all sort of timeouts. So I uploaded via ftp the .sql file on the server. Now my question is : how do I import the .sql file into the database now that it is on the server. The only file I can import with phpmyadmin...

I log as root into mysql server, but I can't see anymore my "user" database. Is there a way to recreate it ? Thanks. nimzo

Hello. Not sure if this is a math or computer question. I am scanning a table and I want to write a formula that will return a value of -1, 0 or 1 for each row depending on the value in the row. Using a combination of the following mathematical mysql functions, I would like to return a value...

Gah! It seems like every time we get our website up, something new happens and it's down again. Here's the short version--I'm interested in opinions of you with more SQL experience-- 1. running website using wordpress. Works great, but a bit unsightly, since we cobbled it together from a plone...