FAQ Database Discussion Community


Why doesn't the follow SQL table creation work?

mysql,django,phpmyadmin
CREATE TABLE `auth_user` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `password` VARCHAR( 128 ) COLLATE utf8_bin NOT NULL , `last_login` DATETIME( 6 ) DEFAULT NULL , `is_superuser` TINYINT( 1 ) NOT NULL , `username` VARCHAR( 30 ) COLLATE utf8_bin NOT NULL , `first_name` VARCHAR( 30 ) COLLATE utf8_bin...

Shifting id values of existing rows in mysql

mysql,phpmyadmin,auto-increment,alter-table,value
I have a table in a mysql database, in which every row has an id column with auto increment. The id values start at 1, and end at 639. What I need to do is change the id column of each row, so that the count doesn't begin at 1...

SQL INSERT INTO Error #1064 on phpMyAdmin

mysql,sql,phpmyadmin
My code keeps giving me the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO tags (id, name) VALUES (1, 'Web Design')' at line 2 I'm running the...

Delete after select not working

mysql,database,wordpress,select,phpmyadmin
In this website I am developing a genuine product code verification system, so when user inserts a code in form this will show them whether their product is genuine or not, but users can verify their product only once after that their code will be deleted from database. I have...

I cant able to execute my mysql query while testing inlocalhost phpmyadmin?

mysql,phpmyadmin
SELECT s1.roomtype, s2.roomno, s1.checkin,s1.checkout FROM guestrocordtransac s1 JOIN guestrocord s2 ON s1.roomtype = s2.roomtype AND s1.roomno != s2.roomno WHERE s1.checkin="2015-06-06 00:00:00" BETWEEN s2.checkin="2015-06-06 00:00:00" AND s2.check0ut="2015-06-13 00:00:00" This is how tried to execute the query and below is the error i am getting #1064 - You have an error in...

MySQL database shows in phpMyAdmin but not the command line client

mysql,phpmyadmin
I have installed MAMP and set it up with wordpress. Everything is OK except that I have four databases under mysql through terminal. They are - information_schema,mysql,performance_schema, test But when I enter phpmyadmin, it shows - information_schema,mysql,performance_schema, wordpress. Under the actual wordpress db there are many tables, but under test...

populating table keep getting error #1452

mysql,phpmyadmin
im getting the following error when trying to populate my products table 1452 - Cannot add or update a child row: a foreign key constraint fails (computer_wholesale.products, CONSTRAINT products_ibfk_1 FOREIGN KEY (supp_id) REFERENCES suppliers (supp_id)) this is the statement im using to populate the table INSERT INTO products (prod_id,prod_name,price,on_hand,supp_id) Values...

SQL Delete Duplicate rows find same text in a field

php,mysql,sql,phpmyadmin
I am using phpmyadmin - joomla cms. i have many articles with a same title. Now I want to delete all those articles having the same title. Please tell me the query how to delete same articles having same title. I used the command which shows me the count of...

LEMP installation with phpmyadmin

php,mysql,nginx,phpmyadmin
I tried many tutorials online, and need help to sort this out. nginx is installed, but http://localhost/ returns a bin file to be saved Here is the site-available/default file. ## # You should look at the following URL's in order to grasp a solid understanding # of Nginx configuration files...

Use SQL subquery as tablename

mysql,sql,phpmyadmin
I want to get all specific scores from users whose tablenames are stored in a list of users, something like this: SELECT Score from (SELECT tablenameOfUser FROM `Users`) WHERE X='something' AND Y='somethingElse' ORDER BY Score I get the error: 1248 - Every derived table must have its own alias ...

How to set it so that 1 of 2 columns is NULL in MySQL

mysql,sql,phpmyadmin
I am going to open by saying that what's happening appears to not be a good practice but it is what myself and some other engineers have arrived at. I have a table which has a column containing foreign keys that map to products. I want to add a second...

PhpMyAdmin - err 1064 - set variable in function

phpmyadmin,mysql-error-1064
I'm getting hard time with PhpMyAdmin. My table is : material(id_item, id_collection,...) primarey_key(id_item, id_collection). I want to make a function to prevent loop in Acyclic Graph Database. So i want to force id_collection > id_item for new id_collection. My function is (i have set // in SQL tab): // CREATE...

Online Excel Web-based Platform

