I have an SQL query like this. When iam executing it though my php file it gives time out error. But when running the same query thoruhg php myadmin it gives results within seconds. SELECT cake_apartments.id, cake_apartments.Headline, cake_apartments.Description, cake_apartments.photoset_id, cake_apartments.Renta...
SELECT * FROM `User` LEFT OUTER JOIN `freshersdata` ON `User`.`username`=`freshersdata`.`username` WHERE (`freshersdata`.`username` IS null) AND (`User`.`Persistent`!=1) This SQL query is falling over with ( #1064 - You have an error in your SQL syntax; ) message but works perfecly with a SELECT instead of a delete, why is th...
In phpMyAdmin, like the create table view with a spreadsheet of column settings, can you edit a table's columns with new columns, as a similar spreadsheet? ...
Hello, I have apache+mysql+phpmyadmnin under Gentoo. phpmyadmin-3.2.2 It worked fine before, but now, when I'm loading http://localhost/phpmyadmin I get a list of flies in phpmyadmin-directory, and when I chose index.php, I get it's own code. What I did wrong? ...
ok, say you have two dbs. one you use as a master template which goes through various revisions, let’s say we’re now on revision 3. but the second db is a copy of the template as it was at revision 1. because db 2 is in use, you don’t want to drop any tables, but you do need to update the structure of the entire db to the latest version...
I'm trying to view my firefox cookies db (cookies.sqlite). Since I've never accessed dbs with anything other than phpmyadmin, I'm at a loss as to how to view the content of this sqlite file. There's localhost/sqlitemanager, but I'd rather stick to the phpmyadmin interface that I'm used to. Any ideas how I can open/view this sqlite db th...
I am changing my db so that certain fields can be longer. Right now they're "varchar(255)" can I just increase that to "varchar(500)" or are there special rules for dealing with this and I should make them "text"? ...
I have plesk 8.3.0, with phpmyadmin 2.8.2.4 I tried to look up where the phpmyadmin is located. I couldn't find it in srv/ and i did a find command in the server and not quite sure where it is actually located. What I want to do is to set up a phpmyadmin under /httpdocs so that I dont have to login to plesk and click many times until...
I want to create two Tables. Product, Members, and Category. I want the structure of the tables to be like: Category: Two Fields: (Category_ID) (Category_Name) and I would like Category_ID to be the Primary Key Product: Three Fields (Product_ID) (Product_Name) (Product_Price),(Category_ID) and I would like Product_ID to be the Primary ...
Hi Friends, I am stuck with a problem. I am working on a backoffice project which needs to access the live database of our website which is very big and complicated. Now when i connect my backoffice with live Mysql database and run my queries, some slow queries are also there which in turn locks the database for that time period and the...
I am getting this error: Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\wamp\www\vacation_showcase\admin\participants_edit_list.php on line 17 This is my sql statement: $sql = 'SELECT substring_index(description,' ',100) as preview, name, extra_line, link FROM participants ORDER BY name ASC'; I dont know why...
I've created new db via phpMyAdmin and while editing db privilages clicked delete localhost privilages for this db (dunno why). Unfotunately all root privilages has gone. I can't see or create any db. Only root has admin rights. Is there any way to fix it? ...
I am using PhpMyadmin. I canceled some structure privileges of the user root this afternoon and I want to recover these privileges. I always log in to PhpMyAdmin with the user identity of "root". But I get an error message when I attempt to recover my all privileges. Error SQL query: Edit GRANT ALL PRIVILEGES ON * . * TO 'root'@'loca...
When I use the phpMyAdmin export, it has an option for MS SQL export compatibility. However, the resulting file includes many non-MS SQL compatible items, such as mediumtext and enum datatypes. How do I work around this issue? ...
Hi i want to know that how the auto increment id can be get from the mysql db for two fields in a table ...
In phpMyAdmin v2.8.2.4 for MyISAM tables, the "Relation View" appears under the Structure tab. It shows a list of Internal Relations. But what do these do, given that MyISAM does not support foreign key constraints or relational integrity? By phpMyAdmin version 3.2.0.1 this page ("Relation View") no longer appears for MyISAM tables. So ...
i have php myAdmin installed on my machine how can make it connect to external server database Thanks in advance ...
I want to export data and structure from MySQL database using PHP. I know about SELECT INTO OUTFILE command but I want to have the file like the one which is generated by PhpMyAdmin in Export window, so all the CREATE TABLE and INSERT INTO. HDo you know how PhpMyAdmn generates those files? I was browsing through the code and I've found ...
My WAMP phpMyAdmin instance is now throwing a SHOW PLUGINS error on startup. It has never done this in the past, but now does this and will not start. Any ideas how to resolve this issue? I contacted support but haven't gotten a response back yet. ...
Is there a good PHP client for SQLite 3 databases? I'm looking for something like phpMyAdmin of SQLBuddy that allows me to manage SQLite 3 databases, preferably one that uses the PDO (pdo_sqlite) driver. ...