Change field default in phpmyadmin
Try update command resource, UPDATE table_name SET column_name = NULL WHERE column_name = '0000-00-00' ...
How to create a timeline in phpmyadmin using nanoseconds?
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...
Performing a transaction across multiple statements in phpMyAdmin
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....
SQL Date datatype query
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`,...
how should i import a huge table in 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...
Merging two tables into new table by ID and date
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...
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...
PHPMYadmin table Migraton
EDIT: the query you want to be running seems to be get all records from the 'store' table and insert them into tbl_storefinder_stores with the same values like this: INSERT INTO tbl_storefinder_stores(store_name, store_address, lat, long) SELECT name, address, latitude, longitude from stores; fiddle If you want to create new records...
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...
PhpMyAdmin export : reference without uppercase
Adjust your lower_case_table_names setting for MySQL to achieve your goal. See How to force case sensitive table names?
How to run a specific sql query for every row in the table?
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. ...
Cannot log in to the MySQL server [closed]
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....
Add a row to JTable and Database (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...
PHP doesn't fetch all rows from my database query
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...
How can I restart my autoincrement in 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...
mysql error #1064
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...
Rename and add prefix to all tables with 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 : ...
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...
error creating table in sql [closed]
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) ); ...
Is it possible to connect to remote DB while working in localhost?
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.
I cant able to execute my mysql query while testing inlocalhost 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,...
MySQL MyPHPAdmin import from text without having the primary key?
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...
populating table keep getting error #1452
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; ...
LEMP installation with 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....
PHPMyAdmin issue: Is it advisable to assign a very large value to `$cfg['MaxExactCount']`?
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...
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 =...
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...
If I export my database with phpmyadmin will it lock my tables or take my database down?
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).
SQL Error while working on web with PhP
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....
MySQL command run on terminal is stuck, but phpmyadmin success
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...
Why doesn't the follow SQL table creation work?
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...
Importing sql file into Mysql running xampp using commandline in Mac
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.
SQL result show empty results in phpmyadmin xampp [closed]
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.
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...
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...
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...
how to know the date of insertion of record in SQL
mysql,sql,date,insert,phpmyadmin
While designing your database if you forgot to keep an extra field to store the insertion time of a row then you have only one option left to know the the insertion time. But the condition is you must have binary logging enabled prior to it. Reference You may check...
Make Mysql database that exists manageable with phpmyadmin
The database created using the root? if so you must set user permissions to cPanel in WHM.
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...
creating new database manually for a software every time while distributing it to a new user?
java,mysql,database,phpmyadmin
Yes, it is possible to create a database dynamically. SQL language allows that, and you can invoke SQL expressions using java. In SQL to create a database MyDatabase you need to invoke: CREATE DATABASE MyDatabase In java you can do it with this code: Connection conn = DriverManager.getConnection("jdbc:mysql://databasehost/?user=root&password=rootpassword"); Statement statement...
Use SQL subquery as tablename
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 many rows can mysql store?
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 before update trigger an insert syntax error using 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...
My phpAdmin says 'no tables in database' [closed]
You will have to create a Database and Tables offcourse!
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. ...
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; ...
SELECT MAX of COUNT
ORDER BY and LIMIT should be what you're looking for. SELECT count(`sentiment`) as count, `sentiment` FROM `sno_social_listener` WHERE `keyword_id` = 104 GROUP BY `sentiment` ORDER BY count DESC LIMIT 1 ...
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...
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...
How to exclude entries with specific value/strings in phpmyadmin SQL?
Do it with NOT LIKE operator: SELECT * FROM mytable WHERE path NOT LIKE '%coffee%' AND path NOT LIKE '%Beans%' ...
Online Excel Web-based Platform
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/...
MySQL: #1293 - Incorrect table definition
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...
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...
Select from multiple tables in mysql [on hold]
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...
PHPMyAdmin How to do datatype set of relationships
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...
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...
Phpmyadmin cant create table
Your id column have to be the primary key of your table: CREATE TABLE `playquzi`.`quiz` ( `id` INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT , `name` VARCHAR(255) NOT NULL , `question_id` INT(11) NOT NULL , `awnser_id` INT(11) NOT NULL ) ENGINE = InnoDB; ...
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...
mysql database does not store complete number of memberId
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:
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 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();...
Need to route to different php files and call separate functions using .htaccess
php,mysql,.htaccess,mod-rewrite,phpmyadmin
If dual is a real directory and .htaccess is present inside the dual folder then this simple .htaccess should work: RewriteEngine On RewriteBase /dual/ RewriteRule ^(login|register)/?$ $1.php [L,NC] ...
Catchable fatal error: Object of class mysqli could not be converted to string
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....
PhpMyAdmin - err 1064 - set variable in function
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...
SQL - Get all rows with same ID [on hold]
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...
Print MySQL table in php (simple) [closed]
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 ()); //...
Storing data MySQL in Kurdish font?
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....
How to get the last payment and the check if account is expired today or not?
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,...
Displaying certain records from MySQL statement
[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 returns blank page
It was the mbstring support that has not installed yet. Thanks to Nanne for pointing out to look after error log....
Storing array in MySQL
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?...
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 ...
How fatal is the maximum execution timeout warning in MySQL
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 order NULL between two particular records and data
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...
Checking whether indexes are being used in SQL query?
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...
MySQL database shows in phpMyAdmin but not the command line client
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...
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...
SQL Delete Duplicate rows find same text in a field
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...
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...
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row
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. ...
Creating SQL Indexes?
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...
I can not access the local web and 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...
order by: if two or more result match with limit 1 then randomize
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...
Getting max count from mysql database
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...
Choose results by date filter PHP and MySQL
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...
How to set it so that 1 of 2 columns is NULL in MySQL
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...
What is the best way of creating tables in MySQL? [closed]
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...
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...
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.
PHP math does not work in sql value ZERO
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.
Update field in table based on sum of others
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...
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 auto_increment not reseting (stuck on increment by 10)
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.