php,mysql,excel,phpmyadmin
I just want to install Excel on my webserver (online excel platform) so that I can connect my database (phpmyadmin) with it. And make some excel files and also export as .pdf ( I just need to make invoices and save it and export it ) ( right now i...

MySQL before update trigger an insert syntax error using PhpMyAdmin

mysql,triggers,phpmyadmin
CREATE TRIGGER question_preserver BEFORE UPDATE ON bank FOR EACH ROW BEGIN IF TRIM(NEW.question) != TRIM(OLD.question) THEN INSERT INTO bank_question_history (id,old_question) VALUES (OLD.id,OLD.question)$$ END IF$$ END$$ I am inserting that query into Mysql using PHPMyAdmin's SQL window, using a delim of $$. I get an error You have an error...

If I export my database with phpmyadmin will it lock my tables or take my database down?

mysql,database,phpmyadmin
I want to create a backup of my database using the phpmyadmin export function. the database can't have any down time so I need to know if running a database export will take the database down? I've looked on-line but all I get is instructions on how to export. No...

Catchable fatal error: Object of class mysqli could not be converted to string

php,mysql,sql,phpmyadmin
I was trying to create a Registration form for my project but unfortunately i got this error while i could not find any error in the code!Please help me to get ride from this Issue ! my code <?php // this file is connected with regform.php $firstname= $_POST['firstname']; $lastname =$_POST['lastname'];...

What is the best way of creating tables in MySQL? [closed]

mysql,phpmyadmin
We are developing a site in which 3 persons are working. One of my friend used a separate file named "dbsetup.php" to set up all the tables in MySQL, which works when included in the script, whereas i have created all the tables using Command-Line and phpMyAdmin. Which one is...

Add first and last button on pagination bar

php,phpmyadmin,pagination
I have a code that helps in pagination. index.php: <?php $per_page = 10; // number of results to show per page $result = mysqli_query($con,"SELECT * FROM vendor "); <? $total_results = mysqli_num_rows($result); $row = mysqli_fetch_assoc($result); $total_pages = ceil($total_results / $per_page);//total pages we going to have //-------------if page is setcheck------------------// if...

MySQL command run on terminal is stuck, but phpmyadmin success

mysql,phpmyadmin
I want to get location from members IP. I can use the command on phpmyadmin, and it costs about 2 seconds. But it will be stuck when the command is executed on MySQL through terminal. How can I fix the problem. SQL Command: SELECT ID,country FROM (SELECT ID,substring_index(members.server_ids,',',1) AS IP...

Import csv file with less columns than the table to which I'm importing?

mysql,sql,csv,phpmyadmin,load-data-infile
I have exported a csv file with four columns in phpMyAdmin whith these options: Columns separated with: , Columns enclosed with: " Columns escaped with: " Lines terminated with: AUTO Now I want to import this file into a table with 17 columns!? So only four columns will be populated...

PHPMyAdmin How to do datatype set of relationships

php,mysql,phpmyadmin
today I decided to little automate my work in PHPMyAdmin, so i create many relationships, but there is one problem. For example i have two tables: foodRaws and allergens. In foodRaws table I have columns like name, tags, etc.. and allergens. So I created relationship between foodRaws.allergens and allergens.ID. Now,...

MYSQL order NULL between two particular records and data

mysql,sql,mysqli,phpmyadmin
Is there a way to set the default order used by MYSQL to be NULL in a specific record. my columns: id : id state : 'downloading','error','finish','fail' try : number of try for download file. order in result: downloading error : if try between 0 to 20 NULL error :...

phpMyAdmin CSV Upload Replace Data Not Working

sql,database,csv,data,phpmyadmin
I Have created a database and table in phpMyAdmin. I am importing the data from a csv file. This works fine and adds the data correctly. However each time I upload I want to replace the existing data. I have ticked the box "Replace table data with file", it uploads...

My phpAdmin says 'no tables in database' [closed]

database,phpmyadmin
I've built a site locally on Mac using MAMP. All looks fine. BUT, My phpAdmin says 'no tables in database'. It's empty. What have I done wrong? And how is it that I can see and work on the website locally if the database says it's empty? Is there anything...

Creating SQL Indexes?

mysql,sql,indexing,phpmyadmin
I have two tables in my database that look roughly like this: Communication: (Calls made) Timestamp FromIDNumber ToIDNumber GeneralLocation 2012-03-02 09:02:30 878 674 Grasslands 2012-03-02 11:30:01 456 213 Tundra 2012-03-02 07:02:12 789 654 Mountains Movement: Timestamp IDNumber Type X Y 2012-03-02 11:02:30 379 pedestrian 32 46 2012-03-01 12:32:41 654 pedestrian...

phpMyAdmin returns blank page

phpmyadmin
I am installing phpmyadmin 4.2.11 with php 5.3.3. I have extracted to web server doc root. When I browse it I get blank page. I have followed steps in this page (http://docs.phpmyadmin.net/en/latest/setup.html#quick-install) and I have tried solution 1.1 from this page (https://phpmyadmin.readthedocs.org/en/latest/faq.html) but did not success. What would be the...

How to Query Cookie Variables

php,mysql,phpmyadmin,dreamweaver
I'm trying to create a mysql/php chat (private message) for my site using the "WHERE" clause in PHP. SELECT * FROM (tablename) WHERE (columnname) = $_SESSION('MM_USERNAME') However, I seem to only be able to search for plain text or my table "users.username" which brings up all results in table (not...

creating new database manually for a software every time while distributing it to a new user?

java,mysql,database,phpmyadmin
I've made a desktop based shop-management software using java that will save every product detail and sell history of a particular shop in a database over internet (phpmyadmin). I've a made a connector class and give the path of the database name which connects to the database. The problem is,...

Choose results by date filter PHP and MySQL

php,mysql,datetime,phpmyadmin
I have one page (members.php) that post date to another page (results.php). Using the below code, i can successfully get the "to" and "from" variables from the members page. <?php echo $_POST["to"]; ?> <?php echo $_POST["from"]; ?> My problem now is, how can i create a query (in results.php) in...

PhpMyAdmin: How to find the foreign key that is missing in the parent table?

mysql,phpmyadmin,foreign-key-relationship
In a mySQL database I have two populated tables. Their structures are as in the image. When trying to relate them on idArticol (in PhpMyAdmin), an error appears: "Relation could not be added". I have more than 6000 records in each table. Apparently, the error comes from a missing foreign...

MySQL: #1293 - Incorrect table definition

php,mysql,phpmyadmin
Designed Database and Table in Local Server Using MySQL 5.6.17 and Export into *.sql file. When try to Import *.sql file into Live Server(MySQL 5.1.36) got below Error: #1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause Understood the...

Merging two tables into new table by ID and date

sql,sql-server,phpmyadmin
Let' say I have two tables: table 1: col a | col b | col c 1 | 62215 | 21 1 | 62015 | 22 2 | 62215 | 23 2 | 51315 | 24 and table 2: col a | col b| col f 1 | 62015| z...

error creating table in sql [closed]

mysql,sql,table,phpmyadmin
i keep getting errors when running this query in phpmyadmin bto create a customers table for my database this is the query i am trying to use... CREATE TABLE customers ( cust_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Name character(30), phone character(15), ); any help would greatly appreciated :) thank...

order by: if two or more result match with limit 1 then randomize

mysql,phpmyadmin
SELECT * FROM my_database ORDER BY priority DESC LIMIT 1 my_database: name | priority ################## dave | 100 pat | 100 jo | 99 1: What's the deciding factor when there's two possible results and the limit is set to 1? 2: Can you add randomization between the two possible...

Displaying certain records from MySQL statement

mysql,phpmyadmin,records
I want to display only certain records from my products table Structure of products table: Structure of suppliers table: I want to display all product IDs, product descriptions, product prices, and the supplier company name and contact phone number for all products and list them in descending order of price....

PHP math does not work in sql value ZERO

php,mysql,math,phpmyadmin
I am trying to math between value of 0 but in php code it's work properly but when that value come from database then it does not work. Here is a demo to test only PHP code: <?php $a = 0; echo $a+1; ?> The result of this code 1...

SELECT MAX of COUNT

mysql,phpmyadmin
i made query to display the count of total number of positive and negative but i need to get or display only the maximum count of either positive or negative.please see the image and give me an answer to this ....this is my query SELECT count(`sentiment`) as count,`sentiment` FROM `sno_social_listener`...

Performing a transaction across multiple statements in phpMyAdmin

mysql,phpmyadmin,innodb
I'm not sure if this is an issue with phpMyAdmin, or that I'm not fully understanding how transactions work, but I want to be able to step through a series of queries within a transaction, and either ROLLBACK or COMMIT based on the returned results. I'm using the InnoDB storage...

I want to fetch data from first table then again i need to fetch second data from another two table using first table where value [closed]

php,mysql,database,mysqli,phpmyadmin
I have 3 tables, 1). mobile, 2). store1, 3). store2 Fetching from table "mobile" then we received 4 rows of record from table. then i am fetching this row to store1 and store2 for other details. Please suggest me what i need to do. <?php $mysqli = new mysqli("host" ,...

Rename and add prefix to all tables with phpMyAdmin

mysql,sql,phpmyadmin
I want to add a prefix and rename all tables in a database with PhpMyAdmin. I’ve tried these 2 scripts : 1) select concat('rename table', table_name, ' to ', 'prefix_',table_name,';') from information_schema.tables where table_schema='db_name'; 2) SELECT Concat('ALTER TABLE ', TABLE_NAME, ' RENAME TO osc_', TABLE_NAME, ';') FROM INFORMATION_SCHEMA.TABLES where table_schema='db_name';...

