Menu
  • HOME
  • TAGS

SQL Delete Duplicate rows find same text in a field

php,mysql,sql,phpmyadmin

Please try this, For keep lowest id value, DELETE item1 FROM q3ept_k2_items item1, q3ept_k2_items item2 WHERE item1.id > item2.id AND item1.title = item2.title For keep highest id value, DELETE item1 FROM q3ept_k2_items item1, q3ept_k2_items item2 WHERE item1.id < item2.id AND item1.title = item2.title If you want to improve a little...

PhpMyAdmin Blank Page on fodora 22 localhost server [closed]

php,mysql,phpmyadmin,fedora,lamp

Possibly you can get more info via 2 things 1- Enabling php display_errors in php.ini file which you can find by running php --ini changing display_errors to on and save it then restart apache web server and revisit phpmyadmin url which should show you the error 2- looking in apache...

mysql error #1064

mysql,sql,phpmyadmin

You need to add which table the foreign key references. Below would be if the table containing supp_Id was called suppTable and had referencing key supp_id. Edit: updated to reflect your referencing table being suppliers with supp_id referencing column. Note that supp_id on suppliers must be an int for this...

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

mysql,phpmyadmin

I would say using a separate script is always good. Security may not be a issue in either approach but if you have a separate script file then deployment become easy since the same file you can run in multiple different environment and deploy the database. It's also more maintainable...

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

mysql,phpmyadmin

1: What's the deciding factor when there's two possible results and the limit is set to 1? Unless we specify ordering by a primary key (or a combination of fields to make it completely clear to the DB how to order), we cannot predict which of the two possible...

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" AND s2.checkin BETWEEN "2015-06-06 00:00:00" AND "2015-06-13 00:00:00" Specifically the problem seems to lay with your where clause. You need to add in the and after your first clause,...

Magento Database transfer oddity

database,magento,ubuntu,phpmyadmin

Run this query to get the URLs in the DB: SELECT * FROM core_config_data WHERE path = "web/unsecure/base_url" OR path = "web/secure/base_url"; If cache was enabled when you attempted to access the site, you'll need to clear your cache by removing the files in var/cache & var/full_page_cache. Also, 1.5 GB...

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

php,mysql,sql,phpmyadmin

There are two error seems in your code:- mysqli_close($dbc). You never created $dbc in your code. It must be mysqli_close($bookConn). You need to modified your last mysqli_query like this:- $result = mysqli_query($bookConn , $query) OR die(mysqli_error($bookConn)); Note:- I hope by doing these changes you will get rid of your proble....

Use SQL subquery as tablename

mysql,sql,phpmyadmin

The error message says it all. You need an alias on your derived table. SELECT Score from (SELECT tablenameOfUser FROM `Users`) WHERE X='something' AND Y='somethingElse' ORDER BY Score Should be: SELECT Score from (SELECT tablenameOfUser FROM `Users`) yourAlias WHERE X='something' AND Y='somethingElse' ORDER BY Score Your subquery only has the...

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

sql,phpmyadmin

Do it with NOT LIKE operator: SELECT * FROM mytable WHERE path NOT LIKE '%coffee%' AND path NOT LIKE '%Beans%' ...

Amazon web services phpmyadmin: The mbstring extension is missing

php,mysql,amazon-web-services,amazon-ec2,phpmyadmin

You need to install the PHP 5.6 version. yum install php56-mbstring...

error creating table in sql [closed]

mysql,sql,table,phpmyadmin

You added a comma after phone character(15) Try this: CREATE TABLE customers ( cust_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Name character(30), phone character(15) ); ...

Php code does not come out from MySQL Database properly

php,mysql,while-loop,phpmyadmin,echo

Please modify your table value ok, your code in sql INSERT INTO `right_widgets` (`right_widgets_id`, `func_name`, `active_status`) VALUES (1, '<?php get_search_engine(); ?>', 'true'), (2, '<?php get_clock(); ?>', 'true'), (3, '<?php get_virtual_nav_menu(); ?>', 'false'), (4, '<?php get_non(); ?>', 'false'); That's mean you table cols name is func_name and value is <?php get_search_engine();...

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

