View Full Version : mysql answers


Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

  1. how to restore MySQL database?
  2. Security Groups linking with a MySQL on Alibaba Cloud
  3. MySQL how to repair a corrupted database
  4. Join field name to row data
  5. How do I automatically update column data from a .csv file uploaded every 2 hours.
  6. creation of a church database to keep track of faithfuls,enrolment,activities and gif
  7. How to create table from a pre-existing table
  8. MySQL startup error under Windows Installing MySQL as an Service
  9. Data file MySQL
  10. convert this query into storeprocedure
  11. even id numbers in a table called station
  12. The problem with the MySQL startup
  13. Restoring MySQL dump
  14. Master-Slave Synchronization for MySQL
  15. merge two tables make the first table come under the second having same column size
  16. #1146 - Table 'cccc' doesn't exist
  17. Can't open MySQL Database
  18. Wordpress Database
  19. create a mySQL table from the field headings line of a CSV file
  20. Need advice with ER diagram (relations)
  21. recover mysql deleted rows
  22. mysql data missing
  23. Generating random unique numbers and insert them into a columun.
  24. Mysql update stored procedure
  25. How can I fix my stored procedure to return the average GPA across all sections?
  26. Why would I need the OrderLineItems tables?
  27. How can I be sure that many to many relationships are created right?
  28. How to calculate time difference between datetime and only time
  29. Can someone show me how I can output hrs:mins:secs in mySQL SELECT statement below?
  30. How can I get the DATE_ADD to output the hrs:min:secs after it calculates 31 days?
  31. How can I get the DATE_ADD to output the hrs:min:secs after it calculates 31 days fro
  32. Query Help so simple I cant see it
  33. SELECT data from 2 databases
  34. Does MySQL 5.6 include support for Roles Based Access Control (RBAC)?
  35. Moving data from specific column to another
  36. .mdb file on a MSSQL Server
  37. Email Notification after Event Execution
  38. SELECT COUNT for column in database?
  39. Event Registration with Multiple Tables
  40. how can I fetch dynamic rows (drop down's database values) using ajax?
  41. Does 5.7.11-ndb-7.5.1-cluster-gpl support json datatype in ndb table?
  42. limit 10 on mysql and equal values with the 10th record
  43. Moving data from one table to another without duplicates
  44. dynamic rows insert into database using php
  45. Best database for Laravel 5.2 on Windows
  46. query for max date value for each item in a WHERE IN clause
  47. database table Normalization how to normlize a duplicate table
  48. Extracting information from two different tables ..
  49. Remove Leading Zero's from table field
  50. DB Design for Memberships
  51. Access denied to mysql
  52. How to store conversations in sql database for Cleverbot type system?
  53. one customer database for multiple different business
  54. how i can search multiple word search in Mysql Database
  55. stored procedure with dual personality
  56. I have below 2 queries and I want to combine them together.
  57. Is it possible to make auto updating sub tables?
  58. Comples Query to Include % of two columns calculation
  59. protecting from sql injections
  60. Making search box function.
  61. change from PDO to MSQLI
  62. Help regarding connection
  63. Is it possible to Installing mySql to a remote server using putty?
  64. ERROR: Can't connect to MySQL server on '<IP address>' (10061)
  65. how to auto generate a Varchar in phpmyadmin database
  66. Can anyone please help me? I have this MySQL ERROR
  67. How To Increase Max_Allowed_Packet In Mysql In Windows 8 I Tried Editing .Ini File Bu
  68. How to check if the data in the field is decimal using sql sysntax?
  69. Can you tell me please what is wrong with this ERD?
  70. Compare Two Dates on 30 days greater than the other
  71. connectivity of database about the php mysql through byethost websites
  72. how to count size of every row in mysql database table??? Is it possible? If yes then
  73. Paging in mysql store procedure? need help
  74. Java in Eclipse - MySQL Non Registering Driver when connecting to database
  75. How recover a deleted MySQL function
  76. Workbench 6.2 works but odbc connection failed with connection errors?
  77. I tried to run this create query but fail each time.
  78. A starting point...
  79. Need help with MYSQL table crash
  80. How to convert then combine field values
  81. Corrupt read only tables
  82. Not able to insert to db from form in production
  83. Alternative of DLookup in PHP
  84. Export data in excel format using datepicker in php & mysql
  85. Incorrect Information in File == MySQL Table Corrupted?
  86. How to compare same column and multiple values in same table?
  87. Sha1 encryption and posting login details to mysql database
  88. error creating database in mysql
  89. modify sql code
  90. To multiply two coluumns which are in two different columns
  91. how to show the output of two forms below the text box?
  92. To subtract two columns which are in two different tables
  93. phpunit, symfony, Bitnami WAMP.
  94. Join Two tables using the group by function
  95. ERROR 1045 (28000) Access denied for user 'root'@'localhost'. Symfony. Bitnami WAMP
  96. Grouping mysql result as per arrey
  97. My website was hacked and spam was spread through it.
  98. Adding JLabel Component to flow layout by calling custom function is not working
  99. How to Connect my MS Access to the remote SQL Server??
  100. Delivery report problem during sms sending
  101. comma separated values in tables eg rooms 2,3 want value where rooms =3
  102. Update rows with ids in CSV value passed to stored procedure
  103. Move some part of data from one column to another
  104. display records which does not match a pattern
  105. A_I field always 8388607
  106. auto generate id on customer table like cus001.
  107. nth highest salary of the employee
  108. convert sql into hql : I have written the code whch includes sql queries but i neeed
  109. How to create a count expression?
  110. You have an error in your SQL syntax check the manual that corresponds to your MySQL
  111. Replace data in mysql with the same primary key
  112. Multiple columns in MATCH AGAINST
  113. I need help building a junction table out of two tables
  114. Mysql subquery COUNT in same Table returns NULL
  115. Warning: getimagesize(img/header.jpg) [function.getimagesize]: failed to open stream:
  116. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
  117. how to drop many databases in the same time
  118. how can i solve and how to fix to correct?
  119. How to select mysql databases without changing distance between paragraphs?
  120. MySQL Load data infile divides data field in two parts. The later moved to next field
  121. Search engine for books
  122. sum of two number in sql server2008 with storeprocdure
  123. How to calculate break hours from in/out details in php?
  124. sql syntax length too long
  125. Downloading MySQL
  126. Update multiple columns with a SELECT statement
  127. How to show five tables in same code
  128. IF statement in mysql returns failed result
  129. How to Add a Dynamic Column in Mysql
  130. Software error:
  131. Upload image to Mysql with PHP fails
  132. I cannot upload data onto my website database - syntax error 1064
  133. Display the query of following problem.
  134. wamp server access through another system
  135. How to insert current date and time via plsql
  136. insert value of a previous table to a new table and update the new table
  137. error 1064 have detected on a Case When statement, please help
  138. Saving time by using MySQL query command and the WHERE function
  139. how to set linesize in mysql?
  140. How can I retrieve records and a total count of the records - MySQL
  141. Query to Extract Distinct Substring after Specific Character & Provide Count Of Each
  142. How to fetch particular row in a table without mentioning it's id or other elements
  143. equalise data from one table column to another table column
  144. Fetch All rows of column in a table
  145. How to select odd and even numbers in mysql
  146. Change color of specific text while watching logs
  147. How to Generate unique random number?
  148. $mysqli->real_escape_string() not working
  149. Creating bridge table for combine two other table
  150. Joining three tables at a time and get the required output
  151. data conversion
  152. mysqldump not working in my batch file
  153. One primary key in one table linked to two foreign keys in two different tables?
  154. What is the difference between MyISAM and INNODB?
  155. how to get same item row from different item in one time in vb and ms access
  156. migration from sqlserver to MySql
  157. tables connection
  158. which SQL statement to be written inorder to store the registration values in MySQL
  159. sqlite conditional select from multiple tables
  160. get day records based on id
  161. connect and create database with php via wamp/mysql
  162. find the index of row in datatable,mysql
  163. Datetime problem in Mysql Database
  164. Can't find /var/lib/mysql when I log in to the server
  165. updating database.
  166. editing an MYSQL tablevia a web page
  167. reterieving the most recently added data from MySQL
  168. no connection in MySQL
  169. Display the two column values in one column but in next line
  170. inserting new line in mysql
  171. key specification without a key length
  172. Migrate
  173. inserting new line in the same column in MySQL
  174. online database server
  175. relation view tab missing in phpMyAdmin
  176. mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password
  177. unknown error and filling data in MySQL
  178. Connecting a MySQL database & creating & inserting values in a table via a php script
  179. Use of "CASE" in the select statement
  180. Populate empty field1 with specific text if that text found in field2
  181. EXCEL Data to Existing MYSQL Tables w/ DATA
  182. project as a reserved word
  183. it dont take the project word as a reserved word
  184. Is there a free program that can be used to write a SQL database, and is this the bes
  185. please guys help me to get this query
  186. Installing MySQL
  187. Master - Slave Replication on specific rows of table
  188. The drive or network connection that the shortcut " refers to is unavailable. Make su
  189. how to store two different form values in single table?
  190. SQL Error: State:21000, Native Code: FFFFFCD5
  191. How to separate a filed using SQL
  192. Using MS Access as front end for MySQL Database -- is it possible to tune & speed per
  193. want to create a tool by selecting different events the LastOccurrence field must b
  194. executenonquery problem in c#.net
  195. Noob having problems joining two queries in one report Access 2007
  196. Complex SQL query suggestions please
  197. Divide the count of a query by total number of rows in the table
  198. how to get table structure from .frm files
  199. extract records using UNIX_TIMESTAMP and CONCAT
  200. installing mysql either with java or xampp
  201. How do I pull latest results when there is duplicate results?
  202. #1064 - You have an error in your SQL syntax;
  203. How to create a computed column that is recalculated each time it is accessed
  204. need row total and column total
  205. How to connect MySQL to command prompt
  206. Add more data into existing rows and column at SQL
  207. how to store image in database?
  208. how to select multiple rows data from one collumn of database
  209. Select 3rd maximum value from table
  210. Do the database owner see every column of a table
  211. I have a list- null, 1,2,3 and am asking for only the 1 but keep getting 1 and null.
  212. how to select data from two different database
  213. the XML content can be retrieved by using: $fluxXml = $GLOBALS['HTTP_RAW_POST_DATA'];
  214. my query it's right ?
  215. Display mysql data one at a time using a next button
  216. sqlite insert question
  217. select command in mysql returns an empty row even though the entry exist in table
  218. query SQL
  219. Will not allow me to generate a certificate
  220. How to Connect MYSQL to MS ACCESS in NETWORK?
  221. merging of two mysql databases having two different ports
  222. Problem of indexing Country, State , City columns
  223. You tried to execute a query that does not include the specified expression 'X' as
  224. com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityCons traintViolationException:
  225. How to get all occurrence of a string in clob data in MySQL
  226. Can't start the mysql server
  227. How to add a select statement to a function of which will display the results?
  228. Search and replace unwanted character
  229. finding the max
  230. C# connector string to mySQL Cluster Database
  231. Uploading a sql database on 1&1 host
  232. Why does my SQL SELECT statement not work? "... missing expression"
  233. How to make MYSQL Query faster
  234. Storing multiple values/range of values in a single cell
  235. I need report generator tool for wamp
  236. how to erase the previously loaded data in datagrid?
  237. Getting Data From Mysql Database and save it to textbox or variable in Visual Studio
  238. I have a site and want to add notification script
  239. add image in mysql database in java form and retrieve image
  240. I can't get my inner join to work between two tables
  241. Importing Database to netbeans java project by sql dump file
  242. i want to connect wamp MySQL to my netbeans project
  243. While installing MYSQL: Could not connect to the service Control Manager error:0
  244. how to count value of record in the database using asp.net
  245. Multilingual database - using a variable instead of a column name in Mysql
  246. Trying to use a blob data type to add an image to a database
  247. Error in Query3Duplicate entry '127.0.0.1' for key 'lastupdateipaddress'
  248. How to set Dynamic WHERE showing customer rows depend on customer_ID using PHP?
  249. How can I connect to my MySQL server from my computer?
  250. how to Connect MySql Server in msi installshield12
  251. How to retrieve two different data from same database and same table.
  252. Trigger for creating csv of new data
  253. tran.rollback does not work
  254. single transaction over multiple databases
  255. Can not add Record to mySQL via Openoffice Base
  256. active server vs passive server
  257. Case subquery displays in mysql
  258. what is dynamic SQL?
  259. Error Code: 1064 - You have an error in your SQL syntax; check the manual that corres
  260. How to Store 'live' list-type data
  261. Need to fetch current date records from SQL server 2008
  262. check if the selected value contain a value and then change the value
  263. in date format how do i write my d.o.b. as dd/mm/yyyy
  264. (update Set) Blocked field = 1 when there is no sells to one client.
  265. Does MAX() in INSERT / UPDATE work ?
  266. Unknown database ('database_name')
  267. structure a select statement with multiple where
  268. updating most recent entry, regardless of previous records in database
  269. Search fails when criteria includes an underscore
  270. MYSQL client ran out of Memory
  271. format in which data is stored in mysql database
  272. copy all tables and data from one system to another system via lan
  273. New Server (Brinkster) doesn't support DSN connection
  274. upload client side data to the MySQL server
  275. How to connect MySQL server using ODBC connector? how to configure ODBC connector 3.5
  276. Can a table be both parent and child to another table? Newsdatabase with comments
  277. Connectivity Issues in Apache Server
  278. Can't delete any foreign key on every query to drop foreign key
  279. Avoid column duplicate printing in mysql
  280. I need to get certain information out of a database
  281. Unable to find my.ini file to set variable event_scheduler = on
  282. How do I create a clustered index and use it to speed up my MySQL query
  283. How to lock selected rows from reading in other session?
  284. Event scheduler not working
  285. Effect of bandwidth on MySQL ODBC driver
  286. how query four tables from the database
  287. how to create a fixed size table in mysql
  288. sql query send updated data into new table
  289. Auto deletion of table in database after certain period of time
  290. subtracting 2 columns of different tables with a update query
  291. i want to display data from textnews field in mysql within limited lines. can any one
  292. I receive the error " the ***service could not be started" when launching MySQL from
  293. #1248 - Every derived table must have its own alias ,
  294. Slow in fetching records from table using left join
  295. How can i fetch all the values in a minute from a table ?
  296. Best way to Index large tables in MySQL database
  297. How to stop and start MySQL service automatically at certain time?
  298. Query Cache Hit Rate
  299. `table` doesn't exist... but I'm sure it does!
  300. how to execute pl/sql using mysql?
  301. Can i call python script on every updation of column value
  302. What is the difference between time and timestamp data type in MySQL
  303. Pleasehelp me with my problem in sql.. column to row
  304. How to store images and videos in database
  305. SELECT statement problem
  306. Bridge table in mySQL
  307. Exception in creating a delete query in EntityManager
  308. Get query results using array
  309. compare date within the same table and delete the oldest one.
  310. insert data
  311. mysql query returns null value
  312. How to combine two tables with different table headers into one
  313. mysql query problem
  314. Mix of Match() Against(), & Match() Against(in boolean mode) = Non-Sorted results
  315. How to show distinct column values when it doesn't come in query result
  316. mySQL get information from multiple tables with efficient query
  317. error in sql statement
  318. Update MySql Column (if field is not empty, go to next one)
  319. sql query in ireport
  320. Conditional Where clause using SQL in Access
  321. Converting/Trimming XML VARCHAR Tag to Date
  322. VLookup equivalent MySQL multiple criteria
  323. Is something wrong with my query?
  324. connection to databse
  325. how to count group by data on two union table
  326. clarification on GROUP_CONCAT()
  327. Trigger & error #1329 No data - zero rows fetched, selected, or processed
  328. error 150: Can't create table
  329. holding a vector with in a column of data
  330. How does MYSQL handle NOT NULL columns when added to tables with records?
  331. MySQL service won't start on external drive
  332. how can i display dates that are less than 1 week and equals to date now in mysql?
  333. Merge 2 integer columns into 1 seperate column in database
  334. report generation in mysql
  335. backup of mysql from a crashed database
  336. switch case
  337. Pattern Matching
  338. Creating a many to many table
  339. select records by latest date
  340. I want to create trigger for alter table
  341. Select from multiple tables
  342. #1064 error when importing database
  343. question: load_file('proc/self/environ') - possible?
  344. selecting values from a table of one server to insert them into another server by php
  345. How to show and count empty cells for a field / table?
  346. Table join including link creation & sum
  347. complicated SQL:how to using a query to compute rank of order(Outstanding of Class 1)
  348. How to filtrate duplicate data about technical support and compute rank of order
  349. #1064 - You have an error in your SQL syntax; check the manual that corresponds to yo
  350. PHP MYADMIN 1064 error as trying to copy table
  351. run time error:241721790{80040e10} no value given for one or more parameters
  352. How to optimize a big database with slow writes?
  353. select data after timer interval
  354. How I can optimize this query?
  355. MySql Query Error
  356. Proper SQL String
  357. Cannot add or update a child row: a foreign key constraint fails
  358. Java mysql play framework about uploading file data to db
  359. Merge Query
  360. how to insert '\' in mysql database using java code
  361. taking count from 3 table
  362. mysql
  363. selecting records on basis of condition
  364. Error In sql You have an error in your SQL syntax; check the manual that corresponds
  365. how we can upload aimage in database and get it in jsp page
  366. Going absolutely crazy...
  367. Insert record unless duplicate for non-key field (except when empty)
  368. choice for DBMS
  369. mysql for select using sum in another table
  370. inverted index, postings lists, and linked lists
  371. How to diagnose a query problem
  372. trigger for creating a csv file
  373. Date Format as dd-mm-yyyy
  374. select statement
  375. How to insert data into temporary table using Procedure
  376. count at each change in value
  377. Why AUTO_INCREMENT field keeps previous values
  378. how to backup database
  379. Mysql Error while connection from remote ip on linux
  380. getting record from SQL and place in a textBox in VB 6.0
  381. compare rows. do something when value changes in a particular column
  382. Date Query removing present month
  383. my.cnf error's
  384. how to join 3 tables with Full Joins
  385. While row displaying repeated values
  386. Vb6
  387. MySQL database connection: what to put for hostname?
  388. Error: access denied for user ''@'localhost' to database
  389. how can a change a column named 'population * 1.1' with oher name?
  390. Average on MAX by Group
  391. How to compare data from 2 database.
  392. Problem with SQL Query
  393. mysql-php multiple slave/master replication
  394. What is the syntax for parameter query in mysql
  395. Database question
  396. update query with select query
  397. Problem setting foreign key using phpmyadmin
  398. Calendar: x weeks ago always starting on a Sunday
  399. WAMP offline/online
  400. Removing leading zeros in an address field
  401. Connection Failed OBBC driver 5.1 Access Denied for user 'Root'@'localhost'
  402. How to approach area searching
  403. Yes/No Datatype
  404. How to put multiselect information into mysql database?
  405. Is there a fix to the Timeout bug
  406. Sending Multiselect List information to MySql
  407. my.cnf errors..
  408. mySQL upload
  409. How to combine two data rows into one
  410. MySQL in cmd prompt
  411. Kindly, help fixing error 1064
  412. Afeter insert trigger
  413. WAMP MySQL Database access in java code
  414. How should I go about this?
  415. mysql
  416. MySql Database backup
  417. how to copy a row from a table'tipuranibasti'(one field is blob type)to'puranibasti'
  418. Problem with "packet bigger than 'max_allowed_packet' error"
  419. can someone help me on how to Insert pdf document into MySQL using PHPMyAdmin?
  420. Comparing SUM of two tables
  421. Locate same or changed values
  422. MySQL false empty result set
  423. How to get records against root level id using MySql Query
  424. Install SQL 2008 and SSMSE 2008
  425. Sql
  426. MYSQL if statement syntax
  427. How to split a text field into words
  428. Region wise count for total requests.
  429. Mysqldump extracts unwanted tables
  430. Time Frame
  431. mysql syntax error
  432. uploading data from a Msql slave to its Master
  433. mysql
  434. string comparision
  435. Checking for a FileNotFoundException in a Seperate Method
  436. I am having trouble with INSERT INTO creating a new record into a different table.
  437. my sql question "join"
  438. To get the column names based on value
  439. Need to count distinct number of occurances in a non-normalizedfield
  440. MySQL service does not start
  441. Transpose Query Output
  442. Data dissapearing from data base
  443. Disabling some field in a ms access form
  444. how can i count the filled cells/columns of a mysql row with PHP?
  445. Interlink two rows in my database
  446. error occurred: Can not issue SELECT via executeUpdate()
  447. getting 4 consective values in a query... this is interesting and hard
  448. passing array to php from Ajax
  449. Getting mutliple values from mutliple tables
  450. table structure for seasonal pricing for members and guest
  451. Alternatives to using SQL
  452. Select pair of rows that obey a rule
  453. Need to delete MySQL records from a table that are older than 700 days
  454. how to actually set up eclipse with mondrian setup
  455. Handling Decimal format
  456. Create a table from an xls or csv file
  457. IN clause in php mysql
  458. In a Select Statement, how do you create a temporary column to display calc results?
  459. Backup My Sql Server 2000 database via queries
  460. MySQL 5.5 execution of sql file using "source"
  461. Select right price by products..
  462. delete Xampp's mysql folder
  463. sql count based on key id
  464. Find highest rank across table columns
  465. Connect to a local MySQL database from a remote computer using phpMyAdmin
  466. How to use SET to Update a Pre-exiting Table
  467. Connect MySQL using phps on different network
  468. Insert data into two table into diferent server at the same time
  469. How to improve the performance of mysql query
  470. Mysql error
  471. Count the downline node in tree using store procedure in mysql
  472. How to connect Delphi 6 and MySQL via ODBC
  473. Calculation across Tables
  474. fetching data from many tables
  475. ISO 6346 Check Digit Calculation in T-SQL. Need to change it to use in MySQL
  476. Write a Check Digit in mysql
  477. Xampp on LAN
  478. Strange query results
  479. sql injection hi
  480. Right amount of indexes to use on a big table?
  481. Having trouble with MyQSL Queries
  482. Dyanamic Select Query
  483. "update" mysql table
  484. How to save file to database using external folders
  485. MS Access Attachment vs MySQL Blob
  486. how to import csv file to mysql database file size more than 440MB
  487. How do you insert more than one row at a time?
  488. storing images in database
  489. How to search string with special char like Exupéry in MySQL?
  490. MySQL optimize a slow query
  491. The -p in MYSQL
  492. Rows into columns/columns into rows
  493. How to write a query that allows multiple input from a select list
  494. How to get multiple row values having distinct column value
  495. Where stored procedures are stored in mysql
  496. FULLTEXT search, all words must match
  497. How to add a value which is a primary key of another table
  498. Image button in PHP
  499. Select distinct from multiple columns into one column
  500. Update second dropdown via ajax
  501. Dependies of a copied table
  502. Two drop down boxes in php and mysql
  503. Filter database with list from a text file
  504. Store Multiple Images in Mysql
  505. How many methods of search and when where should use
  506. Select rows with inner join and max id
  507. Extends, include in use case (uml)
  508. DBD::mysql installation error.
  509. no results in WHERE LIKE without capital
  510. mysqldump: Maximum size of an insert block
  511. How can I manually create an admin?
  512. Connection Failure on Mysql Server 5.1
  513. phpmyadmin error #1064: error in SQL syntax
  514. "This is not a number!" Error when using VARCHAR type in PhpMyAdmin.
  515. How to insert dynamic field values into mysql table?
  516. MYSQL max_allowed_packet won't change, can't restore..
  517. Select row in table with id from another table
  518. how do i insert 70,000 rows into my database
  519. Getting the sum of two fields from a view
  520. Library Database Entity Relation Diagram
  521. analytical query
  522. Exact comma delimited search
  523. Why am I getting a MySQLi Syntax error?
  524. Using same field as alias and using the count in the query.
  525. How do I select columns with a certain value?
  526. online booking hotel
  527. How to export data from a MySQL PHP shopping cart to AS/400 computer
  528. using Sql 2005 EE need to truncate not delete table data older than 15 days old
  529. tabe is full, but InnoDB free shows 3072 kB
  530. retrive results from 4 tables
  531. WordPress database error: help ?
  532. Counting from multiple tables with the same column
  533. i want to store all incoming emails Database
  534. Boolean Full-Text Searches
  535. error msg for mssql_query()
  536. Deleting database entrys from a website
  537. I have MySQL tables in notepad, how can i put them in MySQL database server
  538. PhpMyAdmin unknown size by ndbcluster table.
  539. Help with simplifying this query
  540. MySQL pingback code help needed
  541. MySQL tables, join, update, delete and insert linked via foreign key
  542. How to categorize orders for each month or year
  543. Sorting results from one table by rows in another table
  544. Getting similar rows (same title, different description)
  545. Search, grab & append the rows
  546. Getting data from two different tables in one query
  547. Simple thumb up / down vote system
  548. SUM and MAX query
  549. Grouping results from different rows
  550. How do i remove this time 02:30 from 1899-12-30 timestamp?