Storing array in MySQL

php,mysql,phpmyadmin
I am trying to figure out how to best store an array into a MySQL field that can be manipulated from PHPMyAdmin. We are inputting employees into a table in a MySQL database, using PHPMyAdmin, and one of their columns is state licensing. We will be evaluating the states they...

Can't Import Wordpress Database via PHPmyAdmin - Can't Perform Migration Via Plugin

mysql,database,wordpress,phpmyadmin
I normally migrate databases for wordpress installs using wp_sync_db plugin. It has never failed before. Now when I'm trying to migrate from my local development server to the live site it's giving the following error. I've tried only migrating specific fields, but it always runs into an error, just the...

Php code does not come out from MySQL Database properly

php,mysql,while-loop,phpmyadmin,echo
I was try to loop PHP CODE data from MYSQL database, but it looks different when it's echo'd out. HERE IS MY PHP CODE: <?php mysql_connect("localhost","root",""); mysql_select_db("myweb"); ?> <table width="100%" border="1"> <?php $query=mysql_query("SELECT * FROM right_widgets ORDER BY right_widgets_id ASC"); while($rows2=mysql_fetch_assoc($query)) { $right_widgets_id=$rows2['right_widgets_id']; $func_name=$rows2['func_name']; $active_status=$rows2['active_status']; ?> <tr> <td><?php echo $func_name;...

PhpMyAdmin Blank Page on fodora 22 localhost server [closed]

php,mysql,phpmyadmin,fedora,lamp
I follow this guide to install LAMP server on fedora 22 workstation How To Install LAMP Stack (Apache, MariaDB And PHP) In Fedora 22 Everything working well except phpmyadmin. When i need access it of the browser i see nothing (blank page) How i can fix this issue ? Any...

how to know the date of insertion of record in SQL

mysql,sql,date,insert,phpmyadmin
I am using phpMyAdmin for my project and I have a table without date/datetime field. I am wondering if there's a way to know when I inserted each record on the database...

phpMyAdmin: Date Fields Display as BLOB

php,phpmyadmin
I am running phpMyAdmin version 4.4.4. When browsing a table, all of the DATETIME and DATE fields display as [BLOB 19]. I clicked on +Options above the table list, selected "Show BLOB contents" and clicked GO, but, all date fields still display as [BLOB 19]. I've tried this on three...

How to exclude entries with specific value/strings in phpmyadmin SQL?

sql,phpmyadmin
My DB is collecting relative urls as data. The column is called 'path'. How would I filter out all URLS that have a specific word in phpmyadmin SQL section? Example: I would like to see all URLs without the word 'coffee' and my path column is full of urls with...

Magento Database transfer oddity

database,magento,ubuntu,phpmyadmin
My situation is that I have a 1.5 GB sqldump file from my website. I took this and dumped it into virtual box ubuntu environment on a fresh copy of Magento and restored my file system. Pretty standard. But when I go to access my local copy in the browser...

mysql error #1064

mysql,sql,phpmyadmin
i keep getting this error code #1064 when trying to create my products table this is the code im tryng to use CREATE TABLE products ( prod_id int NOT NULL, prod_name character(20) NOT NULL, Price decimal(19, 4), on_hand int, supp_id int, PRIMARY KEY (prod_id), FOREIGN KEY (supp_id) ); if anyone...

MySQL query runs ok in phpadmin but hangs in php

php,mysql,phpmyadmin,cpu-usage,hang
I have a fairly simple query which runs okay when I test it in phpMyAdmin: SELECT c.customers_id, c.customers_cid, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_email_address, c.customers_telephone, c.customers_date_added, ab.entry_company, ab.entry_street_address, ab.entry_postcode, ab.entry_city, COUNT(o.customers_id) AS orders_number, SUM(ot.value) AS totalvalue, mb.bonus_points FROM orders AS o, orders_total AS ot, customers AS c, address_book AS ab, module_bonus AS...

Update field in table based on sum of others

mysql,mysqli,phpmyadmin
I have 2 tables : Users : {id, name, studentid, overall_score} userbadges : {id,badge_id,user_id,level,score} A user can have multiple badges. I want to have the overall_score update itself to be the sum of all scores in userbadges where the user_id matcher the id in the user table. Can this be...

How fatal is the maximum execution timeout warning in MySQL

mysql,sql,database,phpmyadmin
Been working with the XAMP which I installed just under a year. I recently installed few frontend software for MySQL (to see which one am I comfortable with the most). Now, for the past two days, whenever I go to localhost/phpmysql, I receive this warning Fatal error: Maximum execution time...

Handling users of phpMyAdmin

mysql,security,phpmyadmin,user,privileges
Hi stackoverflow community, I have some doubts in how to manage the users in phpMyAdmin, I am starting a project but I see multiple users with ALL PRIVILEGES. I should choose one user, set my password, and then delete the other ones? Having multiple users with ALL PRIVILEGES and without...

Find the closest timestamp SQL?

mysql,sql,phpmyadmin,timestamp
I have two tables that look like this: Communication: (Calls made) Timestamp FromIDNumber ToIDNumber GeneralLocation 2012-03-02 09:02:30 878 674 Grasslands 2012-03-02 11:30:01 456 213 Tundra 2012-03-02 07:02:12 789 654 Mountains Movement: Timestamp IDNumber Type X Y 2012-03-02 11:02:30 379 pedestrian 32 46 2012-03-01 12:32:41 654 pedestrian 54 56 2012-03-02 07:02:16...

PHPMyAdmin issue: Is it advisable to assign a very large value to `$cfg['MaxExactCount']`?

mysql,phpmyadmin
I have a MySQL table with exactly 1 million rows of dummy data for testing purposes. However when I click the table's "browse" option, this is what I get: Notice how it says there are only 994,622 records whereas I know there are more. Funny thing is I can still...

MySQL and phpMyAdmin - copy data from one database to another?

mysql,wordpress,phpmyadmin
Here is the MySQL code I have tried: "INSERT INTO wpcustom_productmeta.wpc_productmeta(brand,model,country,carrier) VALUES (SELECT meta_value FROM wordpress.wp_postmeta WHERE meta_key='brand'), (SELECT meta_value FROM wordpress.wp_postmeta WHERE meta_key='model'), (SELECT meta_value FROM wordpress.wp_postmeta WHERE meta_key='country'), (SELECT meta_value FROM wordpress.wp_postmeta WHERE meta_key='carrier')"; I would like to insert data into wpcustom_productmeta.wpc_productmeta from the separate database and table...

Storing data MySQL in Kurdish font?

java,mysql,unicode,phpmyadmin
Hi so I've made an application in java that lets the user to store data in a MySQL database. Whenever I enter this به‌رواری ده‌رچوون I just get ??????. Is there any way I can fix that? It's really important that this job is done before tomorrow... I've never faced...

SQL Date datatype query

mysql,date,phpmyadmin
when I run INSERT INTO `table 4`(`COL 5`, `COL 6`) VALUES ([STR_TO_DATE(`7/11/2014`, `%m/%d/%Y`)],[STR_TO_DATE(`7/18/2014`,`%m/%d/%Y`)]) I get #1064 - Erreur de syntaxe près de '[STR_TO_DATE(`7/11/2014`,`%m/%d/%Y`)], [STR_TO_DATE(`7/18/2014`,`%m/%d/%Y`)])' à la ligne 1 Is there any other way to format string to date? Or should I go ahead this way with some modifications. I already...

Change field default in phpmyadmin

mysql,sql,phpmyadmin
Hi so i created a date type field in phpmyadmin and forgot to set its default to NULL, so i returned and edited the default to null my question is how to change the data in the fields affected from the creation of the field? In other words all data...

PHP doesn't fetch all rows from my database query

php,mysql,phpmyadmin
I have this code below: if(isset($_POST['period'])){ $query_str = "SELECT `id` FROM `orders` WHERE `status` = 'Send' AND `date` BETWEEN '".date('Y-m-d H:i:s', time()-$_POST['period'])."' AND '".date('Y-m-d H:i:s', time())."' "; echo $query_str; $query = mysql_query($query_str) or die(mysql_error()); $arr = mysql_fetch_assoc($query); var_dump($arr); } As result I have these two strings: // this value of...

MySQL auto_increment not reseting (stuck on increment by 10)

php,mysql,phpmyadmin
So running MySQL Version 5.5.42-cll My tables wherever auto_increment are refusing to reset, they're all incremented by 10 and not by 1. Tried changing it in phpmyadmin and no luck. Tried following statement but it didn't work: ALTER TABLE tablename AUTO_INCREMENT = 1; Has anyone had this issue before? I...

Getting max count from mysql database

mysql,sql,phpmyadmin
I have table as follows +------+------+------+----------+ | vno | ino | cno | quantity | +------+------+------+----------+ | V1 | I1 | C1 | 150 | | V1 | I5 | C1 | 100 | | V1 | I5 | C4 | 150 | | V2 | I2 | C1 |...

Phpmyadmin cant create table

mysql,phpmyadmin
I am trying to create a new database for a quiz project. Now I ran into a strange error and never seen anything like it before. I'm trying to add a table named : questions. After that I'm only trying to give it 4 columns. "id => int, name =>...

How check if the sum of the values of two columns, in the same row have exactly 100 as result in mysql

mysql,sql,phpmyadmin,xampp,checksum
I have this problem in mysql (phpmyadmin).. I should want to check if the values of 2 columns do 100… for example I have this table | BLABLABLA | BLABLABLA | VALUE1 | VALUE2 | and user want add this values(bla, bla, 20, 30).. I would that 20 and 30...

MySQL database relationship without an ID

mysql,sql,database,phpmyadmin,relation
Hi StackOverflow community, I have these two tables: tbl_users ID_user (PRIMARY KEY) Username (UNIQUE) Password ... tbl_posts ID_post (PRIMARY KEY) Owner (UNIQUE) Description ... Why always everybody make database relationships with foreign keys? What about if I want to relate Username with Owner instead of doing ID_user with ID_user in...

importing csv into phpmyadmin

mysql,csv,import,phpmyadmin
I am trying to import a dataset that looks like.... ~01001~^~0100~^~Butter, salted~^~BUTTER,WITH SALT~^~~^~~^~Y~^~~^0^~~^6.38^4.27^8.79^3.87 ~01002~^~0100~^~Butter, whipped, with salt~^~BUTTER,WHIPPED,WITH SALT~^~~^~~^~Y~^~~^0^~~^6.38^4.27^8.79^3.87 ~01003~^~0100~^~Butter oil, anhydrous~^~BUTTER OIL,ANHYDROUS~^~~^~~^~Y~^~~^0^~~^6.38^4.27^8.79^3.87 ~01004~^~0100~^~Cheese, blue~^~CHEESE,BLUE~^~~^~~^~Y~^~~^0^~~^6.38^4.27^8.79^3.87 I went to import, uploaded the file.... selected CSV chose the delimeters as: Columns separated with: ~^~...

Select from multiple tables in mysql [on hold]

sql,phpmyadmin
Is it possible directly in phpmyadmin in sql form to select from 10 tables at once? In my database I have 10 tables: table1, table2, ... table10. I have same column in them column1. Records in that column always starts like 123... and always is 12 symbols length. What I...

I can not access the local web and phpmyadmin

php,mysql,database,phpmyadmin
I have a local Web that can be accessed every day from some other pc. I have done are: - I set the root password for mysql - Then I have to adjust it to the database password (database.php) ---> that can still access my local web. And it works....

Importing sql file into Mysql running xampp using commandline in Mac

mysql,osx,phpmyadmin
I have installed xampp in my macosx and i want to import the wordnet sql file its not working. i tried this command /Applications/XAMPP/xamppfiles/bin/mysql -u root -p dict < wordnet20-from-prolog-all-3.mysql The commandline works without any errors takes a while to finish. I fireup phpmyadmin and check the dict database and...

Cannot log in to the MySQL server error when logging into phpmyadmin with Google Cloud SQL on Google App Engine

google-app-engine,phpmyadmin,google-cloud-sql
EDIT: Changed my question around as this is the real problem: I followed this Google guide to deploy phpmyadmin on Google Cloud SQL with Google App Engine. I followed the tutorial and deployed phpmyadmin successfully to my App Engine however, when I try to log in with user: "root" password:...

PHPMYadmin table Migraton

php,html,mysql,sql,phpmyadmin
I need some help with a migration in phpmyadmin I have 2 Tables with different stucture, I want that it automatically copy the NAME ADRESS LONGITUDE AND LATIDUDE from the [ store ] database to the [ tbl_storefinder_stores ] in the right row, but don't know how to do this....

PhpMyAdmin export : reference without uppercase

mysql,phpmyadmin,export
First, I'm sorry for my poor English, I'm french. I use PhpMyAdmin with Xampp in localhost and an other PhpMyAdmin on server My tables are like Personne, Adresse, Titre. When I use the export option with server my sql is perfect : CREATE TABLE IF NOT EXISTS `Personne` ( `idPersonne`...

Need to route to different php files and call separate functions using .htaccess

php,mysql,.htaccess,mod-rewrite,phpmyadmin
Need to route the api calls to two different PHP files and call different functions inside those php files. URL: 1) http://localhost/dual/LOGIN this should call the login.php and inside that the function log_in() should be called 2) http://localhost/dual/REGISTER this should call the register.php and inside that the function register_in() should...

Count the number of times each members name appears in a table with a condition

php,mysql,sql,mysqli,phpmyadmin
Consider the following table: Im looking for a query that will: - Count the number of times each members name appears in the table where tournament= "EPL" AND round ="12" For this EXAMPLE the query should return: Andrew = 3 Wins Joseph = 2 wins John = 1 win Martin...

Print MySQL table in php (simple) [closed]

php,mysql,table,phpmyadmin
I am having problems printing my MySQL database table into my PHP code. I want the MySQL table to be printed in my website as an actual table, not just the database values. Everything I do doesn't seem to work and I have looked at similar questions to this but...

SQL Error while working on web with PhP

php,mysql,sql,phpmyadmin
While giving the correct login ID and Password which is there in the databse "tutorial" in table "users", it is giving me an error on the login.php which is being redirected. Error is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server...

MySQL MyPHPAdmin import from text without having the primary key?

mysql,import,phpmyadmin
How can I import data from a text file into a database without giving a primary key in the text file? So I have a table where I have 3 columns: ID, firstName, lastName. ID is auto incremented. I would like to read in the names from the text file...

How to create a timeline in phpmyadmin using nanoseconds?

java,mysql,jdbc,phpmyadmin
I am currently trying to create a timeline in phpmyadmin from a mysql database, using java and jdbc. In the database I store IPs that I get from a pcap file, and I get the time I want from the packet (using packet.getCaptureHeader().nanos()). Every time an IP occurs I increment...

Amazon web services phpmyadmin: The mbstring extension is missing

php,mysql,amazon-web-services,amazon-ec2,phpmyadmin
I have installed phpMyAdmin on the hand of this tutorial: https://gist.github.com/suvozit/8998731 and connected my RDS instance as host in the /var/www/html/phpmyadmin/config.inc.php file. Now I got the following error when I visit example.com/phpmyadmin/index.php: The mbstring extension is missing. Please check your PHP configuration. So I searched the internet for this error...

Make Mysql database that exists manageable with phpmyadmin

mysql,phpmyadmin,cpanel
I have a Mysql database on my server. I can get into it via the command line, so it does exist. However, when I go into cpanel and open up phpmyadmin, it is not there. What do you have to do to make an existing database manageable with phpmyadmin?...

My password root caused disappearance in Mysql database

mysql,phpmyadmin,passwords,root
I set a password for the user root manually in the phpmyadmin, and suddenly the mysql database disappeared from the list. When I use the control console, the root user can connect without a password, but the command line show database doesn't display the mysql database.

How can I restart my autoincrement in phpmyadmin?

php,mysql,phpmyadmin
I have some tables in my phpmyadmin with one column that is auto incremented. The problem is that when I delete some rows from the table (For example the element Car, with index auto incremented 1) and I create another row into the table, the new row have the index...

Importing a mysql database with command line

mysql,linux,database,command-line,phpmyadmin
Have tried all other answers on stackoverflow, and they haven't worked. I have a database in phpMyAdmin, and I need to update it. The file is too big to upload via phpMyAdmin, and I've tried increasing limits in php.ini to no avail. I think that didn't work because I updated...

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row

php,phpmyadmin,magento-1.7
This error show every..*.**please help me for the exact answer for this qyery... SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (mydawai.cataloginventory_stock_item, CONSTRAINT FK_CATINV_STOCK_ITEM_PRD_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (product_id) REFERENCES catalog_product_entity (entity_id) ON DELETE CA) i'm importing the 20 to 50 thousand csv...

SQL result show empty results in phpmyadmin xampp [closed]

php,sql,phpmyadmin,xampp
i have make a login and register page in php and every thing work fine and it show me that user register successful . my question is that when i navigate to localhost/phpmyadmin and try to get the user and password i just entered it so i use : SELECT*FROM...

Checking whether indexes are being used in SQL query?

mysql,sql,indexing,phpmyadmin
I have two tables in my database that look roughly like this: Movement: Timestamp visitorID Type X Y 2012-03-02 11:02:30 379 pedestrian 32 46 2012-03-01 12:32:41 654 pedestrian 54 56 2012-03-02 07:02:16 789 pedestrian 39 52 Communication: (Calls made) Timestamp senderID toID GeneralLocation 2012-03-02 09:02:30 878 674 Grasslands 2012-03-02 11:30:01...

Conditional statements and multiple queries in mysql

mysql,phpmyadmin,mysql-workbench
In MySQL (both instances of phpmyadmin and MySQL workbench) I would like to check if a value exists in a table before I perform any other additional queries to the same table or other tables and below are the sets of queries I have tried but neither are working and...

SQL - Adding user defined variables to table (mysql)?

mysql,sql,stored-procedures,phpmyadmin,cursor
So I have this code thats part of a stored procedure: SET @MID = 0; SET @MX = 0; SET @MY = 0; SET @MT = 0; SET @CSTAMP = '2014-6-06 08:03:19'; SELECT @MID=m.ID, @MX=m.x , @MY=m.y , @MT=m.timestamp FROM movement m WHERE m.ID = cSID AND m.timestamp = (SELECT...

How to run a specific sql query for every row in the table?

mysql,sql,phpmyadmin
So I have two tables in my Database and they both look something like this: Communication: (Calls made) Timestamp FromIDNumber ToIDNumber GeneralLocation 2012-03-02 09:02:30 878 674 Grasslands 2012-03-02 11:30:01 456 213 Tundra 2012-03-02 07:02:12 789 654 Mountains Movement: Timestamp IDNumber Type X Y 2012-03-02 11:02:30 379 pedestrian 32 46 2012-03-01...

Issues with using SHA1 password encryption in PHP/mysql

php,mysql,encryption,phpmyadmin,sha1
I have a simple script for user login. I have the passwords encrypted as SHA1 in mySQL database table (using charset utf8_unicode_ci). When I run "$q" in the database with values it returns result all right. But through the script even after entering correct credentials, I am not able to...

Laravel fresh install login issues

php,laravel,phpmyadmin,laravel-5
RESOLVED appearantly I was truncating my passwords as I set the column size for password too low Yesterday I started using the PHP framework Laravel and I am very happy with it, except for one small part, this part being the standard login provided by the framework. I created a...

Add a row to JTable and Database (phpMyAdmin)?

java,phpmyadmin
initComponents(); try { ResultSet res = statement.executeQuery("SELECT * FROM banh"); ResultSetMetaData RSMD = res.getMetaData(); NumberOfColumns = RSMD.getColumnCount(); AttributeNames = new String[NumberOfColumns]; for(int i=0;i<NumberOfColumns;i++) AttributeNames[i]=RSMD.getColumnName(i+1); MyArray=new Object[10000][NumberOfColumns]; int R=0; while(res.next()) { for(int C=1; C<=NumberOfColumns;C++) MyArray[R][C-1]=res.getObject(C); R++; } res.close(); NumberOfRows=R; Object[][] TempArray=MyArray; MyArray=new...

MySQL - SQL not searching for UTF 2019 (’) single quote

php,mysql,wordpress,character-encoding,phpmyadmin
I have the following character in one of my row entry in a MySQL database:- http://www.fileformat.info/info/unicode/char/2019/index.htm When I run the following sql query in phpmyadmin it says that no results are found. SQL:- SELECT * FROM `wp_posts` WHERE `post_title` LIKE '%ABC, D’EF%' I've copy pasted the title from phpmyadmin as:-...

How to get the last payment and the check if account is expired today or not?

mysql,sql,phpmyadmin
I want to check the user is expiring today or not on base of the last payment My payment table is like below... id user_id create_at 32 38 2014-06-05 10:30:00 33 38 2015-06-05 01:30:00 My query is as below.... I am checking who has payed 1 year ago and no...

How many rows can mysql store?

mysql,phpmyadmin
So I am a beginner and have just learned MySQL by myself for a few months. I always use phpmyadmin in my work. My past work only involved tables with about 100k rows so there is no major issue. However my client now wants to store about 8 million rows...

how should i import a huge table in phpmyadmin

php,mysql,upload,phpmyadmin
I have a table with 300,000 rows. then when i import it, it will uploaded almost 200,000 rows then phpmyadmin kills the upload with this error: Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\import\sql.php on line 246 Note: 'on line 246' is not unchanged. sometimes is 130...

SQL - Get all rows with same ID [on hold]

mysql,sql,phpmyadmin
I'm trying to get all rows with the same id, this is a example of the table: Curs_ID Cursistnr payed Excel 2 500 Internet 3 100 C# 2 200 what I want to get out of the table is everything where Cursistnr is 2 So what I need is 2...

Is it possible to connect to remote DB while working in localhost?

php,mysql,git,phpmyadmin
I am working on a project with my developers on localhost. We are using git to collaborate but are having issues collaborating the database using git or using a remote db. Is there any possible way where I can use git or set up a remote server while working with...

mysql database does not store complete number of memberId

php,mysql,sql,phpmyadmin
Hi Im facing quite an odd problem Users log in to my website via FB, the member nr is quite a lengthy nr looking something like this 10153852694717081. When user does a transaction im noticing that only part of the member_id gets stored, the first 8 digits of member_id, in...

Cannot log in to the MySQL server [closed]

php,mysql,phpmyadmin
I'm starting to develop in PHP and I'm using this guide to get me started. The issue I'm facing is that I cannot log into MySQL (using phpMyAdmin). After reading some questions I tries to change the localhost to 127.0.0.1 but this didn't solve the issue. This is the contents...