I have a database called nitm. I haven’t created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has size of about 103 MB. I am using wamp server. I have used the following syntax … Read more
Can I run a select statement and get the row number if the items are sorted? I have a table like this: mysql> describe orders; +————-+———————+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +————-+———————+——+—–+———+—————-+ | orderID | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | … Read more
Our previous programmer set the wrong collation in a table (Mysql). He set it up with Latin collation, when it should be UTF8, and now I have issues. Every record with Chinese and Japan character turn to ??? character. Is possible to change collation and get back the detail of character? 5 Answers 5
Is it possible to somehow get structure of MySQL database, or just some table with simple query? Or is there another way, how can I do it? 11 Answers 11
In the footer of my page, I would like to add something like “last updated the xx/xx/200x” with this date being the last time a certain mySQL table has been updated. What is the best way to do that? Is there a function to retrieve the last updated date? Should I access to the database … Read more
Which is the valid syntax of this query in MySQL? SELECT * FROM courses WHERE (now() + 2 hours) > start_time note: start_time is a field of courses table 5 Answers 5
How can I make a copy values from one column to another? I have: Database name: list ——————- number | test ——————- 123456 | somedata 123486 | somedata1 232344 | 34 I want to have: Database name: list —————- number | test —————- 123456 | 123456 123486 | 123486 232344 | 232344 What MySQL query … Read more
In linux I could find the mysql installation directory with the command which mysql. But I could not find any in windows. I tried echo %path% and it resulted many paths along with path to mysql bin. I wanted to find the mysql data directory from command line in windows for use in batch program. … Read more
Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I’d like to use VARCHAR as the primary key for reference lists (think US States, Country Codes) and a coworker won’t budge on the INT AUTO_INCREMENT as a primary key for all tables. My argument, as detailed here, … Read more
I’ve a table like: +———–+——-+————+ | client_id | views | percentage | +———–+——-+————+ | 1 | 6 | 20 | | 1 | 4 | 55 | | 1 | 9 | 56 | | 1 | 2 | 67 | | 1 | 7 | 80 | | 1 | 5 | 66 | … Read more
