phpmyadmin

MYSQL Inner Join with 2 ON Clauses

I am trying to setup a simple database in which I have a user and store both their residential and postal address. I have 2 tables Users id (Primary Key) name (Varchar 255) residential_id (foreign key) postal_id (foreign key) Address id (primary key) type (enum of R and P) street (varchar 255) suburb (varchar 255) I am tring ...

Same MySQL query takes 0.3 sec in MyPHPAdmin, 7.9 sec in PHP -- Why?

I am running the following MySQL query: select * from combinations where family_type='f597'; on a table that has about 90,000 lines. If I run the query via MyPHPAdmin, it takes 0.3 seconds to run, but in my php page on the same host it consistently takes about 8 seconds. To test the amount of time it takes in my page, I run it like ...

How do i connect my .php to phpmyadim?

I need help on creating a basic log-in page and registration page. I only know the basic stuff on php. And my boss told me to use the database he created online (phpmyadmin). So how do I connect the .php file I created to the online database? I have experienced connecting it to a database. But not the one that's online. Any help please? ...

How to export a single table from phpmyadmin to a comma delimited text file?

Hi, I need to export a table from phpmyadmin to a comma delimited text file. I think there is a code but can't seem to find it. I found one but it doesnt work. I need to export this table because I need to organize it and sort it and add another column so I can add data to this column. How can I do this please? Many thanks ...

Looking to downgrade phpMyAdmin, but don't know what version.

Had to re-set up everything on my laptop recently, which included reinstalling XAMPP. While I was quite happy with the version of phpMyAdmin I had installed the first time around, the new bundled version has a few quirks that get to me. Specifically: Auto-incremented fields ignore values I enter when inserting new rows (e.g. if I wan...

Run php scripts from within phpMyAdmin

Hello, Is it possible to run external php scripts(located inside the root folder of my web server) from within phpMyAdmin? The reason being I have some chart scripts which I would like to execute from within phpMyAdmin. Thanks. Tim ...

Japanese text is unrecognizable in phpMyAdmin?

I am phpMyAdmin, why is Japanese text in tables unrecognizable? However, I can output the Japanese text from the tables and it can be displayed correctly. Any idea? How to fix phpMyAdmin? ...

hyperlinks in phpmyadmin

Hello guys, I have an excel spreadsheet, with one of the columns in form of hyperlinks which when clicked opens a particular web page which is not stored on my computer. How do I import these hyperlinks into phpMyAdmin and make them clickable? The import function creates text which is not clickable. Thanks! ...

How can I get back my privilege to create a new database in MySQL?

I log in PhpMyadmin with the root user,there is a red message No Privileges under create new database, How can I get back my privilege to create a new database? ...

#1130 - Host ‘localhost’ is not allowed to connect to this MySQL server

I issued a command of: DROP USER 'root'@'localhost'; GRANT ALL PRIVILEGES ON . TO 'root'@'%'; ...in PhpMyAdmin. Immediately after the execution, I was forced out PhpMyAdmin. I got: error #1130 - Host 'localhost' is not allowed to connect to this MySQL server, how to resolve my problem? ...

Create stored procedure in mysqladmin?

I am trying to create stored procedure in mysql admin. I am hosting a website in POWWEB.com. For this purpose i am trying to create stored procedure in mysqladmin. The Mysql version is 5.0.45. I am able to create a stored procedure with only 1 line of code. CREATE PROCEDURE TEST(input INT) INSERT INTO TEST(COL1) VALUES(input...

Automatically add user and date to records

Hello guys, I have a database which can be accessed by multiple users. Is there any way I can set the tables such that whenever somebody enters a new record or modifies a record, his/her username and the date entered is stored into 2 columns in the same table as the record itself. The table would look like this: Id | Name | Username...

Error Loading Mysql using PHPmyadmin

Trying to load the following into a database: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL'; use es; -- ----------------------------------------------------- -- Table `events` -- ----------------------...

Using SELECT in this SQL statement isn't working...

My table is organised like this: With key as the primary field. The records shown are in the renamed table. I need to get out the original_name by the key. The key coluimn is the primary key of the table. This is my SQL code: SELECT original_name FROM `renamed` WHERE key='fb166' However, it does not return any results. I have tri...

Tools for managing complex relationships in mysql databases, more specifically for manual data insertion

Hello, Sometime you have many relationships in a table, and you need to insert data. It becomes a painful task when you constantly have to go check the ids of your parent rows for each foreign keys. Is there a tool that make this task easier, by allowing me to do a kind of ajax search for ids while I am inserting data? For exemple, ...

PHP based MySQL database managers

I'm looking to some lightweight open source php based MySQL database managing script. I would essentially prefer something that is packed into a single file, and has a decent UI and features. PS: I already know about PHPMiniAdmin, I'm looking for alternatives. ...

PHP myAdmin - Change Field Order (Move Up Or Down)

How do I change the order of my table fields without deleting the field and re-inserting it, using PHP myAdmin? ...

localhost Date Format Function can not run

hi Friends... I am not able to run date format function in local host.PHP i am using to develop hotel application. In that hotel contain Check in date and Check out date, formally i used Zapa calender. But i am not able to run local host. Please suggest how can i solve this problem. thanks Periyasamy ...

Unicode Spreadsheet to MySQL

I am trying to get a document from Excel or OpenOffice that contains UTF 16 characters into MySQL, but I can't find the best way to export the document so that phpmyadmin will read it. I can export out of NeoOffice as "unicode" format, but the closest option in MySQL is ucs2. When I try that format, it just spins and thinks. UTF8 doesn't...

how can i lock tables in MySQL or phpmyadmin?

I need to use a table for a queuing system. The table will be constantly be updated. For example, multiple users on my website, will add their files for process, and I heard that when updates occur simultaneously from multiple users, the table becomes non responsive or something like that. so do I need locking tables in this situation...