mysql,sql,phpmyadmin

Try this one: SELECT c.FromIDNumber, m.Timestamp, m.X, m.Y FROM Communication c JOIN Movement m ON c.FromIDNumber = m.IDNumber WHERE m.TimeStamp = (SELECT MIN(mm.Timestamp) FROM Movement mm WHERE mm.TimeStamp >= c.TimeStamp) You can use this SQL Fiddle to test with different data combinations. ...

MySQL auto_increment not reseting (stuck on increment by 10)

php,mysql,phpmyadmin

In phpMyAdmin, log in as a privileged user, go to home page, Variables, type "increment". Then for "auto increment increment", click on Edit, set it to the value you wish (1) and Save.

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

php,mysql,sql,mysqli,phpmyadmin

If you actually want the exact output you mentioned you could try this SELECT CONCAT(winning_member, ' = ', count(*), ' Wins') WHERE tournament="EPL" AND round="12" GROUP BY winning_member; ...

Merging two tables into new table by ID and date

sql,sql-server,phpmyadmin

You can use a SELECT statement when inserting into a table. What I would do here is write a select statement that pulls all of the columns you need first. You will have to do a full outer join (simulated by a union of left and right joins) because some...

how should i import a huge table in phpmyadmin

php,mysql,upload,phpmyadmin

I could solve my problem with the help of @vohuman. To get rid of the limitations of import (and even export), you should use command line, Or in the words of @vohuman: @vohuman: 'Log into mysql shell and source the sql file' So, to import a .sql file (for windows...

Find the closest timestamp SQL?

mysql,sql,phpmyadmin,timestamp

I think you want this version: SELECT c.FromIDNumber, m.Timestamp, m.X, m.Y FROM Communication c JOIN Movement m ON c.FromIDNumber = m.IDNumber WHERE m.TimeStamp = (SELECT mm.Timestamp FROM Movement mm ORDER BY abs(mm.TimeStamp - c.TimeStamp) LIMIT 1 ); You may need to use timestampdiff() instead of - depending on the types...

Importing a mysql database with command line

mysql,linux,database,command-line,phpmyadmin

You are missing the -D option here. Correct syntax would be: mysql -u db_username -p db_pw -h localhost -D existing_empty_db_name < new_db.sql ...

SQL result show empty results in phpmyadmin xampp [closed]

php,sql,phpmyadmin,xampp

Check for spelling errors in your Form and your SQL Statement. Also, consider making your username/email field/s non-nullable as a good practice.

Shifting id values of existing rows in mysql

mysql,phpmyadmin,auto-increment,alter-table,value

UPDATE myTable SET id=id+1923 Simple as that...

PHP math does not work in sql value ZERO

php,mysql,math,phpmyadmin

I having run you code and I just found you solution. in your Phpmyadmin database in side mate table cell name up_down update that, please goto Structure>up_down click Change>Attributes{UNSIGNED ZEROFILL} select that>Save And then you can test that you will find the different.

Delete after select not working

mysql,database,wordpress,select,phpmyadmin

I would place the deletion query inside the while: if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_assoc($result)) { echo '<font color="green"><h3>Congratulations!! You Have Genuine Product</h3></font>'; $sql2 = "DELETE FROM product_code WHERE product_code=".$_GET['product_code']; $result2 = mysqli_query($conn, $sql2); } This way you will execute the query only when you are sure...

Displaying certain records from MySQL statement

mysql,phpmyadmin,records

[Per your edited post] you need to JOIN with both table and Add a ORDER BY Price DESC in your SELECT statement; like select p.`prod_id`, p.`prod_name`, p.`price`, s.`company_name`, s.`phone` from products p join suppliers s on p.supp_id = s.supp_id order by p.`price` desc; ...

phpMyAdmin: Date Fields Display as BLOB

php,phpmyadmin

