Tag: database
Suppose if you want to copy a Table to another, this can be done in MySQL with two steps. The first one is to copy the table structure, and …
In SQL, sometimes, you want to search a string field that contains a keyword, but as a whole word. So for example, if you search for ‘word‘, you do …
October 4, 2013
algorithms, database, implementation, internet, mysql, optimization, php, programming languages, search, SEO, sorting, technical, tricks
I have created an online page that allows people to upload any single photo to server. The URL to list all the photos (visible) is https://rot47.net/picture-gallery To add a photo …
My FTP provider (fasthosts) only allows 150MB maximum usage per database created. This is big enough for most personal usages. However, the other day, after I logined to the …
Sometimes if you want to extract some records from a table you can use the following SQL syntax select * from table order by rand() limit 10 Different SQL …