I have since found the solution to this problem. phpMyAdmin was not using the mysqli extension. Once I added the mysqli extension to PHP, all of the date fields started displaying the date instead of BLOB.

How many rows can mysql store?

mysql,phpmyadmin

Just google it is very easy: In InnoDB, with a limit on table size of 64 terabytes and a MySQL row-size limit of 65,535 there can be 1,073,741,824 rows. That would be minimum number of records utilizing maximum row-size limit. However, more records can be added if the row size...

MySQL database relationship without an ID

mysql,sql,database,phpmyadmin,relation

The reason is primarily for data integrity. The argument concerning performance is a little misleading. While neither exhaustive, nor definitive, I hope this little example will shed some light on that fact: DROP TABLE IF EXISTS my_table; CREATE TABLE my_table (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,s CHAR(12) NOT...

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

php,mysql,git,phpmyadmin

Yes, of course it is. You'll need to whitelist your development servers on the remote server's firewall and allow remote access to the database. If you're using cPanel, there are options there to do so, but you may need to speak to your host as well.

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

As already commented MySQL doesn't support CHECK constraint. Per MySQL Documentation it says: The CHECK clause is parsed but ignored by all storage engines You should rather use a BEFORE INSERT trigger as an alternative like below DELIMITER // CREATE TRIGGER sumcheck_before_insert BEFORE INSERT ON bla_table FOR EACH ROW BEGIN...

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

mysql,sql,stored-procedures,phpmyadmin,cursor

In a SELECT statement, assignment to user defined variables use the (pascal-like) assignment operator (:=) rather than just an equals sign. For example, this performs an assignment of the value 'foo' to the user defined variable: SELECT @var := 'foo' ^ That is much different than this: SELECT @var =...

How can I restart my autoincrement in phpmyadmin?

php,mysql,phpmyadmin

It is possible, but you shouldn't do that on production. The SQL query is: ALTER TABLE tablename AUTO_INCREMENT = 1 The most important part of this is to prevent overriding. For example you have an user and this user has id of 81 and if you delete this user and...

How to Query Cookie Variables

php,mysql,phpmyadmin,dreamweaver

Since $_SESSION('MM_USERNAME') is a string it needs to be in quotes. $query_chat = "SELECT * FROM (tablename) WHERE (columnname) = '" . $_SESSION['MM_USERNAME'] . "'"; Using the error reporting of which ever driver you are using should return this to you. You also should be sure you sanatize that value...

Choose results by date filter PHP and MySQL

php,mysql,datetime,phpmyadmin

If dates are in YYYY-mm-dd format then you can use it as below otherwise you need to change the format. You can do as below : $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db('foo', $link); if (!$db_selected) { die ('Can\'t...

Importing sql file into Mysql running xampp using commandline in Mac

mysql,osx,phpmyadmin

In your .sql file, look for a USE statement that would switch execution to another database. It might explain why you see nothing in the database used on the command line.

PHPMyAdmin How to do datatype set of relationships

php,mysql,phpmyadmin

This would be better modelled as a many-to-many relationship. You would need to add a link table that contains the columns (for example) allergen_id and raw_id. Then you can have multiple records in that table per entry in raws, and attach each record to multiple records in allergens without using...

How fatal is the maximum execution timeout warning in MySQL

mysql,sql,database,phpmyadmin

DCoder answer is good, try to change the maximium execution time in MySQL server, also, you can try to find what query is making the noise using the slow-query-log (you can activate it and is very useful in the case of messy querys). Check this page for more information If...

MySQL: #1293 - Incorrect table definition

php,mysql,phpmyadmin

There is not a direct way to do it, since this is not a valid table definition for any version prior to MySQL Server 5.6.5. You could edit the dump file by hand or with a tool like sed or perl to modify the offending lines, or you could change...

Add first and last button on pagination bar

php,phpmyadmin,pagination

In paginate.php change on 6th line $out = ""; for $out = "<li><a href=\"" . $reload . "&amp;page=1\">FIRST PAGE</a>\n</li>"; // or maybe without page param for the first page? And before return add the last page link: $out.= "<li><a href=\"" . $reload . "&amp;page=" . $tpages . "\">LAST PAGE</a>\n</li>"; ...

populating table keep getting error #1452

mysql,phpmyadmin

you have at least one row in the second(supplier )table i.e. child table referencing a non-existent row in the parent table. You could disable using -- SET FOREIGN_KEY_CHECKS = 0; ...

MySQL query runs ok in phpadmin but hangs in php

php,mysql,phpmyadmin,cpu-usage,hang

Use explicit join instead of implicit 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 o join orders_total ot on o.orders_id = ot.orders_id join customers c on c.customers_id = o.customers_id join address_book ab on...

MYSQL order NULL between two particular records and data

mysql,sql,mysqli,phpmyadmin

SELECT * FROM `report_table` WHERE state IN ('downloading', 'error','fail') OR state IS NULL ORDER BY CASE WHEN state = 'downloading' THEN 1 WHEN state = 'error' AND try<=20 THEN 2 WHEN state IS NULL THEN 3 WHEN state = 'error' AND try>20 THEN 4 WHEN state = 'fail' THEN 5...

MySQL MyPHPAdmin import from text without having the primary key?

mysql,import,phpmyadmin

Your spec says that Columns enclosed with: " I added quotes around the columns (and took away the spaces): "John","Smith";"Michael","Jordan"; AND put the auto increment ID column last. It imported fine with these settings. This is a dump from my test table. Compare it with yours and see what is...

mysql database does not store complete number of memberId

php,mysql,sql,phpmyadmin

Facebook uid's don't have a set length, therefore there is no way to know how big to set your table so set your column type to an unsigned bigint, how to do this in phpmyadmin is like this:

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

mysql,wordpress,phpmyadmin

Your question is still not clear to me. But you can try to start from (I guess that you have product_id column in both tables): INSERT INTO wpcustom_productmeta.wpc_productmeta(product_id,brand,model,country,carrier) SELECT product_id, MAX(IF(meta_key='brand',meta_value,''), MAX(IF(meta_key='model',meta_value,''), MAX(IF(meta_key='country',meta_value,''), MAX(IF(meta_key='carrier',meta_value,''), FROM wordpress.wp_postmeta GROUP BY product_id; ...

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

mysql,database,phpmyadmin

The answer is no, tables won't be locked, database won't be down. But, if your database is large and it takes long time to backup it, you can sometimes expect performance degradation(slow SQL queries from your application).

Online Excel Web-based Platform

php,mysql,excel,phpmyadmin

You can use any of following php packages... https://phpexcel.codeplex.com/ https://github.com/PHPOffice/PHPExcel https://code.google.com/p/php-excel/ If you are looking for web based excel view, then use following jquery package. http://handsontable.com/...

Storing data MySQL in Kurdish font?

java,mysql,unicode,phpmyadmin

What happened: you had utf8-encoded data (good) SET NAMES latin1 was in effect (default, but wrong) the column was declared CHARACTER SET latin1 (default, but wrong) As you INSERTed the data, it was converted to latin1, which does not have values for Arabic (Kurdish/Farsi/etc) characters, so question marks replaced them....

I can not access the local web and phpmyadmin

php,mysql,database,phpmyadmin

maybe you can try reset your mysql root password. first you need shut down your mysql server # server mysqld stop use safe mode # mysqld_safe --skip-grant-tables & login mysql # mysql -u root use sql command to update your password mysql> use mysql; mysql> UPDATE user SET Password=PASSWORD("password") WHERE...

Why doesn't the follow SQL table creation work?

mysql,django,phpmyadmin

You do not need the length for datetime `date_joined` DATETIME( 6 ) NOT NULL , should be `date_joined` DATETIME NOT NULL , https://dev.mysql.com/doc/refman/5.0/en/datetime.html...

Creating SQL Indexes?

mysql,sql,indexing,phpmyadmin

I think you need a composite index that includes both the ID that you're using in the JOIN and the timestamp. Otherwise, it will just use the ID indexes for the join, but it will then have to scan all the matching rows to do the timestamp comparisons. CREATE INDEX...

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

php,mysql,wordpress,character-encoding,phpmyadmin

The ’ character isn't the same as ' - looks like you have one in the title and another in the query. Either character is separately searchable, but they seem to have gotten mixed up by accident.

Select from multiple tables in mysql [on hold]

sql,phpmyadmin

The below query is what you're looking for SELECT * from (SELECT column1, 'table1' table_name from table1 UNION ALL SELECT column1, 'table2' table_name from table2 UNION ALL ... --repeat for all 10 tables SELECT column1, 'table10' table_name from table10) where column1 not like '123%' and length(column1) < 12; This will...

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

php,phpmyadmin,magento-1.7

its means that there is a foreign key that is not satisfied (ie you need it to exist but it doesnt) catalog_product_entity must have and entry for entity_id which is then referenced as product_id in cataloginventory_stock_item. ...

Rename and add prefix to all tables with phpMyAdmin

mysql,sql,phpmyadmin

Finally, i found an easy way to do that : 1) select all tables you want to add a prefix 2) choose in the select option : replace prefix table 3) fill the field with the prefix. screenshot : ...

PhpMyAdmin export : reference without uppercase

mysql,phpmyadmin,export

Adjust your lower_case_table_names setting for MySQL to achieve your goal. See How to force case sensitive table names?

Storing array in MySQL

php,mysql,phpmyadmin

So it sounds like I will need to have a user table and also a state licensing table with a user id linking the two then just make each possible state license a table and mark it with a 1 if they're licensed in that state or nothing if not?...

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

This was the problem: In the guide it says: // Change this to use the project and instance that you've created. $host = '/cloudsql/<your-project-id>:<your-cloudsql-instance>'; If you go to your Google Cloud SQL and view your GC-SQL instance, you will see that the instance ID is listed as <your-project-id>:<your-cloudsql-instance> So the...

Getting max count from mysql database

mysql,sql,phpmyadmin

Your query is working because MySQL doesn't throw errors in case there are columns in the select that are not either aggregated or grouped by, so it manages to display B.cno, but result is incorrect. In case total sum is unique you can use the following: order the records in...

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

mysql,phpmyadmin,foreign-key-relationship

You can find the missing key by using this command SELECT * FROM userart WHERE idArticol NOT IN (SELECT idArticol FROM articol) This will give you all entrys in userart having an idArticol that is not in articol.idArticol...

MySQL before update trigger an insert syntax error using PhpMyAdmin

mysql,triggers,phpmyadmin

Go figure I figured it out right after asking. 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$$ You have to use ; to break each statement/command and your delim $$ to end the...

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

mysql,sql,phpmyadmin

I am very sure that $query->fetch(); does only fetch the first row of your result. If you could try this modified version of your cursusDone function: function cursusDone($magazijn, $id){ $sql = "SELECT curs_code FROM c_regel WHERE cursistnr='$id'"; $query = $magazijn->query($sql); var_dump($query->fetch()); var_dump($query->fetch()); //return $query->fetch(); } This should output the first...

SQL Error while working on web with PhP

php,mysql,sql,phpmyadmin

Abhik Chakraborty is correct. If you want to enclose field/column or table names you have to use backticks (so ` instead of '). The backtick is the diagonal quote on the button next to the "1", above "Tab". To enclose field values you should use quotes the way you did....

How to create a timeline in phpmyadmin using nanoseconds?

java,mysql,jdbc,phpmyadmin

MySQL doesn't support nanosecond resolution. Since MySQL 5.6.4, there is support for fractional seconds with microsecond precision, but for further precision (or if you have an old MySQL version), you'll have to come up with something on your own. Probably what I'd do in this particular case is store it...

My password root caused disappearance in Mysql database

mysql,phpmyadmin,passwords,root

I've resolved it after 3 weeks ooof. Shutdown the mysql service Open the my.ini file You have to edit it where is [mysqld] and put skip-grant-tables Save the file and restart the service. ...

PHP doesn't fetch all rows from my database query

php,mysql,phpmyadmin

That is because you only fetch the first row. Put your fetch call into a while loop to fetch all rows, e.g. $arr = mysql_fetch_assoc($query); var_dump($arr); to: while($arr = mysql_fetch_assoc($query)) { var_dump($arr); } $query is a resource and with mysql_fetch_assoc() you fetch row by row from the resource. As from...

Conditional statements and multiple queries in mysql

mysql,phpmyadmin,mysql-workbench

As stated you can't perform an update, Insert or Delete when running a normal query, thus it would have to be a stored procedure in my database and i created one like so BEGIN IF(SELECT COUNT(*) FROM expressions WHERE face_id = face_id_ AND phone_id = phone_id_ = 1 ) THEN...

Add a row to JTable and Database (phpMyAdmin)?

java,phpmyadmin

That is a poor example to use: Variable names should NOT start with an upper case character. Hardcoding the array size to support 10,000 rows is the wrong approach. You can also use Vector which are dynamic. Instead check out the Table From Database Example code found in Table From...

Cannot log in to the MySQL server [closed]

php,mysql,phpmyadmin

Since you are using the ['auth_type'] = 'cookie' you need to enter the mysql username and password. This guide from the same site your following might be helpful although its using Mac OS Yosimite....

Performing a transaction across multiple statements in phpMyAdmin

mysql,phpmyadmin,innodb

Is it possible that phpMyAdmin is ending the client session after Go is hit and a query is submitted? That is pretty much how PHP works. You send the request, it get's processed, and once done, everything (including MySQL connections) gets thrown away. With next request, you start afresh....

MySQL command run on terminal is stuck, but phpmyadmin success

mysql,phpmyadmin

phpMyAdmin automatically adds a LIMIT clause to the query. Because you do not have an ODER BY clause, MySQL sends the results as soon as it has found the number of records that you requested in the LIMIT clause. Add a LIMIT clause to the query that you execute on...

phpMyAdmin returns blank page

phpmyadmin

It was the mbstring support that has not installed yet. Thanks to Nanne for pointing out to look after error log....

Handling users of phpMyAdmin

mysql,security,phpmyadmin,user,privileges

MySQL allows you to restrict permissions to a username, host pair. This means that the user only has the permissions when they login from the specified host. Typically you restrict MySQL admin permissions only if the user on the local machine (ie: the one that is running MySQL). The local...

SQL INSERT INTO Error #1064 on phpMyAdmin

mysql,sql,phpmyadmin

USE and INSERT are 2 different statements, like 2 queries. You need to write ";" at the very end of all statements if you want to execute them in the row.

phpMyAdmin CSV Upload Replace Data Not Working

sql,database,csv,data,phpmyadmin

This appears to be misleading text; it adds the "ON DUPLICATE KEY UPDATE" directive rather than truncating the table prior to insert, see the bug report at: https://sourceforge.net/p/phpmyadmin/bugs/4891/

PhpMyAdmin - err 1064 - set variable in function

phpmyadmin,mysql-error-1064

Finally found a solution to the error. First : It seems u can't use NEW & OLD keywords in function on MYSQL. So i made a Trigger instead. Switched to Adminer instead of PHPmyAdmin to use DELIMITER I notice DELIMITER*(space)$$* means (space)$$ and not only $$ SET := didn't work...

LEMP installation with phpmyadmin

php,mysql,nginx,phpmyadmin

Everything is solved i followed that guide. I did a simple mistake of not changing location = /50x.html { root /usr/share/nginx/www; } to location = /50x.html { root /usr/share/nginx/html; } As my system is 14.04. I did changed that in the starting lines....

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

mysql,sql,csv,phpmyadmin,load-data-infile

You can spcify the column name while import data from file, and use user variable to discard an input value by assigning it to a user variable while import data in table . AS PER MYSQL DOCUMENTATION You can also discard an input value by assigning it to a user...

Checking whether indexes are being used in SQL query?

mysql,sql,indexing,phpmyadmin

No, it's using an index. The ref and keylen tell us that. I think you may be confused by the Using index in the Extra column of the other rows in the EXPLAIN output. That means that the query is being satisfied entirely from the index, without a need to...

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

mysql,database,wordpress,phpmyadmin

I have no idea about the wp_sync_db plugin, but the phpMyAdmin error comes from having an older version of MySQL on your host which doesn't support the utf8mb4_unicode_ci collation. You could look for the "Database system or older MySQL server to maximize output compatibility with:" dropdown on the phpMyAdmin export...

Issues with using SHA1 password encryption in PHP/mysql

php,mysql,encryption,phpmyadmin,sha1

For the "$q" variable, you should use php sha1 function: $q = "select * from users where email = '$_POST[email]' and password = '" . sha1($_POST[password]) . "'"; But as Fred-ii said you really shoud (have to) protect your variables before. For example : $_POST['email'] = mysqli_real_escape_string($_POST['email']); It will protect...

Update field in table based on sum of others

mysql,mysqli,phpmyadmin

Try this query(EDITED) : update USERS u set u.overall_score = ( select sum(b.score) from USERBADGES b where b.user_id=u.id ) ; Now If you want to run this query automatically say everyday then use MySQL scheduler, like this : DELIMITER $$ CREATE EVENT update_users_table ON SCHEDULE EVERY 1 DAY STARTS '2015-05-27...

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

mysql,sql,phpmyadmin

You're abusing group by a little bit here. The general technique is to find the last payment in a subquery, and then join back to that query result. It is (almost) the only way to get the rest of the row details associated with the max/min value of another column,...

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

you have to do in this way step 1 : try to fetch the query like this as you are take the data in result so try to make like this $result1 = $mysqli->query( "SELECT * FROM $store where productId= $result.productId ") ; same for the table two...

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

mysql,sql,phpmyadmin

Since it's MySQL, I guess creating a BEFORE INSERT OR UPDATE trigger is your best bet. Example code: CREATE TRIGGER Validate_Trigger BEFORE INSERT OR UPDATE ON MyTable FOR EACH ROW BEGIN DECLARE msg VARCHAR(255); IF new.colA IS NOT NULL AND new.colB IS NOT NULL THEN -- Disallowed: yhrow exception from...

MySQL database shows in phpMyAdmin but not the command line client

mysql,phpmyadmin

So you see the database from within phpMyAdmin and want to know why you can't see it from the command line (terminal); this appears to be because you're not connected as the same user. Even if you're connected as the same user name, if one user is connected via sockets...

Make Mysql database that exists manageable with phpmyadmin

mysql,phpmyadmin,cpanel

The database created using the root? if so you must set user permissions to cPanel in WHM.

SQL Date datatype query

mysql,date,phpmyadmin

What needs to happen: STR_TO_DATE is expecting single quotes "'" around the date and formatting parameters. Table 4 is not a valid table name without "`" Remove brackets around STR_TO_DATE functions SQL Fiddle Demo Before 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)]) After INSERT INTO `table 4`(`COL 5`,...

Print MySQL table in php (simple) [closed]

php,mysql,table,phpmyadmin

In you html form place a submit button with name fetch like this <form method="post" action="yourphpfilename.php"> <input type="submit" name ="fetch" value="FETCH DATA" /> </form> and in your php code insert this code and configure this. if(isset($_POST['fetch'])) { // Connect to database server $con=mysqli_connect("localhost", "root", "") or die (mysqli_error ()); //...

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

mysql,phpmyadmin

Yes, you've correctly diagnosed the problem, at least it seems that way. As you've probably seen in the documentation, the MaxExactCount directive is basically used to configure at what point phpMyAdmin uses a faster but inexact row count. Whether it's a good idea to change it is pretty much up...